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
⤷ 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
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 |