SAP ABAP Table ROIKDCSV (Vehicles in Shipment for delivery confirmation process)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
⤷ OIK_DC (Package) TAS Delivery confirmation
⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
⤷ OIK_DC (Package) TAS Delivery confirmation
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIKDCSV | Table Relationship Diagram |
Short Description | Vehicles in Shipment for delivery confirmation process |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Io/Area for Vehicle in Shipments | |||||
2 | .INCLUDE | 0 | 0 | TD Vehicles in Transport/Shipment | |||||
3 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | SHNUMBER | OIG_SHNUM | OIG_SHNUM | CHAR | 10 | 0 | TD shipment number | OIGS | |
5 | VEH_NR | OIG_VEHNR | OIG_VEHNR | NUMC | 3 | 0 | Vehicle Sequence Number in Shipment | * | |
6 | VEHICLE | OIG_VHLNMR | OIG_VHLNMR | CHAR | 10 | 0 | TD Vehicle Number | OIGV | |
7 | .INCLUDE | 0 | 0 | TD Vehicle header data in transport | |||||
8 | COMP_GROUP | OIG_VEHCUSTGRP | OIG_VCG | CHAR | 8 | 0 | TD Vehicle Customer group | TOIGBV | |
9 | VEH_TYPE | OIG_VHLTYP | OIG_VHLTYP | CHAR | 4 | 0 | TD vehicle type | TOIGV | |
10 | VEH_ID | OIG_VEHID | OIG_LICNMR | CHAR | 18 | 0 | TD vehicle identifier | ||
11 | CARRIER | OIG_LIFNR | LIFNR | CHAR | 10 | 0 | TD carrier (vendor account number) | LFA1 | |
12 | VEH_NRTUS | OIG_NMRTU | OIG_NMRTU | NUMC | 2 | 0 | Number of transport units on vehicle (TD) | ||
13 | VOL_UOM | OIG_VOLUOM | MEINS | UNIT | 3 | 0 | TD volume unit of measure | T006 | |
14 | WGT_UOM | OIG_WGTUOM | MEINS | UNIT | 3 | 0 | TD weight unit of measure | T006 | |
15 | DIM_UOM | OIG_DIMUOM | MEINS | UNIT | 3 | 0 | TD dimension unit of measure | T006 | |
16 | VEH_MAXWGT | OIG_VEHMWT | OIB_ADQNT | FLTP | 16 | 16 | TD vehicle maximum weight | ||
17 | VEH_UNLWGT | OIG_VEHUWT | OIB_ADQNT | FLTP | 16 | 16 | TD vehicle unladen weight | ||
18 | VEH_MAXVOL | OIG_VEHMVL | OIB_ADQNT | FLTP | 16 | 16 | TD vehicle maximum volume | ||
19 | EQUIP_NR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | EQUI | |
20 | VEH_HEIGHT | OIG_VEHHEI | MENG13 | QUAN | 13 | 3 | Vehicle height | ||
21 | VEH_WIDTH | OIG_VEHWID | MENG13 | QUAN | 13 | 3 | TD width | ||
22 | VEH_LENGTH | OIG_VEHLEN | MENG13 | QUAN | 13 | 3 | Vehicle length | ||
23 | ROUTE | OIG_ROUTEV | ROUTE | CHAR | 6 | 0 | TD-F vehicle route | TVRO | |
24 | TZONE | TZNZONE | TZNZONE | CHAR | 6 | 0 | Time Zone | TTZZ | |
25 | CALENDAR | CR_WFCID | WFCID | CHAR | 2 | 0 | Factory calendar ID | TFACD | |
26 | DEPOT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
27 | VEH_SCREL | OIG_VHSCREL | OIG_VHLNMR | CHAR | 10 | 0 | Freight cost relevant vehicle | OIGV | |
28 | .INCLUDE | 0 | 0 | TD Vehicle, Marine Scheduling Attributes | |||||
29 | NAME_EFF_DATE | OIG_NMEFFDT | OIG_NMEFFDT | DATS | 8 | 0 | Name Effective Date | * | |
30 | CLF_EFDT | OIG_CLFEFFDT | OIG_CLFEFFDT | DATS | 8 | 0 | Vehicle Classification Effective Date | * | |
31 | REG_CNTRY | OIG_REG_CNTR | LAND1 | CHAR | 3 | 0 | Vehicle Registered Country | T005 | |
32 | REG_DATE | OIG_REGDT | OIG_REGDT | DATS | 8 | 0 | TD-Vehicle Registered Date | * | |
33 | OWNER | OIG_VEH_OWNER | OIG_VEH_OWNER | CHAR | 20 | 0 | TD-Vehicle Owner | ||
34 | REG_OWNER | OIG_VEH_REG_OWN | OIG_VEH_REG_OWN | CHAR | 20 | 0 | TD-Vehicle Registered Owner | ||
35 | GRP_ID | OIG_BR_CP_GRP_ID | OI0_CP_GRP_ID | CHAR | 10 | 0 | TD-Vehicle Berth Compatibility Group ID | TOI0_CP_GRP | |
36 | OWN_FLAG | OIG_VOWNFL | OIG_VOWNFL | CHAR | 1 | 0 | TD-Vehicle Own Flag | ||
37 | BALLCAP | OIG_BALLCAP | OIG_BALLCAP | QUAN | 13 | 3 | TD-Vehicle Ballast Capacity | ||
38 | FL_BNK_CAPA | OIG_FL_BNK_CAPA | OIG_FL_BNK_CAPA | QUAN | 13 | 3 | TD-Vehicle Fuel Bunker Capacity | ||
39 | DSL_BNK_CAPA | OIG_DSL_BNK_CAPA | OIG_DSL_BNK_CAPA | QUAN | 13 | 3 | TD-Vehicle Diesel Bunker Capacity | ||
40 | CAP_UOM | OIG_CAP_UOM | MEINS | UNIT | 3 | 0 | UoM of TD-Vehicle Bunker Capacity | T006 | |
41 | WT_UOM | OIG_WT_UOM | MEINS | UNIT | 3 | 0 | UoM of TD-Vehicle(For Draft) | T006 | |
42 | CLASS_GRP | OIG_CL_GRP | OIG_CL_GRP | CHAR | 10 | 0 | TD-Vehicle Classification Group | TOIGVCLGR | |
43 | VHCLSIGN | OIG_VHCLSIGN | OIG_VHCLSIGN | CHAR | 10 | 0 | TD-Vehicle Call Sign | ||
44 | STCMNR | OIG_STCMNR | OIG_STCMNR | CHAR | 30 | 0 | TD-Vehicle Telex Number | ||
45 | SRFXNR | OIG_STFXNR | OIG_STFXNR | CHAR | 30 | 0 | TD-Vehicle Fax Number | ||
46 | DRAFT | OIG_VEH_DRAFT | OIG_VEH_DRAFT | QUAN | 13 | 3 | Maximum Vehicle Draft | ||
47 | OIG_SSTSF | OIG_SSTSF | OIG_SSTSF | CHAR | 1 | 0 | TD Shipment Status (Functional) | ||
48 | LDDATE | OIG_LDDATE | DATUM | DATS | 8 | 0 | Loading Date | ||
49 | LDTIME | OIG_LDTIME | TIME | TIMS | 6 | 0 | Loading time | ||
50 | SHIFT | OIG_SHIFT | OIG_SHIFT | CHAR | 1 | 0 | TD driver shift | TOIGH | |
51 | TRIP | OIG_TRIP | OIG_TRIP | NUMC | 5 | 0 | Trip Number | ||
52 | RTDATE | OIG_RTDATE | DATUM | DATS | 8 | 0 | Date of return | ||
53 | RTTIME | OIG_RTTIME | TIME | TIMS | 6 | 0 | Time of return | ||
54 | PRINTFLG | OIG_PRNTFL | OIG_PRNTFL | CHAR | 1 | 0 | Output selection flag (indicates print required) | ||
55 | DDCDAT | OIG_DDCDAT | DATUM | DATS | 8 | 0 | Document date in delivery confirmation | ||
56 | PSTDAT | OIG_PSTDAT | DATUM | DATS | 8 | 0 | Posting date in delivery confirmation | ||
57 | MBLNRGL | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
58 | MBLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
59 | MJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
60 | VCLOSE | OIG_VCLOSE | CHAR1_X | CHAR | 1 | 0 | Vehicle close flag; set confirmation to complete (status=6) | ||
61 | GLPST | OIG_GLPST | CHAR1_X | CHAR | 1 | 0 | TD gain/loss postings at vehicle close | ||
62 | VBALNC | OIG_VBALNC | CHAR1_X | CHAR | 1 | 0 | TD vehicle balance check against tolerance table (TOIGS5) | ||
63 | REAS_CODE | OIG_REASCD | OIG_REASC | CHAR | 2 | 0 | Reason code - to group quantities in shipment process | TOIGS4 | |
64 | CHK_OVL | OIG_CHKOVL | CHAR1_X | CHAR | 1 | 0 | TD check overloading | ||
65 | CRE_DATE | ERSDA | DATUM | DATS | 8 | 0 | Created On | ||
66 | CRE_NAME | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
67 | CRE_TIME | ERZEIT | UHRZT | TIMS | 6 | 0 | Time, at Which Record Was Added | ||
68 | CHA_DATE | LAEDA | DATUM | DATS | 8 | 0 | Date of Last Change | ||
69 | CHA_NAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
70 | CHA_TIME | AEZEIT | UHRZT | TIMS | 6 | 0 | Time of Change | ||
71 | TPPOINT | TPLST | TPLST | CHAR | 4 | 0 | Transportation planning point | TTDS | |
72 | FBSTA | OIG_VFBSTA | FBSTA | CHAR | 1 | 0 | Status of shipment costing vehicle level | ||
73 | FBGST | OIG_VFBGST | FBGST | CHAR | 1 | 0 | Overall status of shipment costing vehicle level | ||
74 | ARSTA | OIG_VARSTA | ARSTA | CHAR | 1 | 0 | Status of shipment cost settlement vehicle level | ||
75 | ARGST | OIG_VARGST | ARGST | CHAR | 1 | 0 | Overall status of shipment cost settlement vehicle level | ||
76 | SKALSM | OIG_KALSM_V | KALSM | CHAR | 6 | 0 | Pricing procedure in vehicle of shipment | T683 | |
77 | ACT_WGT | OIG_VACTWT | OIB_ADQNT | FLTP | 16 | 16 | Actual weight of vehicle | ||
78 | ACT_VOL | OIG_VACTVL | OIB_ADQNT | FLTP | 16 | 16 | Actual volume for vehicle | ||
79 | UNL_WGT | OIG_VUNWT | OIB_ADQNT | FLTP | 16 | 16 | TD vehicle unladen weight | ||
80 | MAX_WGT | OIG_VMXWT | OIB_ADQNT | FLTP | 16 | 16 | TD vehicle maximum weight | ||
81 | MAX_VOL | OIG_VMXVL | OIB_ADQNT | FLTP | 16 | 16 | TD vehicle maximum weight | ||
82 | VEH_TEXT | OIG_VHLTXT | OIG_TEXT | CHAR | 40 | 0 | TD vehicle header text | ||
83 | SHIFT_TEXT | OIG_SHIFTT | OIG_TEXT | CHAR | 40 | 0 | Shift description | ||
84 | UPDATEFLAG | TRTYP | TRTYP | CHAR | 1 | 0 | Transaction type | ||
85 | VEH_TYTEXT | OIG_VHTYTX | OIG_TEXT | CHAR | 40 | 0 | TD vehicle type text | ||
86 | STAT_TEXT | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
87 | TPLST_TEXT | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
88 | GROUPTEXT | OIG_VCGT | OIG_TEXT | CHAR | 40 | 0 | TD vehicle group text | ||
89 | EQKTX | KTX01 | TEXT40 | CHAR | 40 | 0 | Description of technical object | ||
90 | VEH_MODE | OIG_VMOT | OIG_VMOT | CHAR | 1 | 0 | TD vehicle mode of transport | ||
91 | MODE_TEXT | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
92 | CARR_TEXT | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
93 | VEH_STATUS | OIG_VEHSTA | OIG_VEHSTA | CHAR | 1 | 0 | TD vehicle status | ||
94 | WGT_TEXT | MSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
95 | VOL_TEXT | MSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
96 | VEH_AS_IND | OIG_ASIND | XFELD | CHAR | 1 | 0 | TD-F Indicator for quantity assignment completed | ||
97 | DISTZ | DISTZ | MENG13 | QUAN | 13 | 3 | Distance | ||
98 | MEDST | MEDST | MEINS | UNIT | 3 | 0 | Unit of measure for distance | * | |
99 | OIG_GESZTD | OIG_GESZTD | OIG_GESZT | QUAN | 13 | 2 | Total time for stage | ||
100 | OIG_FAHZTD | OIG_FAHZTD | OIG_GESZT | QUAN | 13 | 2 | Total travel time for stage | ||
101 | MEIZT | MEIZT | MEINS | UNIT | 3 | 0 | Unit of measure for travelling times | * | |
102 | ROUTE_BEZ | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
103 | FBSTA_BEZ | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
104 | FBGST_BEZ | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
105 | ARSTA_BEZ | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
106 | ARGST_BEZ | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
107 | GESZTD | OIGGESZTDP | TSTRDURAG | DEC | 11 | 0 | TD Planned total time for stage (in days) | ||
108 | FAHZTD | OIGEFFZTDP | TSTRDURAN | DEC | 11 | 0 | TD - planned duration for stage (in hours:minutes) | ||
109 | GESZTDA | OIGGESZTDA | TSTRDURAG | DEC | 11 | 0 | TD - actual total time for shipment stage (in days) | ||
110 | FAHZTDA | OIGEFFZTDA | TSTRDURAN | DEC | 11 | 0 | TD - actual duration for shipment stage (in hours:minutes) | ||
111 | DEPOT_TEXT | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
112 | TZONE_TEXT | TZNDESCTZN | TEXT30 | CHAR | 30 | 0 | Time Zone Text | ||
113 | VEH_SCREL_TYPE | OIG_VHLTYP | OIG_VHLTYP | CHAR | 4 | 0 | TD vehicle type | * | |
114 | VEL_AVG | OIJ_VEL_AVG | MENG13 | QUAN | 13 | 3 | Average Velocity | ||
115 | VEL_UOM | OIJ_VEL_UOM | MEINS | UNIT | 3 | 0 | Velocity UoM | T006 | |
116 | VEL_UOMT | OIJ_VEL_UOMT | MEINS | UNIT | 3 | 0 | Velocity - Time | T006 | |
117 | RC_MGAIN | OIG_REASCD | OIG_REASC | CHAR | 2 | 0 | Reason code - to group quantities in shipment process | * | |
118 | RC_MLOSS | OIG_REASCD | OIG_REASC | CHAR | 2 | 0 | Reason code - to group quantities in shipment process | * | |
119 | RC_VGAIN | OIG_REASCD | OIG_REASC | CHAR | 2 | 0 | Reason code - to group quantities in shipment process | * | |
120 | RC_VLOSS | OIG_REASCD | OIG_REASC | CHAR | 2 | 0 | Reason code - to group quantities in shipment process | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIKDCSV | CALENDAR | TFACD | IDENT | |||
2 | ROIKDCSV | CAP_UOM | T006 | MSEHI | |||
3 | ROIKDCSV | CARRIER | LFA1 | LIFNR | |||
4 | ROIKDCSV | CLASS_GRP | TOIGVCLGR | CLASS_GRP | |||
5 | ROIKDCSV | CLIENT | T000 | MANDT | |||
6 | ROIKDCSV | COMP_GROUP | TOIGBV | GROUPNAME | |||
7 | ROIKDCSV | DEPOT | T001W | WERKS | |||
8 | ROIKDCSV | DIM_UOM | T006 | MSEHI | |||
9 | ROIKDCSV | EQUIP_NR | EQUI | EQUNR | |||
10 | ROIKDCSV | GRP_ID | TOI0_CP_GRP | GRP_ID | REF | C | CN |
11 | ROIKDCSV | REAS_CODE | TOIGS4 | REAS_CODE | |||
12 | ROIKDCSV | REG_CNTRY | T005 | LAND1 | |||
13 | ROIKDCSV | ROUTE | TVRO | ROUTE | |||
14 | ROIKDCSV | SHIFT | TOIGH | SHIFT | |||
15 | ROIKDCSV | SHNUMBER | OIGS | SHNUMBER | |||
16 | ROIKDCSV | SKALSM | T683 | KALSM | |||
17 | ROIKDCSV | TPPOINT | TTDS | TPLST | |||
18 | ROIKDCSV | TZONE | TTZZ | TZONE | |||
19 | ROIKDCSV | VEHICLE | OIGV | VEHICLE | KEY | 1 | CN |
20 | ROIKDCSV | VEH_SCREL | OIGV | VEHICLE | |||
21 | ROIKDCSV | VEH_TYPE | TOIGV | VEH_TYPE | |||
22 | ROIKDCSV | VEL_UOM | T006 | MSEHI | |||
23 | ROIKDCSV | VEL_UOMT | T006 | MSEHI | |||
24 | ROIKDCSV | VOL_UOM | T006 | MSEHI | |||
25 | ROIKDCSV | WGT_UOM | T006 | MSEHI | |||
26 | ROIKDCSV | WT_UOM | T006 | MSEHI |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |