Show TOC

Extraction SD Sales: Document Schedule Line Allocation Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 2LIS_11_V_SCL

 

The structure Extraction SD Sales: Document Schedule Line Allocation is used to extract open quantities to be delivered from SD order schedule lines to a BI system.

Note 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). That means that you can use this DataSource both for data replication in a BW system (SAP Business Warehouse), and for search and analytics based on ODP.

The ODP extractor can extract data by direct access to an ERP system, or using SAP NetWeaver Business Warehouse Accelerator (BWA) technology.

End of the note.

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

Delta Update

In the standard system, the delta update of the data records for the extract structure MC11V_0SCL (Sales-Shipping: Allocation Schedule Line) is a combination of ABR and ADD delta methods. For more information, see MC11V_0SCL: Delta Update Without Activation of ABR Delta Method.

If the data is determined via the SAP NetWeaver Business Warehouse Accelerator (BWA), BWA indexing can only be performed correctly if you follow the entire ABR delta method.

The ABR images deliver the following data:

  • The after image delivers the data record after the change.

  • The before image delivers the data record before the change with a minus sign.

  • The reverse image also sends the data record with a minus sign, and at the same time marks it for deletion.

So that the system updates the changed data records entirely according to the ABR delta method, you must activate this function explicitly for extract structure MC11V_0SCL in Customizing for Sales and Distribution under Start of the navigation path Operational Reporting Next navigation step Activate Analytics End of the navigation path.

Note Note

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

ROCANEL

Indicator: Cancellation of the data record

ABSTA

Rejection status

VBUP

ABSTA

B_DELAY

BW extraction SD/LE: Confirmation delay

BMENG

Confirmed quantity

VBEP

BMENG

BUKRS

Company code

VBAK

BUKRS

BZIRK

Sales district

VBKD

BZIRK

CHARG

Batch number

VBAP

CHARG

EAN11

European article number (EAN)

VBAP

EAN11

EDATU

Schedule line date

VBEP

EDATU

ERDAT

Date on which record was added

VBAP

ERDAT

ETENR

Item category of schedule line

VBEP

ETENR

ETTYP

Schedule line category

VBEP

ETTYP

FAKSK

Billing type block

VBAK

FAKSK

FAKSP

Billing block item

VBAP

FAKSP

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

KUNNR

Sold-to party

VBAK

KUNNR

KURSK

Pricing exchange rate

VBKD

KURSK

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

LIFSK

Delivery note block document header

VBAK

LIFSK

LIFSP

Delivery block schedule line

VBEP

LIFSP

MATKL

Material group

VBAP

MATKL

MATNR

Material number

VBAP

MATNR

MBDAT

Material availability date

VBEP

MBDAT

MCBW_BWERT

BW: Value of confirmed quantity

MCBW_NETPR_AVKM

BW: Net price of order item sales units

MCBW_OLFWRT

BW: Open sales order value for schedule line

MCBW_VSWRT

BW: Delivery value for schedule line

MCBW_WWERT

BW: Value of requested quantity

MCEX_APCAMPAIGN

Campaign of referred sales order item for BW extraction

VBKD

CAMPAIGN

MEINS

Base unit of measure

VBAP

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

OLFMNG

Open quantity to be delivered in sales unit

PERIV

Fiscal year variant

T001

PERIV

PKUNRE

Bill-to party

VBAP

PKUNRE

PKUNRG

Payer

VBAP

PKUNRG

PKUNWE

Consignee

VBAP

PKUNWE

POSNR

Item number of the SD document

VBUP

POSNR

PRODH

Product hierarchy

VBAP

PRODH

PS_POSID

Work breakdown structure element (WBS element)

VBAP/PRPS

PS_PSP_PNR/POSID

PSPDNR

Forwarding agent

VBAP

PSPDNR

PVRTNR

Sales representative

VBAP

PVRTNR

PZPERS

Employee responsible

VBAP

PZPERS

ROUTE

Route

VBAP

ROUTE

SHKZG

Returns item

VBAP

SHKZG

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

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

VBELN

SD document number

VBUK

VBELN

VBTYP

SD document category

VBAK

VBTYP

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

VSMNG

Delivered quantity in sales unit

VSTEL

Shipping point/receiving point

VBAP

VSTEL

VTWEG

Distribution channel

VBAK

VTWEG

WADAT

Goods issue date

VBEP

WADAT

WAERK

Currency of sales and distribution document

VBAP

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

> PI 2004.1

APOPLANNED

Planning in APO

Extractor Logic

The decisive factor for extraction using DataSource 2LIS_11_V_SCL is whether the order item is relevant for delivery.

  • If the order item is not relevant for delivery, no data is extracted.

  • Fields that are determined during runtime are not saved on the database as their values are influenced by sales order and delivery processing.

    This applies in particular to the key figures Open Quantity to by Delivered (field OLFMNG) and Shipped Quantity (field VSMNG).

    The key figures are built during creation of a sales order and reduced when the order item is delivered.