Master Data
SAP Customer Activity Repository, or more specifically PIPE, acquires POS transaction data from connected point of sale locations (stores) in your business. When the transaction records (TLOGs) are received by PIPE, the engine carries out a number of master data checks to verify that the received data is valid. PIPE also enriches the data received in the TLOGs with master data available in the SAP ERP system.
During master data checking and enrichment, TLOGs are verified against master data that is available to the repository from a source SAP ERP system (either through replication or direct access, when the systems are co-deployed).
The table below lists the master data checks carried out by PIPE along with the SAP ERP tables required to perform the checks.
Note
Only the most important SAP ERP tables are referenced in the table. For the complete list of SAP ERP tables used by SAP Customer Activity Repository, refer to the files attached to SAP Note 1897024
.
Master Data Check/Enrichment | Main SAP ERP Tables |
|---|---|
Article (Material) Number and Description | MARA, MAKT |
Article EAN/GTIN Numbers | MEAN |
Article (Material) Store (Plant) | MARC |
Units of Measure for Article | MARM, T006, T006A, T006D, T006T |
Store (Plant) Number and Description | T001W |
Distribution Channel | TVTW, TVTWT |
Merchandise Categories (Material Groups) | T023, T023T |
Sales Organizations | TVKO, TVKOT |
Company Codes | T001 |
Furthermore, a number of PIPE tasks require additional SAP ERP master data:
Tasks | Main SAP ERP Tables |
|---|---|
Supply - DMF-Based Applications | KONBBYH, KONBBYPRQ, KONBBYT, KONDN, WAKH, WAKP, WAKR, WRF_MATGRP_HIER, WRF_MATGRP_HIERT |
Supply WFM | KLAH, KSSK, SWOR, TCLA |
Distribution | WLK2 |