| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAddress ManagementBusiness Address |
1 | SADR | Address Management: Company Data | 16 | HAUSN | House number | nvarchar | 6 | 0 | | |
TOPBank Customer Accounts |
2 | BKKPOGISP | EDI Payments: Reporting Data to Clearing, Segm. E1EDLA1 | 31 | HAUSN | House number | nvarchar | 6 | 0 | | |
TOPLocalization |
3 | J_1BNFDOC | Nota Fiscal Header | 93 | HAUSN | House number | nvarchar | 6 | 0 | | |
4 | J_1BNFNAD | Nota Fiscal partners | 33 | HAUSN | House number | nvarchar | 6 | 0 | | |
TOPMaster Data |
5 | JGTSADR | IS-M: Extended Address Management | 33 | HAUSN | IS-M: House Number | nvarchar | 10 | 0 | | |
6 | JSTALIAS | IS-M: Alias Table for Streets | 19 | HAUSN | IS-M: House Number | nvarchar | 10 | 0 | | |
TOPOrganizational Management |
7 | HRP1028 | Infotype 1028 DB Table | 31 | HAUSN | House number | nvarchar | 6 | 0 | | |
8 | T777A | Building Addresses | 13 | HAUSN | House number | nvarchar | 6 | 0 | | |
TOPPeriodical Sales and Distribution |
9 | JKWWWTEMP_BP | IS-M/SD: WWW, Temporary Table for BP Data from Internet | 22 | HAUSN | IS-M: House Number | nvarchar | 10 | 0 | | |
10 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 40 | HAUSN | IS-M: House Number | nvarchar | 10 | 0 | | |
11 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 40 | HAUSN | IS-M: House Number | nvarchar | 10 | 0 | | |
12 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 21 | HAUSN | IS-M: House Number | nvarchar | 10 | 0 | | |
TOPPublic Sector |
13 | PA0320 | Official Housing | 24 | HAUSN | House number | nvarchar | 6 | 0 | | |
14 | PA0321 | Employee Accommodation | 24 | HAUSN | House number | nvarchar | 6 | 0 | | |
15 | PDPBSZVADR | Address (Record Type 81), ZVE-PBS | 14 | HAUSN | House Number, ZVE-PBS | nvarchar | 10 | 0 | | |
16 | T5D72 | Houses | 2 | HAUSN | House number | nvarchar | 6 | 0 | | |
17 | T5D73 | Official Housing | 2 | HAUSN | House number | nvarchar | 6 | 0 | | |
18 | T5D74 | Employee Accommodation | 2 | HAUSN | House number | nvarchar | 6 | 0 | | |
TOPRecycling Administration Core Functions |
19 | J_7LSADR | Address Management: Company Data | 16 | HAUSN | House number | nvarchar | 6 | 0 | | |
TOPSAP Media |
20 | J_1SFSPED | IS-M/SD CH/V: Addresses, Orders for Third-Party Shipping | 17 | HAUSN | IS-M: House Number | nvarchar | 10 | 0 | | |
TOPTax |
21 | P01T_LST | ETStmt: General Employment Tax Data | 26 | HAUSN | ETStmt: House No. | nvarchar | 9 | 0 | | |