SAP table OIGSVC (TD Transport Unit in Shipment)
SAP table OIGSVC has 4 primary key fields being CLIENT,SHNUMBER,VEH_NR,TPU_NR.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SHNUMBER | TD shipment number | CHAR | 10 | 0 | OIGS | OIG_SHNUM | |
| VEH_NR | Vehicle Sequence Number in Shipment | NUMC | 3 | 0 | OIGSV | OIG_VEHNR | |
| TPU_NR | Transport unit sequence number in shipment | NUMC | 3 | 0 | OIG_TPUNR | ||
| TU_NUMBER | TD transport unit number | CHAR | 10 | 0 | OIGC | OIG_TRUNMR | |
| TU_TYPE | TD Transport unit type | CHAR | 4 | 0 | TOIGC | OIG_TRUTYP | |
| WGT_UOM | TD weight unit of measure | UNIT | 3 | 0 | T006 | OIG_WGTUOM | |
| TU_ID | TD transport unit identifier | CHAR | 18 | 0 | OIG_LICNMR | ||
| TU_NRCOMPS | Number of compartments (TD) | INT1 | 3 | 0 | OIG_NMRCMP | ||
| TU_NRMETS | TD number of meters on the transport unit | INT1 | 3 | 0 | OIG_NMRMET | ||
| TU_UNLWGT | TD transport unit unladen weight | FLTP | 16 | 16 | OIG_TUUWT | ||
| TU_MAXWGT | TD transport unit maximum weight | FLTP | 16 | 16 | OIG_TUMWT | ||
| TU_HEIGHT | TD transport unit height | QUAN | 13 | 3 | OIG_TUHGT | ||
| TU_WIDTH | TD transport unit width | QUAN | 13 | 3 | OIG_TUWDT | ||
| TU_LENGTH | TD transport unit length | QUAN | 13 | 3 | OIG_TULEN | ||
| TU_AXLES | TD: number of axles on transport units | NUMC | 1 | 0 | OIG_AXLE | ||
| TU_MAXVOL | TD transport unit maximum volume | FLTP | 16 | 16 | OIG_TUMVL | ||
| VOL_UOM | TD volume unit of measure | UNIT | 3 | 0 | T006 | OIG_VOLUOM | |
| DIM_UOM | Unit of measure for length/width/height | UNIT | 3 | 0 | T006 | OIG_MEABM | |
| EQUIP_NR | Equipment Number | CHAR | 18 | 0 | EQUI | EQUNR | |
| CRE_DATE | Created On | DATS | 8 | 0 | ERSDA | ||
| CRE_NAME | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| CRE_TIME | Entry time | TIMS | 6 | 0 | ERZET | ||
| CHA_DATE | Date of Last Change | DATS | 8 | 0 | LAEDA | ||
| CHA_NAME | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| CHA_TIME | Time of Change | TIMS | 6 | 0 | AEZEIT | ||
| SHNUM_PRV | Previous shipment number | CHAR | 10 | 0 | OIGS | OIG_SHNUMP | |
| SHNUM_NXT | Previous shipment number | CHAR | 10 | 0 | OIGS | OIG_SHNUMP | |
| RECFLGPTL | Indicator for reconciliation of prior to load | CHAR | 1 | 0 | OIG_RECPTL | ||
| RECFLGLOV | Indicator for reconciliation of left on vehicle qty. | CHAR | 1 | 0 | OIG_RECLOV |
OIGSVC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 OIGSVC | CLIENT | T000 | Clients | MANDT |
| 1 OIGSVC | DIM_UOM | T006 | Units of Measurement | MANDT |
| 1 OIGSVC | DIM_UOM | T006 | Units of Measurement | MSEHI |
| 0 OIGSVC | EQUIP_NR | EQUI | Equipment master data | MANDT |
| 1 OIGSVC | SHNUMBER | OIGS | TD Shipment Header | CLIENT |
| 1 OIGSVC | SHNUMBER | OIGS | TD Shipment Header | SHNUMBER |
| 0 OIGSVC | SHNUM_NXT | OIGS | TD Shipment Header | CLIENT |
| 0 OIGSVC | SHNUM_NXT | OIGS | TD Shipment Header | SHNUMBER |
| 1 OIGSVC | SHNUM_PRV | OIGS | TD Shipment Header | CLIENT |
| 1 OIGSVC | SHNUM_PRV | OIGS | TD Shipment Header | SHNUMBER |
| 0 OIGSVC | TU_NUMBER | OIGC | TD Transport unit | CLIENT |
| 0 OIGSVC | TU_NUMBER | OIGC | TD Transport unit | TU_NUMBER |
| 1 OIGSVC | TU_TYPE | TOIGC | TD Transport Unit Type | CLIENT |
| 1 OIGSVC | TU_TYPE | TOIGC | TD Transport Unit Type | TU_TYPE |
| 0 OIGSVC | VEH_NR | OIGSV | TD Vehicles in Transport/Shipment | CLIENT |
| 1 OIGSVC | WGT_UOM | T006 | Units of Measurement | MANDT |
| 1 OIGSVC | WGT_UOM | T006 | Units of Measurement | MSEHI |