| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | MSPT_OIGS | TD Shipment Header to store deleted records | 58 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
2 | S950E | S950 - Info structurelles | 3 | TPLST | Point de planification du transport | nvarchar | 4 | 0 | | |
3 | S951E | S951 - Info structurelles | 3 | TPLST | Point de planification du transport | nvarchar | 4 | 0 | | |
4 | TMS_C_TRA | Ext. Transport Manag.: Determination of Transfer Relev. TRA | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
5 | TNAD8 | Output Control: Printers by Shipping Point | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPConditions |
6 | B022 | TrspPlPoint and Shipment Type | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
7 | B023 | TrspPlPoint, TrspProcessingType and Service Agent | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPDangerous Goods Management |
8 | TDGA9 | DG: Check Schema Determination Routines for Shipment Docs | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
9 | TDGB7 | DG: Assign DG check schemata for transport documents | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
10 | TDGD17 | EHS: Determ. Routine for Template Processing in Shipment | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
11 | TDGD19 | EHS: Validity Template Processing for Shipment Documents | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPData Collection |
12 | S050 | Shipment | 8 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
13 | S050E | S050 - Structural Information | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
14 | S051 | Shipment routes | 8 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
15 | S051E | S051 - Structural Information | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
16 | S052 | Means of transportation | 8 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
17 | S052E | S052 - Structural Information | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
18 | S053 | Shipment: shipping data | 8 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
19 | S053E | S053 - Structural Information | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
20 | S054 | Stages of shipment | 8 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
21 | S054E | S054 - Structural Information | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
22 | S055 | Shipment: materials | 8 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
23 | S055E | S055 - Structural Information | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
24 | S950 | TRANSPORTS | 8 | TPLST | Point de planification du transport | nvarchar | 4 | 0 | | |
25 | S951 | TRANSPORTS2 | 8 | TPLST | Point de planification du transport | nvarchar | 4 | 0 | | |
TOPDirect Store Delivery |
26 | /DSD/C_OC_PRCDEF | Def. of Sales Doc. Type & Item Usage for Price Determination | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPDownloadUpload |
27 | /DSD/HH_DRVTXT | DSD: Download HH - Driver Messages | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
28 | /DSD/HH_TRADAT | DSD: Download HH - Volume of the Transferred Shipment Data | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPFreight Processing |
29 | TVFAP | Shipment Cost Information Profile Data | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
30 | TVFCSF | Pricing Procedure Determination | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
31 | TVFP | Assignment of Purchasing Data for Shipment Costs | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
32 | TVFPTZ | Tariff Zone Assignment for Postal Code Area | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
33 | TVFPTZH | Tariff Zone Assignment for Postal Code Area Header Data | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
34 | VFKP | Shipment Costs: Item Data | 14 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPGoods Receipt Process |
35 | BORRTTS | Route schedule header (new) | 10 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPInterface to Terminal Automation System |
36 | OIK01 | IS-OIL/TAS: LID Document Data | 78 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
37 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 79 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
38 | OIKCF | TAS - Control Field Data | 14 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
39 | OIKCFW | TAS - Control Field Data | 14 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
40 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 45 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
41 | OIKLIDR | TD - TAS Reference Table | 45 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
42 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 45 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
43 | OIKPEXLOC | OIL: Status of gen. Location in ext. Transport Planning Sy | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
44 | OIKPEXORD | Status of Orders Within Transportation Planning | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
45 | OIKTPIRD | TPI: SD doc. - obsolete - but needed for XPRA ROIKXTPIREL | 17 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
46 | OIKTTDS | OIL-TPI: Transportation planning point additional data | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
47 | OIKTTDSTX | OIL-TPI: Text IDs per TPP and interface type | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
48 | OIKVD | TPI: Vehicle/Driver assignment | 6 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
49 | TOIKDCP | Delivery Confirmatio Process | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPLogistics - General |
50 | OIFSPBL | Physical Location - Master Data | 35 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
51 | OIJTS | Transport system (IS-Oil TSW standard/core object ) | 20 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPMain Process |
52 | /VSO/M_PLT_TP | Assignment Plant to Transportation Planning Point (VSO) | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPProduct Safety |
53 | TCGR5 | EHS: Condition Schema for RGV Selection - Table 5 | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
54 | /BEV1/RPDBLART | Permissible Delivery and Order Types for Dynamic Dispatch | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
55 | /BEV1/RPFA | Driver Master (Route Planning) | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
56 | /BEV1/RPFZ | Vehicle Master (Route Planning) | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
57 | /BEV1/RPTO | Route Master (Route Planning) | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
58 | /BEV1/RSCOBART | Difference Document Types for Check-Out | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
59 | /BEV1/RSZABSTA | Route Settlement - Permiss. Settlem. Types per Shipment Type | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
60 | /DSD/LD_CR_STAT | DSD - LD: Load Delivery Shipment Status | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
61 | /DSD/LD_DFTVAL | DSD - LD: Load Delivery Standard Value | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
62 | /DSD/ME_CPT_USER | Data from Handheld User | 5 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
63 | /DSD/ME_CPT_VEHI | Maintenance Table for Vehicles in DSD Cockpit | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPReporting |
64 | VTSFF | Updating Sequence: Statistics Shipment | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPRoute Settlement |
65 | /DSD/SL_ASL_EXCL | DSD: Control of Automatic Settlement | 8 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
66 | /DSD/SL_TBSOASSM | DSD Route Settlement: Settlement Office Determ. for Shipm. | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPSCM Basis |
67 | CIF_IMSHP | Integration Model Reference Table for Shipments | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPStock Visibility |
68 | /DSD/SV_LC_CUS | Customizing Settings for Loading Confirmation Dialog | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
69 | /DSD/SV_LC_HD | DSD LC: Loading Confirmation Header | 6 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPTour Status |
70 | /DSD/ST_CSCEN_SH | Assignment shipment <-> delivery scenario | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
71 | /DSD/ST_CTYPE_SH | Shipment relevant for DSD | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
72 | /DSD/ST_STATUS | Current tour status | 12 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPTraders and Schedulers Workbench |
73 | B453 | Shpm.type/Carrier/Inspector/Shipper/TranSys/TrspPlanPt | 9 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
74 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 23 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
75 | OIJNOMH | Nomination Header | 71 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
76 | OIJNOMHVERS | Nomination Header Version Table | 64 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
77 | OIJ_EL_TICKET_H | Universal ticket table | 8 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
78 | TOI0_REL_SD | IS-OIL: Relevance customizing for SD Documents | 20 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPTransportation |
79 | TTDS | Organizational Unit: Transportation Scheduling Point | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
80 | TTDST | Organizational Unit: Transportation Scheduling Point: Texts | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
81 | TTPLST | Determination of Transportation Planning Point f. BAPI Call | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
82 | TVARS | Archiving Control Shipment | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
83 | TVT_CA_TRA | Transportation Basis Data for Forwarding Agent | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
84 | VTCFPP | Freight Planning Transfer Profile | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
85 | VTDST | Status of deliveries within transportation planning | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
86 | VTDSTC | Condition of Deliveries for Freight Planning by Fwdng Agent | 22 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
87 | VTLST | Status of Gen. Location in Ext. Transportatn Planning System | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
88 | VTPRG | Transport. planng system cumulation proc. for delivery item | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
89 | VTPRL | Transportation Planning System Route Limitations | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
90 | VTTK | Shipment Header | 5 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPTransportation and Distribution |
91 | B410 | Transportation Planning Point | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
92 | B411 | Transport Planning Point / Loading Plant | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
93 | OIGS | TD Shipment Header | 58 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
94 | TOIGTXT | Default Texts For Shipment Header | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPTransportation Planning |
95 | /BEV1/RPLMT | Capacity Limit Dynamic Dispatch | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
96 | /DSD/RP_DRVTPLST | Assign Possible Transportation Planning Points to Driver | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
97 | /DSD/RP_FLTTPLST | Transportation Planning Point of a Vehicle | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
98 | /DSD/RP_LMT | Capacity Limit: Dynamic Transportation Planning | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
99 | /DSD/RP_TOH | Tour Master, Header Data | 4 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPTransportation Planning Interface |
100 | TOIKTPIREL | TPI: Transportation Planning Point for Relevancy Type | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
TOPVisit Control |
101 | /DSD/VC_DELIVER | DSD: Delivery Types for DSD | 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |
102 | /DSD/VC_V7_PRN | DSD: Message Types for Print Output for Shipment | 3 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | |