Aggregation Order Header 
Aggregation Order Header
Technical Name: 0SD_O03
Use
The ODS contains data on orders and complimentary orders on the basis of order headers (2LIS_11_VAHDR), as well as aggregate information on order items (0SD_C03). The update start routine ensures that only orders and complimentary orders are updated in the ODS.
The update start routines also ensure that Reverse Images are converted to After Images. In this way, the ODS does not delete any records. Instead, deleted records are marked with an indicator (0HEADER_DEL).
InfoSources
2LIS_11_VAHDR: Sales Document Header Data
2LIS_11_VASTH: Sales Document Header Status
0SD_O01: Aggregation Order Item
0SD_O02: Returns Items
Key Fields
|
Key Field |
Description |
|
0DOC_NUMBER |
Document number |
Data Fields
|
Data Field |
Description |
|
0DLV_STS |
Delivery status |
|
0DLV_STSOI |
Overall delivery status of all order items |
|
0CREATEDON |
Creation date |
|
0SOLD_TO |
Sold-to party |
|
0COMP_CODE |
Company code |
|
0CUST _GROUP |
Customer group |
|
0CUST _GRP1 |
Customer group 1 |
|
0CUST _GRP1 |
Customer group 2 |
|
0CUST _GRP3 |
Customer group 3 |
|
0CUST _GRP4 |
Customer group 4 |
|
0CUST _GRP5 |
Customer group 5 |
|
0DISTR_CHAN |
Distribution channel |
|
0SALESEMPLY |
Sales employee |
|
0SALES_GRP |
Sales group |
|
0SALES_OFF |
Sales office |
|
0SALESORG |
Sales organization |
|
0DIVISION |
Division |
|
0DOC_CURRCY |
Sales document currency |
|
0FISCVARNT |
Fiscal year variant |
|
0RECORDMODE |
Cancellation |
|
0DOC _ITEMS |
Number of order items |
|
0CUML_TME |
Cumulative lead time of all order items |
|
0DLVIEYCR |
Number of order items delivered earlier than requested delivery date |
|
0DLVVEYCR |
Value of order items delivered earlier than requested delivery date |
|
0DLVILECR |
Number of order items delivered later than requested delivery date |
|
0DLVVLECR |
Value of order items delivered later than requested delivery date |
|
0DLVIELCR |
Number of order items delivered earlier and later than requested delivery date |
|
0DLVVELCR |
Value of order items delivered earlier and later than requested delivery date |
|
0DLVIOVER |
Number of order items with overdelivery |
|
0DLVVOVER |
Value of order items with overdelivery |
|
0DLVIUNDR |
Number of order items with underdelivery |
|
0DLVVUNDR |
Value of order items with underdelivery |
|
0DITM_RET |
Number of returns items |
|
0VAL_RET |
Value of returns items |
|
0DLVIEYSC |
Number of order items delivered earlier than confirmed delivery date |
|
0DLVVEYSC |
Value of order items delivered earlier than confirmed delivery date |
|
0DLVILESC |
Number of order items delivered later than confirmed delivery date |
|
0DLVVLESC |
Value of order items delivered later than confirmed delivery date |
|
0DLVIELSC |
Number of order items delivered earlier and later than confirmed delivery date |
|
0DLVVELSC |
Value of order items delivered earlier and later than confirmed delivery date |
|
0ICOASREQ |
Number of order items confirmed as requested |
|
0VCOASREQ |
Value of order items confirmed as requested |
|
0ISHP_STCK |
Number of order items delivered ex stock |
|
0VSHP_STCK |
Value of order items delivered ex stock |
|
0DLV_24 |
Number of order items delivered within 24 hours |
|
0VAL_24 |
Value of order items delivered within 24 hours |
|
0HEADER_DEL |
Headers deleted |
Delta Update
The ODS supports a Delta update of the InfoSources 2LIS_1_VAHDR and 2LIS_11_VASTH as well as the ODS objects 0SD_O01 and 0SD_O02.