SAP ABAP Table EKKN (Account Assignment in Purchasing Document)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EKKN	Table Relationship Diagram
Short Description	Account Assignment in Purchasing Document

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
4	ZEKKN	☑	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
5	LOEKZ	☐	KLOEK	XFELD	CHAR	1	0	Deletion Indicator: Purchasing Document Account Assignment
6	AEDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	KFLAG	☐	EFLAG	XFELD	CHAR	1	0	Change flag: Purchasing (currently not used)
8	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
9	VPROZ	☐	VPROZ	VPROZ	DEC	3	1	Distribution percentage in the case of multiple acct assgt
10	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
11	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
12	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
13	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
14	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
15	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
16	VBELP	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
17	VETEN	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
18	KZBRB	☐	KZBRB	CHAR1	CHAR	1	0	Gross requirements indicator
19	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
20	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
21	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
22	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
23	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
24	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
25	XBKST	☐	XBKST	XFELD	CHAR	1	0	Posting to cost center?
26	XBAUF	☐	XBAUF	XFELD	CHAR	1	0	Post To Order
27	XBPRO	☐	XBPRO	XFELD	CHAR	1	0	Post to project
28	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
29	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
30	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
31	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
32	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
33	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
34	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
35	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
36	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
37	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
38	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
39	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
40	.INCLUDE	☐				0	0
41	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
42	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
43	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
44	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
45	AUFPL_ORD	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
46	APLZL_ORD	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
47	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
48	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
49	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
50	.INCLUDE	☐				0	0	Include for the Reduction of Funds Reservations (FM)
51	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
52	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKKN	AUFNR	AUFK	AUFNR	REF	1	N
2	EKKN	EBELN	EKKO	EBELN	KEY	1	CN
3	EKKN	EBELP	EKPO	EBELP	KEY	1	CN
4	EKKN	FIPOS	FMFPO	FIPOS	REF	C	CN
5	EKKN	KOKRS	TKA01	KOKRS	REF	1	N
6	EKKN	KOSTL	CSKS	KOSTL	KEY	1	CN
7	EKKN	MANDT	T000	MANDT	KEY	1	N
8	EKKN	NPLNR	AUFK	AUFNR	REF	1	CN
9	EKKN	PS_PSP_PNR	PRPS	PSPNR		1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in