| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPDirect Store Delivery |
| 1 | /DSD/C_OC_PRCDEF | Def. of Sales Doc. Type & Item Usage for Price Determination | 4 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| TOPFunds Management |
| 2 | FMCI | Commitment items master data | 13 | VPTYP | Carryforward item category for commitment item | nvarchar | 2 | 0 | | |
| 3 | FMFPO | FIFM: Commitment Item | 21 | VPTYP | Carryforward item category for commitment item | nvarchar | 2 | 0 | | |
| 4 | FMPG | Commitment Items in FM Area/Fiscal Year | 9 | VPTYP | Carryforward item category for commitment item | nvarchar | 2 | 0 | | |
| 5 | FMVORTR | Cmmt items for carryover item category of totals records | 3 | VPTYP | Carryforward item category for commitment item | nvarchar | 2 | 0 | | |
| 6 | FMVORTR0 | Carryforward Item Categories of Totals Records | 3 | VPTYP | Carryforward item category for commitment item | nvarchar | 2 | 0 | | |
| TOPRecycling Administration Core Functions |
| 7 | J_7LV01 | REA Packaging Master Data: General Data | 4 | VPTYP | Packaging Class | nvarchar | 1 | 0 | | |
| TOPRoute Settlement |
| 8 | /DSD/SL_ASL_EXCL | DSD: Control of Automatic Settlement | 9 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| TOPTour Status |
| 9 | /DSD/ST_CSCEN_VL | Assignment visit list <-> sales scenario | 3 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 10 | /DSD/ST_CTYPE_VL | Visit list relevant for DSD | 2 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 11 | /DSD/ST_STATUS | Current tour status | 13 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| TOPTransportation Planning |
| 12 | /DSD/RP_TOH | Tour Master, Header Data | 3 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 13 | /DSD/RP_TOP | Tour Master, Item Data | 3 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| TOPVisit Control |
| 14 | /DSD/VC_VLC_ARCH | Archiving: Residence Time Maintenance | 2 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 15 | /DSD/VC_VLH | DSD: Visit List - Header Data | 6 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 16 | /DSD/VC_VLTRADAT | DSD: Download VL - Extent of Visit List Transfer | 2 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 17 | /DSD/VC_VL_PRN | DSD: Message Types for Print Output for Each Visit List | 2 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 18 | /DSD/VC_VPH | DSD: Visit Schedule - Header Data | 4 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 19 | /DSD/VC_VPTYPE | DSD: Visit Schedule Type | 2 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
| 20 | /DSD/VC_VPTYPET | DSD: Visit Schedule Type - Texts | 2 | VPTYP | Visit Plan Type | nvarchar | 3 | 0 | | |
