| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | A514 | ServcAgent/Ship.type | 5 | VSART | Shipping type for shipment stage | nvarchar | 2 | 0 | | |
2 | MSPT_OIGS | TD Shipment Header to store deleted records | 39 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPBasic Functions |
3 | ANKP | Asset classes: Fld Cont Dpndnt on Chart of Depreciation | 12 | VSART | Asset insurance type | nvarchar | 2 | 0 | | |
4 | ANKV | Asset classes: insurance types | 4 | VSART | Asset insurance type | nvarchar | 2 | 0 | | |
5 | ANLV | Insurance data | 6 | VSART | Asset insurance type | nvarchar | 2 | 0 | | |
6 | T099 | Insurance types | 2 | VSART | Asset insurance type | nvarchar | 2 | 0 | | |
7 | T099T | Description of Insurance Types | 3 | VSART | Asset insurance type | nvarchar | 2 | 0 | | |
TOPClinical System |
8 | N2DLV_RECEIVER | i.s.h.med: Dispatch - Recipient | 9 | VSART | Dispatch Type - Key | nvarchar | 10 | 0 | | |
9 | TN2DLV_RECART | i.s.h.med: Dispatch Control - Recipient Types | 5 | VSART | Dispatch Type - Key | nvarchar | 10 | 0 | | |
10 | TN2DLV_VSART | i.s.h.med: Dispatch - Dispatch Types | 3 | VSART | Dispatch Type - Key | nvarchar | 10 | 0 | | |
11 | TN2DLV_VSART_T | i.s.h.med: Dispatch Control - Dispatch Type (Text) | 3 | VSART | Dispatch Type - Key | nvarchar | 10 | 0 | | |
TOPCollectionsDisbursements |
12 | TKKVINVER | Dunning Information Procedure | 13 | VSART | Dispatch Medium | nvarchar | 1 | 0 | | |
TOPConditions |
13 | A135 | Transp. service agent/shipping type/bulk group | 5 | VSART | Shipping type for shipment stage | nvarchar | 2 | 0 | | |
14 | A508 | ServcAgent/Ship.type | 5 | VSART | Shipping type for shipment stage | nvarchar | 2 | 0 | | |
TOPFreight Processing |
15 | TVFPTZ | Tariff Zone Assignment for Postal Code Area | 4 | VSART | Shipping type | nvarchar | 2 | 0 | | |
16 | TVFPTZH | Tariff Zone Assignment for Postal Code Area Header Data | 4 | VSART | Shipping type | nvarchar | 2 | 0 | | |
17 | VFKP | Shipment Costs: Item Data | 15 | VSART | Shipping type for shipment stage | nvarchar | 2 | 0 | | |
TOPGermany |
18 | PA0026 | HR Master Record: Infotype 0026 (Company Insurance) | 30 | VSART | Insurance type | nvarchar | 4 | 0 | | |
19 | PA0126 | Infotype: Supplementary Pension Germany | 24 | VSART | Pension Type | nvarchar | 4 | 0 | | |
20 | T5D15 | EDI Funds | 9 | VSART | EDI - Encryption Type | nvarchar | 2 | 0 | | |
21 | T5DP8 | Conversion of Infotype 0026 -> PAISY | 3 | VSART | Insurance type | nvarchar | 4 | 0 | | |
TOPLogistics - General |
22 | OIJTS | Transport system (IS-Oil TSW standard/core object ) | 5 | VSART | Shipping type | nvarchar | 2 | 0 | | |
23 | WBHD | Trading Contract: Commercial Data | 56 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPMaterials Management |
24 | /ISDFPS/DG_EXCPT | DG Management: Exception Requests DG Check OBSOLETE | 3 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPPension Administration |
25 | PA0782 | HR Master Record Infotype 0782 | 28 | VSART | Pension Type | nvarchar | 80 | 0 | | |
TOPPersonnel Administration |
26 | PA0037 | HR Master Record: Infotype 0037 (Insurance) | 24 | VSART | Insurance type | nvarchar | 4 | 0 | | |
TOPProduct Safety |
27 | TCGR5 | EHS: Condition Schema for RGV Selection - Table 5 | 5 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPPublic Sector |
28 | PA0484 | HR Master Record Infotype 0484 (Joint Taxation A) | 24 | VSART | Type of Taxation | nvarchar | 4 | 0 | | |
29 | T5D5G | Supplementary Pension Public Sector: Combination Table | 3 | VSART | Insurance Type to Be Reported | nvarchar | 2 | 0 | | |
30 | T5D5GT | Insurance Types for Supplementary Pension in Public Sector | 1 | VSART | Insurance Type to Be Reported | nvarchar | 2 | 0 | | |
TOPPurchasing |
31 | EKKO | Purchasing Document Header | 92 | VSART | Shipping type | nvarchar | 2 | 0 | | |
32 | EKPO | Purchasing Document Item | 123 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPR2-R3 Link |
33 | LDK04 | Communication Rec. 04 LVS Decentr.: DN Supplem. R/2 -> ERP | 13 | VSART | Dispatch type from delivery document for WMS link | nvarchar | 2 | 0 | | |
TOPSales |
34 | VBKD | Sales Document: Business Data | 71 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPShipping |
35 | LDA01 | Decentralized WMS: Delivery Document Appendix | 12 | VSART | Dispatch type from delivery document for WMS link | nvarchar | 2 | 0 | | |
36 | LIKP | SD Document: Delivery Header Data | 123 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPSimulation |
37 | VSVBKD_CN | Version: Sales document - commercial data | 72 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPSwitzerland |
38 | PA0046 | HR Master Record: Infotype 0046 (Company Pension Fund CH) | 24 | VSART | Insurance type | nvarchar | 2 | 0 | | |
39 | T5C18 | Pension Funds - Insurance Types | 3 | VSART | Key specification for insurance type | nvarchar | 2 | 0 | | |
40 | T5C1D | Texts for Pension Funds | 4 | VSART | Key specification for insurance type | nvarchar | 2 | 0 | | |
TOPTraders and Schedulers Workbench |
41 | B450 | OIL-TSW: Carrier/Shipping Type | 5 | VSART | Shipping type | nvarchar | 2 | 0 | | |
42 | OIJNOMH | Nomination Header | 57 | VSART | Shipping type | nvarchar | 2 | 0 | | |
43 | OIJNOMHVERS | Nomination Header Version Table | 50 | VSART | Shipping type | nvarchar | 2 | 0 | | |
44 | OIJ_STAGES | TSW (&TD) Shipment Stages | 15 | VSART | Shipping type for shipment stage | nvarchar | 2 | 0 | | |
TOPTransportation |
45 | T173 | Routes: Mode of Transport for Each Shipping Type | 2 | VSART | Shipping type | nvarchar | 2 | 0 | | |
46 | T173T | Routes: Mode of Transport by Shipping Type: Texts | 3 | VSART | Shipping type | nvarchar | 2 | 0 | | |
47 | TGAVF | Determine Freight Code Set | 4 | VSART | Shipping type | nvarchar | 2 | 0 | | |
48 | TTPLST | Determination of Transportation Planning Point f. BAPI Call | 3 | VSART | Shipping type | nvarchar | 2 | 0 | | |
49 | TVRAB | Route Stages | 19 | VSART | Shipping type | nvarchar | 2 | 0 | | |
50 | TVRO | Routes | 15 | VSART | Shipping type | nvarchar | 2 | 0 | | |
51 | TVRSZ | Routes: Legs for each Route | 5 | VSART | Shipping type | nvarchar | 2 | 0 | | |
52 | TVTK | Shipment Types | 11 | VSART | Shipping type | nvarchar | 2 | 0 | | |
53 | VTRDI | Shipment Planning Index | 30 | VSART | Shipping type | nvarchar | 2 | 0 | | |
54 | VTTK | Shipment Header | 16 | VSART | Shipping type | nvarchar | 2 | 0 | | |
55 | VTTS | Stage of Shipment | 14 | VSART | Shipping type for shipment stage | nvarchar | 2 | 0 | | |
TOPTransportation and Distribution |
56 | OIGS | TD Shipment Header | 39 | VSART | Shipping type | nvarchar | 2 | 0 | | |
57 | OIGSS | TD Shipment Stages | 15 | VSART | Shipping type for shipment stage | nvarchar | 2 | 0 | | |
58 | TOIGS | TD Shipment Types | 39 | VSART | Shipping type | nvarchar | 2 | 0 | | |
TOPVehicle Management System |
59 | VLCBATCHACT | VELO : Variant for Action Execution in Batch | 75 | VSART | Shipping type | nvarchar | 2 | 0 | | |