Purchasing Data (Document Item Level)
Purchasing Data (Document Item Level)
Technical name: 2LIS_02_ITM
Use
In combination with the InfoSources
Purchasing Data (Document Header Level) and Purchasing Data (Document Schedule Line Level, the InfoSource Purchasing Data (Document Item 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 |
 0INV_PARTY |
Invoicing party |
PREST |
PREST |
MC02M_0ITM.PREST |
|
0INV_PTY |
Different invoicing party |
LIFRE |
LIFRE |
MC02M_1ITM.LIFRE |
|
0ITEM_COUNT |
Indicator: item counter |
MC_KZPOS |
KZPOS |
MC02M_2ITM.KZPOS |
|
0MPN_MATNR |
Manufacturer part |
EMATNR |
EMATN |
MC02M_2ITM.EMATN |
|
0VENDOR |
Vendor number |
ELIFN |
LIFNR |
MC02M_1ITM.LIFNR |
|
0PUR_REASON |
Reason for ordering |
BSGRU |
BSGRU |
MC02M_2ITM.BSGRU |
|
0RT_PROMO |
Promotion |
WAKTION |
AKTNR |
MC02M_2ITM.AKTNR |
|
0STORNO |
Cancellation/reversal indicator |
ROCANCEL |
ROCANCEL |
MC02M_0ITM.ROCANCEL |
|
0STOR_LOC |
Storage location |
LGORT_D |
LGORT |
MC02M_2ITM.LGORT |
|
0SUPP_PLANT |
Supplying plant |
RESWK |
RESWK |
MC02M_1ITM.RESWK |
|
0SUPPLIER |
Goods supplier |
PWLIF |
PWLIF |
MC02M_0ITM.PWLIF |
|
0SUPPL_VEND |
Supplying vendor |
LLIEF |
LLIEF |
MC02M_1ITM.LLIEF |
|
0SUP_PLANT |
Supplying plant to which partner roles have been assigned |
PLIWK |
PLIWK |
MC02M_0ITM.PLIWK |
|
0DOC_TIME |
Time at which document was created |
UZEIT |
UZEIT |
MC02M_0ITM.UZEIT |
|
0ENTRY_DATE |
Date on which the purchasing document was entered |
MC_ERFDAT |
SYDAT |
MC02M_1ITM.SYDAT |
|
0ORD_ADDR |
Ordering address |
PBEST |
PBEST |
MC02M_0ITM.PBEST |
|
0PARTNER |
Vendor to whom partner roles have been assigned |
PLIEF |
PLIEF |
MC02M_0ITM.PLIEF |
|
0QTY_DEV |
Indicator: quantity variance relevant |
MC_KZMAB |
KZMAB |
MC02M_2ITM.KZMAB |
|
0SCHED_DEV |
Indicator: delivery date variance |
MC_KZTAB |
KZTAB |
MC02M_2ITM.KZTAB |
|
0MATL_GROUP |
Merchandise category |
MATKL |
MATKL |
MC02M_2ITM.MATKL |
|
0MATERIAL |
Material number |
MATNR |
MATNR |
MC02M_2ITM.MATNR |
|
0ITM_CAT |
Item category in purchasing document |
PSTYP |
PSTYP |
MC02M_2ITM.PSTYP |
|
0DOC_CAT |
Purchasing document category |
BSTYP |
BSTYP |
MC02M_1ITM.BSTYP |
|
0DOC_DATE |
Document date in document |
EBDAT |
BEDAT |
MC02M_1ITM.BEDAT |
|
0DOCTYPE |
Purchasing document category |
ESART |
BSART |
MC02M_1ITM.BSART |
|
0DOC_NUM |
BW: document number |
EBELN |
EBELN |
MC02M_1ITM.EBELN |
|
0DOC_ITEM |
BW: document item number |
EBELP |
EBELP |
MC02M_2ITM.EBELP |
|
0BWAPPLNM |
Application component |
RSAPPLNM |
BWAPPLNM |
MC02M_2ITM.BWAPPLNM |
|
0PROCESSKEY |
BW: process key |
MCBW_VORG |
BWVORG |
MC02M_2ITM.BWVORG |
|
0PSTNG_DATE |
Posting date in the document |
MC_BUDAT |
BUDAT |
MC02M_1ITM.BUDAT |
|
0PLANT |
Plant |
EWERK |
WERKS |
MC02M_2ITM.WERKS |
|
0PUR_GROUP |
Purchasing group |
BKGRP |
EKGRP |
MC02M_1ITM.EKGRP |
|
0PURCH_ORG |
Purchasing organization |
EKORG |
EKORG |
MC02M_1ITM.EKORG |
|
0GR_BASE_IV |
GR-based invoice verification |
WEBRE |
WEBRE |
MC02M_2ITM.WEBRE |
|
0LOG_SYS |
Logical system |
LOGSYSTEM |
LOGSY |
MC02M_1ITM.LOGSY |
|
0LOG_SYS_BE |
Logical system back end |
LOGSYSTEM |
ORGLOGSY |
MC02M_1ITM.ORGLOGSY |
|
0PO_STATUS |
Status of purchasing document |
ESTAK |
STATU |
MC02M_1ITM.STATU |
|
0VAL_END |
End of validity period |
KDATE |
KDATE |
MC02M_1ITM.KDATE |
|
0VAL_START |
Award date |
KDATB |
KDATB |
MC02M_1ITM.KDATB |
|
0FINAL_INV |
Final invoice indicator |
EREKZ |
EREKZ |
MC02M_2ITM.EREKZ |
|
0COMPL_DEL |
"Inward delivery completed" indicator |
ELIKZ |
ELIKZ |
MC02M_2ITM.ELIKZ |
|
0CONTRACT |
Number of principal agreement |
KONNR |
KONNR |
MC02M_2ITM.KONNR |
|
0CONT_ITEM |
Item of principal agreement |
KTPNR |
KTPNR |
MC02M_2ITM.KTPNR |
|
0EVAL_R_S |
Evaluated receipt settlement (ERS) |
XERSY |
XERSY |
MC02M_2ITM.XERSY |
Time Characteristics
|
Info Object |
Description |
Data Element |
Field in Transfer Structure |
Source |
|
0FISCVARNT |
Fiscal year variant |
PERIV |
PERIV |
MC02M_0ITM.PERIV |
Units
|
Info Object |
Description |
Data Element |
Field in Transfer Structure |
Source |
|
0PO_UNIT |
Order unit |
BSTME |
MEINS |
MC02M_2ITM.MEINS |
|
0ORDER_CURR |
PO currency |
BSTWA |
WAERS |
MC02M_1ITM.WAERS |
|
0BASE_UOM |
Base unit of measurement |
LAGME |
LMEIN |
MC02M_2ITM.LMEIN |
|
0LOC_CURRCY |
Local currency |
HWAER |
HWAER |
MC02M_1ITM.HWAER |
Key Figures
|
Info Object |
Description |
Data Element |
Field in Transfer Structure |
Source |
| 0SHP_INS |
Points score for compliance with shipping instructions |
MC_PWEV |
PWEV |
MC02M_2ITM.PWEV |
| 0SRV_TIME |
Score for timeliness of service provision |
MC_PWFR |
PWFR |
MC02M_2ITM.PWFR |
| 0SRV_QUAL |
Score for quality of service provision |
MC_PWWE |
PWWE |
MC02M_2ITM.PWWE |
| 0SMOOTH_SHP |
Smoothing factor for compliance with shipping instructions |
VVABW |
VVABW |
MC02M_0ITM.VVABW |
| 0SMOOTH_DEL |
Smoothing factor for date variance |
LFABW |
LFABW |
MC02M_0ITM.LFABW |
| 0DELIVERIES |
Number of deliveries |
MC_ALIEF |
ALIEF |
MC02M_2ITM.ALIEF |
| 0BEST_SCORE |
Best score |
BEWERX |
MAXBW |
MC02M_0ITM.MAXBW |
| 0SMOOTH_QTY |
Smoothing factor for quantity variance |
MGABW |
MGABW |
MC02M_0ITM.MGABW |
| 0NO_POS |
Counter for items |
MC_NOPOS |
NOPOS |
MC02M_0ITM.NOPOS |
| 0TIME_INT |
Window of time grid |
MC_TIME_INT |
TIME_INT |
MC02M_0ITM.TIME_INT |
| 0TARG_QTY |
Target quantity |
KTMNG |
KTMNG |
MC02M_2ITM.KTMNG |
|
0DENOMINTR |
Denominator for conversion of sales unit into SKU. |
UMBSN |
UMREN |
MC02M_2ITM.UMREN |
| 0SHIP_NOT |
Points score for shipping notification (GR date – notified date) |
MC_LAVI |
LAVI |
MC02M_2ITM.LAVI |
| 0NO_TIME |
Counter for time grid |
MC_NOTIME |
NOTIME |
MC02M_0ITM.NOTIME |
| 0NO_QUAN |
Counter for quantity grid |
MC_NOQUAN |
NOQUAN |
MC02M_0ITM.NOQUAN |
|
0NUMERATOR |
Numerator for conversion of sales unit into SKU. |
UMBSZ |
UMREZ |
MC02M_2ITM.UMREZ |
| 0DEL_DEVTN |
Delivery date variance in days |
MC_TABW |
TABW |
MC02M_2ITM.TABW |
| 0CURR_GRQTY |
Current goods receipt quantity in order unit |
MC_AKTWE |
AKTWE |
MC02M_2ITM.AKTWE |
| 0TOTDELTIME |
Total delivery time in days |
MC_LFZTA |
LFZTA |
MC02M_2ITM.LFZTA |
| 0ONT_DEL |
Points score for on-time delivery performance |
MC_PWTT |
PWTT |
MC02M_2ITM.PWTT |
| 0QTY_VAR |
Delivery quantity variance in % |
MC_MABW |
MABW |
MC02M_2ITM.MABW |
| 0QTY_REL |
Points score for quantity reliability |
MC_PWMT |
PWMT |
MC02M_2ITM.PWMT |
| 0QUAN_INT |
Window of quantity grid |
MC_QUAN_INT |
QUAN_INT |
MC02M_0ITM.QUAN_INT |
|
0EXCHG_RATE |
Currency exchange rate for price determination and statistics |
WKURS |
WKURS |
MC02M_1ITM.WKURS |
| 0OUTAGTARGT |
Target value for outline agreement in document currency |
ZWERT |
ZWERT |
MC02M_2ITM.ZWERT |
| 0ORDER_QUAN |
PO quantity |
BSTMG |
MENGE |
MC02M_2ITM.MENGE |
| 0PRICE_UNIT |
Price unit |
PEINH |
PEINH |
MC02M_2ITM.PEINH |
| 0NETPRICE |
Net price |
NETPR |
NETPR |
MC02M_2ITM.NETPR |