| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /BIC/B0000285000 | PSA for 0PERSON_ATTR T90CLNT090 Person | 16 | COUNC | | nvarchar | 3 | 0 | | |
| 2 | /SMD/MD_____00PJ | SID-Tabelle fuer County code | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 3 | P2HK_TAXADR | HR-HK: Payroll structure for Tax Quarters - Tax year | 11 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 4 | T77PADRU_OGRN | Main State Registration Numbers | 9 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 5 | T7RU50 | Personnel areas/subareas region assignment | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 6 | T7RU9A | Addresses of organizations | 20 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 7 | T7RUAA | KLADR: Cities | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 8 | T7RUAB | KLADR: Boroughs (City districts) | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 9 | T7RUAD | KLADR: Streets | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 10 | T7RUCOUNTY | KLADR: Counties (Regional districts) | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 11 | T7RUCOUNTYT | KLADR: Counties (Regional districts): Texts | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 12 | T7RUPA0006 | PA0006 copy | 58 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 13 | T7RURK | Regional Coefficient for Region and County | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 14 | T7RUSC_OGRN | Main State Registration Codes | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 15 | TZD0A | Darwin: Customer default values per trans. type for KNA1 | 12 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPAddress ManagementBusiness Address |
| 16 | T005E | County | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 17 | T005F | County: Texts | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPAdvertising Management |
| 18 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 96 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPBank Customer Accounts |
| 19 | BKKPOGISP | EDI Payments: Reporting Data to Clearing, Segm. E1EDLA1 | 15 | COUNC | County code | nvarchar | 9 | 0 | | |
| TOPBilling |
| 20 | VBRK | Billing Document: Header Data | 34 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPBusiness Partner Enhancements for Financial Services |
| 21 | BP1020 | BP: Business Partner - Fiscal Data | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPConditions |
| 22 | A041 | Country/State/County/Customer Classif.2/Material Classif.2 | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 23 | DFKKMOPK | Items in contract account document | 52 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 24 | DFKKOPK | Items in contract account document | 52 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 25 | DFKKREV06 | Report for Tax on Sales/Purchases (bill. time or triggered) | 23 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 26 | DFKKREV07 | Report on Tax on Sales/Purchases (clearing time) | 29 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 27 | TEARGIPER | ARGENTINA: Revenue tax municipal rate | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 28 | TEARMACOF | ARGENTINA: Revenue tax municipal distribution coefficient | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 29 | TEARREPCONTRT | ARGENTINA: Legal report revenue tax control table | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 30 | TEARREVTAX_M | ARGENTINA: Legal report revenue tax attributes at municipe | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 31 | TFKARCOF_C | Argentina: Revenue tax distribution coefficient - County | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 32 | TFKARGIPER_C | Argentina: Revenue tax rate - County | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 33 | TFKARGROUP_C | Argentina: Reporting time definition at County level | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 34 | TFKARMZPKT_C | Argentina: Reporting time definition at County level | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 35 | TFKARREPCONTRT | ARGENTINA: Legal report revenue tax control table | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPCross-Application Components |
| 36 | BC490KKNA1 | General data in customer master | 48 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 37 | KKNA1 | General Data in Customer Master | 48 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 38 | SKNA1 | Customer Master table for BC417 Course | 48 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPCustomer Master |
| 39 | KNA1 | General Data in Customer Master | 48 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPData Collection |
| 40 | S008 | Communications Table SD -> CO/Projects | 54 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPHong Kong |
| 41 | PA0344 | HR Master Record: Infotype 0344 (Familiy members HK) | 28 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 42 | PA0351 | HR Master Record: Infotype 0351 (Country Information) | 25 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPInformation System |
| 43 | DKKOS | Balance Audit Trail | 19 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 44 | DKOKS | Open Item Account Balance Audit Trail Master Record | 20 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPJapan |
| 45 | T5J61 | HR Address Information of Pers. Subarea for Residence Tax | 7 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 46 | T5J62 | HR Address Information of Personnel Subarea for Income Tax | 7 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 47 | T5JAD | HR company office address JP | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 48 | T5JL1 | HR Address Infomation 1 of Personnel Subarea for LI JP | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 49 | T5JL2 | HR Address Infomation 2 of Personnel Subarea for LI JP | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 50 | T5JSI | HR Branch Office Information for Social Insurance JP | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 51 | T7JPBT_BUSOFFICE | Define Business Establishments | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPLocalization |
| 52 | J_1ATAXID | Tax Class | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPLogistics Basic Data |
| 53 | DMF_D_T001W | Transferred Sites | 21 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPMaster Data |
| 54 | EHAUISU | Connect. Obj. | 3 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 55 | JGTSADR | IS-M: Extended Address Management | 56 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPPatient Accounting |
| 56 | NVBRK | IS-H: Billing document header data | 24 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 57 | JFRK | IS-M/SD: Billing - Header Data | 24 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 58 | JITCIRCBOOK | IS-M/SD: Circulation Book with Delivery Quantities | 46 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPPersonnel Administration |
| 59 | PA0006 | HR Master Record: Infotype 0006 (Addresses) | 58 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 60 | PA0517 | HR Master Record: Infotype 0517 | 31 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 61 | T500P | Personnel Areas | 13 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 62 | T7PLD1 | Payee data | 13 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 63 | T7PLD2 | GUS reporting entity data | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 64 | T7PLE1 | County GUS code according to TERYT | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 65 | T7PLE2 | Municipality GUS code according to TERYT | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 66 | T7PLE3 | Keys for conversion TERYT GUS codes | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 67 | T7PLE4 | TERYT municipality GUS codes texts | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 68 | T7PLET | TERYT municipality GUS codes texts | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPPlant Master |
| 69 | T001W | Plants/Branches | 21 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPRecruitment |
| 70 | PB0006 | HR Master Record: Infotype 0006 (Addresses) | 58 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPRegional structure |
| 71 | ADRSTRTISU | IS-U Applic. Data for Street | 17 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPTaiwan |
| 72 | PA0352 | NHI for Family member (TW) | 37 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 73 | T7TW0A | ZIP code | 4 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 74 | T7TW0Z | ZIP code | 6 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPTariffs, Duties and Permits |
| 75 | OIH22 | Interstate excise table | 5 | COUNC | County Code | nvarchar | 3 | 0 | | |
| 76 | OIHL | License Master Data | 25 | COUNC | County Code | nvarchar | 3 | 0 | | |
| TOPTreasury |
| 77 | VZKNA1 | Collector for batch input KNA1 from RF-VV | 26 | COUNC | County Code | nvarchar | 3 | 0 | | |
