| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 54 | KUNDE | Customer to Whom Serial Number was Delivered | nvarchar | 10 | 0 | | |
| 2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 54 | KUNDE | Customer to Whom Serial Number was Delivered | nvarchar | 10 | 0 | | |
| 3 | CNVC_SCNG_HEAD | Comparison run header | 3 | KUNDE | Customer | nvarchar | 16 | 0 | | |
| TOPActual CostingMaterial Ledger |
| 4 | FCML_ALT | Alternatives | 19 | KUNDE | Customer Number (Alternative) | nvarchar | 10 | 0 | | |
| 5 | FCML_PROC | Business Processes | 21 | KUNDE | Customer Number (Process) | nvarchar | 10 | 0 | | |
| TOPAllocation |
| 6 | AUKAI | Worklist for Sales Orders (FBG) | 16 | KUNDE | Customer no. of plant | nvarchar | 10 | 0 | | |
| TOPBasic Functions |
| 7 | VBKOF | SD index: Open sales activities by partner function | 2 | KUNDE | Partner number (KUNNR, LIFNR, or PERNR) | nvarchar | 10 | 0 | | |
| 8 | VBKPA | SD index: Sales activities by partner function | 2 | KUNDE | Partner number (KUNNR, LIFNR, or PERNR) | nvarchar | 10 | 0 | | |
| TOPBilling |
| 9 | VRKPA | Sales Index: Bills by Partner Functions | 2 | KUNDE | Partner number (KUNNR, LIFNR, or PERNR) | nvarchar | 10 | 0 | | |
| TOPEnhancements SD |
| 10 | ESDADFD | Maintenance of Additional Fields for Scheduling Agreement | 2 | KUNDE | Customer Number | nvarchar | 10 | 0 | | |
| TOPEquipment |
| 11 | EQUI | Equipment master data | 49 | KUNDE | Customer to Whom Serial Number was Delivered | nvarchar | 10 | 0 | | |
| TOPMarketing Retail Network |
| 12 | OIFPBL | Index to point at Business Location | 3 | KUNDE | Partner number (KUNNR, LIFNR, or PERNR) | nvarchar | 10 | 0 | | |
| TOPMaster Data |
| 13 | EKON | Franchise Contract MasterData | 5 | KUNDE | Business Partner Number | nvarchar | 10 | 0 | | |
| TOPMove-InOut |
| 14 | EAUS | Move-out Doc. for Contract Acc. | 3 | KUNDE | Business Partner Number | nvarchar | 10 | 0 | | |
| 15 | EEIN | Move-in Doc. for ContAcc. | 4 | KUNDE | Business Partner Number | nvarchar | 10 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 16 | /BEV1/CLDEB | Customer Information | 39 | KUNDE | Customer's Customer Number | nvarchar | 20 | 0 | | |
| TOPSales |
| 17 | VAKPA | Sales Index: Orders by Partner Function | 2 | KUNDE | Partner number (KUNNR, LIFNR, or PERNR) | nvarchar | 10 | 0 | | |
| TOPSerial Numbers |
| 18 | EQSE | Serial Number Records | 14 | KUNDE | Customer to Whom Serial Number was Delivered | nvarchar | 10 | 0 | | |
| 19 | SER01 | Document Header for Serial Numbers for Delivery | 7 | KUNDE | Customer Number | nvarchar | 10 | 0 | | |
| 20 | SER02 | Document Header for Serial Nos for Maint.Contract (SD Order) | 7 | KUNDE | Partner number (KUNNR, LIFNR, or PERNR) | nvarchar | 10 | 0 | | |
| 21 | SER03 | Document Header for Serial Numbers for Goods Movements | 15 | KUNDE | Customer Number | nvarchar | 10 | 0 | | |
| 22 | SERI | Serial Numbers | 13 | KUNDE | Sold-to party | nvarchar | 10 | 0 | | |
| TOPShipping |
| 23 | VLKPA | SD Index: Deliveries by Partner Functions | 2 | KUNDE | Partner number (KUNNR, LIFNR, or PERNR) | nvarchar | 10 | 0 | | |
| TOPTravel Expenses |
| 24 | PTRV_ARCHIVE | Administrative Table for Archived Trip Data | 8 | KUNDE | Reason for trip (e.g. customer/requisitioner) | nvarchar | 17 | 0 | | |
| 25 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 15 | KUNDE | Reason for Trip (for example, customer/requisitioner) | nvarchar | 59 | 0 | | |
| 26 | PTRV_HEAD | General Trip Data | 15 | KUNDE | Reason for Trip (for example, customer/requisitioner) | nvarchar | 59 | 0 | | |
| 27 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 19 | KUNDE | Reason for trip (e.g. customer/requisitioner) | nvarchar | 17 | 0 | | |
| 28 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 21 | KUNDE | Reason for Trip (for example, customer/requisitioner) | nvarchar | 59 | 0 | | |
| 29 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 21 | KUNDE | Reason for Trip (for example, customer/requisitioner) | nvarchar | 59 | 0 | | |
| TOPTravel Planning |
| 30 | FTPT_TM_MEMO | Memo table for Travel Management | 11 | KUNDE | Reason for trip (e.g. customer/requisitioner) | nvarchar | 17 | 0 | | |
