SAP ABAP Table ROIJ_3WP_IO (Structure for parameter of 3WP selection)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	ROIJ_3WP_IO	Table Relationship Diagram
Short Description	Structure for parameter of 3WP selection

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	PROFILE_ID	☐	OIJ_PROFILE_ID	OIJ_PROFILE_ID	CHAR	22	0	Planning profile ID
2	G_TSTMP_FROM	☐	OIJ_G_FROM	TZNTSTMPS	DEC	15	0	Overall start timestamp
3	G_TSTMP_TO	☐	OIJ_G_TO	TZNTSTMPS	DEC	15	0	Overall end timestamp
4	.INCLUDE	☐				0	0	General Period
5	G_DATE_F	☐	OIJ_DATE_F_GEN	DATS	DATS	8	0	General Period Start Date
6	G_DATE_T	☐	OIJ_DATE_T_GEN	DATS	DATS	8	0	General Period End Date
7	G_TIME_F	☐	OIJ_TIME_F_GEN	TIME	TIMS	6	0	General Period Start Time
8	G_TIME_T	☐	OIJ_TIME_T_GEN	TIME	TIMS	6	0	General Period End Time
9	G_OFFSET	☐	OIJ_OFFSET_GEN	OIJ_OFFSET	INT1	3	0	General Period Offset
10	G_DURATION	☐	OIJ_OFFSET_DUR_GEN	TSTRDURAN	DEC	11	0	General Period Duration (in hours:minutes)
11	G_MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	G_MATNR_RTAB	☐	ROIJ_MATNR_RTAB		TTYP	0	0
13	G_UNIT	☐	OIJ_UNIT	MEINS	UNIT	3	0	General unit of measure	*
14	G_TIME_UNIT	☐	OIJ_UNITI_T	MEINS	UNIT	3	0	Scheduled UoM Time	*
15	G_TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
16	G_TSYST_RTAB	☐	ROIJ_TSYST_RTAB		TTYP	0	0
17	P_S_CHECKBOX	☐	OIJ_XFLAG_PS	XFELD	CHAR	1	0	Pegging to Stock
18	BOM_CHECKBOX	☐	OIJ_XFLAG_BOM	XFELD	CHAR	1	0	BOM Explosion
19	G_MAXSEL	☐	TBMAXSEL	SYST_LONG	INT4	10	0	Maximum Number of Selected Entries
20	G_SCHED_TYPE_RTAB	☐	ROIJ_SIMTYP_RTAB		TTYP	0	0
21	D_CHECKBOX	☐	OIJ_XFLAG_DMD	XFELD	CHAR	1	0	Select no Demand Items
22	D_TSTMP_FROM	☐	OIJ_D_FROM	TZNTSTMPS	DEC	15	0	Demand start timestamp
23	D_TSTMP_TO	☐	OIJ_D_TO	TZNTSTMPS	DEC	15	0	Demand end timestamp
24	.INCLUDE	☐				0	0	Demand Period
25	D_DATE_F	☐	OIJ_DATE_F_DMD	DATS	DATS	8	0	Demand Period Start Date
26	D_DATE_T	☐	OIJ_DATE_T_DMD	DATS	DATS	8	0	Demand Period End Date
27	D_TIME_F	☐	OIJ_TIME_F_DMD	TIME	TIMS	6	0	Demand Period Start Time
28	D_TIME_T	☐	OIJ_TIME_T_DMD	TIME	TIMS	6	0	Demand Period End Time
29	D_OFFSET	☐	OIJ_OFFSET_DMD	OIJ_OFFSET	INT1	3	0	Demand Period Offset
30	D_DURATION	☐	OIJ_OFFSET_DUR_DMD	TSTRDURAN	DEC	11	0	Demand Period Duration (in hours:minutes)
31	D_LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
32	D_LOCID_RTAB	☐	ROIJ_LOCID_RTAB		TTYP	0	0
33	D_CUST	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
34	D_CUST_RTAB	☐	ROIJ_KUNNR_RTAB		TTYP	0	0
35	D_SHIP	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	LFA1
36	D_SHIP_RTAB	☐	ROIJ_SHIP_RTAB		TTYP	0	0
37	D_TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
38	D_TSYST_RTAB	☐	ROIJ_TSYST_RTAB		TTYP	0	0
39	D_MAXSEL	☐	TBMAXSEL	SYST_LONG	INT4	10	0	Maximum Number of Selected Entries
40	S_CHECKBOX	☐	OIJ_XFLAG_SUP	XFELD	CHAR	1	0	Select no Supply Avails
41	S_TSTMP_FROM	☐	OIJ_S_FROM	TZNTSTMPS	DEC	15	0	Supplies start timestamp
42	S_TSTMP_TO	☐	OIJ_S_TO	TZNTSTMPS	DEC	15	0	Supplies end timestamp
43	.INCLUDE	☐				0	0	Supply Period
44	S_DATE_F	☐	OIJ_DATE_F_SUP	DATS	DATS	8	0	Supply Period Start Date
45	S_DATE_T	☐	OIJ_DATE_T_SUP	DATS	DATS	8	0	Supply Period End Date
46	S_TIME_F	☐	OIJ_TIME_F_SUP	TIME	TIMS	6	0	Supply Period Start Time
47	S_TIME_T	☐	OIJ_TIME_T_SUP	TIME	TIMS	6	0	Supply Period End Time
48	S_OFFSET	☐	OIJ_OFFSET_SUP	OIJ_OFFSET	INT1	3	0	Supply Period Offset
49	S_DURATION	☐	OIJ_OFFSET_DUR_SUP	TSTRDURAN	DEC	11	0	Supply Period Duration (in hours:minutes)
50	S_LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
51	S_LOCID_RTAB	☐	ROIJ_LOCID_RTAB		TTYP	0	0
52	S_VEND	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
53	S_VEND_RTAB	☐	ROIJ_LIFNR_RTAB		TTYP	0	0
54	S_SHIP	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	LFA1
55	S_SHIP_RTAB	☐	ROIJ_SHIP_RTAB		TTYP	0	0
56	S_TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
57	S_TSYST_RTAB	☐	ROIJ_TSYST_RTAB		TTYP	0	0
58	S_MAXSEL	☐	TBMAXSEL	SYST_LONG	INT4	10	0	Maximum Number of Selected Entries
59	T_CHECKBOX	☐	OIJ_XFLAG_TRANS	XFELD	CHAR	1	0	Select no Transportation Avails
60	T_TSTMP_FROM	☐	OIJ_T_FROM	TZNTSTMPS	DEC	15	0	Transportation avails start timestamp
61	T_TSTMP_TO	☐	OIJ_T_TO	TZNTSTMPS	DEC	15	0	Transportation avails end timestamp
62	.INCLUDE	☐				0	0	Transport Period
63	T_DATE_F	☐	OIJ_DATE_F_TRANS	DATS	DATS	8	0	Transport Period Start Date
64	T_DATE_T	☐	OIJ_DATE_T_TRANS	DATS	DATS	8	0	Transport Period End Date
65	T_TIME_F	☐	OIJ_TIME_F_TRANS	TIME	TIMS	6	0	Transport Period Start Time
66	T_TIME_T	☐	OIJ_TIME_T_TRANS	TIME	TIMS	6	0	Transport Period End Time
67	T_OFFSET	☐	OIJ_OFFSET_TRANS	OIJ_OFFSET	INT1	3	0	Transport Period Offset
68	T_DURATION	☐	OIJ_OFFSET_DUR_TRANS	TSTRDURAN	DEC	11	0	Transport Period Duration (in hours:minutes)
69	T_LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
70	T_LOCID_RTAB	☐	ROIJ_LOCID_RTAB		TTYP	0	0
71	T_TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
72	T_TSYST_RTAB	☐	ROIJ_TSYST_RTAB		TTYP	0	0
73	T_VKTRA	☐	VKTRA	VKTRA	CHAR	2	0	Mode of transport	*
74	T_VKTRA_RTAB	☐	ROIJ_VKTRA_RTAB		TTYP	0	0
75	T_NMVEH	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
76	T_NMVEH_RTAB	☐	ROIJ_VHLNMR_RTAB		TTYP	0	0
77	T_CARR	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	LFA1
78	T_CARR_RTAB	☐	ROIJ_CARRNR_RTAB		TTYP	0	0
79	T_SHIP	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	LFA1
80	T_SHIP_RTAB	☐	ROIJ_SHIP_RTAB		TTYP	0	0
81	T_FC_NO	☐	OIJ_DOCNR_FCC	OIJ_DOCNR	CHAR	10	0	Freight Contract - Charter Arrangements Reference Document
82	T_FC_NO_RTAB	☐	OIJ_CPNO_RTAB		TTYP	0	0
83	T_DOCIND	☐	OIJ_DOCIND_FCC	OIJ_DOCIND	CHAR	1	0	Freight Contract - Charter Arrangements Ref. Doc. Ind.
84	T_POSNR	☐	OIJ_DOCITM_FCC	NUM06	NUMC	6	0	Freight Contract - Charter Arrangements Ref. Doc. Item
85	T_FC_POSNR_RTAB	☐	OIJ_POSNR_RTAB		TTYP	0	0
86	T_MINAV	☐	OIJ_PERIOD_MINAV	ANZTA	NUMC	3	0	Minimum availability period [day]
87	T_VHRL	☐	OIJ_PERIOD_VHRL	ANZTA	NUMC	3	0	Nomination relevance period [day]
88	T_REMCAP_QUAN	☐	OIJ_REMCAP_QUAN	MENG13	QUAN	13	3	Remaining Capacity in Quantity
89	T_REMCAP_PERC	☐	OIJ_REMCAP_PERC	DEC3_1	DEC	4	1	Remaining capacity in percentage
90	T_MAXSEL	☐	TBMAXSEL	SYST_LONG	INT4	10	0	Maximum Number of Selected Entries
91	DS_CHECKBOX	☐	OIJ_XFLAG_DS	XFELD	CHAR	1	0	Select no Distribution Schedule Items
92	DS_TSTMP_FROM	☐	OIJ_DS_FROM	TZNTSTMPS	DEC	15	0	Distribution schedule start timestamp
93	DS_TSTMP_TO	☐	OIJ_DS_TO	TZNTSTMPS	DEC	15	0	Distribution schedule end timestamp
94	.INCLUDE	☐				0	0	Distribution Schedule Period
95	DS_DATE_F	☐	OIJ_DATE_F_DS	DATS	DATS	8	0	Distribution Schedule Period Start Date
96	DS_DATE_T	☐	OIJ_DATE_T_DS	DATS	DATS	8	0	Distribution Schedule Period End Date
97	DS_TIME_F	☐	OIJ_TIME_F_DS	TIME	TIMS	6	0	Distribution Schedule Period Start Time
98	DS_TIME_T	☐	OIJ_TIME_T_DS	TIME	TIMS	6	0	Distribution Schedule Period End Time
99	DS_OFFSET	☐	OIJ_OFFSET_DS	OIJ_OFFSET	INT1	3	0	Distribution Schedule Period Offset
100	DS_DURATION	☐	OIJ_OFFSET_DUR_DS	TSTRDURAN	DEC	11	0	Distribution Schedule Period Duration (in hours:minutes)
101	DS_LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
102	DS_LOCID_RTAB	☐	ROIJ_LOCID_RTAB		TTYP	0	0
103	DS_NMVEH	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
104	DS_NMVEH_RTAB	☐	ROIJ_VHLNMR_RTAB		TTYP	0	0
105	DS_CARR	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	LFA1
106	DS_CARR_RTAB	☐	ROIJ_CARRNR_RTAB		TTYP	0	0
107	DS_SHIP	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	LFA1
108	DS_SHIP_RTAB	☐	ROIJ_SHIP_RTAB		TTYP	0	0
109	DS_VEND	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
110	DS_VEND_RTAB	☐	ROIJ_LIFNR_RTAB		TTYP	0	0
111	DS_CUST	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
112	DS_CUST_RTAB	☐	ROIJ_KUNNR_RTAB		TTYP	0	0
113	DS_NOMNR	☐	OIJ_NOMNR	OIJ_NOMNR	CHAR	20	0	Nomination number
114	DS_NOMNR_RTAB	☐	ROIJ_NOMNR_RTAB		TTYP	0	0
115	DS_NOMTK	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	OIJNOMH
116	DS_NOMTK_RTAB	☐	ROIJ_NOMTK_RTAB		TTYP	0	0
117	DS_NOMTYP	☐	OIJ_NOMTYP	OIJ_NOMTYP	CHAR	4	0	Nomination type	TOIJNOMTYP
118	DS_NOMTYP_RTAB	☐	ROIJ_NOMTYP_RTAB		TTYP	0	0
119	DS_ERNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
120	DS_ERNAM_RTAB	☐	ROIJ_ERNAM_RTAB		TTYP	0	0
121	DSMAXSEL	☐	TBMAXSEL	SYST_LONG	INT4	10	0	Maximum Number of Selected Entries
122	INCLUDE	☐	ROIJ_3WP_SCREEN_CTRL		STRU	0	0
123	FIELD_STATE	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type
124	SHOW_DMD	☐	OIJ_SHOW_DMD	XFELD	CHAR	1	0	Display/Hide Demand Items Section
125	SHOW_SUP	☐	OIJ_SHOW_SUP	XFELD	CHAR	1	0	Display/Hide Supply Avails Section
126	SHOW_TRANS	☐	OIJ_SHOW_TRANS	XFELD	CHAR	1	0	Display/Hide Transport Avails Section
127	SHOW_DS	☐	OIJ_SHOW_DS	XFELD	CHAR	1	0	Display/Hide Distribution Schedule Section
128	SHOW_DS_PEG	☐	OIJ_SHOW_PEG	XFELD	CHAR	1	0	Display/Hide Pegging Section
129	DMD_SIZE	☐	OIJ_DMD_SIZE	INT4	INT4	10	0	Demand section size (width)
130	SUP_SIZE	☐	OIJ_SUP_SIZE	INT4	INT4	10	0	Supply section size (width)
131	TRANS_SIZE	☐	OIJ_TRANS_SIZE	INT4	INT4	10	0	Transport section size (width)
132	DS_SIZE	☐	OIJ_DS_SIZE	INT4	INT4	10	0	Distribution Schedule section size (height)
133	TOP_SIZE	☐	OIJ_TOP_SIZE	INT4	INT4	10	0	Top section size (height)
134	DS_PEG_SIZE	☐	OIJ_PEG_SIZE	INT4	INT4	10	0	DS Pegging section size (height)
135	SHOW_FOOTER_CON	☐	OIJ_SHOW_FOOTER_CON	XFELD	CHAR	1	0	Display/Hide Footer Container
136	FOOTER_SIZE	☐	OIJ_FOOTER_SIZE	INT4	INT4	10	0	Footer section (height)
137	SHOW_TREE_CON	☐	OIJ_SHOW_TREE_CON	XFELD	CHAR	1	0	Display/Hide Tree Container
138	TREE_SIZE	☐	OIJ_TREE_SIZE	INT4	INT4	10	0	Tree section size (width)
139	SHOW_DMD_TREE	☐	OIJ_SHOW_DMD_TR	XFELD	CHAR	1	0	Display/Hide Demand Tree
140	SHOW_SUP_TREE	☐	OIJ_SHOW_SUP_TR	XFELD	CHAR	1	0	Display/Hide Supply Tree
141	SHOW_TRANS_TREE	☐	OIJ_SHOW_TRANS_TR	XFELD	CHAR	1	0	Display/Hide Transport Avails Tree
142	SHOW_DS_TREE	☐	OIJ_SHOW_DS_TR	XFELD	CHAR	1	0	Display/Hide Distribution Schedule Tree
143	DMD_TREE_SIZE	☐	OIJ_DMD_TR_SIZE	INT4	INT4	10	0	Demand Tree section size (height)
144	SUP_TREE_SIZE	☐	OIJ_SUP_TR_SIZE	INT4	INT4	10	0	Supply Tree section size (height)
145	TRANS_TREE_SIZE	☐	OIJ_TRANS_TR_SIZE	INT4	INT4	10	0	Transport Tree section size (height)
146	DS_TREE_SIZE	☐	OIJ_DS_TR_SIZE	INT4	INT4	10	0	Distribution Schedule Tree section size (height)
147	SHOW_TITLE	☐	OIJ_SHOW_ALV_TITLE	XFELD	CHAR	1	0	Display/Hide Title for ALV Grids
148	SHOW_CONSUMED	☐	OIJ_SHOW_CONS	XFELD	CHAR	1	0	Display/Hide Consumed Lines in ALV Grids
149	SHOW_DS_DETAIL	☐	OIJ_SHOW_DS_DETAIL	XFELD	CHAR	1	0	Display/Hide Detailed Distribution Schedule Lines
150	TRANS_COLOR	☐	OIJ_TRANS_COLOR	CHAR4	CHAR	4	0	ALV Color code for highlighted transport avails
151	ASGCTX_FCODE	☐	OIJ_CTX_FCODE	SYCHAR70	CHAR	70	0	Context menu function code
152	NEW_SEL	☐	OIJ_NEW_SEL	XFELD	CHAR	1	0	New selection flag
153	UNASGCTX_FCODE	☐	OIJ_CTX_FCODE	SYCHAR70	CHAR	70	0	Context menu function code
154	PUBLCTX_FCODE	☐	OIJ_CTX_FCODE	SYCHAR70	CHAR	70	0	Context menu function code
155	PEGCTX_FCODE	☐	OIJ_CTX_FCODE	SYCHAR70	CHAR	70	0	Context menu function code
156	SHOW_PUBL	☐	OIJ_SHOW_PUBL	XFELD	CHAR	1	0	Display/Hide Published Lines in Distribution Schedule

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_3WP_IO	DS_CARR	LFA1	LIFNR
2	ROIJ_3WP_IO	DS_CUST	KNA1	KUNNR
3	ROIJ_3WP_IO	DS_LOCID	OIJLOC	LOCID
4	ROIJ_3WP_IO	DS_NMVEH	OIGV	VEHICLE
5	ROIJ_3WP_IO	DS_NOMTK	OIJNOMH	NOMTK
6	ROIJ_3WP_IO	DS_NOMTYP	TOIJNOMTYP	NOMTYP
7	ROIJ_3WP_IO	DS_SHIP	LFA1	LIFNR
8	ROIJ_3WP_IO	DS_VEND	LFA1	LIFNR
9	ROIJ_3WP_IO	D_CUST	KNA1	KUNNR
10	ROIJ_3WP_IO	D_LOCID	OIJLOC	LOCID
11	ROIJ_3WP_IO	D_SHIP	LFA1	LIFNR
12	ROIJ_3WP_IO	D_TSYST	OIJTS	TSYST
13	ROIJ_3WP_IO	G_MATNR	MARA	MATNR
14	ROIJ_3WP_IO	G_TSYST	OIJTS	TSYST
15	ROIJ_3WP_IO	S_LOCID	OIJLOC	LOCID
16	ROIJ_3WP_IO	S_SHIP	LFA1	LIFNR
17	ROIJ_3WP_IO	S_TSYST	OIJTS	TSYST
18	ROIJ_3WP_IO	S_VEND	LFA1	LIFNR
19	ROIJ_3WP_IO	T_CARR	LFA1	LIFNR
20	ROIJ_3WP_IO	T_LOCID	OIJLOC	LOCID
21	ROIJ_3WP_IO	T_NMVEH	OIGV	VEHICLE
22	ROIJ_3WP_IO	T_SHIP	LFA1	LIFNR
23	ROIJ_3WP_IO	T_TSYST	OIJTS	TSYST

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C