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

  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.

  1. 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)

  1. 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.

  1. 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

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

0STGR_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

Material group

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

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 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

 

Time Characteristics

InfoObject

Description

Data Element

Field in Transfer Structure

Source

0FISCVARNT

Fiscal year variant

PERIV

PERIV

MC02M_0ITM.PERIV

 

Units

InfoObject

Description

Data Element

Field in Transfer Structure

Source

0PO_UNIT

Purchase order unit of measure

BSTME

MEINS

MC02M_2ITM.MEINS

0ORDER_CURR

PO currency

BSTWA

WAERS

MC02M_1ITM.WAERS

0BASE_UOM

Base unit of measure

LAGME

LMEIN

MC02M_2ITM.LMEIN

 

Key Figures

InfoObject

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

Interval for 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.

UMBSZ

UMREZ

MC02M_2ITM.UMREZ

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.

UMBSN

UMREN

MC02M_2ITM.UMREN

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

Interval for 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