SAP ABAP Table ROIJ_EL_DOC_MOT (TSW Details header / internal structure)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ_EL (Package) TSW Trader's and Scheduler's Workbench - Execution Layer

Basic Data

Table Category	INTTAB	Structure
Structure	ROIJ_EL_DOC_MOT	Table Relationship Diagram
Short Description	TSW Details header / internal structure

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	Oil TSW: TSW Relevance of order item
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
4	VBTYP	☐	OIJ_EL_VBTYP	OIJ_EL_VBTYP	CHAR	1	0	TSW Details document type
5	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
6	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
7	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
9	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
10	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
11	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
12	TSWRELV	☐	OIJ_EL_TSWRELV	XFELD	CHAR	1	0	OIL TSW: TSW relevance flag
13	CHARG	☐	OIJ_CHARG	CHARG	CHAR	10	0	Batch / Valuation type	MCH1
14	RELV_TICKET	☐	OI0_RELTYPE	OI0_RELTYPE	CHAR	6	0	IS-Oil: Relevance type	*
15	RELV_RUNDOWN	☐	OI0_RELTYPE	OI0_RELTYPE	CHAR	6	0	IS-Oil: Relevance type	*
16	PLANLOC	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	*
17	REFVBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
18	REFVBTYP	☐	OIJ_EL_VBTYP	OIJ_EL_VBTYP	CHAR	1	0	TSW Details document type
19	DEALNO	☐	OIJ_DEALNO	OIJ_DEALNO	CHAR	16	0	OIL-TSW: Deal number (trading system)
20	DEALGROUP	☐	OIJ_DEALGROUP	OIJ_DEALGROUP	CHAR	16	0	OIL-TSW: Deal group (trading system)	OIJ_EL_DEALGROUP
21	DEALTYPE	☐	OIJ_DEALTYPE	OIJ_DEALTYPE	CHAR	6	0	OIL-TSW: Deal type (trading system)	OIJ_EL_DEALTYPE
22	FROMDATE	☐	OIJ_FROMDATE	DATUM	DATS	8	0	OIL-TSW: Deal validity From date
23	TODATE	☐	OIJ_TODATE	DATUM	DATS	8	0	OIL-TSW: Deal validity To date
24	EVENTTYPE	☐	OIJ_EVENTTYPE	OIJ_EVENTTYPE	CHAR	16	0	TSW event date type	OIJ_EL_EVT_TYPE
25	PR_BASIS	☐	OIJ_EL_PR_BASIS	OIJ_EL_PR_BASIS	CHAR	20	0	Pricing basis
26	RING_TR	☐	OIJ_EL_RTR	OIJ_EL_RTR	CHAR	1	0	Ring trade identifier
27	CO_CARR	☐	OIJ_EL_CCA	LIFNR	CHAR	10	0	Connecting carrier	*
28	CO_SHIP	☐	OIJ_EL_CSH	LIFNR	CHAR	10	0	Connecting shipper	*
29	ITBOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
30	ITBUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
31	UNLIMITED	☐	OIJ_EL_TOL	OIJ_EL_TOL	CHAR	1	0	Tolerance indicator
32	DEV_FLAG	☐	OIJ_DEV_FLAG	OI0_XFELD	CHAR	1	0	Amendment for quantity control
33	DEV_MIN	☐	OIJ_DEV_MIN	DEC3_1	DEC	4	1	Percentage quantity amendment (under).
34	DEV_MAX	☐	OIJ_DEV_MAX	DEC3_1	DEC	4	1	Percentage quantity amendment (over)
35	MASS_DEV	☐	OIJ_MASS_DEV	OI0_XFELD	CHAR	1	0	Group amendment allowed
36	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
37	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
38	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
39	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
40	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
41	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
42	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
43	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
44	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
45	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
46	UPDATEFLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type
47	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
48	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
49	PROC_FLAG	☐	OI0_SELKZ	OI0_SELKZ	CHAR	1	0	Selection flag / general switch
50	PARTNR	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
51	CONPAT	☐	OIJ_CONPAT	OIJ_PARTNR	CHAR	10	0	Contract Partner
52	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
53	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
54	SOLDTO	☐	OIJ_SOLDTO	OIJ_SOLDTO	CHAR	10	0	Customer Sold-to or Vendor

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_EL_DOC_MOT	CHARG	MCH1	CHARG
2	ROIJ_EL_DOC_MOT	DEALGROUP	OIJ_EL_DEALGROUP	DEALGROUP
3	ROIJ_EL_DOC_MOT	DEALTYPE	OIJ_EL_DEALTYPE	DEALTYPE
4	ROIJ_EL_DOC_MOT	EVENTTYPE	OIJ_EL_EVT_TYPE	EVENTTYPE
5	ROIJ_EL_DOC_MOT	LOCID	OIJLOC	LOCID
6	ROIJ_EL_DOC_MOT	MANDT	T000	MANDT
7	ROIJ_EL_DOC_MOT	SITYP	TOIJ_EL_SITYPES	SITYP
8	ROIJ_EL_DOC_MOT	TSYST	OIJTS	TSYST
9	ROIJ_EL_DOC_MOT	VBELN	VBUK	VBELN

History

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