SAP ABAP View V_OIGSDS (View Shipments assigned to driver)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIG (Package) TD Transport and Distribution

Basic Data

View Type	D	Database View
Database View	V_OIGSDS
Short Description	View Shipments assigned to driver
Root table	OIGS	TD Shipment Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIGS	OIGS
2	OIGSVD
3	OIGSV
4	OIGD
5	TOIGH

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIGS	CLIENT	JL	EQ				0	0
2	OIGSV	CLIENT	JR	EQ			AND	0	0
3	OIGS	SHNUMBER	JL	EQ				0	0
4	OIGSV	SHNUMBER	JR	EQ			AND	0	0
5	OIGSV	CLIENT	JL	EQ				0	0
6	OIGSVD	CLIENT	JR	EQ			AND	0	0
7	OIGSV	SHNUMBER	JL	EQ				0	0
8	OIGSVD	SHNUMBER	JR	EQ			AND	0	0
9	OIGSV	VEH_NR	JL	EQ				0	0
10	OIGSVD	VEH_NR	JR	EQ			AND	0	0
11	OIGD	CLIENT	JL	EQ				0	0
12	OIGS	CLIENT	JR	EQ			AND	0	0
13	OIGD	DRIVERCODE	JL	EQ				0	0
14	OIGSVD	DRIVERCODE	JR	EQ			AND	0	0
15	TOIGH	CLIENT	JL	EQ				0	0
16	OIGSV	CLIENT	JR	EQ			AND	0	0
17	TOIGH	SHIFT	JL	EQ				0	0
18	OIGSV	SHIFT	JR	EQ			AND	0	0
19	OIGSV	OIG_SSTSF		LT	'6'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	OIGS	CLIENT		☐	MANDT	☐	Client
2	LOAD_STDT	OIGS	LOAD_STDT		☐	OIG_LDSTDT	☐	Planned date for start of loading
3	SHNUMBER	OIGS	SHNUMBER		☐	OIG_SHNUM	☐	TD shipment number
4	TPLST	OIGS	TPLST		☐	TPLST	☐	Transportation planning point
5	VEH_NR	OIGSV	VEH_NR		☐	OIG_VEHNR	☐	Vehicle Sequence Number in Shipment
6	DRIVERCODE	OIGSVD	DRIVERCODE		☐	OIG_DRVNMR	☐	TD driver number
7	SHIFT	OIGSV	SHIFT		☐	OIG_SHIFT	☐	TD driver shift
8	OIG_VEHST	OIGSV	OIG_SSTSF		☐	OIG_SSTSF	☐	TD Shipment Status (Functional)
9	OIG_SSTSF	OIGS	OIG_SSTSF		☐	OIG_SSTSF	☐	TD Shipment Status (Functional)
10	LAST_NAME	OIGD	LAST_NAME		☐	OIG_DRNAM2	☐	Driver's last name
11	FIRST_NAME	OIGD	FIRST_NAME		☐	OIG_DRNAME	☐	Driver's first name
12	CARRIER	OIGD	CARRIER		☐	OIG_LIFNR	☐	TD carrier (vendor account number)
13	VEHICLE	OIGSV	VEHICLE		☐	OIG_VHLNMR	☐	TD Vehicle Number

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	20110901
SAP Release Created in