| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /1CADMC/00000454 | T005U | 7 | BLAND | | nvarchar | 3 | 0 | | |
| 2 | /SMD/MD_____00DN | SID-Tabelle fuer Region | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 3 | /SMD/MD_____00GY | SID-Tabelle fuer PO Box Region | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 4 | /SMD/MD_____01CY | SID-Tabelle fuer Region | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 5 | P2CO_COSSA | PC2CO_SSA | 55 | BLAND | Work location department | nvarchar | 2 | 0 | | |
| 6 | P2CO_COSSP | PC2CO_SSP | 18 | BLAND | Residence department | nvarchar | 3 | 0 | | |
| 7 | T5FPBS3B | Code commune INSEE | 7 | BLAND | Région (Etat, land, province, comté, etc.) | nvarchar | 3 | 0 | | |
| 8 | T7RUREGION | KLADR: Regions (Provinces) | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 9 | T7RUREGIONT | KLADR: Regions (Provinces): Texts | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 10 | T7RU_005Y | KLADR: Regions - territorial entity | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPAddress ManagementBusiness Address |
| 11 | T005S | Taxes: Region (Province) Key | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 12 | T005U | Taxes: Region Key: Texts | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPBank |
| 13 | T005P | Validation of tax keys | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPBasic Data |
| 14 | NC301P | IS-H EDI Data Collection Points | 16 | BLAND | IS-H: Region (Federal State, Province, County) | nvarchar | 3 | 0 | | |
| TOPBelgium |
| 15 | T5B5D | Match Belgium Postal codes to region | 2 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPChina |
| 16 | T7CN71 | Province Key for CN | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPClinical System |
| 17 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 42 | BLAND | IS-H: Bölge (eyalet, il, ilçe, belde) | nvarchar | 3 | 0 | | |
| 18 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 43 | BLAND | IS-H: Bölge (eyalet, il, ilçe, belde) | nvarchar | 3 | 0 | | |
| 19 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 43 | BLAND | IS-H: Bölge (eyalet, il, ilçe, belde) | nvarchar | 3 | 0 | | |
| TOPFinancial Accounting |
| 20 | T059Q | Withholding Tax | 14 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 21 | T059R | Recipient Code | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPFlexible Real Estate Management |
| 22 | TIVFGEMAGEME | LUM: Zuordnung Gemarkung zu Gemeinde | 3 | BLAND | Bundesland | nvarchar | 3 | 0 | | |
| 23 | TIVFGEMARK | LUM: Gemarkung | 3 | BLAND | Bundesland | nvarchar | 3 | 0 | | |
| 24 | TIVFGEMARKT | LUM: Gemarkung - Texte | 3 | BLAND | Bundesland | nvarchar | 3 | 0 | | |
| 25 | TIVFGEMEINDE | LUM: Gemeinde | 3 | BLAND | Bundesland | nvarchar | 3 | 0 | | |
| 26 | TIVFGEMEINDET | LUM: Gemeinde - Texte | 3 | BLAND | Bundesland | nvarchar | 3 | 0 | | |
| 27 | TIVFKREIS | LUM: Kreis | 3 | BLAND | Bundesland | nvarchar | 3 | 0 | | |
| 28 | TIVFKREIST | LUM: Kreis - Texte | 3 | BLAND | Bundesland | nvarchar | 3 | 0 | | |
| TOPGeographical Functions |
| 29 | GEOT005S | Table Containing Geocoordinates at Country- and Region Level | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPGermany |
| 30 | T5D0P | Plant/Personnel Subarea (D) | 11 | BLAND | State | nvarchar | 3 | 0 | | |
| TOPInformation System |
| 31 | T001M | Data on Z5A Foreign Trade Regulations Report, Germany | 5 | BLAND | Federal State Key | nvarchar | 2 | 0 | | |
| TOPItaly |
| 32 | T5ITM4 | District indicator table | 7 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPLocalization |
| 33 | J_1BTREGX | Tax region | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 34 | TCUST_NATURE_IT | Define Customer as Natural Person | 5 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPMalaysia |
| 35 | T5LSC | Table to maintain state codes for EPF download formats | 2 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPPatient Management |
| 36 | NPAT | IS-H: Patient Master Data (General) | 33 | BLAND | IS-H: Region (Federal State, Province, County) | nvarchar | 3 | 0 | | |
| TOPPersonnel Administration |
| 37 | PA0880 | HR master record for infotypes 0880 | 36 | BLAND | Residence department | nvarchar | 3 | 0 | | |
| 38 | T7CO01 | Additional data of the company | 11 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 39 | T7CO04A | Social insurance entities | 17 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 40 | T7CO05 | Social Insurance branches | 5 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 41 | T7COT2 | Payroll external results transfer: COSSA | 55 | BLAND | Work location department | nvarchar | 2 | 0 | | |
| TOPPersonnel Management |
| 42 | T7HRMU | Municipality codes (Croatia) | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPRussia |
| 43 | T7RUGA | Garnishment: Region Key | 3 | BLAND | Region (State, Province, County) for Garnishments | nvarchar | 3 | 0 | | |
| 44 | T7RUGZ | Garnishment: Region Key: Texts | 4 | BLAND | Region (State, Province, County) for Garnishments | nvarchar | 3 | 0 | | |
| TOPSAP Utilities |
| 45 | TE014_COMP_IND | Components for LPC, PPI, Interest | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 46 | TE014_EXEM_IND | LPC Exemptions | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 47 | TE014_TOL_IND | LPC/PPI limits | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 48 | TFK056_EXM_IND | Interest Exemptions | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| 49 | TFK056_SLB_IND | Interest Slabs | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPTariffs, Duties and Permits |
| 50 | OIH_J_1BTREGX | Tax region | 4 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPTax |
| 51 | P01T_ADMIN | ETSmt: Administration of Employment Tax Statement | 8 | BLAND | ETStmt: State | nvarchar | 2 | 0 | | |
| 52 | P01T_A_ADM | ETNotif.: Administration - Employment Tax Notification | 8 | BLAND | ETStmt: State | nvarchar | 2 | 0 | | |
| 53 | T5D2J | StADUEV Form Control | 3 | BLAND | State | nvarchar | 3 | 0 | | |
| 54 | T5D2O | ETNotif.: Asssignment - Cumulation Wage Type to Key Figure | 4 | BLAND | ETStmt: State | nvarchar | 2 | 0 | | |
| 55 | T5D2P | ETNotif.: Key Figures | 3 | BLAND | ETStmt: State | nvarchar | 2 | 0 | | |
| 56 | T5D2Q | ETNotif.: Totals Formation for Key Figures | 3 | BLAND | ETStmt: State | nvarchar | 2 | 0 | | |
| TOPTime Zones |
| 57 | TTZ5S | Assign time zones to regions | 3 | BLAND | Region (State, Province, County) | nvarchar | 3 | 0 | | |
| TOPUSA |
| 58 | PA0104 | HR Master Record: Infotype 0104 (Bond Denominations NA) | 49 | BLAND | Country Key | nvarchar | 3 | 0 | | |
