SAP ABAP Table WRF_POTB_EKET_STY (Schedule Line Data for OTB Check)

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_EKET_STY	Table Relationship Diagram
Short Description	Schedule Line Data for OTB Check

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	Purchase Order Document Schedule Lines
2	.INCLUDE	☐				0	0	Scheduling Agreement Schedule Lines
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
5	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
6	ETENR	☐	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	*
7	.INCLUDE	☐				0	0	Scheduling Agreement Schedule Lines
8	EINDT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
9	SLFDT	☐	SLFDT	DATUM	DATS	8	0	Statistics-Relevant Delivery Date
10	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
11	MENGE	☐	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
12	AMENG	☐	VOMNG	MENG13V	QUAN	13	3	Previous Quantity (Delivery Schedule Lines)
13	WEMNG	☐	WEEMG	MENG13	QUAN	13	3	Quantity of goods received
14	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
15	UZEIT	☐	LZEIT	UZEIT	TIMS	6	0	Delivery Date Time-Spot
16	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
17	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
18	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
19	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
20	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
21	MAHNZ	☐	MAHNZE	PACK2	DEC	3	0	No. of Reminders/Expediters for Schedule Line
22	BEDAT	☐	ETBDT	DATUM	DATS	8	0	Order date of schedule line
23	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
24	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
25	FIXKZ	☐	ETFIX	XFELD	CHAR	1	0	Schedule Line is "Fixed"
26	GLMNG	☐	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
27	DABMG	☐	DABMG	MENGE	QUAN	13	3	Quantity Reduced (MRP)
28	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
29	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
30	CHKOM	☐	CHKOM	XFELD	CHAR	1	0	Components
31	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
32	ABART	☐	MEABART	ABART	CHAR	1	0	Scheduling agreement release type
33	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
34	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
35	ALTDT	☐	ALTDT	DATUM	DATS	8	0	Previous delivery date
36	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule	VALW
37	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
38	MBUHR	☐	MBUHR	TIME_PLANT	TIMS	6	0	Material Staging Time (Local, Relating to a Plant)
39	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
40	LDUHR	☐	LDUHR	TIME_SHIPP	TIMS	6	0	Loading Time (Local Time Relating to a Shipping Point)
41	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
42	TDUHR	☐	TDUHR	TIME_SHIPP	TIMS	6	0	Transp. Planning Time (Local, Relating to a Shipping Point)
43	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
44	WAUHR	☐	WAUHR	TIME_PLANT	TIMS	6	0	Time of Goods Issue (Local, Relating to a Plant)
45	ELDAT	☐	ELDAT	ELDAT	DATS	8	0	Goods Receipt End Date
46	ELUHR	☐	ELUHR	ELUHR	TIMS	6	0	Goods Receipt End Time (Local, Relating to a Plant)
47	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
48	NODISP	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
49	GEO_ROUTE	☐	/SPE/DE_ROUTE_ID	CHAR10	CHAR	10	0	Description of a Geographical Route
50	ROUTE_GTS	☐	/SPE/DE_ROUTE_GTS_CODE	CHAR10	CHAR	10	0	Route Code for SAP Global Trade Services
51	GTS_IND	☐	/SPE/DE_LEG_GTS_CODE	CHAR2	CHAR	2	0	Goods Traffic Type
52	TSP	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	*
53	CD_LOCNO	☐	APOLOCNO	APOLOCNO	CHAR	20	0	Location number in APO
54	CD_LOCTYPE	☐	APOLOCTYPE	APOLOCTYPE	CHAR	4	0	APO location type
55	HANDOVERDATE	☐	HANDOVER_DATE	HANDOVER_DATE	DATS	8	0	Handover Date at the Handover Location
56	HANDOVERTIME	☐	HANDOVER_TIME	HANDOVER_TIME	TIMS	6	0	Handover time at the handover location
57	.INCLU--AP	☐				0	0	EKET Enhancement Seasonal Procurement: Procurement
58	.INCLUDE	☐				0	0	EKET Enhancement: OTB
59	.INCLUDE	☐				0	0	OTB-Relevant Data
60	KEY_ID	☐	WRF_BUDG_KEY_ID	WRF_BUDG_KEY_ID	NUMC	16	0	Unique Number of Budget
61	OTB_VALUE	☐	WRF_POTB_VALUE	WRF_POTB_VALUE	CURR	17	2	Required Budget
62	.INCLUDE	☐				0	0	OTB Currency
63	OTB_CURR	☐	WRF_POTB_CURRENCY	WAERS	CUKY	5	0	OTB Currency	*
64	OTB_RES_VALUE	☐	WRF_POTB_RES_VALUE	WRF_POTB_RES_VALUE	CURR	17	2	Reserved Budget for OTB-Relevant Purchasing Document
65	OTB_SPEC_VALUE	☐	WRF_POTB_SPECIAL_VALUE	WRF_POTB_SPECIAL_VALUE	CURR	17	2	Special Release Budget
66	SPR_RSN_PROFILE	☐	WRF_POTB_SPR_RSN_PROFILE	WRF_POTB_SPR_RSN_PROFILE	CHAR	4	0	Reason Profile for OTB Special Release
67	BUDG_TYPE	☐	WRF_BUDG_TYPE	WRF_BUDG_TYPE	CHAR	2	0	Budget Type
68	OTB_STATUS	☐	WRF_POTB_STATUS	WRF_POTB_STATUS	CHAR	1	0	OTB Check Status
69	OTB_REASON	☐	WRF_POTB_STATUS_REASON	WRF_POTB_STATUS_REASON	CHAR	3	0	Reason Indicator for OTB Check Status
70	CHECK_TYPE	☐	WRF_BUDG_OTB_CHECK	WRF_BUDG_OTB_CHECK	CHAR	1	0	Type of OTB Check
71	.INCLUDE	☐				0	0	EKET Enhancement: Scheduling
72	.INCLUDE	☐				0	0	Fields That Are Stored in Appl. Doc. e.g. Order List
73	DL_ID	☐	WRF_PSCD_DL_ID	SYSUUID_22	CHAR	22	0	Date Line ID (GUID)
74	HANDOVER_DATE	☐	WRF_PSCD_HANDOVER_DATE	DATS	DATS	8	0	Transfer Date
75	NO_SCEM	☐	WRF_PSCD_NO_SCEM	CHAR1_X	CHAR	1	0	Purchase Order Not Transferred to SCEM
76	DNG_DATE	☐	WRF_PCTR_DNG_DATE	DATUM	DATS	8	0	Creation Date of Reminder Message Record
77	DNG_TIME	☐	WRF_PCTR_DNG_TIME	UZEIT	TIMS	6	0	Creation Time of Reminder Message Record
78	CNCL_ANCMNT_DONE	☐	WRF_PCTR_CNCL_ANCMT_DONE	CHAR1_X	CHAR	1	0	Cancellation Threat Made
79	DATESHIFT_NUMBER	☐	WRF_PCTR_DATESHIFT_NUMBER	DEC3	DEC	3	0	Number of Current Date Shifts
80	.INCLUDE	☐				0	0	OTB-Relevant Data for Internal Application
81	.INCLUDE	☐				0	0	OTB Check-Relevant Data for Internal Application
82	OTB_MISS_VALUE	☐	WRF_POTB_MISS_VALUE	WRF_POTB_VALUE	CURR	17	2	Missing Budget
83	.INCLUDE	☐				0	0	Additional Fields for an Operational OTB Bucket
84	VAL_AVAIL	☐	WRF_POTB_AVAIL_VALUE	WRF_POTB_VALUE	CURR	17	2	Available Budget
85	VAL_OVERBOOK	☐	WRF_POTB_OVERBOOK	WRF_BUDG_VALUE	CURR	17	2	Overbooking Amount of Budget
86	VAL_TOLERANCE	☐	WRF_BUDG_VALUE_TOLERANCE	WRF_BUDG_VALUE	CURR	17	2	Determined Tolerance Value
87	.INCLUDE	☐				0	0	OTB Actual Values
88	VAL_SPENT	☐	WRF_BUDG_VALUE_ACTUAL	WRF_BUDG_VALUE_ACTUAL	CURR	17	2	Exhausted Budget
89	VAL_SPREL	☐	WRF_BUDG_VALUE_RELEASE	WRF_BUDG_VALUE_RELEASE	CURR	17	2	Special Release Budget
90	VAL_CONTR	☐	WRF_BUDG_VALUE_CONTRACT	WRF_BUDG_VALUE_CONTRACT	CURR	17	2	Budget Flagged as Available for Contracts
91	OTB_CONTR_USED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
92	.INCLUDE	☐				0	0	PReq-Relevant Data for Internal Use
93	LOEKZ	☐	LOEKZ	XFELD	CHAR	1	0	Asset class marked for deletion
94	EBELP_TEMP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
95	UEBPO_TEMP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
96	UPO_ETENR	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
97	HANDOVER_STARTDATE	☐	WRF_PBAS_BOOLEAN	CHAR1_X	CHAR	1	0	Boolean Value
98	START_DATE_FIX	☐	WRF_PSCD_START_DATE_FIX	XFELD	CHAR	1	0	Transferred Started Date Will Not Be Changed
99	.INCLUDE	☐				0	0	Internal Data Relevant for OTB Check
100	OTB_DELTA	☐	WRF_POTB_DELTA	WRF_POTB_VALUE	CURR	17	2	Difference Between Available Budget and Required Budget
101	OTB_SPENT_TOL	☐	WRF_POTB_SPENT_TOL	WRF_POTB_SPENT_TOL	CURR	17	2	Used Tolerance Value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_POTB_EKET_STY	AULWE	VALW	AULWE	REF
2	WRF_POTB_EKET_STY	BNFPO	EBAN	BNFPO	REF	1	N
3	WRF_POTB_EKET_STY	EBELN	EKKO	EBELN	KEY	1	CN
4	WRF_POTB_EKET_STY	EBELP	EKPO	EBELP	KEY	1	CN
5	WRF_POTB_EKET_STY	MANDT	T000	MANDT	KEY	1	N

History

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