Extraction SD Sales: Document Schedule Line

DataSource Transactional Data: 2LIS_11_VASCL

The structure Extraction SD Sales: Document Schedule Line is used to extract schedule line information from SD orders and quotations (but not requests) to a BI system.

Technical Data

Application Component	SD Sales (BW-BCT_SD-SLS)
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

Data Modeling

Delta Update

Note Note

The delta update is supported using the delta method ABR. Note that when a change is made to the sales document, 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.

End of the note.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`ROCANCEL`	Indicator: Cancellation of the data record
`ABGRU`	Reason for rejection for quotations and orders	`VBAP`	`ABGRU`
`ABSTA`	Rejection status of sales document item	`VBUP`	`ABSTA`
`AEDAT`	Last date on which object was changed	`VBAP`	`AEDAT`
`ANGDT`	Quotation/request valid from	`VBAK`	`ANGDT`
`AUART`	Sales document type	`VBAK`	`AUART`
`AUGRU`	Order reason (reason for transaction)	`VBAK`	`AUGRU`
`AWAHR`	Sales probability for item	`VBAP`	`AWAHR`
`BMENG`	Confirmed quantity	`VBEP`	`BMENG`
`BNDDT`	Binding period of quotation for service performance (valid to)	`VBAK`	`BNDDT`
`BUKRS`	Company code	`VBAK`	`BUKRS`
`BZIRK`	Sales district	`VBKD`	`BZIRK`
`CHARG`	Batch number	`VBAP`	`CHARG`
`CMENG`	Corrected quantity in sales units	`VBEP`	`CMENG`
`CMKUA`	Exchange rate for credit data on requested delivery date	`VBAP`	`CMKUA`
`EAN11`	European article number (EAN)	`VBAP`	`EAN11`
`EDATU`	Schedule line date	`VBEP`	`EDATU`
`ERDAT`	Date on which record was added	`VBAP`	`ERDAT`
`ERNAM`	Name of person who added the object	`VBAP`	`ERNAM`
`ERZET`	Time of entry	`VBAP`	`ERZET`
`ETENR`	Item category of schedule line	`VBEP`	`ETENR`
`ETTYP`	Schedule line category	`VBEP`	`ETTYP`
`FAKSK`	Billing type block sales and distribution document	`VBAK`	`FAKSK`
`FAKSP`	Billing block item	`VBAP`	`FAKSP`
`FBUDA`	Date of services rendered	`VBKD`	`FBUDA`
`FKDAT`	Billing date for billing index and print	`VBKD`	`FKDAT`
`GEWEI`	Weight unit	`VBAP`	`GEWEI`
`HWAER`	Local currency	`VBAK`	`HWAER`
`INCO1`	Incoterms 1	`VBKD`	`INCO1`
`INCO2`	Incoterms 2	`VBKD`	`INCO2`
`KDGRP`	Customer group	`VBKD`	`KDGRP`
`KMEIN`	Condition unit	`VBAP`	`KMEIN`
`KPEIN`	Condition pricing unit	`VBAP`	`KPEIN`
`KTGRD`	Customer account assignment group	`VBKD`	`KTGRD`
`KUNNR`	Sold-to party	`VBAK`	`KUNNR`
`KURSK`	Pricing exchange rate	`VBKD`	`KURSK`
`KURSK_DAT`	Conversion date	`VBKD`	`PRSDT`
`KURST`	Exchange rate type	`VBAK`	`KURST`
`KVGR1`	Customer group 1	`VBAK`	`KVGR1`
`KVGR2`	Customer group 2	`VBAK`	`KVGR2`
`KVGR3`	Customer group 3	`VBAK`	`KVGR3`
`KVGR4`	Customer group 4	`VBAK`	`KVGR4`
`KVGR5`	Customer group 5	`VBAK`	`KVGR5`
`LDDAT`	Loading date	`VBEP`	`LDDAT`
`LGORT`	Storage location	`VBAP`	`LGORT`
`LIFSK`	Delivery note block document header	`VBAK`	`LIFSK`
`LIFSP`	Delivery block schedule line	`VBEP`	`LIFSP`
`LMENG`	Requirement quantity for materials management in stockkeeping units	`VBEP`	`LMENG`
`MATKL`	Material group	`VBAP`	`MATKL`
`MATNR`	Material number	`VBAP`	`MATNR`
`MATWA`	Material entered	`VBAP`	`MATWA`
`MBDAT`	Material availability date	`VBEP`	`MBDAT`
`MCEX_APCAMPAIGN`	Campaign of referred sales order item for BW extraction	`VBKD`	`CAMPAIGN`
`MEINS`	Base unit of measure	`VBEP`	`MEINS`
`MVGR1`	Material group 1	`VBAP`	`MVGR1`
`MVGR2`	Material group 2	`VBAP`	`MVGR2`
`MVGR3`	Material group 3	`VBAP`	`MVGR3`
`MVGR4`	Material group 4	`VBAP`	`MVGR4`
`MVGR5`	Material group 5	`VBAP`	`MVGR5`
`NETPR`	Net price	`VBAP`	`NETPR`
`PABLA`	Unloading point for ship-to party	`VBAP`	`PABLA`
`PERIV`	Fiscal year variant	`T001`	`PERIV`
`PKUNRE`	Bill-to-party	`VBAP`	`PKUNRE`
`PKUNRG`	Payer	`VBAP`	`PKUNRG`
`PKUNWE`	Ship-to Party	`VBAP`	`PKUNWE`
`POSNR`	Item number of sales document	`VBUP`	`POSNR`
`PRODH`	Product hierarchy	`VBAP`	`PRODH`
`PRSDT`	Date for pricing and exchange rate	`VBKD`	`PRSDT`
`PS_POSID`	Work breakdown structure element (WBS element)	`VBAP/PRPS`	`PS_PSP_PNR/POSID`
`PSPDNR`	Forwarding agent	`VBAP`	`PSPDNR`
`PSTYV`	Item category sales and distribution document	`VBAP`	`PSTYV`
`PVRTNR`	Sales representative	`VBAP`	`PVRTNR`
`ROUTE`	Route	`VBAP`	`ROUTE`
`SPARA`	Division order header	`VBAK`	`SPART`
`SPART`	Division	`VBAP`	`SPART`
`STADAT`	Statistics date	`VBAP`	`STADAT`
`STCUR`	Exchange rate for statistics (exchange rate upon creation)	`VBAP`	`STCUR`
`STWAE`	Statistics currency	`VBAK`	`STWAE`
`SUGRD`	Reason for material substitution	`VBAP`	`SUGRD`
`TDDAT`	Transportation planning date	`VBEP`	`TDDAT`
`UMVKN`	Denominator for conversion of sales quantity into SKU	`VBAP`	`UMVKN`
`UMVKZ`	Numerator for conversion of sales quantity into SKU	`VBAP`	`UMVKZ`
`UMZIN`	Denominator for conversion factor of target quantity to storage quantity	`VBAP`	`UMZIN`
`UMZIZ`	Numerator for conversion factor of target quantity to storage quantity	`VBAP`	`UZIZ`
`UVALL`	Incompleteness status of general item	`VBUP`	`UVALL`
`UVFAK`	Incompleteness status of item in relation to billing document	`VBUP`	`UVFAK`
`UVPRS`	Item incomplete in relation to pricing	`VBUP`	`UVPRS`
`UVVLK`	Incompleteness status of item in relation to delivery	`VBUP`	`UVVLK`
`VBELN`	Sales and distribution document number	`VBUK`	`VBELN`
`VBTYP`	Sales document category	`VBAK`	`VBTYP`
`VDATU`	Update date for statistics update	`VBAP`	`VDATU`
`VGTYP`	Preceding sales document category	`VBAP`	`VGTYP`
`VGTYP_AK`	Sales document category of reference document in the order header	`VBAK`	`VGTYP`
`VKBUR`	Sales office	`VBAK`	`VKBUR`
`VKGRP`	Sales group	`VBAK`	`VKGRP`
`VKORG`	Sales organization	`VBAK`	`VKORG`
`VOLEH`	Volume unit	`VBAP`	`VOLEH`
`VRKME`	Sales unit	`VBEP`	`VRKME`
`VSTEL`	Shipping point/goods receiving point	`VBAP`	`VSTEL`
`VTWEG`	Distribution channel	`VBAK`	`VTWEG`
`WADAT`	Goods issue date	`VBEP`	`WADAT`
`WAERK`	Currency of sales and distribution document	`VBAP`	`WAERK`
`WAERK_VBAK`	Currency of sales and distribution document	`VBAK`	`WAERK`
`WERKS`	Plant	`VBAP`	`WERKS`
`WLDATBE`	Requested delivery date in confirmed schedule lines	`VBEP`	`WLDATBE`
`WMENG`	Order quantity for customer in sales units	`VBEP`	`WMENG`
`ZIEME`	Target quantity unit of measure	`VBAP`	`ZIEME`
`> PI 20004.1`
`APOPLANNED`	Planning in APO
`FACELOC`	Customer-facing location
`FLOCTYPE`	Type of customer-facing location
`EXECLOC`	Executing location
`ELOCTYPE`	Type of executing location
`LOGSYS`	Logical system
`VWPOS`	Item usage
`STOCKLOC`	First stockholding location
`SLOCTYPE`	Type of first stockholding location

Extractor Logic

Determination of Update Date for Statistics Update (VDATU):

The update date for the statistics update is filled in the delta update with the local date of the user (SY-DATLO).

In reorganization, VDATU is filled with the creation date of the SD document (XVBAP-ERDAT).

ROCANCEL - Cancellation of the data record

This field can have the following values:

“Blank” — New data record or after image
“X” — Cancellation of data record or before image
“R” — Deletion of data record