POS Sales Data Aggregated - Cockpit
In ScopeTechnical: WPUUMS | ID: SAP-ISR-WPUUMS-POS_SALES_DATA_AGGREGATED
Aggregated point-of-sale (POS) sales data is migrated to SAP IS Retail to enable sales analysis, inventory replenishment, and financial reconciliation. This object supports daily summarized sales for articles by site,...
See how this object fits into Is Retail
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 4 – Operational master data
- Typical Sources
- Legacy POS systemThird-party retail data warehouseStore-level aggregation engineRetail databaseCSV file exports
Classification
- Information Type
- Transaction
- Object Type
- cockpit
Target Structure
- Load Approach
- iDoc
- Target Objects
- EDIDCEDID2
Field Definitions(5)
Rules & Considerations(32)
validation
constraint
Sample Load Data(4)
| _scenario | SITE_IDRPK | SALES_DATERPK | CASH_REGISTERRPK | SALES_INTERVALRPK | TOTAL_SALES_NETR | SDATA | DOCNUM | MESTYP | RCVPRN | SNDPRN | IDOCTYP | TOTAL_QUANTITY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 10000001 | 20231201 | REG00123 | 090010 | 1250.75 | Sample text | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 85.000 |
| Closed historical record from last fiscal year | 10000002 | 20231231 | REG00234 | 180000 | 500.50 | End of year summary record | TAMPLE | POS_AGGREGATED | RCV002 | SND002 | WPUUMS | 20.000 |
| Minimal data record for future sales event | 10000003 | 20240101 | REG00345 | 000000 | 0.00 | — | SCMPLE | — | — | — | WPUUMS | 0.000 |
Example values from field definitions
- SITE_IDRPK
- 10000001
- SALES_DATERPK
- 20231201
- CASH_REGISTERRPK
- REG00123
- SALES_INTERVALRPK
- 090010
- TOTAL_SALES_NETR
- 1250.75
- SDATA
- Sample text
- DOCNUM
- SAMPLE
- MESTYP
- SAMPLE
- RCVPRN
- SAMPLE
- SNDPRN
- SAMPLE
- IDOCTYP
- SAMPLE
- TOTAL_QUANTITY
- 85.000
Closed historical record from last fiscal year
- SITE_IDRPK
- 10000002
- SALES_DATERPK
- 20231231
- CASH_REGISTERRPK
- REG00234
- SALES_INTERVALRPK
- 180000
- TOTAL_SALES_NETR
- 500.50
- SDATA
- End of year summary record
- DOCNUM
- TAMPLE
- MESTYP
- POS_AGGREGATED
- RCVPRN
- RCV002
- SNDPRN
- SND002
- IDOCTYP
- WPUUMS
- TOTAL_QUANTITY
- 20.000
Minimal data record for future sales event
- SITE_IDRPK
- 10000003
- SALES_DATERPK
- 20240101
- CASH_REGISTERRPK
- REG00345
- SALES_INTERVALRPK
- 000000
- TOTAL_SALES_NETR
- 0.00
- SDATA
- —
- DOCNUM
- SCMPLE
- MESTYP
- —
- RCVPRN
- —
- SNDPRN
- —
- IDOCTYP
- WPUUMS
- TOTAL_QUANTITY
- 0.000
Rule Validation Summary
- Source Rule Count
- 32
- Governed Rule Count
- 32