SAP ABAP Table OIJ_EL_DOC_MOT (Oil TSW: TSW Relevance of order item)

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	TRANSP	Transparent table
Transparent table	OIJ_EL_DOC_MOT	Table Relationship Diagram
Short Description	Oil TSW: TSW Relevance of order item

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in