| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /FLDQ/AD_CHKSTAT | Table to temporarily hold the check status values | 52 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
2 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 50 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
3 | /FLDQ/AD_QU_INDX | QU2 Index Table | 51 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
4 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 53 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
5 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 53 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
6 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 51 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
7 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 51 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
8 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 53 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
9 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 54 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
10 | /ORS/INV_ADD | Invoice Add | 8 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
11 | BBP_PCACC | Procurement Card: Accounting Data | 11 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
12 | BBP_PCLOG | Procurement Card Statement: Logistic data | 20 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
13 | BBP_PCMOD | Procurement Card: Modified Statement Data | 13 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
14 | BBP_PCPOS | Procurement Card Statement: Position Data | 37 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
15 | BBP_PCTAX | Procurement Card: Tax Data | 7 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
16 | BBP_SUS_STG_ADR | Staging address table | 36 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
17 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 37 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
18 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 37 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
19 | CNVTDMS_11_SCADR | Scrambling Addresses | 33 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
20 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 81 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
21 | REQLINESR | Temporary Line Data: Requirement Coverage Request (Services) | 47 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
22 | T7BRCITY | Municipality code by postal code interval | 6 | TAXJURCODE | Brazilian municipality code | nvarchar | 15 | 0 | | |
23 | T7BRCITY_TEXT | Text table for Brazilian municipality code | 4 | TAXJURCODE | Brazilian municipality code | nvarchar | 15 | 0 | | |
24 | PIQDB_NL_ADDR | Maintain GBA Address | 39 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
TOPAddress ManagementBusiness Address |
25 | ADRC | Addresses (Business Address Services) | 83 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
26 | ADRCITY | Postal cities | 8 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
27 | ADRCS | Shadow Table: Addresses (Business Address Services) | 84 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
28 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 85 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
29 | ADRDIF_CT | City Difference Table for Quarterly Adjustment | 15 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
30 | ADRDIF_ST | Street Difference Table for Quarterly Adjustment | 32 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
31 | ADRSTREET | Streets | 9 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
32 | ADRSTRPCD | Street (section)/postal code: Assignment | 13 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
TOPBasis Components |
33 | /XFT/INV_Q_1 | Invoice receipt queue: Items | 12 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
34 | /XFT/INV_Q_11 | Account assignment data | 8 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
35 | /XFT/INV_Q_11_S | Account assignment data | 8 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
36 | /XFT/INV_Q_1_S | Invoice receipt queue: Items | 12 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
TOPCountry-Specific Objects |
37 | COMC_TAXJUR_CITY | Tax Jurisdiction codes by City | 5 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
38 | COMC_TAXJUR_REG | Tax Jurisdiction codes by region | 4 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
39 | COMC_TAXJUR_REGT | Tax Jurisdiction codes by region | 5 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
40 | COMC_TAXJUR_ZPCD | Tax Jurisdiction Codes by Range of Postal Codes | 6 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
41 | CRMC_TAX_JUR | Tax jurisdiction code values | 3 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
42 | CRMC_TAX_JUR_TXT | Tax jurisdiction code text | 4 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
TOPDown Payment Chains |
43 | /SAPPCE/TDPC01 | Down Payment Chains | 41 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
44 | /SAPPCE/TDPC21 | Down Payment Chain: Document Segments | 24 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
TOPFinancial Accounting |
45 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 83 | TAXJURCODE | Steuerstandort | nvarchar | 15 | 0 | | |
TOPGL Account Posting |
46 | TCJ_POSITIONS | Cash Journal Document Items | 92 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
TOPGlobal Trade Services |
47 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 67 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
48 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 100 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
TOPLocalization |
49 | J_1BNFCPD | Nota Fiscal one-time accounts | 80 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
50 | J_1BSERVASSIGN1 | Assignment of Official to Generic Service Types | 4 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
51 | J_1BSERVASSIGN2 | Assignment of Official Service Types to Material Numbers | 4 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
52 | J_1BSERVASSIGN3 | Assignment of Official Service Types to Service Numbers | 4 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
53 | J_1BSERVTYPES1 | Official Brazilian Service Types - Incoming | 3 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
54 | J_1BSERVTYPES1T | Texts For Official Brazilian Service Types - Incoming | 4 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
55 | J_1BSERVTYPES2 | Official Brazilian Service Types - Outgoing | 3 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
56 | J_1BSERVTYPES2T | Texts For Official Brazilian Service Types - Outgoing | 4 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
57 | J_1BTREG_CITY | Tax Jurisdiction Codes by Range of Postal Codes | 6 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
58 | J_1BTXISS | Tax Calculation: ISS | 4 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
59 | J_1BTXJUR | Tax Jurisdiction Codes For Brazilian Tax Calculation | 3 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
60 | J_1BTXJURT | Text Table For Brazilian Tax Jurisdiction Codes | 4 | TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | nvarchar | 15 | 0 | | |
TOPMaster Data |
61 | EFISEL | Field Selection Control for Address Data | 49 | TAXJURCODE | Jurisdiction for tax calculation - tax jurisdiction code | nvarchar | 1 | 0 | | |
TOPMove-InOut |
62 | ECAMIOPRADDR | IS-U: Parked Document: Addresses (Business Partner) | 34 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | |
TOPWaste Management |
63 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 49 | TAXJURCODE | Jurisdiction for tax calculation - tax jurisdiction code | nvarchar | 1 | 0 | | |
64 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 49 | TAXJURCODE | Jurisdiction for tax calculation - tax jurisdiction code | nvarchar | 1 | 0 | | |