SAP ABAP Table WRF_PCON_DATA_EKKO_STY (Contract Header Data)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ WRF_PRC_CON_DDIC (Package) Seasonal Procurement: DDIC Objects Contract

Basic Data

Table Category	INTTAB	Structure
Structure	WRF_PCON_DATA_EKKO_STY	Table Relationship Diagram
Short Description	Contract Header Data

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	.INCLUDE	☐				0	0	Purchasing Document Header
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
4	.INCLUDE	☐				0	0	Purchasing Document Header: Data Part
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
7	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	T161
8	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
9	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
10	STATU	☐	ESTAK	ESTAK	CHAR	1	0	Status of Purchasing Document
11	AEDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
12	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
13	PINCR	☐	PINCR	PINCR	NUMC	5	0	Item Number Interval
14	LPONR	☐	LPONR	EBELP	NUMC	5	0	Last Item Number	EKPO
15	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
16	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
17	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
18	ZBD1T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
19	ZBD2T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
20	ZBD3T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
21	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
22	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
23	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
24	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
25	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
27	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
28	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
29	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
30	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
31	BWBDT	☐	BWBDT	DATUM	DATS	8	0	Closing Date for Applications
32	ANGDT	☐	ANGAB	DATUM	DATS	8	0	Deadline for Submission of Bid/Quotation
33	BNDDT	☐	EBNDT	DATUM	DATS	8	0	Binding Period for Quotation
34	GWLDT	☐	MM_GWLDT	DATUM	DATS	8	0	Warranty Date
35	AUSNR	☐	AUSCH	EBELN	CHAR	10	0	Bid invitation number	EKKO
36	ANGNR	☐	ANGNR	ANGNR	CHAR	10	0	Quotation Number
37	IHRAN	☐	IHRAN	DATUM	DATS	8	0	Quotation Submission Date
38	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
39	VERKF	☐	EVERK	TEXT30	CHAR	30	0	Responsible Salesperson at Vendor's Office
40	TELF1	☐	TELF0	TEXT16	CHAR	16	0	Vendor's Telephone Number
41	LLIEF	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	LFA1
42	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
43	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
44	ABGRU	☐	ABDUM	CHAR2	CHAR	2	0	Field Not Used
45	AUTLF	☐	KMPLF	XFELD	CHAR	1	0	Complete Delivery Stipulated for Each Purchase Order
46	WEAKT	☐	WEAKT	XFELD	CHAR	1	0	Indicator: Goods Receipt Message
47	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
48	LBLIF	☐	LBLIF	LIFNR	CHAR	10	0	Field not used	LFA1
49	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
50	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
51	KTWRT	☐	KTWRT	WERT15	CURR	15	2	Target Value for Header Area per Distribution
52	SUBMI	☐	SUBMI	CHAR10	CHAR	10	0	Collective Number
53	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
54	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
55	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
56	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	LFA1
57	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
58	UNSEZ	☐	UNSEZ	TEXT12	CHAR	12	0	Our Reference
59	LOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
60	UPINC	☐	UPINC	PINCR	NUMC	5	0	Item Number Interval for Subitems
61	STAKO	☐	STAKO	XFELD	CHAR	1	0	Document with time-dependent conditions
62	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	T16FG
63	FRGSX	☐	FRGSX	FRGSX	CHAR	2	0	Release Strategy	T16FS
64	FRGKE	☐	FRGKE	FRGKE	CHAR	1	0	Release Indicator: Purchasing Document	T16FB
65	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
66	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
67	LANDS	☐	LAND1_STML	LAND1	CHAR	3	0	Country for Tax Return	T005
68	LPHIS	☐	LPHIS	XFELD	CHAR	1	0	Indicator for scheduling agreement release documentation
69	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
70	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	*
71	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
72	ABSGR	☐	ABSGR	NUMC02	NUMC	2	0	Reason for Cancellation	T165R
73	ADDNR	☐	ADDI_BELNR	ADDI_BELNR	CHAR	10	0	Document number for additional
74	KORNR	☐	KORNR	KORNR	CHAR	1	0	Correction of miscellaneous provisions
75	MEMORY	☐	MEMER	XFELD	CHAR	1	0	Purchase order not yet complete
76	PROCSTAT	☐	MEPROCSTATE	MEPROCSTATE	CHAR	2	0	Purchasing document processing state
77	RLWRT	☐	RLWRT	WERT15	CURR	15	2	Total value at time of release
78	REVNO	☐	REVNO	REVNO	CHAR	8	0	Version number in Purchasing
79	SCMPROC	☐	SCMPROC	CHAR1	CHAR	1	0	SCM Process That Created the Purchase Order
80	REASON_CODE	☐	/SAPPSPRO/_GR_REASON_CODE	/SAPPSPRO/_GR_REASON_CODE	CHAR	4	0	Goods Receipt Reason Code
81	MEMORYTYPE	☐	MEMORYTYPE	MM_MEMORYTYPE	CHAR	1	0	Category of Incompleteness
82	RETTP	☐	RETTP	RET_TYPE	CHAR	1	0	Retention Indicator
83	RETPC	☐	RETPZ	PRZ32	DEC	5	2	Retention in Percent
84	DPTYP	☐	ME_DPTYP	ME_DPTYPE_DOMAIN	CHAR	4	0	Down Payment Indicator
85	DPPCT	☐	ME_DPPCNT	PRZ32	DEC	5	2	Down Payment Percentage
86	DPAMT	☐	ME_DPAMNT	WERT11	CURR	11	2	Down Payment Amount in Document Currency
87	DPDAT	☐	ME_DPDDAT	DATS	DATS	8	0	Due Date for Down Payment
88	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
89	HIERARCHY_EXISTS	☐	HIERARCHY_EXISTS	XFELD	CHAR	1	0	Part of a Contract Hierarchy
90	THRESHOLD_EXISTS	☐	EX_RATE_THRESHOLD	XFELD	CHAR	1	0	Threshold Value for Exchange Rates Exists
91	LEGAL_CONTRACT	☐	LEGAL_CONTRACT_ID	CHAR040	CHAR	40	0	Legal Contract Number
92	DESCRIPTION	☐	CONTRACT_DESCRIPTION	TEXT40	CHAR	40	0	Contract Name
93	RELEASE_DATE	☐	RELEASE_DATE	DATUM	DATS	8	0	Release Date of Contract
94	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	*
95	HANDOVERLOC	☐	HANDOVER_LOC	HANDOVER_LOC	CHAR	10	0	Location for a physical handover of goods
96	.INCLU--AP	☐				0	0	Append to EKKO for DFPS
97	.INCLUDE	☐				0	0	Relocation: Structure for Enhancing Logistics Documents
98	FORCE_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
99	FORCE_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
100	RELOC_ID	☐	/ISDFPS/RELOC_ID	/ISDFPS/RELOC_ID	CHAR	10	0	Relocation ID	/ISDFPS/REL
101	RELOC_SEQ_ID	☐	/ISDFPS/RELOC_SEQ_ID	/ISDFPS/RELOC_SEQ_ID	CHAR	4	0	Relocation Step ID	/ISDFPS/RELSEQ
102	.INCLUDE	☐				0	0
103	.INCLU--AP	☐				0	0	EKKO Enhancement Seasonal Procurement: Procurement
104	.INCLUDE	☐				0	0	EKKO Enhancement: PO Handling
105	POHF_TYPE	☐	WRF_POHF_TYPE	WRF_POHF_TYPE	CHAR	1	0	Document for Seasonal Purchase Order Processing
106	EQ_EINDT	☐	WRF_POHF_EQ_EINDT	DATUM	DATS	8	0	Delivery Date Header: All Items Have Same Delivery Date
107	EQ_WERKS	☐	WRF_POHF_EQ_EWERK	WERKS	CHAR	4	0	Plant Header: All Items Have Same Receiving Plant	*
108	FIXPO	☐	WRF_POHF_FIXPO	WRF_POHF_FIXPO_X	CHAR	1	0	Firm Deal Indicator
109	.INCLUDE	☐				0	0	Structure for Grouping Criteria
110	EKGRP_ALLOW	☐	WRF_POHF_EKGRP_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Take Account of Purch. Group
111	WERKS_ALLOW	☐	WRF_POHF_WERKS_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Take Account of Plants
112	CONTRACT_ALLOW	☐	WRF_POHF_CONTRACT_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Take Account of Contracts
113	PSTYP_ALLOW	☐	WRF_POHF_PSTYP_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Take Account of Item Categories
114	FIXPO_ALLOW	☐	WRF_POHF_FIXPO_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Take Account of Fixed-Date Purchases Indicator
115	KEY_ID_ALLOW	☐	WRF_POHF_KEY_ID_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Consider Budget
116	AUREL_ALLOW	☐	WRF_POHF_AUREL_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Take Account of Alloc. Table Relevance
117	DELPER_ALLOW	☐	WRF_POHF_DELPER_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Take Account of Dlvy Period
118	EINDT_ALLOW	☐	WRF_POHF_EINDT_ALLOW	WRF_POHF_CHAR_1_2	CHAR	1	0	Take Account of Delivery Date
119	.INCLUDE	☐				0	0	EKKO Enhancement: OTB
120	OTB_LEVEL	☐	WRF_POTB_CHECK_LEVEL	WRF_POTB_CHECK_LEVEL	CHAR	1	0	OTB Check Level
121	OTB_COND_TYPE	☐	WRF_POTB_COND_TYPE	KSCHL	CHAR	4	0	OTB Condition Type	*
122	.INCLUDE	☐				0	0	OTB-Relevant Data
123	KEY_ID	☐	WRF_BUDG_KEY_ID	WRF_BUDG_KEY_ID	NUMC	16	0	Unique Number of Budget
124	OTB_VALUE	☐	WRF_POTB_VALUE	WRF_POTB_VALUE	CURR	17	2	Required Budget
125	.INCLUDE	☐				0	0	OTB Currency
126	OTB_CURR	☐	WRF_POTB_CURRENCY	WAERS	CUKY	5	0	OTB Currency	*
127	OTB_RES_VALUE	☐	WRF_POTB_RES_VALUE	WRF_POTB_RES_VALUE	CURR	17	2	Reserved Budget for OTB-Relevant Purchasing Document
128	OTB_SPEC_VALUE	☐	WRF_POTB_SPECIAL_VALUE	WRF_POTB_SPECIAL_VALUE	CURR	17	2	Special Release Budget
129	SPR_RSN_PROFILE	☐	WRF_POTB_SPR_RSN_PROFILE	WRF_POTB_SPR_RSN_PROFILE	CHAR	4	0	Reason Profile for OTB Special Release
130	BUDG_TYPE	☐	WRF_BUDG_TYPE	WRF_BUDG_TYPE	CHAR	2	0	Budget Type
131	OTB_STATUS	☐	WRF_POTB_STATUS	WRF_POTB_STATUS	CHAR	1	0	OTB Check Status
132	OTB_REASON	☐	WRF_POTB_STATUS_REASON	WRF_POTB_STATUS_REASON	CHAR	3	0	Reason Indicator for OTB Check Status
133	CHECK_TYPE	☐	WRF_BUDG_OTB_CHECK	WRF_BUDG_OTB_CHECK	CHAR	1	0	Type of OTB Check
134	.INCLUDE	☐				0	0	Add-On Data for Contracts
135	CON_OTB_REQ	☐	WRF_POTB_CON_REQ	CHAR1_X	CHAR	1	0	OTB-Relevant Contract
136	CON_PREBOOK_LEV	☐	WRF_POTB_PREBOOK_LEVEL	WRF_POTB_PREBOOK_LEVEL	CHAR	1	0	OTB Indicator Level for Contracts
137	CON_DISTR_LEV	☐	WRF_POTB_DISTRIB_LEVEL	WRF_POTB_DISTRIB_LEVEL	CHAR	1	0	Distribution Using Target Value or Item Data
138	.INCLUDE	☐				0	0	Enhancement Structure: Contract Header
139	CO_VAL_CURRENT	☐	WRF_PCON_VAL_CURRENT	WERT11	CURR	11	2	Current Value Released Against Contract
140	CO_VAL_AVERAGE	☐	WRF_PCON_VAL_AVERAGE	WERT11	CURR	11	2	Average Value Released Against Contract
141	CO_VAL_OVERBOOKED	☐	WRF_PCON_VAL_OVERBOOKED	WERT11	CURR	11	2	Overbooked Value
142	CO_VAL_OPEN	☐	WRF_PCON_VAL_OPEN	WERT11	CURR	11	2	Open Contract Value
143	CO_VAL_EXTRAPOL	☐	WRF_PCON_VAL_EXTRAPOL	WERT11	CURR	11	2	Extrapolated Contract Value
144	CO_STAT_DUE_DATE	☐	WRF_PCON_STATUS_DUE_DATE	WRF_PCON_STATUS_DUE_DATE	CHAR	1	0	Status of Comparison of Last Order Date with Key Date
145	CO_STAT_OVERBOOKED	☐	WRF_PCON_STATUS_OVERBOOKED	XFELD	CHAR	1	0	Indicates if Contract Is Overbooked
146	CO_STAT_STARTED	☐	WRF_PCON_CO_STARTED	XFELD	CHAR	1	0	Indicates if Contract Has Already Begun
147	CO_STAT_FINISHED	☐	WRF_PCON_CO_FINISHED	XFELD	CHAR	1	0	Indicates If Contract Already Terminated
148	CO_AMOUNT_CURRENT	☐	WRF_PCON_AMOUNT_CURRENT	MENG13	QUAN	13	3	Current Released Contract Quantity
149	CO_AMOUNT_AVERAGE	☐	WRF_PCON_AMOUNT_AVERAGE	MENG13	QUAN	13	3	Average Released Contract Quantity
150	CO_AMOUNT_OVERBOOKED	☐	WRF_PCON_AMOUNT_OVERBOOKED	MENG13	QUAN	13	3	Overbooked Contract Quantity
151	CO_AMOUNT_OPEN	☐	WRF_PCON_AMOUNT_OPEN	MENG13	QUAN	13	3	Open Contract Quantity
152	CO_AMOUNT_EXTRAPOL	☐	WRF_PCON_AMOUNT_EXTRAPOL	MENG13	QUAN	13	3	Average Released Contract Quantity
153	CO_AMOUNT_MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
154	CO_REQUESTED	☐	WRF_PCON_ONLY_REQUESTED	XFELD	CHAR	1	0	Only Contracts with Releases
155	CO_STAT_EXTRAPOL	☐	WRF_PCON_STATUS_EXTRAPOL	WRF_PCON_STATUS_EXTRAPOL	CHAR	1	0	Status Regarding Comparison Contract - w/Extrapolated Data

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_PCON_DATA_EKKO_STY	ABSGR	T165R	ABSGR
2	WRF_PCON_DATA_EKKO_STY	AUSNR	EKKO	EBELN	REF	1	N
3	WRF_PCON_DATA_EKKO_STY	BSART	T161	BSART	REF	1	N
4	WRF_PCON_DATA_EKKO_STY	BUKRS	T001	BUKRS	REF	1	N
5	WRF_PCON_DATA_EKKO_STY	EKGRP	T024	EKGRP	REF	1	N
6	WRF_PCON_DATA_EKKO_STY	EKORG	T024E	EKORG	REF	1	N
7	WRF_PCON_DATA_EKKO_STY	EXNUM	EIKP	EXNUM	REF	1	N
8	WRF_PCON_DATA_EKKO_STY	FRGGR	T16FG	FRGGR
9	WRF_PCON_DATA_EKKO_STY	FRGKE	T16FB	FRGKE
10	WRF_PCON_DATA_EKKO_STY	FRGSX	T16FS	FRGSX
11	WRF_PCON_DATA_EKKO_STY	INCO1	TINC	INCO1	REF	1	N
12	WRF_PCON_DATA_EKKO_STY	KALSM	T683	KALSM	REF	1	N
13	WRF_PCON_DATA_EKKO_STY	KONNR	EKKO	EBELN	REF	1	N
14	WRF_PCON_DATA_EKKO_STY	KUNNR	KNA1	KUNNR	REF	1	N
15	WRF_PCON_DATA_EKKO_STY	LANDS	T005	LAND1	REF	1	N
16	WRF_PCON_DATA_EKKO_STY	LBLIF	LFA1	LIFNR	REF	1	N
17	WRF_PCON_DATA_EKKO_STY	LIFNR	LFA1	LIFNR	REF	1	N
18	WRF_PCON_DATA_EKKO_STY	LIFRE	LFA1	LIFNR	REF	1	N
19	WRF_PCON_DATA_EKKO_STY	LLIEF	LFA1	LIFNR	REF	1	N
20	WRF_PCON_DATA_EKKO_STY	LPONR	EKPO	EBELP	REF	1	N
21	WRF_PCON_DATA_EKKO_STY	MANDT	T000	MANDT	KEY	1	N
22	WRF_PCON_DATA_EKKO_STY	RELOC_ID	/ISDFPS/REL	RELOC_ID
23	WRF_PCON_DATA_EKKO_STY	RELOC_SEQ_ID	/ISDFPS/RELSEQ	RELOC_SEQ_ID
24	WRF_PCON_DATA_EKKO_STY	RESWK	T001W	WERKS	REF	1	N
25	WRF_PCON_DATA_EKKO_STY	SPRAS	T002	SPRAS	REF	1	N
26	WRF_PCON_DATA_EKKO_STY	WAERS	TCURC	WAERS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in	600