SE11 ABAP Dictionary SE11 EKKN

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

EKKN

Account Assignment in Purchasing Document

SAP MM Transparent Table 75 Fields

Primary Key:

MANDT EBELN EBELP ZEKKN

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	EBELN	KEY	Purch.Doc.	CHAR	10	-	EKKO	Purchasing Document Number
3	EBELP	KEY	Item	NUMC	5	-	-	Item Number of Purchasing Document
4	ZEKKN	KEY	SqNoAccAss	NUMC	2	-	-	Sequential Number of Account Assignment
5	LOEKZ	-	Del. Ind.	CHAR	1	-	-	Deletion Indicator: Purchasing Document Account Assignment
6	AEDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
7	KFLAG	-	Change flag: Purchasing (currently not used)	CHAR	1	-	-	Change flag: Purchasing (currently not used)
8	MENGE	-	Quantity	QUAN	13	3	-	Quantity
9	VPROZ	-	Distrib.	DEC	3	1	-	Distribution Percentage in Case of Multiple Account Assgt
10	NETWR	-	Net Value	CURR	13	2	-	Net Order Value in PO Currency
11	SAKTO	-	G/L acct	CHAR	10	-	-	G/L Account Number
12	GSBER	-	Bus. Area	CHAR	4	-	-	Business Area
13	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
14	PROJN	-	not in use	CHAR	16	-	-	Old: Project number : No longer used --> PS_POSNR
15	VBELN	-	SD Doc.	CHAR	10	-	VBAK	Sales and Distribution Document Number
16	VBELP	-	Item	NUMC	6	-	-	Sales Document Item
17	VETEN	-	Schd. Line	NUMC	4	-	-	Delivery Schedule Line Number
18	KZBRB	-	Gross reqs	CHAR	1	-	-	Gross requirements indicator
19	ANLN1	-	Asset	CHAR	12	-	-	Main Asset Number
20	ANLN2	-	Subnumber	CHAR	4	-	-	Asset Subnumber
21	AUFNR	-	Order	CHAR	12	-	-	Order Number
22	WEMPF	-	Recipient	CHAR	12	-	-	Goods Recipient/Ship-To Party
23	ABLAD	-	Unl. Point	CHAR	25	-	-	Unloading Point
24	KOKRS	-	CO Area	CHAR	4	-	-	Controlling Area
25	XBKST	-	Posting to cost center?	CHAR	1	-	-	Posting to cost center?
26	XBAUF	-	Order	CHAR	1	-	-	Post To Order
27	XBPRO	-	Project	CHAR	1	-	-	Post to project
28	EREKZ	-	Final Inv.	CHAR	1	-	-	Final Invoice Indicator
29	KSTRG	-	CostObject	CHAR	12	-	-	Cost Object
30	PAOBJNR	-	Prof.Segmt	NUMC	10	-	-	Profitability Segment Number (CO-PA)
31	PRCTR	-	Profit Ctr	CHAR	10	-	-	Profit Center
32	PS_PSP_PNR	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
33	NPLNR	-	Network	CHAR	12	-	-	Network Number for Account Assignment
34	AUFPL	-	Plan no.	NUMC	10	-	-	Routing number of operations in the order
35	IMKEY	-	RE Key	CHAR	8	-	-	Internal Key for Real Estate Object
36	APLZL	-	Counter	NUMC	8	-	-	Internal counter
37	VPTNR	-	Partner	CHAR	10	-	-	Partner account number
38	FIPOS	-	Cmmt Item	CHAR	14	-	-	Commitment Item
39	RECID	-	Rec.Indic.	CHAR	2	-	-	Recovery Indicator
40	ZZSPREG	-	SpecREG	CHAR	5	-	-	Special Region
41	ZZBUSPARTN	-	Bus.partn.	CHAR	10	-	-	Business partner
42	ZZPRODUCT	-	ProductGrp	CHAR	10	-	-	Product group
43	ZZLOCA	-	City	CHAR	4	-	-	City
44	ZZCHAN	-	Dist. chan	CHAR	4	-	-	Distribution channel
45	ZZLOB	-	BUSINESS L	CHAR	7	-	-	BUSINESS LINE
46	ZZNFAL	-	ZZNFAL	CHAR	10	-	-
47	ZZUSERFLD1	-	Territory	CHAR	9	-	-	Territory
48	ZZUSERFLD2	-	Ownr/Cntr	CHAR	12	-	-	Owner/Cont.
49	ZZUSERFLD3	-	Vein	CHAR	22	-	-	Vein
50	ZZREGION	-	Location	CHAR	3	-	-	Location
51	ZZSTATE	-	State/Prov	CHAR	3	-	-	State/Province Code
52	FISTL	-	Funds Ctr	CHAR	16	-	-	Funds Center
53	GEBER	-	Fund	CHAR	10	-	-	Fund
54	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
55	DABRZ	-	Ref. Date	DATS	8	-	-	Reference Date for Settlement
56	AUFPL_ORD	-	Plan no.	NUMC	10	-	-	Routing number of operations in the order
57	APLZL_ORD	-	Counter	NUMC	8	-	-	General counter for order
58	MWSKZ	-	Tax Code	CHAR	2	-	-	Sales Tax Code
59	TXJCD	-	Tax Jur.	CHAR	15	-	-	Tax Jurisdiction
60	NAVNW	-	Non-deductible input tax	CURR	13	2	-	Non-deductible input tax
61	KBLNR	-	DocumentNo	CHAR	10	-	-	Document Number for Earmarked Funds
62	KBLPOS	-	Doc. item	NUMC	3	-	-	Earmarked Funds: Document Item
63	LSTAR	-	Acty Type	CHAR	6	-	-	Activity Type
64	PRZNR	-	BusProcess	CHAR	12	-	-	Business Process
65	GRANT_NBR	-	Grant	CHAR	20	-	-	Grant
66	BUDGET_PD	-	BP	CHAR	10	-	-	FM: Budget Period
67	FM_SPLIT_BATCH	-	Batch #	NUMC	3	-	-	Batch to group results from an PSM assignment distribution
68	FM_SPLIT_BEGRU	-	Auth.Grou	CHAR	4	-	-	Authorization group for PSM account assignment distribution
69	EGRUP	-	Equity grp	CHAR	3	-	-	Equity group
70	VNAME	-	Venture	CHAR	6	-	-	Joint Venture
71	TCOBJNR	-	Obj. no.	CHAR	22	-	-	Object number
72	DATEOFSERVICE	-	DATEOFSERVICE	DATS	8	-	-
73	NOTAXCORR	-	NOTAXCORR	CHAR	1	-	-
74	DIFFOPTRATE	-	Option rte	DEC	9	6	-	Real estate option rate
75	HASDIFFOPTRATE	-	HASDIFFOPTRATE	CHAR	1	-	-

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk EKKN.

Interactive ERD Diagrams

SAP MM - Purchase Orders Relation →

Standard T-Codes

SE11 SE16

Related Tables

EKKO VBAK EKPO EKET EORD EINA EINE S011

ANSI SQL Query

SELECT a.EBELN,
       a.EBELP,
       a.ZEKKN,
       a.LOEKZ,
       a.AEDAT,
       a.KFLAG,
       a.MENGE
FROM EKKN AS a
WHERE a.EBELN = '4500017291'
  AND a.EBELP = '0001';

ABAP OpenSQL (7.40+)

SELECT a~ebeln,
       a~ebelp,
       a~zekkn,
       a~loekz,
       a~aedat,
       a~kflag,
       a~menge
  FROM ekkn AS a
  WHERE a~ebeln = '4500017291'
  and a~ebelp = '0001'
  INTO TABLE @DATA(lt_ekkn)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 EKKN

EKKN

Dictionary Fields Fields

Related References & SQL