SAP ABAP Table ROIJ_3WP_DEFAULT (Structure for defaulting ROIJ_3WP_GRID from ROIJNOM I/H IO)

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_DEFAULT	Table Relationship Diagram
Short Description	Structure for defaulting ROIJ_3WP_GRID from ROIJNOM I/H IO

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	NOMTK	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	*
2	NOMIT	☐	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	*
3	NOMCL	☐	OIJ_NOMCL	OIJ_NOMCL	CHAR	2	0	Nomination Class
4	BUSTYP	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	*
5	NOMST	☐	OIJ_NOMST	OIJ_ISTAT	CHAR	1	0	Nomination header status	*
6	NMSHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	*
7	NMBALCH	☐	OIJ_BALCH	XFELD	CHAR	1	0	Balance check indicator (default)
8	STAGES_ID	☐	GUID_22	SYSUUID_22	CHAR	22	0	GUID in 'CHAR' format with upper-/lowercase (!)
9	WORKLIST	☐	OIJ_WORKLT	XFELD	CHAR	1	0	Worklist entry indicator
10	SENTDAT	☐	OIJ_SENDAT	DATUM	DATS	8	0	Last header action date
11	SENTTIME	☐	OIJ_SENTIM	UZEIT	TIMS	6	0	Last header action time
12	SENTNAM	☐	OIJ_SENNAM	USNAM	CHAR	12	0	Last user who worked on object
13	ITEMS	☐	OIJ_ITEMCOUNTER	NUM04	NUMC	4	0	Nomination item counter
14	COUNTER1	☐	OIJ_PLANNEDITEMS	NUM04	NUMC	4	0	Nomination planned item Counter
15	COUNTER2	☐	OIJ_SCHEDULEDITEMS	NUM04	NUMC	4	0	Nomination scheduled Item Counter
16	COUNTER3	☐	OIJ_REJECTEDITEMS	NUM04	NUMC	4	0	Nomination rejected Item Counter
17	COUNTER4	☐	OIJ_CONFIRMEDITEMS	NUM04	NUMC	4	0	Nomination confirmed Item Counter
18	COUNTER5	☐	OIJ_PARTCOMPLETEITEMS	NUM04	NUMC	4	0	Nomination partially complete Item Counter
19	COUNTER6	☐	OIJ_COMPLETEDITEMS	NUM04	NUMC	4	0	Nomination completed Item Counter
20	APO_SHIPMENT_ID	☐	GUID_22	SYSUUID_22	CHAR	22	0	GUID in 'CHAR' format with upper-/lowercase (!)
21	APO_SHIPMENT_NUM	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
22	NMBLOCK	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
23	.INCLUDE	☐				0	0	Nomination Header Default Fields
24	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
25	NMSHIPPER	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	LFA1
26	NMCARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	LFA1
27	CYCLE	☐	OIJ_CYCLE	CHAR10	CHAR	10	0	Nomination Pipeline cycle ID
28	NMWERK	☐	OIJ_WERK	WERKS	CHAR	4	0	Transport system In-transit Plant	T001W
29	NMLGORT	☐	OIJ_LGORT	LGORT	CHAR	4	0	Transport system In-transit Storage Location	T001L
30	NMVEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
31	NMVESSEL	☐	OIG_VEHID	OIG_LICNMR	CHAR	18	0	TD vehicle identifier
32	NMTPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
33	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
34	BOOKTS	☐	OIJ_BOOKTS	XFELD	CHAR	1	0	Book TS indicator
35	EV_GROUP	☐	OIG_EVGRP	OIG_EVGRP	CHAR	4	0	TD - event default group
36	VKTRA	☐	VKTRA	VKTRA	CHAR	2	0	Mode of transport	TVTR
37	QTYIN	☐	OIJ_QTYIN	MENG13	QUAN	13	3	Qty received in TS
38	QTYOUT	☐	OIJ_QTYOUT	MENG13	QUAN	13	3	Qty delivered from TS
39	UNIT	☐	OIJ_NMUNIT	MEINS	UNIT	3	0	Nomination(pipe) UoM	*
40	TST_FROM_MIN	☐	OIJ_SCHED_F	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch Start Timestamp
41	TST_TO_MAX	☐	OIJ_SCHED_T	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch End Timestamp
42	.INCLUDE	☐				0	0	Nomination Item Required Fields
43	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
44	ISTAT	☐	OIJ_ISTAT	OIJ_ISTAT	CHAR	1	0	Nomination Item status	OIJSTAT
45	ISUBSTAT	☐	OIJ_SSTAT	OIJ_SSTAT	CHAR	1	0	Nomination Item sub-status	OIJSUBSTAT
46	IDATE	☐	OIJ_IDATE	DATUM	DATS	8	0	Scheduled date
47	SCHED_TST_FROM	☐	OIJ_SCHED_F	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch Start Timestamp
48	SCHED_TST_TO	☐	OIJ_SCHED_T	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch End Timestamp
49	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
50	S_MATNR_I	☐	OIJ_SMATNR	MATNR	CHAR	18	0	Scheduled material	MARA
51	MATNR_I	☐	OIJ_MATNRI	MATNR	CHAR	18	0	Demand material	MARA
52	MENGE	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
53	UNIT_I	☐	OIJ_UNITI	MEINS	UNIT	3	0	Scheduled UoM	T006
54	UNIT_I_T	☐	OIJ_UNITI_T	MEINS	UNIT	3	0	Scheduled UoM Time	*
55	DOCIND	☐	OIJ_DOCIND	OIJ_DOCIND	CHAR	1	0	Reference document indicator (PSX)
56	DOCNR	☐	OIJ_DOCNR	OIJ_DOCNR	CHAR	10	0	Nomination Reference Document
57	DOCITM	☐	OIJ_DOCITM	NUM06	NUMC	6	0	Nomination Reference Document Item
58	DOCSCHEDLN	☐	OIJ_DOCSCHEDLN	EETEN	NUMC	4	0	Nomination Reference Document Schedule line	*
59	QTYFCR	☐	OIJ_QTYFCR	MENG13	QUAN	13	3	First requested quantity
60	QTYFCR_UOM	☐	OIJ_QTYFCR_UOM	MEINS	UNIT	3	0	First Requested Quantity UoM	*
61	WORKLIST_I	☐	OIJ_WORKLT	XFELD	CHAR	1	0	Worklist entry indicator
62	TANK	☐	OIJ_TANKAGE	OIJ_PARTNR	CHAR	10	0	Tankage Partner
63	CONS	☐	OIJ_CONSIGNEE	OIJ_PARTNR	CHAR	10	0	Consignee Partner
64	PARTNR	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
65	CONPAT	☐	OIJ_CONPAT	OIJ_PARTNR	CHAR	10	0	Contract Partner
66	INSPE	☐	OIJ_INSPECTOR	OIJ_PARTNR	CHAR	10	0	Inspector
67	IMPOEXPO	☐	OIJ_IMEXPO	LIFNR	CHAR	10	0	Import / Export Partner	LFA1
68	FLAG_IMEX	☐	OIJ_IMEXFL	OIJ_IMEXFL	CHAR	2	0	Import / Export Partner Indicator	OIJIMEX
69	OWNER	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
70	CHARG_O	☐	OIJ_CHARGO	CHARG	CHAR	10	0	Batch origin Location	*
71	CHARG_D	☐	OIJ_CHARGD	CHARG	CHAR	10	0	Batch destination Location	*
72	RVP	☐	OIJ_RVP	DEC2_1	DEC	3	1	RVP value
73	VALUATIONTYPE_O	☐	OIJ_BWTAR_O	BWTAR	CHAR	10	0	Valuation Type Origin Loc.	T149D
74	VALUATIONTYPE_D	☐	OIJ_BWTAR_D	BWTAR	CHAR	10	0	Valuation Type Destination Loc.	T149D
75	SHNUM	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
76	SHITEM	☐	OIG_SHITM	OIG_SHITM	NUMC	4	0	Shipment item	OIGSI
77	ILOCK	☐	OIJ_ILOCK	XFELD	CHAR	1	0	Nomination item complete flag
78	PRORATEQTY	☐	OIJ_PRRA_QTY	MENG13	QUAN	13	3	Prorated Quantity
79	ASSIGNEDQTY	☐	OIJ_ASSG_QTY	MENG13	QUAN	13	3	Assigned Quantity
80	ACTDAT	☐	OIJ_ACTDAT	DATUM	DATS	8	0	Last item action date
81	ACTTIME	☐	OIJ_ACTIME	UZEIT	TIMS	6	0	Last item action time
82	ACTUALS	☐	OIJ_ACTUAL	XFELD	CHAR	1	0	Nomination item partially complete
83	ACTUALQTY	☐	OIJ_ACTQTY	MENG13	QUAN	13	3	Actual posted quantity
84	ACTUALUOM	☐	OIJ_ACTUOM	MEINS	UNIT	3	0	Actual posted quantity Unit of Measure	T006
85	ITBOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
86	ITBUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
87	ITBOTOLABS	☐	OIJ_TOLABO	MENG13	QUAN	13	3	Absolute tolerance qty over
88	ITBUTOLABS	☐	OIJ_TOLABS	MENG13	QUAN	13	3	Absolute tolerance qty under
89	ITTOLUNIT	☐	OIJ_TOLUOM	MEINS	UNIT	3	0	Absolute tolerance UoM	T006
90	UNLIMITED	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
91	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
92	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
93	UPDATEXDOK	☐	OIJ_EXDOK	FLAG	CHAR	1	0	Update external details failure flag
94	INCOMPLETE_FLAG	☐	OIJ_INCOMPLETE_FLAG	OIJ_INCOMPLETE_FLAG	CHAR	1	0	Incompletion Flag
95	DOCTYP	☐	OIJ_DOCTYP	CHAR04	CHAR	4	0	Reference Document Type
96	LDRATE	☐	OIJ_EL_LDRATE	MENG13	QUAN	13	3	Planned load/discharge rate
97	LDQUOM	☐	OIJ_EL_LDQUOM	MEINS	UNIT	3	0	Planned load/discharge rate quantity UoM	*
98	LDTUOM	☐	OIJ_EL_LDTUOM	MEINS	UNIT	3	0	Planned load/discharge rate time UOM	*
99	THIRD_NOMNR	☐	OIJ_3RD_NOMNR	OIJ_NOMNR	CHAR	20	0	Partner Nomination number
100	UPMAT	☐	UPMAT	MATNR	CHAR	18	0	Pricing reference material of main item	*
101	REFITEM	☐	OIJ_REF_BOM_ITEM	OIJ_ITEM	NUMC	10	0	Higher-level item in bill of material structures	*
102	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
103	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
104	CHARG_D_CREATE	☐	OIJ_CHARG_D_C	XFELD	CHAR	1	0	Destination Batch create new flag
105	CHARG_O_CREATE	☐	OIJ_CHARG_O_C	XFELD	CHAR	1	0	Origin Batch create new flag
106	CO_CARR	☐	OIJ_EL_CCA	LIFNR	CHAR	10	0	Connecting carrier	*
107	CO_SHIP	☐	OIJ_EL_CSH	LIFNR	CHAR	10	0	Connecting shipper	*
108	CO_TSYST	☐	OIJ_EL_CTSYST	OIJ_TSYST	CHAR	10	0	Connecting Transport System	*
109	COMMCTL	☐	OIJ_NOMCOMM	OIJ_NOMCOMM	CHAR	2	0	Nomination Communication Control
110	SOLDTO	☐	OIJ_SOLDTO	OIJ_SOLDTO	CHAR	10	0	Customer Sold-to or Vendor
111	PRORATE_ROUTINE	☐	OIJ_EL_DE_PR_RT	OIJ_EL_DM_PR_RT	CHAR	6	0	Prorate Calculation Routine Type	TOIJ_EL_PR_RT
112	CHARG_L	☐	OIJ_CHARGL	CHARG	CHAR	10	0	Batch load	*
113	CHARG_L_CREATE	☐	OIJ_CHARG_L_C	XFELD	CHAR	1	0	Load Batch create new flag
114	.INCLU-H	☐				0	0	Nomination Header Administration Fields
115	ERDATH	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
116	ERZEITH	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
117	ERNAMH	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
118	AEDATH	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
119	AEZEITH	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
120	AENAMH	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
121	LOCPT	☐	OIJ_LOCPT	WERKS	CHAR	4	0	Location Partner Plant	*
122	LOCSL	☐	OIJ_LOCSL	LGORT	CHAR	4	0	Location Partner Storage Location	*
123	DOCIND_FCC	☐	OIJ_DOCIND_FCC	OIJ_DOCIND	CHAR	1	0	Freight Contract - Charter Arrangements Ref. Doc. Ind.
124	DOCNR_FCC	☐	OIJ_DOCNR_FCC	OIJ_DOCNR	CHAR	10	0	Freight Contract - Charter Arrangements Reference Document
125	DOCITM_FCC	☐	OIJ_DOCITM_FCC	NUM06	NUMC	6	0	Freight Contract - Charter Arrangements Ref. Doc. Item
126	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	*
127	TSSUOMV	☐	OIJ_TSUOMV	MEINS	UNIT	3	0	TS standard volume UoM	*
128	.INCLUDE	☐				0	0	Nomination item: marine fields
129	DOCIND_FC	☐	OIJ_DOCIND_FC	OIJ_DOCIND	CHAR	1	0	Freight Contract - Operational Terms Ref. Doc. Ind. (RDI)
130	DOCNR_FC	☐	OIJ_DOCNR_FC	OIJ_DOCNR	CHAR	10	0	Freight Contract - Operational Terms Reference Document
131	DOCITM_FC	☐	OIJ_DOCITM_FC	NUM06	NUMC	6	0	Freight Contract - Operational Terms Ref. Doc. Item

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_3WP_DEFAULT	ACTUALUOM	T006	MSEHI
2	ROIJ_3WP_DEFAULT	FLAG_IMEX	OIJIMEX	FLAG_IMEX
3	ROIJ_3WP_DEFAULT	IMPOEXPO	LFA1	LIFNR
4	ROIJ_3WP_DEFAULT	ISTAT	OIJSTAT	STATUS
5	ROIJ_3WP_DEFAULT	ISUBSTAT	OIJSUBSTAT	SUBSTATUS
6	ROIJ_3WP_DEFAULT	ITTOLUNIT	T006	MSEHI
7	ROIJ_3WP_DEFAULT	LOCID	OIJLOC	LOCID
8	ROIJ_3WP_DEFAULT	MATNR_I	MARA	MATNR
9	ROIJ_3WP_DEFAULT	NMCARRIER	LFA1	LIFNR
10	ROIJ_3WP_DEFAULT	NMLGORT	T001L	LGORT
11	ROIJ_3WP_DEFAULT	NMSHIPPER	LFA1	LIFNR
12	ROIJ_3WP_DEFAULT	NMTPLST	TTDS	TPLST
13	ROIJ_3WP_DEFAULT	NMVEHICLE	OIGV	VEHICLE
14	ROIJ_3WP_DEFAULT	NMWERK	T001W	WERKS
15	ROIJ_3WP_DEFAULT	OWNER	T149D	BWTAR
16	ROIJ_3WP_DEFAULT	PRORATE_ROUTINE	TOIJ_EL_PR_RT	PRORATE_ROUTINE	REF
17	ROIJ_3WP_DEFAULT	ROUTE	TVRO	ROUTE
18	ROIJ_3WP_DEFAULT	SHITEM	OIGSI	SHITEM
19	ROIJ_3WP_DEFAULT	SHNUM	OIGS	SHNUMBER
20	ROIJ_3WP_DEFAULT	SITYP	TOIJ_EL_SITYPES	SITYP
21	ROIJ_3WP_DEFAULT	S_MATNR_I	MARA	MATNR
22	ROIJ_3WP_DEFAULT	TSYST	OIJTS	TSYST
23	ROIJ_3WP_DEFAULT	UNIT_I	T006	MSEHI
24	ROIJ_3WP_DEFAULT	VALUATIONTYPE_D	T149D	BWTAR
25	ROIJ_3WP_DEFAULT	VALUATIONTYPE_O	T149D	BWTAR
26	ROIJ_3WP_DEFAULT	VKTRA	TVTR	VKTRA

History

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