SAP ABAP View V_OIJ_MVSCEN (TSW Movement Scenario)

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

View Type	D	Database View
Database View	V_OIJ_MVSCEN
Short Description	TSW Movement Scenario
Root table	TOIJ_EL_SITYPES	TSW: Define valid sitypes

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TOIJ_EL_SITYPES	TOIJ_EL_SITYPES
2	TOIJ_EL_SITYPEST
3	TOIJ_EL_MVSCEN
4	TOIJ_EL_MVSCENT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TOIJ_EL_SITYPES	CLIENT	JL	EQ				0	0
2	TOIJ_EL_SITYPEST	CLIENT	JR	EQ			AND	0	0
3	TOIJ_EL_SITYPES	SITYP	JL	EQ				0	0
4	TOIJ_EL_SITYPEST	SITYP	JR	EQ			AND	0	0
5	TOIJ_EL_SITYPES	CLIENT	JL	EQ				0	0
6	TOIJ_EL_MVSCEN	CLIENT	JR	EQ			AND	0	0
7	TOIJ_EL_SITYPES	SITYP	JL	EQ				0	0
8	TOIJ_EL_MVSCEN	SITYP	JR	EQ			AND	0	0
9	TOIJ_EL_MVSCEN	CLIENT	JL	EQ				0	0
10	TOIJ_EL_MVSCENT	CLIENT	JR	EQ			AND	0	0
11	TOIJ_EL_MVSCEN	MVSCENARIO	JL	EQ				0	0
12	TOIJ_EL_MVSCENT	MVSCENARIO	JR	EQ			AND	0	0
13	TOIJ_EL_MVSCENT	CLIENT	JL	EQ				0	0
14	TOIJ_EL_SITYPEST	CLIENT	JR	EQ			AND	0	0
15	TOIJ_EL_MVSCENT	LANG	JL	EQ				0	0
16	TOIJ_EL_SITYPEST	LANG	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	TOIJ_EL_SITYPES	CLIENT		☐	MANDT	☐	Client
2	LANG	TOIJ_EL_SITYPEST	LANG		☐	SPRAS	☐	Language Key
3	SITYP	TOIJ_EL_SITYPES	SITYP		☐	OIJ_SITYP	☐	Schedule type
4	DESCRIPTION_SITY	TOIJ_EL_SITYPEST	DESCRIPTION		☐	OI0_TEXT	☐	IS-Oil: Descriptive text
5	MVSCENARIO	TOIJ_EL_MVSCEN	MVSCENARIO		☐	OIJ_MVSCEN	☐	TSW: Movement scenario number
6	DOCIND	TOIJ_EL_MVSCEN	DOCIND		☐	OIJ_DOCIND	☐	Reference document indicator (PSX)
7	BOOK_TRANSFER	TOIJ_EL_MVSCEN	BOOK_TRANSFER		☐	OIJ_EL_BOOK_TRANSFER	☐	IS-Oil: Indicator book transfer
8	VBTYP	TOIJ_EL_MVSCEN	VBTYP		☐	VBTYP	☐	SD document category
9	AUART	TOIJ_EL_MVSCEN	AUART		☐	AUART	☐	Sales Document Type
10	BSTYP	TOIJ_EL_MVSCEN	BSTYP		☐	EBSTYP	☐	Purchasing Document Category
11	BSAKZ	TOIJ_EL_MVSCEN	BSAKZ		☐	BSAKZ	☐	Control indicator for purchasing document type
12	BSART	TOIJ_EL_MVSCEN	BSART		☐	ESART	☐	Purchasing Document Type
13	BDART	TOIJ_EL_MVSCEN	BDART		☐	BDART	☐	Requirement type
14	EXGTYP	TOIJ_EL_MVSCEN	EXGTYP		☐	OIA_EXGTYP	☐	Exchange type
15	LOC_TYPE	TOIJ_EL_MVSCEN	LOC_TYPE		☐	OIJ_EL_LOC_TYPE	☐	IS-Oil: Location type in nomination
16	FUNC_GRP	TOIJ_EL_MVSCEN	FUNC_GRP		☐	OI0_GRP	☐	IS-OIL: Function group
17	CORRECTING_GROUP	TOIJ_EL_MVSCEN	CORRECTING_GROUP		☐	OI0_GRP_C	☐	IS-OIL: Function group for Ticket Correction
18	REVERTING_GROUP	TOIJ_EL_MVSCEN	REVERTING_GROUP		☐	OI0_GRP_R	☐	IS-OIL: Function group for Ticket Reversals
19	RPART	TOIJ_EL_MVSCEN	RPART		☐	OIJ_RPART	☐	OIL-TSW: Role partner type
20	RTYPE	TOIJ_EL_MVSCEN	RTYPE		☐	OIJ_RTYPE	☐	OIL-TSW: Role type
21	SHIPPING_REL	TOIJ_EL_MVSCEN	SHIPPING_REL		☐	OIJ_EL_SHIPPING_RELEVANCE	☐	IS-Oil: Shipping relevance in TSW scheduling
22	ORIG_PLANT	TOIJ_EL_MVSCEN	ORIG_PLANT		☐	OIJ_EL_CHECK_PLANT	☐	IS-Oil: TSW check plant
23	DEST_PLANT	TOIJ_EL_MVSCEN	DEST_PLANT		☐	OIJ_EL_CHECK_PLANT	☐	IS-Oil: TSW check plant
24	SD_COO_TYPE	TOIJ_EL_MVSCEN	SD_COO_TYPE		☐	AUART	☐	Sales Document Type
25	TD_CLOSE	TOIJ_EL_MVSCEN	TD_CLOSE		☐	OIG_VCLOSE	☐	Vehicle close flag; set confirmation to complete (status=6)
26	MM_COO_TYPE	TOIJ_EL_MVSCEN	MM_COO_TYPE		☐	ESART	☐	Purchasing Document Type
27	POST_AUTOMATIC	TOIJ_EL_MVSCEN	POST_AUTOMATIC		☐	OIJ_PA_INDICATOR	☐	IS-Oil TSW: Automatic processing indicator
28	RELATED_MVSCEN	TOIJ_EL_MVSCEN	RELATED_MVSCEN		☐	OIJ_MVSCEN	☐	TSW: Movement scenario number
29	DESCRIPTION_MVSC	TOIJ_EL_MVSCENT	DESCRIPTION		☐	OI0_TEXT	☐	IS-Oil: Descriptive text

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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