Purchasing Data (Document Schedule Line Level) 
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 |
|
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. |
|
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). |
|
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. |
|
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
|
Info Object |
Description |
Data Element |
Field in Transfer Structure |
Source |
 0MATL_GROUP |
Merchandise category |
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 |
|
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 |
|
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 in document |
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 the 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 |
|
0CONTRACT |
Number of principal agreement |
KONNR |
KONNR |
MC02M_2SCL.KONNR |
|
0COMPL_DEL |
"Inward delivery completed" indicator |
ELIKZ |
ELIKZ |
MC02M_2SCL.ELIKZ |
|
0CONT_ITEM |
Item of principal agreement |
KTPNR |
KTPNR |
MC02M_2SCL.KTPNR |
|
0LOG_SYS |
Logical system |
LOGSYSTEM |
LOGSY |
MC02M_1SCL.LOGSY |
|
0GR_BASE_IV |
GR-based invoice verification |
WEBRE |
WEBRE |
MC02M_2SCL.WEBRE |
|
0FINAL_INV |
Final invoice indicator |
EREKZ |
EREKZ |
MC02M_2SCL.EREKZ |
|
0VAL_START |
Award date |
KDATB |
KDATB |
MC02M_1SCL.KDATB |
|
0VAL_END |
End of validity period |
KDATE |
KDATE |
MC02M_1SCL.KDATE |
|
0PO_STATUS |
Status of purchasing document |
ESTAK |
STATU |
MC02M_1SCL.STATU |
|
0LOG_SYS_BE |
Logical system back end |
LOGSYSTEM |
ORGLOGSY |
MC02M_1SCL.ORGLOGSY |
|
0EVAL_R_S |
Evaluated receipt settlement (ERS) |
XERSY |
XERSY |
MC02M_2SCL.XERSY |
Time Characteristics
|
Info Object |
Description |
Data Element |
Field in Transfer Structure |
Source |
|
0FISCVARNT |
Fiscal year variant |
PERIV |
PERIV |
MC02M_0SCL.PERIV |
Units
|
Info Object |
Description |
Data Element |
Field in Transfer Structure |
Source |
|
0BASE_UOM |
Base unit of measurement |
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
|
Info Object |
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. |
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 |
| 0NETPRICE |
Net price |
NETPR |
NETPR |
MC02M_2SCL.NETPR |
| 0PRICE_UNIT |
Price unit |
PEINH |
PEINH |
MC02M_2SCL.PEINH |
| 0DLV_COSTS |
Delivery costs |
MC_BZGWR |
BZGWR |
MC02M_3SCL.BZGWR |