Purchasing Data (Item Level) 

Technical name: 2LIS_02_ITM

Technical Data

Type of DataSource	Transaction Data (Movement Data)
Application Component	Materials Management (MM)
Available as of OLTP Release	SAP R/3 4.0B
Available as of Plug-In Release	PI 2000.1
RemoteCube Compatibility	no

Prerequisites

Activation of the DataSource.

Use

The DataSource is used to extract the basic data for analyses of purchasing documents consistently to a BW system.

Delta Update

A delta update is supported. Delta process: ABR – Complete delta update with deletion indicator using delta queue (Cube-compatible).

Fields of Origin in the Extraction Structure

Field in Extraction Structure	Description of Field in Extraction Structure	Table of Origin	Field in Table of Origin
BEDAT	Date of Purchasing Document	EKKO	BEDAT
BSART	Purchasing Document Category	EKKO	BSART
BSTYP	Purchasing Document Category	EKKO	BSTYP
BUDAT	Posting Date of Goods Receipt or Invoice Receipt for the Purchase Order	EKKO / EKBE	BUDAT
EBELN	Document Number of Purchasing Document	EKKO	EBELN
EKGRP	Purchasing Group	EKKO	EKGRP
EKORG	Purchasing Organization	EKKO	EKORG
HWAER	Local Currency	T001	WAERS
KDATB	Validity Period Start Date	EKKO	KDATB
KDATE	End of Validity Period	EKKO	KDATE
LBLIF	Field is not used	EKKO	LBLIF
LIFNR	Vendor’s Account Number	EKKO / T001W	LIFNR
LIFRE	Different Invoicing Party	EKKO	LIFRE
LLIEF	Supplying Vendor	EKKO	LLIEF
LOGSY	Logical System	EKKO	LOGSY
ORGLOGSY	Logical System
RESWK	Issuing Plant for Stock Transport Order	EKKO	REWK
STATU	Status of Purchasing Document	EKKO	STATU
SYDAT	Purchasing Document Creation Date	EKKO / EKBE	BEDAT
WAERS	PO Currency	EKKO	WAERS
WKURS	Exchange Rate	EKKO	WKURS
AFNAM	Name of Requester	EKPO	AFNAM
AKTNR	Action	EKPO	AKTNR
AKTWE	Current Goods Receipt Quantity in PO Unit	EKBE	MENGE
ALAV	Points Score for Shipping Notification (GR Date – Notified Date)	calculated
ALIEF	Number of Deliveries	counted
BSGRU	Reason for Ordering	EKPO	BSGRU
BWAPPLNM	Application Component	TMCLVBW	APPLNM
BWVORG	SAP BW - Transaction Key	hard-coded
EBELP	Item Number of Purchasing Document	EKPO	EBELP
ELIKZ	Final Delivery Indicator	EKPO	ELIKZ
EMATN	Material Number	EKPO	EMATN
EREKZ	Final Invoice Indicator	EKPO	EREKZ
KONNR	Number of Principal Agreement	EKPO	KONNR
KTMNG	Target Quantity	EKPO	KTMNG
KTPNR	Item Number of Principal Agreement	EKPO	KTPNR
KZMAB	Quantity Variance Relevant	hard-coded
KZPOS	Item Counter Relevant (R/2 -> R/3 Linkage, Only LP)
KZTAB	Date Variance Relevant	hard-coded
LAVI	Points Score: Shipping Notification
LFZTA	Total Delivery Time in Days	calculated
LGORT	Storage Location	EKPO	LGORT
LMEIN	Base Unit of Measure	EKPO	LMEIN
MABW	Delivery Quantity Variance in %	calculated
MATKL	Material Group	EKPO	MATKL
MATNR	Material Number	EKPO	MATNR
MEINS	PO Unit	EKPO	MEINS
MENGE	PO Quantity	EKPO	MENGE
NETPR	Net Price	calculated
NETWR	Net Purchase Order Value in Order Currency	EKPO	NETWR
PEINH	Price Unit	EKPO	PEINH
PSTYP	Item Category in Purchasing Document	EKPO	PSTYP
PWEV	Points Score for Compliance with Shipping Instructions	T027C	EVPKT
PWFR	Score for Timeliness of Service Provision	ESSR	PWFR
PWMT	Points Score for Quantity Reliability	T147K	KRPKT
PWTT	Points Score for On-Time Delivery Performance	T147K	KRPKT
PWWE	Score for Quality of Service Provision	ESSR	PWWE
REPOS	Invoice Receipt Indicator	EKPO	REPOS
TABW	Delivery Date Variance in Days	calculated
TXZ01	Description	EKPO	TXZ01
UMREN	Denominator for Converting PO UoM into Base UoM.	EKPO	UMREN
UMREZ	Counter for Converting PO UoM into Base UoM.	EKPO	UMREZ
WEBRE	GR-Based Invoice Verification Indicator	EKPO	WEBRE
WEPOS	Goods Receipt Indicator	EKPO	WEPOS
WERKS	Plant	EKPO	WERKS
XERSY	Evaluated Receipt Settlement (ERS)	EKPO	XERSY
ZWERT	Target Value for Outline Agreement in Document Currency	EKPO	ZWERT
PERIV	Fiscal Year Variant	T001
QUAN_INT	Window of Quantity Grid	calculated	T147L
TIME_INT	Window of Time Grid	calculated	T147H
NOTIME	Counter for Time Grid	COUNTER
NOQUAN	Counter for Quantity Grid	COUNTER
NOPOS	Counter for Items	COUNTER
PWLIF	Goods Supplier	EKPA	LIFN2
PREST	Invoicing Party	EKPA	LIFN2
PLIWK	Supplying Plant to Which Partner Roles Have Been Assigned	EKPA	LIFN2
PLIEF	Vendor to Whom Partner Roles Have Been Assigned	EKPA	LIFN2
PBEST	Ordering Address	EKPA	LIFN2
MGABW	Smoothing Factor for Quantity Variance	T147
LFABW	Smoothing Factor for Date Variance	T147
MAXBW	Best Score	T147
VVABW	Smoothing Factor for Compliance with Shipping Instructions	T147
UZEIT	Time of Day	SY	SY-UZEIT
MCEX_UEBTO	Tolerance Limit for Overdelivery	EKPO	UEBTO
MCEX_UEBTK	Unlimited Overdelivery Permitted	EKPO	UEBTK
MCEX_UNTTO	Tolerance Limit for Underdelivery	EKPO	UNTTO
ROCANCEL	Cancellation of Data Record	hard-coded

Features of Extractor

This DataSource provides information about the header date of a purchasing document, such as vendor, purchasing organization, and purchase order currency, as well as information about the item data, such as material, purchase order quantity, order unit, net price, and so on.

In the ERP system, information about the header data of a purchasing document is contained in the EKKO table (Purchasing Document Header). The EKPO table (Purchasing Document Item) contains the item data.

Note that if you change a purchasing document, the system only takes into consideration the data that is relevant for extraction. The system therefore only executes a delta update for this DataSource if changes are made to purchasing document header data or item data that has a corresponding field in the DataSource.

Purchase Order History During Restructuring

By reading the purchase order history during restructuring, multiple records are created with the Purchase Order or Purchase Order/Item or Purchase Order/Item/Schedule Line key for multiple goods receipts for a purchase order or item or schedule line.

For this reason, all key figures in a DataStore object that contains the corresponding key definition are updated in an additive process. This applies to all key figures whose source field in the DataSource definition has the inversion indicator. These key figures must not be set to Overwrite. For more information, see the DataStore object definition 0PUR_O01 (Purchase Order Items).

For further information about purchasing documents, see the SAP Library under Materials Management ® Purchasing.

Important Key Figures

BWVORG - Transaction Key SAP BW

This field identifies the event that is based on the information in the DataSource. The contents of this field determines the importance and the behavior of other fields in the DataSource. The field ALIEF (Number of Deliveries) is, for example, only filled if the event is a goods receipt.

For more information, see SAP Note 684465: BWVORG for Purchasing Data Sources.

ROCANCEL - Cancellation of Data Record

This field can contain the following values:

·        ‘blank‘ – New data record

·        ‘X’ – Cancellation of data record

·        ‘R’ – Deletion of data record

For more information, see SAP Note 578471: Deleted Items in BW and Statistics

BUDAT – Posting Date

If the information in this field relates to an event in the purchase order, the field is filled with the posting date of the purchase order. If the information relates to a goods receipt or an invoice, the field is filled with the posting date of the corresponding document.

WKURS – Exchange Rate

For purchasing documents that were created in a currency other than the local currency, or to which documents such as invoices were posted in a different currency; The contents of this field specifies the conversion factor with which you can convert the foreign currency to the local currency.

NETPR – Net Price

The system always converts the net price to the local currency and to the base unit of measure.

For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL.

ALIEF - Number of Deliveries

This counter determines the number of deliveries based on the GR document items. The counted number depends on how often a material appears in a GR document.

Ensure that this counter only counts the number of deliveries and does not include reverse postings.

For more information, see SAP Note 381267: Info in rel. to purch. statistics: No. of deliv. for GR reversal.

Data Review in ERP System

In the Purchasing component, you can use the General Reports transaction (transaction code ME80FN) to select, aggregate, and summarize information about purchasing activities. You can assemble the information that is to be reported according to selection criteria such as material, purchasing document, vendor, plant, and purchasing organization.

To assign the information in the list of issued purchasing documents clearly according to your wishes, you can use functions such as Sort, Filter, Aggregate Across Various Fields, Add Totals and Subtotals. You can also display the detail data for a purchasing document, a vendor, or a material.

Changing the View

If you select Change View, you can choose between the following views to display the output list:

·        Header/Item Data(data from the tables EKKO and EKPO)

·        Delivery Schedule Lines (data from the table EKET)

·        Purchase Order History(data from the table EKBE)

You can check the data from the DataSource 2LIS_02_ITM with the Header/Item Data view.

Setting the Layout

If you select Choose Layout, you have access to all the SAP List Viewersfunctions. In other words, you can change the existing layout (such as add or hide fields and columns, change the sort sequence, add subtotals, set filters), save the changed layout, and choose a different layout.

Comparing DataSource 2LIS_02_ITM to ME80FN

If you choose the Header/Item Data view in the transaction ME80FN, you can compare the data in the DataSource fields with the original document data in the ERP system, such as:

·        Document Date (BEDAT)

·        Purchasing Document Type (BSART)

·        Purchasing Document Number (EBELN)

·        Purchasing Group (EKGRP)

·        Purchasing Organization (EKORG)

·        Vendor’s Account Number (LIFNR)

·        Item Number of Purchasing Document (EBELP)

·        Material Number (MATNR)

·        Material Group (MATKL)

·        Plant (WERKS)

·        Storage Location (LGORT)

·        Purchase Order Quantity (MENGE)

·        Order Unit (MEINS)

·        Net Purchase Order Value (NETWR)