Select language:

SD-DLV: Order Items

DataStore object DataStore object: /IMO/SD_D50

 

The DataStore object integrates data on orders and free-of-charge orders on the basis of the order items (DataSource 2LIS_11_VAITM) and aggregated information on order delivery schedule lines (DataSource 2LIS_11_V_SSL).

Data Sources

This DSO is updated by the following data sources:

  • Info Source Sales Document: Item Date (2LIS_11_VAITM) /IMO/SD_IS11

  • InfoSource Order Delivery (2LIS_11_V_SSL) /IMO/SD_IS17

Transformation
Info Source: Sales Document: Item Date (2LIS_11_VAITM) /IMO/SD_IS11
  • Start Routine

    The start routine for the updates ensures that only orders (0DOC_CATEG = “C”) and free-of-charge orders (0DOC_CATEG = “I”) are updated in the DataStore object.

    The start routine for the updates also ensures that reverse images (RECORDMODE = “R”) are converted to after images (RECORDMODE =  “   ”). No records are thus deleted in this DataStore object. Instead, a flag (0ITEM_DEL = “X”) is set for deleted records.

  • Field Routines

    Name Target InfoObject

    Technical Name of Target InfoObject

    Transformation Rule

    Update Date

    0UPD_DATE

    Filled with system date during the data load.

    Sales Category

    0GN_CAT_SAL

    Concatenation of Source System ID, Object Type and Material Group.

    Customer

    0GN_CUSTOM

    Concatenation of the Source System ID, Object Type and Customer.

    Product

    0PRODUCT

    Concatenation of Source System ID, Object Type and Material.

    Location

    0GN_LOCATIO

    Concatenation of Source System ID, Object Type and Plant.

    All key figures are filled with aggregation behavior “Overwrite”.

InfoSource: Sales Document: Order Delivery (2LIS_11_V_SSL) /IMO/SD_IS17
  • Start Routine

    The start routine for the updates ensures that only orders (0DOC_CATEG = “C”) and free-of-charge orders (0DOC_CATEG = “I”) are updated in the DataStore object.

    The start routine for the updates ensures that reverse images (RECORDMODE = “R”) are converted to after images (RECORDMODE = “   ”). No records are thus deleted in this DataStore Object. Instead, a flag (0ITEM_DEL = “X”) is set for deleted records.

  • Field Routines

    Name Target InfoObject

    Technical Name of Target InfoObject

    Transformation Rule

    Quantity delivered early acc. req. delivery date

    0DLVQEYCR

    Calculation of quantity delivered before requested delivery date

    Quantity Delivered Late According to Requested Delivery Date

    0DLVQLECR

    Calculation of quantity delivered after requested delivery date.

    Quantity Delivered Early According to Schedule Line Date

    0DLVQEYSC

    Calculation of quantity delivered before confirmed delivery date of schedule line.

    Quantity Delivered Late According to Schedule Line Date

    0DLVQLESC

    Calculation of quantity delivered after confirmed delivery date of schedule line.

    Quantity Confirmed as Requested

    0QCOASREQ

    Calculation of quantity confirmed as requested based on requested and confirmed quantity.

    Amount with Set GI Status

    0GIS_QTY

    If the delivery status is complete (“C”), the delivery quantity corresponds to the amount with set GI status.

    Update Date

    0UPD_DATE

    Filled with current system date.

    All key figures are filled with aggregation behavior “Summation”.

Structure

Delta Update

The following delta update is supported for this DataStore object:

  • Delta update: ABR: Complete Delta with deletion flag Via Delta Queue (Cube-Comp)

  • DataSource:

Data Modeling

Key Fields

Object Type

Name

Technical Name

Characteristic

Sales document

0DOC_NUMBER

Characteristic

Sales document item

0S_ORD_ITEM

Data Fields

Object Type

Name

Technical Name

Characteristic

Batch number

0BATCH

Characteristic

Independent of Delivery Tolerances

0BND_IND

Time characteristic

Calendar Year/Month

0CALMONTH

Time characteristic

Calendar Year/Quarter

0CALQUARTER

Time characteristic

Calendar Year/Week

0CALWEEK

Time characteristic

Calendar Year

0CALYEAR

Characteristic

Company code

0COMP_CODE

Key figure

Confirmed quantity

0CONF_QTY

Characteristic

Date on which the record was created

0CREATEDON

Characteristic

Customer Group

0CUST_GROUP

Characteristic

Customer Group 1

0CUST_GRP1

Characteristic

Customer Group 2

0CUST_GRP2

Characteristic

Customer Group 3

0CUST_GRP3

Characteristic

Customer Group 4

0CUST_GRP4

Characteristic

Customer Group 5

0CUST_GRP5

Characteristic

Distribution Channel

0DISTR_CHAN

Characteristic

Division

0DIVISION

Key figure

Quantity delivered early acc. req. delivery date

0DLVQEYCR

Key figure

Quantity Delivered Early acc. Schedule Line Date

0DLVQEYSC

Key figure

Quantity delivered late acc. req. delivery date

0DLVQLECR

Key figure

Quantity delivered late acc. schedule line date

0DLVQLESC

Key figure

Actual quantity delivered (in sales units)

0DLV_QTY

Characteristic

Delivery Status

0DLV_STS

Characteristic

Overall delivery status of the item

0DLV_STSO

Unit of measurement

Document currency

0DOC_CURRCY

Time characteristic

Fiscal year variant

0FISCVARNT

Characteristic

Forw.Agent

0FORWAGENT

Key figure

Amount with Set GI Status

0GIS_QTY

Characteristic

Sales Category

0GN_CAT_SAL

Characteristic

Customer

0GN_CUSTOM

Characteristic

Location

0GN_LOCATIO

Characteristic

Source System for R/3 Entity

0GN_R3_SSY

Characteristic

Item Deleted

0ITEM_DEL

Key figure

Tolerance Limit for Under Delivery in %

0LOWR_BND

Characteristic

Last Actual Goods Issue Date of an Order Item

0LST_A_GD

Characteristic

Lowest GI Status of an Order Item

0LW_GISTS

Characteristic

Material

0MATERIAL

Characteristic

Material group

0MATL_GROUP

Characteristic

Material group 1

0MATL_GRP_1

Characteristic

Material group 2

0MATL_GRP_2

Characteristic

Material group 3

0MATL_GRP_3

Characteristic

Material group 4

0MATL_GRP_4

Characteristic

Material group 5

0MATL_GRP_5

Key figure

Net Price per 1*VKME

0NETPR_VKM

Key figure

Net price

0NET_PRICE

Characteristic

Payer

0PAYER

Characteristic

Plant

0PLANT

Characteristic

Planned Goods Issue Date of a Confirmed Scheule Line

0PLD_GI_DTE

Characteristic

Product

0PRODUCT

Characteristic

Product hierarchy

0PROD_HIER

Key figure

Quantity Confirmed as Requested

0QCOASREQ

Data packet characteristic

BW Delta Process: Update Mode

0RECORDMODE

Key figure

Desired Delivery Quantity

0REQU_QTY

Characteristic

Sales Representative

0SALESEMPLY

Characteristic

Sales Organization

0SALESORG

Characteristic

Sales group

0SALES_GRP

Characteristic

Sales Office

0SALES_OFF

Unit of measurement

Sales unit

0SALES_UNIT

Characteristic

Shipping Point

0SHIP_POINT

Characteristic

Delivery from Warehouse

0SHIP_STCK

Characteristic

Ship-To Party

0SHIP_TO

Characteristic

Sold-to party

0SOLD_TO

Characteristic

Update Date

0UPD_DATE

Key figure

Tolerance Limit for Over Delivery in %

0UPPR_BND