SAP ABAP View M_OIKLB (SHLP: LID selection by controlfields)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
⤷ OIK (Package) TAS/TPI Common Objects
⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
⤷ OIK (Package) TAS/TPI Common Objects
Basic Data
View Type | D | Database View |
Database View | M_OIKLB | |
Short Description | SHLP: LID selection by controlfields | |
Root table | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | OIKLIDW | OIKLIDW | ||
2 | OIKCFW |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | OIKLIDW | CLIENT | JL | EQ | 0 | 0 | ||||
2 | OIKCFW | CLIENT | JR | EQ | AND | 0 | 0 | |||
3 | OIKLIDW | LIDNO | JL | EQ | 0 | 0 | ||||
4 | OIKCFW | LIDNO | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | CLIENT | OIKLIDW | CLIENT | MANDT | Client | |||
2 | LIDNO | OIKLIDW | LIDNO | OIK_LID | LOAD ID | |||
3 | CONTRTYP | OIKLIDW | CONTRTYP | OIK_CNTTYP | Control structure type | |||
4 | SOLDTO | OIKCFW | SOLDTO | KUNAG | Sold-to party | |||
5 | SHIPTO | OIKCFW | SHIPTO | KUNWE | Ship-to party | |||
6 | VSTEL | OIKCFW | VSTEL | VSTEL | Shipping Point/Receiving Point | |||
7 | WERKS | OIKCFW | WERKS | WERKS_D | Plant | |||
8 | LGORT | OIKCFW | LGORT | LGORT_D | Storage location | |||
9 | MATKL | OIKCFW | MATKL | MATKL | Material Group | |||
10 | MATNR | OIKCFW | MATNR | MATNR | Material Number | |||
11 | OIHANTYP | OIKCFW | OIHANTYP | OIH_HANTYP | Excise Duty Handling Type | |||
12 | TPLST | OIKCFW | TPLST | TPLST | Transportation planning point | |||
13 | VEHICLE | OIKCFW | VEHICLE | OIG_VHLNMR | TD Vehicle Number | |||
14 | DRIVERCODE | OIKCFW | DRIVERCODE | OIG_DRVNMR | TD driver number | |||
15 | BWTAR | OIKCFW | BWTAR | BWTAR_D | Valuation type | |||
16 | SHIFT | OIKCFW | SHIFT | OIG_SHIFT | TD driver shift | |||
17 | TRIP | OIKCFW | TRIP | OIG_TRIP | Trip Number | |||
18 | OIC_MOT | OIKCFW | OIC_MOT | OIC_MOT | IS-OIL MAP external details mode of transport | |||
19 | VSBED | OIKCFW | VSBED | VSBED | Shipping conditions | |||
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 |