SE11 ABAP Dictionary SE11 EKKO

Popular:

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

EKKO

Purchasing Document Header

SAP MM Transparent Table 125 Fields

Primary Key:

MANDT EBELN

#	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	BUKRS	-	CoCode	CHAR	4	-	T001	Company Code
4	BSTYP	-	Doc.Categ.	CHAR	1	-	-	Purchasing Document Category
5	BSART	-	Doc. Type	CHAR	4	-	-	Purchasing Document Type
6	BSAKZ	-	Ctrl. ind.	CHAR	1	-	-	Control indicator for purchasing document type
7	LOEKZ	-	Delet.Ind.	CHAR	1	-	-	Deletion Indicator in Purchasing Document
8	STATU	-	Status	CHAR	1	-	-	Status of Purchasing Document
9	AEDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
10	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
11	PINCR	-	Item Int.	NUMC	5	-	-	Item Number Interval
12	LPONR	-	Last Item	NUMC	5	-	-	Last Item Number
13	LIFNR	-	Vendor	CHAR	10	-	LFA1	Vendor Account Number
14	SPRAS	-	Language	LANG	1	-	T002	Language Key
15	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
16	ZBD1T	-	Payment in	DEC	3	-	-	Cash (Prompt Payment) Discount Days
17	ZBD2T	-	Payment in	DEC	3	-	-	Cash (Prompt Payment) Discount Days
18	ZBD3T	-	Payment in	DEC	3	-	-	Cash (Prompt Payment) Discount Days
19	ZBD1P	-	Discount %	DEC	5	3	-	Cash Discount Percentage 1
20	ZBD2P	-	Discount 2	DEC	5	3	-	Cash Discount Percentage 2
21	EKORG	-	Purch.Org.	CHAR	4	-	-	Purchasing Organization
22	EKGRP	-	Pur. Group	CHAR	3	-	-	Purchasing Group
23	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
24	WKURS	-	Exch. Rate	DEC	9	5	-	Exchange Rate
25	KUFIX	-	Ex.Rate Fx	CHAR	1	-	-	Indicator: Fixing of Exchange Rate
26	BEDAT	-	Doc. Date	DATS	8	-	-	Purchasing Document Date
27	KDATB	-	Val. Start	DATS	8	-	-	Start of Validity Period
28	KDATE	-	VPer.End	DATS	8	-	-	End of Validity Period
29	BWBDT	-	Apply By	DATS	8	-	-	Closing Date for Applications
30	ANGDT	-	QuotDdln	DATS	8	-	-	Deadline for Submission of Bid/Quotation
31	BNDDT	-	Bindg Per.	DATS	8	-	-	Binding Period for Quotation
32	GWLDT	-	Warranty	DATS	8	-	-	Warranty Date
33	AUSNR	-	Number	CHAR	10	-	-	Bid invitation number
34	ANGNR	-	Quotation	CHAR	10	-	-	Quotation Number
35	IHRAN	-	Quot. Date	DATS	8	-	-	Quotation Submission Date
36	IHREZ	-	Ref. 1	CHAR	12	-	-	Your Reference
37	VERKF	-	Salespers.	CHAR	30	-	-	Responsible Salesperson at Vendor's Office
38	TELF1	-	Telephone	CHAR	16	-	-	Vendor's Telephone Number
39	LLIEF	-	Suppl.Vndr	CHAR	10	-	-	Supplying Vendor
40	KUNNR	-	Customer	CHAR	10	-	KNA1	Customer Number 1
41	KONNR	-	Agreement	CHAR	10	-	-	Number of Principal Purchase Agreement
42	ABGRU	-	Field Not Used	CHAR	2	-	-	Field Not Used
43	AUTLF	-	Cmpl. Dlv.	CHAR	1	-	-	Complete Delivery Stipulated for Each Purchase Order
44	WEAKT	-	GR Message	CHAR	1	-	-	Indicator: Goods Receipt Message
45	RESWK	-	Suppl.Plnt	CHAR	4	-	-	Supplying (Issuing) Plant in Stock Transport Order
46	LBLIF	-	Rec.vendor	CHAR	10	-	-	Field not used
47	INCO1	-	Incoterms	CHAR	3	-	-	Incoterms (Part 1)
48	INCO2	-	Inco. 2	CHAR	28	-	-	Incoterms (Part 2)
49	KTWRT	-	Targ. Val.	CURR	15	2	-	Target Value for Header Area per Distribution
50	SUBMI	-	Coll. No.	CHAR	10	-	-	Collective Number
51	KNUMV	-	Doc.cond.	CHAR	10	-	-	Number of the document condition
52	KALSM	-	Procedure	CHAR	6	-	-	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
53	STAFO	-	Update grp	CHAR	6	-	-	Update group for statistics update
54	LIFRE	-	Inv. Pty	CHAR	10	-	-	Different Invoicing Party
55	EXNUM	-	FT no.	CHAR	10	-	-	Number of foreign trade data in MM and SD documents
56	UNSEZ	-	Our Ref.	CHAR	12	-	-	Our Reference
57	LOGSY	-	Log.System	CHAR	10	-	-	Logical System
58	UPINC	-	SubItemInt	NUMC	5	-	-	Item Number Interval for Subitems
59	STAKO	-	T-d. cnds.	CHAR	1	-	-	Document with time-dependent conditions
60	FRGGR	-	Rel. group	CHAR	2	-	-	Release group
61	FRGSX	-	Strategy	CHAR	2	-	-	Release Strategy
62	FRGKE	-	Release	CHAR	1	-	-	Release Indicator: Purchasing Document
63	FRGZU	-	Rel.status	CHAR	8	-	-	Release status
64	FRGRL	-	Subj.to r.	CHAR	1	-	-	Release Not Yet Completely Effected
65	LANDS	-	Rep.cntry	CHAR	3	-	-	Country for Tax Return
66	LPHIS	-	Rel. docu.	CHAR	1	-	-	Indicator for scheduling agreement release documentation
67	ADRNR	-	Addr. no.	CHAR	10	-	-	Address number
68	STCEG_L	-	CtrySlsTxN	CHAR	3	-	-	Country of Sales Tax ID Number
69	STCEG	-	VAT Reg.No	CHAR	20	-	-	VAT Registration Number
70	ABSGR	-	Reas.Canc.	NUMC	2	-	-	Reason for Cancellation
71	ADDNR	-	DocumentNo	CHAR	10	-	-	Document number for additional
72	KORNR	-	Corr. MP	CHAR	1	-	-	Correction of miscellaneous provisions
73	MEMORY	-	Incomplete	CHAR	1	-	-	Purchase order not yet complete
74	PROCSTAT	-	Proc.state	CHAR	2	-	-	Purchasing document processing state
75	RLWRT	-	Tot. value	CURR	15	2	-	Total value at time of release
76	REVNO	-	Version	CHAR	8	-	-	Version number in Purchasing
77	SCMPROC	-	SCMPROC	CHAR	1	-	-	SCM Process That Created the Purchase Order
78	REASON_CODE	-	Reason	CHAR	4	-	-	Goods Receipt Reason Code
79	MEMORYTYPE	-	Category	CHAR	1	-	-	Category of Incompleteness
80	RETTP	-	Retention	CHAR	1	-	-	Retention Indicator
81	RETPC	-	Retent. %	DEC	5	2	-	Retention in Percent
82	DPTYP	-	Down Paymt	CHAR	4	-	-	Down Payment Indicator
83	DPPCT	-	DP %	DEC	5	2	-	Down Payment Percentage
84	DPAMT	-	DwnPaytAmt	CURR	11	2	-	Down Payment Amount in Document Currency
85	DPDAT	-	DP Due Dte	DATS	8	-	-	Due Date for Down Payment
86	MSR_ID	-	Process ID	CHAR	10	-	-	Process Identification Number
87	HIERARCHY_EXISTS	-	Hierarchy	CHAR	1	-	-	Part of a Contract Hierarchy
88	THRESHOLD_EXISTS	-	Threshold	CHAR	1	-	-	Threshold Value for Exchange Rates Exists
89	LEGAL_CONTRACT	-	Contr. No.	CHAR	40	-	-	Legal Contract Number
90	DESCRIPTION	-	Cont.Name	CHAR	40	-	-	Contract Name
91	RELEASE_DATE	-	Release	DATS	8	-	-	Release Date of Contract
92	FORCE_ID	-	GUID 32	CHAR	32	-	-	Internal Key for Force Element
93	FORCE_CNT	-	Counter	NUMC	6	-	-	Internal (Version) Counter
94	RELOC_ID	-	Reloc. ID	CHAR	10	-	-	Relocation ID
95	RELOC_SEQ_ID	-	Reloc.Step	CHAR	4	-	-	Relocation Step ID
96	SOURCE_LOGSYS	-	LogSystem	CHAR	10	-	-	Logical system
97	POHF_TYPE	-	Category	CHAR	1	-	-	Document for Seasonal Purchase Order Processing
98	EQ_EINDT	-	SameDlyDat	DATS	8	-	-	Delivery Date Header: All Items Have Same Delivery Date
99	EQ_WERKS	-	Same Plant	CHAR	4	-	-	Plant Header: All Items Have Same Receiving Plant
100	FIXPO	-	Firm Deal	CHAR	1	-	-	Firm Deal Indicator
101	EKGRP_ALLOW	-	PurGr	CHAR	1	-	-	Take Account of Purch. Group
102	WERKS_ALLOW	-	Plant	CHAR	1	-	-	Take Account of Plants
103	CONTRACT_ALLOW	-	Contract	CHAR	1	-	-	Take Account of Contracts
104	PSTYP_ALLOW	-	ItemCat	CHAR	1	-	-	Take Account of Item Categories
105	FIXPO_ALLOW	-	FixDatePur	CHAR	1	-	-	Take Account of Fixed-Date Purchases Indicator
106	KEY_ID_ALLOW	-	Budget	CHAR	1	-	-	Consider Budget
107	AUREL_ALLOW	-	AllocT.Rel	CHAR	1	-	-	Take Account of Alloc. Table Relevance
108	DELPER_ALLOW	-	DELPER	CHAR	1	-	-	Take Account of Dlvy Period
109	EINDT_ALLOW	-	DlvyDate	CHAR	1	-	-	Take Account of Delivery Date
110	LTSNR_ALLOW	-	VSRNo	CHAR	1	-	-	Include Vendor Subrange
111	OTB_LEVEL	-	Level	CHAR	1	-	-	OTB Check Level
112	OTB_COND_TYPE	-	Cond. Type	CHAR	4	-	-	OTB Condition Type
113	KEY_ID	-	Budget	NUMC	16	-	-	Unique Number of Budget
114	OTB_VALUE	-	Budget	CURR	17	2	-	Required Budget
115	OTB_CURR	-	OTB Crrncy	CUKY	5	-	-	OTB Currency
116	OTB_RES_VALUE	-	ReservBudg	CURR	17	2	-	Reserved Budget for OTB-Relevant Purchasing Document
117	OTB_SPEC_VALUE	-	SpclReleas	CURR	17	2	-	Special Release Budget
118	SPR_RSN_PROFILE	-	OTBRsnPrfl	CHAR	4	-	-	Reason Profile for OTB Special Release
119	BUDG_TYPE	-	Bdgt Type	CHAR	2	-	-	Budget Type
120	OTB_STATUS	-	OTB Status	CHAR	1	-	-	OTB Check Status
121	OTB_REASON	-	Reason	CHAR	3	-	-	Reason Indicator for OTB Check Status
122	CHECK_TYPE	-	Check Type	CHAR	1	-	-	Type of OTB Check
123	CON_OTB_REQ	-	OTB-Relev	CHAR	1	-	-	OTB-Relevant Contract
124	CON_PREBOOK_LEV	-	Cntrct Lvl	CHAR	1	-	-	OTB Indicator Level for Contracts
125	CON_DISTR_LEV	-	DistrLevel	CHAR	1	-	-	Distribution Using Target Value or Item Data

Related References & SQL

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

Interactive ERD Diagrams

SAP MM - Purchase Orders Relation →

Standard T-Codes

ME23N ME21N ME22N ME2N ME2L

Related Tables

T001 LFA1 T002 TCURC KNA1 EKPO EKET EKKN

ANSI SQL Query

SELECT a.EBELN,
       a.BUKRS,
       a.BSTYP,
       a.BSART,
       a.BSAKZ,
       a.LOEKZ
FROM EKKO AS a
WHERE a.EBELN = '4500017291';

ABAP OpenSQL (7.40+)

SELECT a~ebeln,
       a~bukrs,
       a~bstyp,
       a~bsart,
       a~bsakz,
       a~loekz
  FROM ekko AS a
  WHERE a~ebeln = '4500017291'
  INTO TABLE @DATA(lt_ekko)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 EKKO

EKKO

Dictionary Fields Fields

Related References & SQL