Purchasing Data (Document Schedule Line Level) (SAP Library

Purchasing Data (Document Schedule Line Level)

Technical name: 2LIS_02_SCL

Use

In combination with the InfoSources Purchasing Data (Document Header Level) and Purchasing Data (Document Item Level, the InfoSource Purchasing Data (Document Schedule Line Level) supplies the basic data for analyses of purchasing documents.

Prerequisites

If you wish to use this InfoSource, you must make the following settings in the Implementation Guide (IMG) for the OLTP system:

You need only carry out this step if you...	Steps	Path in IMG of OLTP system
are working with an Industry Business Solution	Choose an industry.	Customer-Defined DataSource ® Logistics ® Settings for Purchasing ® Specify Industry.
wish to transmit data on other processes to the BW Content in addition to the standard processes.	Maintain process keys in order for your data to be interpreted correctly in the BW Content.	Customer-Defined DataSource ® Logistics ® Settings for Purchasing ® Maintain Process Keys for SAP BW.
wish to include additional fields (the extract structures defined in the standard system are insufficient for your needs)	Supplement the existing extract structures by adding the desired fields.	Customer-Defined DataSource ® Logistics ® Management of Extract Structures ® Logistics Extract Structures Customizing Cockpit
This step is mandatory in order to make an initial dataset available for the BW Content.	Have the tables for the extract structure recompiled in order to make the desired data available to the BW Content.	Customer-Defined DataSource ® Logistics ® Management of Extract Structures ® Initialization ® Fill Recompiled Tables ® Application-Specific Recompilation ® Purchasing – Carry Out Recompilation.

For more information on this topic, refer to the documentation of these IMG activities in the Implementation Guide for the OLTP system.

Characteristics

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0MATL_GROUP	Material group	MATKL	MATKL	MC02M_2SCL.MATKL
0SCHED_LINE	Schedule line number	EETEN	ETENR	MC02M_3SCL.ETENR
0VENDOR	Vendor number	ELIFN	LIFNR	MC02M_1SCL.LIFNR
0SCL_DELDAT	Planned delivery date of document schedule line	EINDT	EINDT	MC02M_3SCL.EINDT
0INV_PARTY	Invoicing party	PREST	PREST	MC02M_0SCL.PREST
0BWAPPLNM	Application component	RSAPPLNM	BWAPPLNM	MC02M_2SCL.BWAPPLNM
0DOC_CAT	Purchasing document category	BSTYP	BSTYP	MC02M_1SCL.BSTYP
0DOC_ITEM	BW: document item number	EBELP	EBELP	MC02M_2SCL.EBELP
0DOC_NUM	BW: document number	EBELN	EBELN	MC02M_1SCL.EBELN
0DOCTYPE	Purchasing document category	ESART	BSART	MC02M_1SCL.BSART
0MATERIAL	Material number	MATNR	MATNR	MC02M_2SCL.MATNR
0INV_PTY	Different invoicing party	LIFRE	LIFRE	MC02M_1SCL.LIFRE
0SUP_PLANT	Supplying plant to which partner roles have been assigned	PLIWK	PLIWK	MC02M_0SCL.PLIWK
0SCHED_DATE	Schedule line date	MC_SCL_BEDAT	SCL_BEDAT	MC02M_0SCL.SCL_BEDAT
0SCHED_TIME	Schedule line time	UZEIT	UZEIT	MC02M_3SCL.UZEIT
0ENTRY_DATE	Date on which the purchasing document was entered	MC_ERFDAT	SYDAT	MC02M_1SCL.SYDAT
0STAT_DATE	Statistics date	SLFDT	SLFDT	MC02M_3SCL.SLFDT
0SUPPL_VEND	Supplying vendor	LLIEF	LLIEF	MC02M_1SCL.LLIEF
0MPN_MATNR	Manufacturer part	EMATNR	EMATN	MC02M_2SCL.EMATN
0ORD_ADDR	Ordering address	PBEST	PBEST	MC02M_0SCL.PBEST
0PARTNER	Vendor to whom partner roles have been assigned	PLIEF	PLIEF	MC02M_0SCL.PLIEF
0SUPPLIER	Goods supplier	PWLIF	PWLIF	MC02M_0SCL.PWLIF
0STGR_LOC	Storage location	LGORT_D	LGORT	MC02M_2SCL.LGORT
0STORNO	Cancellation/reversal indicator	ROCANCEL	ROCANCEL	MC02M_0SCL.ROCANCEL
0RT_PROMO	Promotion	WAKTION	AKTNR	MC02M_2SCL.AKTNR
0PUR_REASON	Reason for ordering	BSGRU	BSGRU	MC02M_2SCL.BSGRU
0ITM_CAT	Item category in purchasing document	PSTYP	PSTYP	MC02M_2SCL.PSTYP
0DOC_DATE	Document date	EBDAT	BEDAT	MC02M_1SCL.BEDAT
0PUR_GROUP	Purchasing group	BKGRP	EKGRP	MC02M_1SCL.EKGRP
0PLANT	Plant	EWERK	WERKS	MC02M_2SCL.WERKS
0PSTNG_DATE	Posting date in document	MC_BUDAT	BUDAT	MC02M_1SCL.BUDAT
0BATCH	Batch number	CHARG_D	CHARG	MC02M_3SCL.CHARG
0PROCESSKEY	BW: process key	MCBW_VORG	BWVORG	MC02M_2SCL.BWVORG
0PURCH_ORG	Purchasing organization	EKORG	EKORG	MC02M_1SCL.EKORG
0SUPP_PLANT	Supplying plant	RESWK	RESWK	MC02M_1SCL.RESWK

Time Characteristics

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0FISCVARNT	Fiscal year variant	PERIV	PERIV	MC02M_0SCL.PERIV

Units

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0BASE_UOM	Base unit of measure	LAGME	LMEIN	MC02M_2SCL.LMEIN
0LOC_CURRCY	Local currency	HWAER	HWAER	MC02M_1SCL.HWAER
0PO_UNIT	Purchase order unit of measure	BSTME	MEINS	MC02M_2SCL.MEINS
0ORDER_CURR	PO currency	BSTWA	WAERS	MC02M_1SCL.WAERS

Key Figures

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0NO_RMDRS	Number of reminders/expediters	MAHNZ	MAHNZ	MC02M_3SCL.MAHNZ
0ORDER_VAL	Effective order value	MC_EFFWR	BWEFFWR	MC02M_3SCL.BWEFFWR
0NO_SCL	Counter for scheduling agreement schedule lines	MC_NOSCL	NOSCL	MC02M_0SCL.NOSCL
0CPDEOGPVOC	Delta PO/GR PP excl. tax	MCW_DBWGEO	DBWGEO	MC02M_3SCL.DBWGEO
0CPPVLC	BW: purchase value in local currency	MCBW_GEO	BWGEO	MC02M_3SCL.BWGEO
0CPPVOC	BW: purchase value in order currency	MCBW_GEOO	BWGEOO	MC02M_3SCL.BWGEOO
0CPQUAOU	BW: quantity in order unit	MCBW_MBE	BWMNG	MC02M_3SCL.BWMNG
0CPSTLC	BW: SalesWmS in local currency	MCBW_GVP	BWGVP	MC02M_3SCL.BWGVP
0CPSVLC	BW: sales value in local currency	MCBW_GVO	BWGVO	MC02M_3SCL.BWGVO
0SUBTOT_OC1	Subtotal 1	KZWI1	BWKZWI1	MC02M_3SCL.BWKZWI1
0NUMERATOR	Numerator for conversion of sales unit into SKU.	UMBSN	UMREN	MC02M_2SCL.UMREN
0PUR_GROVAL	Gross order value in order currency	MC_BBRTWR	BWBRTWR	MC02M_3SCL.BWBRTWR
0EXCHG_RATE	Currency exchange rate for price determination and statistics	WKURS	WKURS	MC02M_1SCL.WKURS
0DENOMINTR	Denominator for conversion of sales unit into SKU.	UMBSZ	UMREZ	MC02M_2SCL.UMREZ
0CPDEOGQUOU	Delta PO/GR order quantity	MCW_DBWMNG	DBWMNG	MC02M_3SCL.DBWMNG
0SUBTOT_OC6	Subtotal 6	KZWI6	BWKZWI6	MC02M_3SCL.BWKZWI6
0SUBTOT_OC5	Subtotal 5	KZWI5	BWKZWI5	MC02M_3SCL.BWKZWI5
0SUBTOT_OC4	Subtotal 4	KZWI4	BWKZWI4	MC02M_3SCL.BWKZWI4
0SUBTOT_OC3	Subtotal 3	KZWI3	BWKZWI3	MC02M_3SCL.BWKZWI3
0SUBTOT_OC2	Subtotal 2	KZWI2	BWKZWI2	MC02M_3SCL.BWKZWI2