SAP ABAP Table WRF_POTB_DATA_AC_HEADSPR_STY (Data Application Function "Header Data OTB Special Release")

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ WRF_PRC_OTB_DDIC (Package) Seasonal Procurement: DDIC Objects in Open-To-Buy Area

Basic Data

Table Category	INTTAB	Structure
Structure	WRF_POTB_DATA_AC_HEADSPR_STY	Table Relationship Diagram
Short Description	Data Application Function "Header Data OTB Special Release"

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_POTB_DATA_AC_HEADSPR_STY	ABSGR	T165R	ABSGR
2	WRF_POTB_DATA_AC_HEADSPR_STY	AUSNR	EKKO	EBELN	REF	1	N
3	WRF_POTB_DATA_AC_HEADSPR_STY	EXNUM	EIKP	EXNUM	REF	1	N
4	WRF_POTB_DATA_AC_HEADSPR_STY	FRGGR	T16FG	FRGGR
5	WRF_POTB_DATA_AC_HEADSPR_STY	FRGKE	T16FB	FRGKE
6	WRF_POTB_DATA_AC_HEADSPR_STY	FRGSX	T16FS	FRGSX
7	WRF_POTB_DATA_AC_HEADSPR_STY	INCO1	TINC	INCO1	REF	1	N
8	WRF_POTB_DATA_AC_HEADSPR_STY	KALSM	T683	KALSM	REF	1	N
9	WRF_POTB_DATA_AC_HEADSPR_STY	KONNR	EKKO	EBELN	REF	1	N
10	WRF_POTB_DATA_AC_HEADSPR_STY	KUNNR	KNA1	KUNNR	REF	1	N
11	WRF_POTB_DATA_AC_HEADSPR_STY	LANDS	T005	LAND1	REF	1	N
12	WRF_POTB_DATA_AC_HEADSPR_STY	LBLIF	LFA1	LIFNR	REF	1	N
13	WRF_POTB_DATA_AC_HEADSPR_STY	LIFRE	LFA1	LIFNR	REF	1	N
14	WRF_POTB_DATA_AC_HEADSPR_STY	LLIEF	LFA1	LIFNR	REF	1	N
15	WRF_POTB_DATA_AC_HEADSPR_STY	LPONR	EKPO	EBELP	REF	1	N
16	WRF_POTB_DATA_AC_HEADSPR_STY	MANDT	T000	MANDT	KEY	1	N
17	WRF_POTB_DATA_AC_HEADSPR_STY	RELOC_ID	/ISDFPS/REL	RELOC_ID
18	WRF_POTB_DATA_AC_HEADSPR_STY	RELOC_SEQ_ID	/ISDFPS/RELSEQ	RELOC_SEQ_ID
19	WRF_POTB_DATA_AC_HEADSPR_STY	SPRAS	T002	SPRAS	REF	1	N

History

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