SAP ABAP View V_OIJ_CONPAT (Location Partner Vendor or Customer)

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_CONPAT
Short Description	Location Partner Vendor or Customer
Root table	TOIJ_EL_MVSCEN	TSW: Define Movement scenarios

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TOIJ_EL_MVSCEN	TOIJ_EL_MVSCEN
2	OIJRRA
3	KNA1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIJRRA	MANDT	JL	EQ				0	0
2	TOIJ_EL_MVSCEN	CLIENT	JR	EQ			AND	0	0
3	OIJRRA	RTYPE	JL	EQ				0	0
4	TOIJ_EL_MVSCEN	RTYPE	JR	EQ			AND	0	0
5	OIJRRA	RPART	JL	EQ				0	0
6	TOIJ_EL_MVSCEN	RPART	JR	EQ			AND	0	0
7	OIJRRA	MANDT	JL	EQ				0	0
8	KNA1	MANDT	JR	EQ			AND	0	0
9	OIJRRA	KUNNR	JL	EQ				0	0
10	KNA1	KUNNR	JR	EQ			AND	0	0
11	OIJRRA	WERK		EQ	' '		AND	0	0
12	OIJRRA	RTYPE		EQ	'TSW003'		OR	0	0
13	OIJRRA	RTYPE		EQ	'TSW005'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	TOIJ_EL_MVSCEN	CLIENT		☐	MANDT	☐	Client
2	MVSCENARIO	TOIJ_EL_MVSCEN	MVSCENARIO		☐	OIJ_MVSCEN	☐	TSW: Movement scenario number
3	SITYP	TOIJ_EL_MVSCEN	SITYP		☐	OIJ_SITYP	☐	Schedule type
4	DOCIND	TOIJ_EL_MVSCEN	DOCIND		☐	OIJ_DOCIND	☐	Reference document indicator (PSX)
5	WERK	OIJRRA	WERK		☐	WERKS_D	☐	Plant
6	LGORT	OIJRRA	LGORT		☐	LGORT_D	☐	Storage location
7	RPART	OIJRRA	RPART		☐	OIJ_RPART	☐	OIL-TSW: Role partner type
8	CPARID	OIJRRA	CPARID		☐	OIJ_PARTNR	☐	Location Partner
9	PARNM	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
10	TSYST	OIJRRA	TSYST		☐	OIJ_TSYST	☐	Transport system
11	LOCID	OIJRRA	LOCID		☐	OIJ_LOCID	☐	Location ID
12	RTYPE	OIJRRA	RTYPE		☐	OIJ_RTYPE	☐	OIL-TSW: Role type

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	20131127
SAP Release Created in	46C