Purchasing Data (Account Assignment) 

Technical name: 2LIS_02_ACC

Technical Data

Type of DataSource	Transaction Data (Movement Data)
Application Component	Materials Management (MM)
Available as of OLTP Release	SAP ECC 6.0
Available as of Plug-In Release	PI 2005.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
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
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	RESWK
STATU	Status of Purchasing Document	EKKO	STATU
SYDAT	Purchasing Document Creation Date	EKKO	BEDAT
WAERS	PO Currency	EKKO	WAERS
WKURS	Exchange Rate	EKKO	WKURS
BUKRS	Company Code	EKKO	BUKRS
AFNAM	Name of Requester	EKPO	AFNAM
AKTNR	Action	EKPO	AKTNR
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
KTPNR	Item Number of Principal Agreement	EKPO	KTPNR
LGORT	Storage Location	EKPO	LGORT
LMEIN	Base Unit of Measure	EKPO	LMEIN
MATKL	Material Group	EKPO	MATKL
MATNR	Material Number	EKPO	MATNR
MEINS	PO Unit	EKPO	MEINS
NETPR	Net Price	EKPO	NETPR
PEINH	Price Unit	EKPO	PEINH
PSTYP	Item Category in Purchasing Document	EKPO	PSTYP
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
WERKS	Plant	EKPO	WERKS
XERSY	Evaluated Receipt Settlement (ERS)	EKPO	XERSY
KNTTP	Account Assignment Category	EKPO	KNTTP
VRTKZ	Distribution Indicator for Multiple Account Assignment	EKPO	VRTKZ
TWRKZ	Partial Invoice Indicator	EKPO	TWRKZ
AEDAT	Date of Last Change	EKKN	AEDAT
ANLN1	Asset Main Number	EKKN	ANLN1
ANLN2	Asset Subnumber	EKKN	ANLN2
AUFNR	Order Number	EKKN	AUFNR
AUFPL	Plan Number for Activities in Order	EKKN	AUFPL
FIPOS	Commitment Item	FMFXPO	FIPEX
FISTL	Funds Center	EKKN	FISTL
FKBER	Functional Area	EKKN	FKBER
GEBER	Fund	EKKN	GEBER
GRANT_NBR	Grant	EKKN	GRANT_NBR
GSBER	Business Area	EKKN	GSBER
KBLNR	Document Number Earmarked Funds	EKKN	KBLNR
KBLPOS	Document Item Earmarked Funds	EKKN	KBLPOS
KOKRS	Controlling Area	EKKN	KOKRS
KOSTL	Cost Center	EKKN	KOSTL
KSTRG	Cost Unit	EKKN	KSTRG
MENGE	Quantity	EKKN	MENGE
MWSKZ	Tax Code	EKPO	MWSKZ
NAVNW	Non-Deductible Input Tax	EKPO	NAVNW
NETHW	Local Net PO Value (Base Unit)	Formula
NETWR	Net Purchase Order Value	Formula
EFFWR	Effective PO Value	Formula
EFFHW	Effective PO Value in Local Currency	Formula
NPLNR	Net Plan Number for Account Assignment	EKKN	NPLNR
PAOBJNR	Numbers for Result Objects (CO-PA)	EKKN	PAOBJNR
PRCTR	Profit Center	EKKN	PRCTR
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	EKKN	PS_PSP_PNR
SAKTO	G/L Account Number	EKKN	SAKTO
VBELN	Sales Document Number	EKKN	VBELN
VBELP	Sales Document Item	EKKN	VBELP
VPROZ	Distribution Percentage for Multiple Account Assignment	EKKN	VPROZ
XBAUF	Post to Order	EKKN	XBAUF
XBKST	Post to Cost Center?	EKKN	XBKST
XBPRO	Post to Project	EKKN	XBPRO
ZEKKN	Sequential Number for Account Assignment	EKKN	ZEKKN
FIKRS	FM Area	T001	FIKRS
KTOPL	Chart of Accounts	EKKN	KTOPL
ROCANCEL	Cancellation of Data Record	hard-coded

Features of Extractor

This DataSource provides information about:

·        the header data of a purchasing document, such as vendor, purchasing organization, order currency, and so on

·        the item data. such as material, purchase order quantity, order unit, net price, and so on

·        the account assignment, such as account type, cost center, controlling area, quantities, values, percentage rates, and so on

Note that the account assignment information applies to the item level and not to the schedule line level. This means that the quantities, values, and percentage rates indicate how the account assignment information of an item is assigned. This also applies to service items and purchase orders with invoicing plan.

The information in this DataSource corresponds to the information on the Account Assignment tab page in the transactions ME21N, ME22N, and ME23N.

In the ERP system, this information is contained in the following tables:

·        Header data in the table EKKO (Purchasing Document Header)

·        Item data in the table EKPO (Purchasing Document Item)

·        Account assignment information in the table EKKN (Account Assignment in the Purchasing Document)

For more information about account assignment, see the SAP Library under Materials Management ® Purchasing ® Purchase Orders ® Account Assignment.

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

Important Key Figures

BEDAT – Date of Purchasing Document

The date of the purchasing document indicates when the purchasing document was created. You can determine this date when you create a purchase order.

BSART – Purchasing Document Type

The purchasing document type allows you to differentiate between the different forms of a purchasing document category.
Example: The Purchase Order purchasing document category can be of the Standard Purchase Order or Stock Transport purchasing document type.

BSTYP – Purchasing Document Category

The purchasing document category allows you to differentiate between the different forms of a purchasing document.
Example: The Purchase Order purchasing document is different than the Scheduling Agreement purchasing document.

WKURS – Exchange Rate

For purchasing documents that were created in a different currency than the local currency, the contents of this field indicate the conversion factor with which you can convert the foreign currency to the local currency.

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.

Note:
This DataSource does not consider goods receipts and events with reference to invoices. Thus, this field only contains information related to purchase orders, scheduling agreements, and contracts.

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

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.

KNTTP – Account Assignment Category

The account assignment category determines the account assignment data for an item, such as cost center and account number.

VRTKZ – Distribution Indicator for Multiple Account Assignment

This field indicates how the quantities and values of a purchase order item in multiple account assignment are distributed to the individual account assignments. The following distributions are possible:
1 – quantities on a progressive fill-up basis
2 – proportional to planned quantity distribution

TWRKZ – Partial Invoice Indicator

This field indicates how invoice amounts in partial invoices in multiple account assignment are distributed to the individual account assignments. The following distributions are possible:
1 – on a progressive fill-up basis
2 – proportional

ANLN1 – Main Asset Number

This field determines an asset along with the asset subnumber (ANLN2) in Asset Accounting.

ANLN2 – Asset Subnumber

This field determines an asset along with the main asset number (ANLN1) in Asset Accounting.

FIPOS – Commitment Item

This field specifies the functional structure of an organization in Funds Management.
The information regarding the account assignment in a purchase order (EKKN-FIPOS) is converted based on the information in Funds Management (FMFXPO).

FISTL – Funds Center

This field contains an alphanumeric code with reference to the funds center that has the assigned budget used by the account assignment.

GEBER – Fund

This field contains a key that uniquely identifies a fund in Funds Management (PSM-FM).

GRANT_NBR – Grant

This field contains the information about a grant in Grants Management (PSM-GM).

NETWR – Net Purchase Order Value in Order Currency

This value is calculated based on the item information and account assignment information.

For documents with specified purchase order quantity, such as purchase order documents, the net purchase order value is calculated as follows:
NETWR = EKPO-NETWR / EKPO-MENGE * EKKN-MENGE
Net purchase order value = Net purchase order value of item / Item quantity * Quantity posted to account

For documents with target purchase order quantity, such as contracts, the net purchase order value is calculated as follows:
NETWR = EKPO-ZWERT / EKPO-KTMNG * EKKN-MENGE
Net purchase order value = Target value of item / Target quantity of item * Quantity posted to account

Note:
As long as the schedule lines in the scheduling agreement have not yet been created, the system calculates the net purchase order value base on the target information.

NETHW – Local Net Purchase Order Value (Base Unit)

This value corresponds to the net purchase order value in the purchase order currency that was converted to the local currency based on the conversion rate in the purchase order (WKURS).

EFFWR – Effective Purchase Order Valuet

The calculation of the effective purchase order value is based on the item information and account assignment information.

For documents with specified purchase order quantity, such as purchase order documents, the net purchase order value is calculated as follows:
EFFWR = EKPO-EFFWR / EKPO-MENGE * EKKN-MENGE
Effective purchase order value = Effective value of item / Item quantity * Quantity posted to account

For documents with target quantity, such as contracts,  the effective purchase order value is calculated as follows:
EFFWR = EKPO-EFFWR / EKPO-KTMNG * EKKN-MENGE
Effective purchase order value = Effective value of item / Target quantity of item * Quantity posted to account

Note:
As long as the schedule lines in the scheduling agreement have not yet been created, an item does not yet have an effective purchase order value.

NPLNR – Net Plan Number for Account Assignment

A net plan structures entire projects or individual tasks in a project, wherein the net plan number displays the project structure. This information is only available when this account type is used.

PS_PSP_PNR – Work Breakdown Structure Element

The WBS element contains a key code for unique identification. Note that for performance reasons, this key code is converted for saving in the EKKN table (Account Assignment in the Purchasing Document).

VPROZ – Distribution Percentage for Multiple Account Assignment

This field contains the percentage rate of the purchase order item quantity in multiple account assignment that was distributed to one account assignment. This information is only relevant for items with multiple account assignment.

ZEKKN – Sequential Number for Account Assignment

This field uniquely defines the account assignment sequence for a purchase order item.

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