| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMD/MD_____00QP | SID-Tabelle fuer City code | 5 | CITYC | City Code | nvarchar | 4 | 0 | | |
| 2 | P2CO_COSSA | PC2CO_SSA | 56 | CITYC | City ID | nvarchar | 3 | 0 | | |
| 3 | P2CO_COSSP | PC2CO_SSP | 19 | CITYC | City of residence ID | nvarchar | 3 | 0 | | |
| 4 | T7SAPBS46 | Schools for KSA Public Sector Scholarship | 5 | CITYC | City Code | nvarchar | 4 | 0 | | |
| 5 | TZD0A | Darwin: Customer default values per trans. type for KNA1 | 13 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPAdvertising Management |
| 6 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 97 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPBilling |
| 7 | VBRK | Billing Document: Header Data | 35 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPBusiness Partner Enhancements for Financial Services |
| 8 | BP1020 | BP: Business Partner - Fiscal Data | 7 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPConditions |
| 9 | A042 | Country/State/City/Customer Classif.3/Material Classif.3 | 6 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPCosting |
| 10 | COER | Sales Order Value Revenue | 67 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPCross-Application Components |
| 11 | BC490KKNA1 | General data in customer master | 49 | CITYC | City Code | nvarchar | 4 | 0 | | |
| 12 | KKNA1 | General Data in Customer Master | 49 | CITYC | City Code | nvarchar | 4 | 0 | | |
| 13 | SKNA1 | Customer Master table for BC417 Course | 49 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPCustomer Master |
| 14 | KNA1 | General Data in Customer Master | 49 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPData Collection |
| 15 | S008 | Communications Table SD -> CO/Projects | 55 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPInformation System |
| 16 | DKKOS | Balance Audit Trail | 20 | CITYC | City Code | nvarchar | 4 | 0 | | |
| 17 | DKOKS | Open Item Account Balance Audit Trail Master Record | 21 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPLocalization |
| 18 | A292 | BR: ISS from SD: Ship-to-City | 6 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPLogistics Basic Data |
| 19 | DMF_D_T001W | Transferred Sites | 22 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPMaster Data |
| 20 | JGTSADR | IS-M: Extended Address Management | 57 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPPatient Accounting |
| 21 | NVBRK | IS-H: Billing document header data | 25 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 22 | JFRK | IS-M/SD: Billing - Header Data | 25 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPPersonnel Administration |
| 23 | PA0880 | HR master record for infotypes 0880 | 37 | CITYC | City of residence ID | nvarchar | 3 | 0 | | |
| 24 | T500P | Personnel Areas | 14 | CITYC | City Code | nvarchar | 4 | 0 | | |
| 25 | T7CO01 | Additional data of the company | 12 | CITYC | City ID | nvarchar | 3 | 0 | | |
| 26 | T7CO04A | Social insurance entities | 18 | CITYC | City ID | nvarchar | 3 | 0 | | |
| 27 | T7CO05 | Social Insurance branches | 6 | CITYC | City ID | nvarchar | 3 | 0 | | |
| 28 | T7COT2 | Payroll external results transfer: COSSA | 56 | CITYC | City ID | nvarchar | 3 | 0 | | |
| TOPPlant Master |
| 29 | T001W | Plants/Branches | 22 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPTariffs, Duties and Permits |
| 30 | OIH22 | Interstate excise table | 6 | CITYC | City Code | nvarchar | 4 | 0 | | |
| 31 | OIHL | License Master Data | 26 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPTechnical Application Support |
| 32 | T005G | City | 4 | CITYC | City Code | nvarchar | 4 | 0 | | |
| 33 | T005H | City: Texts | 5 | CITYC | City Code | nvarchar | 4 | 0 | | |
| TOPTreasury |
| 34 | VZKNA1 | Collector for batch input KNA1 from RF-VV | 27 | CITYC | City Code | nvarchar | 4 | 0 | | |
