SAP ABAP Table V_EKKNP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EKKNP	Table Relationship Diagram
Short Description	Generated Table for View

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_CO	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
16	VBELP	☐	POSNR_CO	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
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	KNA1
38	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
39	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator
40	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center
41	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
42	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area
43	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
44	AUFPL_ORD	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
45	APLZL_ORD	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order
46	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
47	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
48	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
49	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds
50	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item
51	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
52	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
53	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
54	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period
55	FM_SPLIT_BATCH	☐	FMSP_SPLIT_BATCH	NUMC3	NUMC	3	0	Batch to group results from an PSM assignment distribution
56	FM_SPLIT_BEGRU	☐	FMSP_SPLIT_AUTG	FMSP_SPLIT_AUTG	CHAR	4	0	Authorization group for PSM account assignment distribution
57	AA_FINAL_IND	☐	AA_FINAL_IND	XFELD	CHAR	1	0	Final Account Assignment Indicator
58	AA_FINAL_REASON	☐	AA_FINAL_REASON	CHAR02	CHAR	2	0	Final Account Assignment Reason Code	T163RC
59	AA_FINAL_QTY	☐	AA_FINAL_QTY	MENG13	QUAN	13	3	Final Account Assignment Quantity
60	AA_FINAL_QTY_F	☐	AA_FINAL_QTY_F		FLTP	16	16	Final Account Assignment Quantity (Floating Point Number)
61	MENGE_F	☐	MENGE_F		FLTP	16	16	Quantity (Floating Point Number - Internal Field)
62	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group
63	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture
64	TCOBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
65	DATEOFSERVICE	☐	VVBEACTDATE	DATUM	DATS	8	0	Date of Service
66	NOTAXCORR	☐	VVREITNOTAXCORR	BOOLE	CHAR	1	0	Do Not Consider Item in Input Tax Correction
67	DIFFOPTRATE	☐	POPTSATZ	POPTSATZ	DEC	9	6	Real Estate Option Rate
68	HASDIFFOPTRATE	☐	VVREITUSEDIFFOPTRATE	BOOLE	CHAR	1	0	Use Different Option Rate
69	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in