SAP ABAP Table EKKODATA (Purchasing Document Header: Data Part)

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	EKKODATA	Table Relationship Diagram
Short Description	Purchasing Document Header: Data Part

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

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in