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 |
... 1. 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. |
2. 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) |
3. 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. |
4. 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 |
Merchandise category |
MATKL |
MATKL |
MC02M_2SCL.MATKL |
|
0SCHED_LINE |
Schedule line number |
EETEN |
ETENR |
MC02M_3SCL.ETENR |
Vendor number |
ELIFN |
LIFNR |
MC02M_1SCL.LIFNR |
|
0SCL_DELDAT |
Planned delivery date of document schedule line |
EINDT |
EINDT |
MC02M_3SCL.EINDT |
Invoicing party |
PREST |
PREST |
MC02M_0SCL.PREST |
|
0BWAPPLNM |
Application component |
RSAPPLNM |
BWAPPLNM |
MC02M_2SCL.BWAPPLNM |
Purchasing document category |
BSTYP |
BSTYP |
MC02M_1SCL.BSTYP |
|
BW: document item number |
EBELP |
EBELP |
MC02M_2SCL.EBELP |
|
BW: document number |
EBELN |
EBELN |
MC02M_1SCL.EBELN |
|
Purchasing document type |
ESART |
BSART |
MC02M_1SCL.BSART |
|
Material number |
MATNR |
MATNR |
MC02M_2SCL.MATNR |
|
Different invoicing party |
LIFRE |
LIFRE |
MC02M_1SCL.LIFRE |
|
Supplying plant to which partner roles have been assigned |
PLIWK |
PLIWK |
MC02M_0SCL.PLIWK |
|
Schedule line date |
MC_SCL_BEDAT |
SCL_BEDAT |
MC02M_0SCL.SCL_BEDAT |
|
Schedule line time |
UZEIT |
UZEIT |
MC02M_3SCL.UZEIT |
|
Date on which the purchasing document was entered |
MC_ERFDAT |
SYDAT |
MC02M_1SCL.SYDAT |
|
0STAT_DATE |
Statistics date |
SLFDT |
SLFDT |
MC02M_3SCL.SLFDT |
Supplying vendor |
LLIEF |
LLIEF |
MC02M_1SCL.LLIEF |
|
Manufacturer part |
EMATNR |
EMATN |
MC02M_2SCL.EMATN |
|
Ordering address |
PBEST |
PBEST |
MC02M_0SCL.PBEST |
|
Vendor to whom partner roles have been assigned |
PLIEF |
PLIEF |
MC02M_0SCL.PLIEF |
|
Goods supplier |
PWLIF |
PWLIF |
MC02M_0SCL.PWLIF |
|
0STOR_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 |
Reason for ordering |
BSGRU |
BSGRU |
MC02M_2SCL.BSGRU |
|
Item category in purchasing document |
PSTYP |
PSTYP |
MC02M_2SCL.PSTYP |
|
Document date in document |
EBDAT |
BEDAT |
MC02M_1SCL.BEDAT |
|
Purchasing group |
BKGRP |
EKGRP |
MC02M_1SCL.EKGRP |
|
Plant |
EWERK |
WERKS |
MC02M_2SCL.WERKS |
|
Posting date in the document |
MC_BUDAT |
BUDAT |
MC02M_1SCL.BUDAT |
|
Batch number |
CHARG_D |
CHARG |
MC02M_3SCL.CHARG |
|
0PROCESSKEY |
BW: process key |
MCBW_VORG |
BWVORG |
MC02M_2SCL.BWVORG |
Purchasing organization |
EKORG |
EKORG |
MC02M_1SCL.EKORG |
|
Supplying plant |
RESWK |
RESWK |
MC02M_1SCL.RESWK |
|
Number of principal agreement |
KONNR |
KONNR |
MC02M_2SCL.KONNR |
|
"Inward delivery completed" indicator |
ELIKZ |
ELIKZ |
MC02M_2SCL.ELIKZ |
|
Item of principal agreement |
KTPNR |
KTPNR |
MC02M_2SCL.KTPNR |
|
Logical system |
LOGSYSTEM |
LOGSY |
MC02M_1SCL.LOGSY |
|
GR-based invoice verification |
WEBRE |
WEBRE |
MC02M_2SCL.WEBRE |
|
Final invoice indicator |
EREKZ |
EREKZ |
MC02M_2SCL.EREKZ |
|
Start of validity period |
KDATB |
KDATB |
MC02M_1SCL.KDATB |
|
End of validity period |
KDATE |
KDATE |
MC02M_1SCL.KDATE |
|
Status of purchasing document |
ESTAK |
STATU |
MC02M_1SCL.STATU |
|
Logical system backend |
LOGSYSTEM |
ORGLOGSY |
MC02M_1SCL.ORGLOGSY |
|
Evaluated receipt settlement (ERS) |
XERSY |
XERSY |
MC02M_2SCL.XERSY |
|
0ITM_UEBPO |
Superior item in purchasing documents |
UEBPO |
UEBPO |
MC02M_0SCL.UEBPO |
0ITM_USE |
Usage for superior item (subitem category) in purchasing documents |
ITMUSE |
ITMUSE |
MC02M_0SCL.ITMUSE |
0SHIP_TO |
Goods recipient |
SHIPTO |
SHIPTO |
MC02M_0SCL.SHIPTO |
0IREQUESTER |
Requester |
AFNAM |
AFNAM |
MC02M_0SCL.AFNAM |
0MATL_GROUP
Time Characteristics
InfoObject |
Description |
Data Element |
Field in Transfer Structure |
Source |
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 |
Order unit |
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 |
Number of reminders/expediters |
MAHNZ |
MAHNZ |
MC02M_3SCL.MAHNZ |
|
Effective order value |
MC_EFFWR |
BWEFFWR |
MC02M_3SCL.BWEFFWR |
|
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. |
UMBSZ |
UMREZ |
MC02M_2SCL.UMREZ |
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. |
UMBSN |
UMREN |
MC02M_2SCL.UMREN |
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 |
Net price |
NETPR |
NETPR |
MC02M_2SCL.NETPR |
|
Price unit |
PEINH |
PEINH |
MC02M_2SCL.PEINH |
|
Delivery costs |
MC_BZGWR |
BZGWR |
MC02M_3SCL.BZGWR |