Extraction SD Sales: Delivery Item 
: 2LIS_12_VCITM
The structure Delivery Item is used to extract item information from delivery documents into a BI system.
Note
As of SAP enhancement package 6 for SAP ERP 6.0 (SAP_APPL 606), business function Sales and Distribution, Analytics 01
(LOG_SD_ANALYTICS_01
), this DataSource also contains an ODP extractor for Operational Data Provisioning (ODP).
Therefore, you can use this DataSource both for data replication in a BW system (SAP Business Warehouse), and for search and analytics functions based on ODP.
The ODP extractor can extract the data by direct access to an ERP system, or using SAP NetWeaver Business Warehouse Accelerator (BWA) technology.
Technical Data
Application Component | Shipping (BW-BCT-LE-SHP) |
|---|---|
Available as of Release | SAP R/3 4.0 |
Shipment | PlugIn 2000_1 |
Content Versions | There are no content versions. |
RemoteCube-Capable | No |
Delta-Capable | Yes |
Extraction from Archives | Yes |
Verifiable | No |
Prerequisites
In the Logistics Extract Structures Customizing Cockpit (transaction LBWE
), you have activated the update for the data source.
Data Modeling
Delta Update
Note
The delta update is supported using the delta method ABR. Note that when a change is made to the delivery item, a delta update occurs only if one or more fields in the extraction structure are affected by the change. For more information, see SAP note 576886.
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
|
Indicator: Cancel Data Record |
||
|
Unloading Point |
|
|
|
Last Changed On |
|
|
|
Promotion |
|
|
|
Number of Deliveries |
||
|
Gross Weight of the Item |
|
|
|
Company Code |
|
|
|
Application Component |
||
|
SAP BW transaction key |
||
|
Sales District |
|
|
|
Batch Number |
|
|
|
International Article Number (EAN/UPC) |
|
|
|
Date on Which Record Was Created |
|
|
|
Name of Person who Created the Object |
|
|
|
Entry time |
|
|
|
Block |
|
|
|
Weight Unit |
|
|
|
Business Area |
|
|
|
Incoterms (Part 1) |
|
|
|
Incoterms (Part 2) |
|
|
|
Customer Group |
|
|
|
Indicator for picking control |
|
|
|
Confirmation Status of Picking/Putaway |
|
|
|
Picking Status/Putaway Status |
|
|
|
Overall Picking/Putaway Status |
|
|
|
Sold-To Party |
|
|
|
Ship-To Party |
|
|
|
Payer |
|
|
|
Customer Group 1 |
|
|
|
Customer Group 2 |
|
|
|
Customer Group 3 |
|
|
|
Customer Group 4 |
|
|
|
Customer Group 5 |
|
|
|
Consumption Posting |
|
|
|
Delivery Type |
|
|
|
Delivery Date |
|
|
|
Actual Quantity Delivered in Sales Units |
|
|
|
Actual Quantity Delivered in Stockkeeping Units |
|
|
|
Warehouse Number / Warehouse Complex |
|
|
|
Storage Location |
|
|
|
Storage Bin |
|
|
|
Storage Type |
|
|
|
Vendor Account Number |
|
|
|
Delivery Block (Document Header) |
|
|
|
Loading Point |
|
|
|
Material Group |
|
|
|
Material Number |
|
|
|
Material Entered |
|
|
|
Campaign of Referred Sales order Item for BW-Extraction |
|
|
|
Base Unit of Measure |
|
|
|
Material Group 1 |
|
|
|
Material Group 2 |
|
|
|
Material Group 3 |
|
|
|
Material Group 4 |
|
|
|
Material Group 5 |
|
|
|
Net Weight |
|
|
|
Fiscal Year Variant |
|
|
|
Bill-To Party |
|
|
|
Item type |
|
|
|
Item Number of the SD Document |
|
|
|
Work Breakdown Structure Element (WBS Element) |
|
|
|
Forwarding Agent |
|
|
|
Product Hierarchy |
|
|
|
Forwarding Agent |
|
|
|
Sales Document Item Category |
|
|
|
Sales Employee |
|
|
|
Person Responsible |
|
|
|
Route |
|
|
|
Division for Order Header |
|
|
|
Statistics Date |
|
|
|
Denominator (Divisor) for Conversion of Sales Qty into SKU |
|
|
|
Numerator (Factor) for Conversion of Sales Quantity into SKU |
|
|
|
Fixed Shipping Processing Time in Days (= Setup Time) |
|
|
|
Variable Shipping Processing Time in Days |
|
|
|
Sales and Distribution Document Number |
|
|
|
SD Document Category |
|
|
|
Date of Update for Statistics Updating |
|
|
|
Document Number of the Reference Document |
|
|
|
Item Number of the Reference Item |
|
|
|
SD Document Category |
|
|
|
Sales Office |
|
|
|
Sales Group |
|
|
|
Sales Organization |
|
|
|
Volume Unit |
|
|
|
Volume |
|
|
|
Sales Unit |
|
|
|
Shipping Point/Receiving Point |
|
|
|
Distribution Channel |
|
|
|
BW Extraction LE: Actual GI Delay - GI Date for Delivery |
||
|
Planned Goods Movement Date |
|
|
|
Actual Goods Movement Date |
|
|
|
Goods Movement Status |
|
|
|
Total Goods Movement Status |
|
|
|
Receiving Plant for Deliveries |
|
|