SAP ABAP Table EKKO (Purchasing Document Header)

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	TRANSP	Transparent table
Transparent table	EKKO	Table Relationship Diagram
Short Description	Purchasing Document Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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
3	.INCLUDE	☐				0	0	Purchasing Document Header: Data Part
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
6	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
7	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
8	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
9	STATU	☐	ESTAK	ESTAK	CHAR	1	0	Status of Purchasing Document
10	AEDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	PINCR	☐	PINCR	PINCR	NUMC	5	0	Item Number Interval
13	LPONR	☐	LPONR	EBELP	NUMC	5	0	Last Item Number	EKPO
14	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
15	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
16	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
17	ZBD1T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
18	ZBD2T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
19	ZBD3T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
20	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
21	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
22	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
23	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
24	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
25	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
26	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
27	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
28	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
29	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
30	BWBDT	☐	BWBDT	DATUM	DATS	8	0	Closing Date for Applications
31	ANGDT	☐	ANGAB	DATUM	DATS	8	0	Deadline for Submission of Bid/Quotation
32	BNDDT	☐	EBNDT	DATUM	DATS	8	0	Binding Period for Quotation
33	GWLDT	☐	MM_GWLDT	DATUM	DATS	8	0	Warranty Date
34	AUSNR	☐	AUSCH	EBELN	CHAR	10	0	Bid invitation number	EKKO
35	ANGNR	☐	ANGNR	ANGNR	CHAR	10	0	Quotation Number
36	IHRAN	☐	IHRAN	DATUM	DATS	8	0	Quotation Submission Date
37	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
38	VERKF	☐	EVERK	TEXT30	CHAR	30	0	Responsible Salesperson at Vendor's Office
39	TELF1	☐	TELF0	TEXT16	CHAR	16	0	Vendor's Telephone Number
40	LLIEF	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	LFA1
41	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
42	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
43	ABGRU	☐	ABGRU	CRMT_ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
44	AUTLF	☐	KMPLF	XFELD	CHAR	1	0	Complete Delivery Stipulated for Each Purchase Order
45	WEAKT	☐	WEAKT	XFELD	CHAR	1	0	Indicator: Goods Receipt Message
46	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
47	LBLIF	☐	LBLIF	LIFNR	CHAR	10	0	Field not used	LFA1
48	INCO1	☐	INCO1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (part 1)	*
49	INCO2	☐	INCO2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (part 2)
50	KTWRT	☐	KTWRT	WERT15	CURR	15	2	Target Value for Header Area per Distribution
51	SUBMI	☐	SUBMI	CHAR10	CHAR	10	0	Collective Number
52	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
53	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
54	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
55	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	LFA1
56	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	*
57	UNSEZ	☐	UNSEZ	TEXT12	CHAR	12	0	Our Reference
58	LOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
59	UPINC	☐	UPINC	PINCR	NUMC	5	0	Item Number Interval for Subitems
60	STAKO	☐	STAKO	XFELD	CHAR	1	0	Document with time-dependent conditions
61	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	*
62	FRGSX	☐	FRGSX	FRGSX	CHAR	2	0	Release Strategy	T16FS
63	FRGKE	☐	FRGKE	FRGKE	CHAR	1	0	Release Indicator: Purchasing Document	*
64	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
65	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
66	LANDS	☐	LAND1_STML	LAND1	CHAR	3	0	Country for Tax Return	T005
67	LPHIS	☐	LPHIS	XFELD	CHAR	1	0	Indicator for scheduling agreement release documentation
68	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
69	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	*
70	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
71	ABSGR	☐	ABSGR	NUMC02	NUMC	2	0	Reason for Cancellation	*
72	ADDNR	☐	ADDI_BELNR	ADDI_BELNR	CHAR	10	0	Document number for additional
73	KORNR	☐	KORNR	KORNR	CHAR	1	0	Correction of miscellaneous provisions
74	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKKO	AUSNR	EKKO	EBELN	REF	1	N
2	EKKO	BUKRS	T001	BUKRS	REF	1	N
3	EKKO	EKGRP	T024	EKGRP	REF	1	N
4	EKKO	EKORG	T024E	EKORG	REF	1	N
5	EKKO	FRGSX	T16FS	FRGSX
6	EKKO	KALSM	T683	KALSM	REF	1	N
7	EKKO	KONNR	EKKO	EBELN	REF	1	N
8	EKKO	LANDS	T005	LAND1	REF	1	N
9	EKKO	LBLIF	LFA1	LIFNR	REF	1	N
10	EKKO	LIFNR	LFA1	LIFNR	REF	1	N
11	EKKO	LIFRE	LFA1	LIFNR	REF	1	N
12	EKKO	LLIEF	LFA1	LIFNR	REF	1	N
13	EKKO	LPONR	EKPO	EBELP	REF	1	N
14	EKKO	MANDT	T000	MANDT	KEY	1	N
15	EKKO	RESWK	T001W	WERKS	REF	1	N
16	EKKO	SPRAS	T002	SPRAS	REF	1	N
17	EKKO	WAERS	TCURC	WAERS	REF	1	N

History

Last changed by/on	SAP	20130604
SAP Release Created in