Skip to Content
Technical Articles
Author's profile photo Aram Kalyanasundaram

Two way integration between SAP CAR and SAP ECC

SAP Customer Activity Repository will typically have a two way communication with ECC when it comes to integration.

Inbound Integration

A)Inbound integration into SAP CAR from SAP ECC(using SLT )

Below are few options through which the integration can occur

1)SLT is a separate standalone system server that replicates data from SAP ECC into SAP CAR

2)SLT is installed within SAP ECC and integrates with SAP CAR(for data replication)

As part of SAP CARAB 4.0, more than 200 tables in both S4 HANA and SAP ECC can be replicated into SAP CAR

SLT is System Landscape Replication Server that replicates the below data from SAP ECC into SAP CAR for master data checks,cost price/gross margin calculation,inventory visibility and various other analytics/reports

1.Master data such as Article/Site/Promotions etc

2.Inventory data such as Stock quantities for a particular article/store combination and also stock in transit details etc

3.Sales documents – Details such as sales orders and also billing documents

 

B)Inbound Integration into SAP CAR from SAP ECC(for DDF using DRFOUT)

If Demand Data Foundation is enabled as a business function, then master data from SAP ECC is required to be transferred into SAP CAR for demand modelling, forecasting etc. This is achieved using DRFOUT framework(RFC connection) from SAP ECC primarily for the below information

1)Product

2)Location

3)Product Location

4)Product Hierarchy

5)Location Hierarchy

6)Offer

7)Source of Supply

8)Distribution Chain(Sales Org, Distribution channel)

Unified Demand Forecast is another module within SAP CAR that utilises DDF master data that feeds into UDF algorithm engine for accurate forecasting(SAP suggests to have 2 years of historical sales data as well for accurate forecasting numbers)

 

Outbound Integration with SAP ECC

Outbound Integration from SAP CAR into SAP ECC(using Idocs)

This integration typically consists of the below idocs

1.WPUUMS – Aggregated Sales data (that posts both Billing and Article documents in SAP ECC)

2.WPUBON – Sales per receipt(that posts both Billing and Article documents in SAP ECC)

3.WPUTAB – Payment information such as cash,credit,debit,cheque, gift card etc.

4.WPUFIB – Financial Transactions such as Paid in, Paid out etc

5.WPUWBW – Goods Movements data that may also include scraps, write offs, damaged items etc depending on the business processes/requirements.

Inventory visibility is one of the key features of SAP CAR and it requires the idoc confirmation settings to be turned on in POSDTA configuration for the respective tasks that sends the request to SAP ECC and receives the confirmation back into SAP CAR, which then updates the unprocessed sales record count in /POSDW/TLOGUS table in POSDTA.

 

You can also refer to my other blogs on SAP CAR using the below URLs

POSDM Vs POSDTA

https://blogs.sap.com/2019/03/03/posdm-vs-posdta/

Journey from POSDM to POSDTA(CAR)

https://blogs.sap.com/2019/03/04/journey-from-posdm-to-posdtacar/

Migration from POSDM to POSDTA(CAR)

https://blogs.sap.com/2019/03/06/migration-from-posdm-to-posdta/

SAP CAR integration with S/4 HANA

https://blogs.sap.com/2019/04/04/sap-car-integration-with-s4-hana/

 

Thanks,

Aram.

Assigned tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Garth Arendse
      Garth Arendse

      So the standard SAP tables like MARA and T001 are now replicated on CAR by SLT so no need for the BW tables like PPLANT.

      I sure will make life easier if that is the case.

       

      Author's profile photo Allan Jørgensen
      Allan Jørgensen

      SLT can be used as a very strong Integration tool.

      We have made multiple minor tables avaliable where needed.

      Author's profile photo Aram Kalyanasundaram
      Aram Kalyanasundaram
      Blog Post Author

      Hi Garth,

       

      Yes you are absolutely right.Those tables such as /bi0/pplant, /bi0/pmaterial etc will be gone and they will be replaced with HANA views once you onboard CAR.

      Thanks,

      Aram.

      Author's profile photo Sharmi G
      Sharmi G

      Hi Aram,

       

      I have used DRFOUT and SLT both for UDF module . So now CAR have all required data for UDF in table and also sales data from POS. So could you please tell me what will be the next step for UDF.

      Thanks,

      Sharmi

      Author's profile photo Aram Kalyanasundaram
      Aram Kalyanasundaram
      Blog Post Author

      Hi Sharmi,

       

      The next logical step would be to Schedule modeling and Forecasting to see the Modeling and Forecasting results prior to using Fiori Analyze Forecast App.

      I believe you would've done all the necessary configuration in CAR for UDF.

      Also i would recommend you to post your generic queries in SAP's CAR community page

      https://answers.sap.com/tags/67837800100800005767

      Thanks,

      Aram.

      Author's profile photo Sharmi G
      Sharmi G

      Thanks Aram

      Author's profile photo kiran r
      kiran r

      Hi Aram,

       

      Thank you so much for the information provided above.

      Can you please provide the step by step activities on how can we replicate Sales Documents from S4 hana to CAR system.

      "Inbound Integration

      A)Inbound integration into SAP CAR from SAP ECC(using SLT )

      3.Sales documents – Details such as sales orders and also billing documents"

      Thanks,

      Lav K

       

       

      Author's profile photo Aram Kalyanasundaram
      Aram Kalyanasundaram
      Blog Post Author

      Hi Kiran/Lav,

       

      You can include the relevant tables such as VBAK,VBAP,VBRK,VBFA,VBUP etc. as part of the SLT replication.

      You can refer to the below link which has more information about SLT replication(Standard SAP supports more than 200+ tables depending on the ERP version - Retail/S4H etc.)

      https://help.sap.com/viewer/55c14d85842b4275afda2af381a7ab71/4.0.3/en-US/abd892fd5e034865ac17df6057dedddb.html

       

      Regards,

      Aram.

      Author's profile photo Sanjay Gupta
      Sanjay Gupta

      Hi Aram,

       

      Please advise if SLT option is also available for CARAB 5.0 and ECC 6.0 EHP7 SP08.

      We are planning to implement PMR and minimum requirement for DRFOUT is ECC 6.0 EHP7 SP16.

      We are exploring option of SLT.

       

      Thanks,

      Sanjay