SAP ABAP Table MCEKKN (Account Assignments: Purchasing - LIS)

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	INTTAB	Structure
Structure	MCEKKN	Table Relationship Diagram
Short Description	Account Assignments: Purchasing - LIS

Delivery and Maintenance

Pool/cluster
Delivery Class
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	SKA1
12	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
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	VBUK
16	VBELP	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
17	VETEN	☐	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
18	KZBRB	☐	KZBRB	CHAR1	CHAR	1	0	Gross requirements indicator
19	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
20	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
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	CKPH
30	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
31	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
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	KNA1
38	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
39	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
40	.INCLUDE	☐				0	0
41	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
42	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
43	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
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	*
53	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
54	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
55	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
56	NETHW	☐	MC_NETHW	WERTV8	CURR	15	2	Net purchase local value (base unit)
57	EFFWR	☐	MC_EFFWR	WERTV8	CURR	15	2	Effective order value
58	EFFHW	☐	MC_EFFHW	WERTV8	CURR	15	2	Effective order value in local currency
59	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
60	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
61	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCEKKN	ANLN1	ANLH	ANLN1
2	MCEKKN	ANLN2	ANLA	ANLN2
3	MCEKKN	AUFNR	AUFK	AUFNR
4	MCEKKN	EBELN	EKKO	EBELN
5	MCEKKN	EBELP	EKPO	EBELP
6	MCEKKN	FIPOS	FMFPO	FIPOS
7	MCEKKN	FISTL	FMFCTR	FICTR
8	MCEKKN	FKBER	TFKB	FKBER
9	MCEKKN	GEBER	FMFINCODE	FINCODE
10	MCEKKN	GSBER	TGSB	GSBER
11	MCEKKN	KOKRS	TKA01	KOKRS
12	MCEKKN	KOSTL	CSKS	KOSTL
13	MCEKKN	KSTRG	CKPH	KSTRG
14	MCEKKN	MANDT	T000	MANDT
15	MCEKKN	NPLNR	AUFK	AUFNR
16	MCEKKN	PRCTR	CEPC	PRCTR
17	MCEKKN	PS_PSP_PNR	PRPS	PSPNR
18	MCEKKN	RECID	T8JJ	RECID
19	MCEKKN	SAKTO	SKA1	SAKNR
20	MCEKKN	VBELN	VBUK	VBELN
21	MCEKKN	VBELP	VBUP	POSNR
22	MCEKKN	VETEN	VBEP	ETENR
23	MCEKKN	VPTNR	KNA1	KUNNR

History

Last changed by/on	SAP	20130529
SAP Release Created in