SAP ABAP Table EKKNU (Work Structure for Account Assignments in Purchasing Doc.-)

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	EKKNU	Table Relationship Diagram
Short Description	Work Structure for Account Assignments in Purchasing Doc.-

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	.INCLUDE	☐				0	0	Account Assignment in Purchasing Document
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
4	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
5	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
6	LOEKZ	☐	KLOEK	XFELD	CHAR	1	0	Deletion Indicator: Purchasing Document Account Assignment
7	AEDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	KFLAG	☐	EFLAG	XFELD	CHAR	1	0	Change flag: Purchasing (currently not used)
9	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
10	VPROZ	☐	VPROZ	VPROZ	DEC	3	1	Distribution percentage in the case of multiple acct assgt
11	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
12	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
13	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
14	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
15	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
16	VBELN	☐	VBELN_CO	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
17	VBELP	☐	POSNR_CO	POSNR	NUMC	6	0	Sales Document Item	VBUP
18	VETEN	☐	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
19	KZBRB	☐	KZBRB	CHAR1	CHAR	1	0	Gross requirements indicator
20	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
21	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
22	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
23	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
24	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
25	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
26	XBKST	☐	XBKST	XFELD	CHAR	1	0	Posting to cost center?
27	XBAUF	☐	XBAUF	XFELD	CHAR	1	0	Post To Order
28	XBPRO	☐	XBPRO	XFELD	CHAR	1	0	Post to project
29	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
30	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
31	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
32	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
33	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
34	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
35	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
36	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
37	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
38	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
39	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
40	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
41	.INCLUDE	☐				0	0
42	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
43	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
44	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
45	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
46	AUFPL_ORD	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
47	APLZL_ORD	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
48	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
49	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
50	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
51	.INCLUDE	☐				0	0	Include for the Reduction of Funds Reservations (FM)
52	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
53	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
54	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
55	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
56	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
57	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
58	.INCLUDE	☐				0	0	PSM Fields used in multiple account splitting
59	FM_SPLIT_BATCH	☐	FMSP_SPLIT_BATCH	NUMC3	NUMC	3	0	Batch to group results from an PSM assignment distribution
60	FM_SPLIT_BEGRU	☐	FMSP_SPLIT_AUTG	FMSP_SPLIT_AUTG	CHAR	4	0	Authorization group for PSM account assignment distribution	*
61	.INCLUDE	☐				0	0	MAA - Final Account Assignment Indicator
62	AA_FINAL_IND	☐	AA_FINAL_IND	XFELD	CHAR	1	0	Final Account Assignment Indicator
63	AA_FINAL_REASON	☐	AA_FINAL_REASON	CHAR02	CHAR	2	0	Final Account Assignment Reason Code	T163RC
64	AA_FINAL_QTY	☐	AA_FINAL_QTY	MENG13	QUAN	13	3	Final Account Assignment Quantity
65	AA_FINAL_QTY_F	☐	AA_FINAL_QTY_F		FLTP	16	16	Final Account Assignment Quantity (Floating Point Number)
66	MENGE_F	☐	MENGE_F		FLTP	16	16	Quantity (Floating Point Number - Internal Field)
67	.INCLU--AP	☐				0	0	Joint venture data
68	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
69	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
70	.INCLU--AP	☐				0	0	Zusatzfelder RE-FX für §15a USTG
71	.INCLUDE	☐				0	0	VstBerichtigung: Zusatzfelder
72	TCOBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
73	DATEOFSERVICE	☐	VVBEACTDATE	DATUM	DATS	8	0	Date of Service
74	NOTAXCORR	☐	VVREITNOTAXCORR	BOOLE	CHAR	1	0	Do Not Consider Item in Input Tax Correction
75	DIFFOPTRATE	☐	POPTSATZ	POPTSATZ	DEC	9	6	Real Estate Option Rate
76	HASDIFFOPTRATE	☐	VVREITUSEDIFFOPTRATE	BOOLE	CHAR	1	0	Use Different Option Rate
77	UPDKZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
78	.INCLUDE	☐				0	0	Additional Fields for MEPO
79	ITEM_WITH_ERROR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
80	ID	☐	INT4	INT4	INT4	10	0	Natural number
81	.INCLUDE	☐				0	0	Include RE Accounting Fields (External,without IMKEY, DABRZ)
82	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
83	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
84	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
85	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
86	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
87	SNKSL	☐	SNKSL	SNKSL	CHAR	4	0	Service Charge Key	*
88	SEMPSL	☐	SEMPSL	SEMPSL	CHAR	5	0	Settlement Unit	*
89	SVWNR	☐	VVSVWNR	VVSVWNR	CHAR	13	0	Management Contract Number	*
90	RECNNR	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
91	SBERI	☐	SBERI	SBERI	CHAR	10	0	Correction item number	*
92	TCNO	☐	VVREITTCNO	VVREITTCNO	CHAR	16	0	RE-FX: Number of Correction Object
93	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
94	PSP_PNR	☐	PSP_PNR	CHAR24	CHAR	24	0	Work breakdown structure element (WBS element)
95	SHARE_F	☐	SHARE_F		FLTP	16	16	Quantity Share Account Assignment Line for Item
96	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKKNU	AA_FINAL_REASON	T163RC	AA_FINAL_REASON	REF	1	N
2	EKKNU	ANLN1	ANLH	ANLN1	REF	1	N
3	EKKNU	ANLN2	ANLA	ANLN2	REF	1	N
4	EKKNU	AUFNR	AUFK	AUFNR	REF	1	N
5	EKKNU	EBELN	EKKO	EBELN	KEY	1	CN
6	EKKNU	EBELP	EKPO	EBELP	KEY	1	CN
7	EKKNU	FIPOS	FMFPO	FIPOS	REF	C	CN
8	EKKNU	GSBER	TGSB	GSBER	REF	1	N
9	EKKNU	KOKRS	TKA01	KOKRS	REF	1	N
10	EKKNU	KOSTL	CSKS	KOSTL	KEY	1	CN
11	EKKNU	LSTAR	CSLA	LSTAR		1	CN
12	EKKNU	MANDT	T000	MANDT	KEY	1	N
13	EKKNU	NPLNR	AUFK	AUFNR	REF	1	CN
14	EKKNU	PRZNR	CBPR	PRZNR		1	CN
15	EKKNU	PS_PSP_PNR	PRPS	PSPNR		1	CN
16	EKKNU	SAKTO	SKA1	SAKNR	KEY	1	N
17	EKKNU	VBELN	VBUK	VBELN	REF	1	N
18	EKKNU	VBELP	VBUP	POSNR	REF	1	N
19	EKKNU	VETEN	VBEP	ETENR	REF	1	N
20	EKKNU	VPTNR	KNA1	KUNNR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in