| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CCEE/FISC_BS | Fiscalization Croatia: Business Space Master Data | 4 | STREET | Street | nvarchar | 100 | 0 | | |
2 | /FLDQ/AD_CHKSTAT | Table to temporarily hold the check status values | 28 | STREET | Street | nvarchar | 60 | 0 | | |
3 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 43 | STREET | Street | nvarchar | 60 | 0 | | |
4 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 43 | STREET | Street | nvarchar | 60 | 0 | | |
5 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 43 | STREET | Street | nvarchar | 60 | 0 | | |
6 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 44 | STREET | Street | nvarchar | 60 | 0 | | |
7 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 43 | STREET | Street | nvarchar | 60 | 0 | | |
8 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 43 | STREET | Street | nvarchar | 60 | 0 | | |
9 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 43 | STREET | Street | nvarchar | 60 | 0 | | |
10 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 37 | STREET | Street | nvarchar | 60 | 0 | | |
11 | /FLDQ/AD_QU_INDX | QU2 Index Table | 36 | STREET | Street | nvarchar | 60 | 0 | | |
12 | /FLDQ/BPMTCCD | Generated Match Code Table for BP | 9 | STREET | Street | nvarchar | 60 | 0 | | |
13 | /FLDQ/BPMTCDISP | Generated Display Table for BP | 9 | STREET | Street | nvarchar | 60 | 0 | | |
14 | /FLDQ/BPMTCPUD | Generated Pending Update Table for BP | 9 | STREET | Street | nvarchar | 60 | 0 | | |
15 | /FLDQ/BPMTCSHDW | Generated Match Shadow Table for BP | 9 | STREET | Street | nvarchar | 60 | 0 | | |
16 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 29 | STREET | Street | nvarchar | 60 | 0 | | |
17 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 29 | STREET | Street | nvarchar | 60 | 0 | | |
18 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 36 | STREET | Street | nvarchar | 60 | 0 | | |
19 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 36 | STREET | street with increased size to stop truncation | nvarchar | 200 | 0 | | |
20 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 36 | STREET | street with increased size to stop truncation | nvarchar | 200 | 0 | | |
21 | /OPT/VIM_STG_LIF | Table: Staging data - Vendor master for ICC | 11 | STREET | House number and street | nvarchar | 35 | 0 | | |
22 | /SAPQUERY/TA02 | Flight customers | 5 | STREET | Street | nvarchar | 30 | 0 | | |
23 | ACMTST_DB_AD | ACMTST: Address (DB-Table) | 8 | STREET | | nvarchar | 60 | 0 | | |
24 | BBP_PCPOS | Procurement Card Statement: Position Data | 21 | STREET | Street | nvarchar | 40 | 0 | | |
25 | BBP_SUS_STG_ADR | Staging address table | 20 | STREET | Street | nvarchar | 60 | 0 | | |
26 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 21 | STREET | Street | nvarchar | 60 | 0 | | |
27 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 21 | STREET | Street | nvarchar | 60 | 0 | | |
28 | CNVTDMS_11_SCADR | Scrambling Addresses | 19 | STREET | Street | nvarchar | 60 | 0 | | |
29 | EHPRCD_ORGIDS | Organisation | 5 | STREET | Street | nvarchar | 50 | 0 | | |
30 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 61 | STREET | Street | nvarchar | 60 | 0 | | |
31 | T7BREFD_BENONRES | Data of beneficiary non-resident or resident abroad | 7 | STREET | Street description | nvarchar | 80 | 0 | | |
32 | T7BREFD_EEADDR | Employee address | 7 | STREET | Street description | nvarchar | 80 | 0 | | |
33 | VIXCCHEGID | Localization Switzerland: EGID | 6 | STREET | Street | nvarchar | 60 | 0 | | |
34 | PIQDB_NL_ADDR | Maintain GBA Address | 23 | STREET | Street | nvarchar | 60 | 0 | | |
35 | T7PIQ_NL_INSBRIN | BRIN Number of the Institute | 8 | STREET | Street | nvarchar | 60 | 0 | | |
TOPABAP Workbench, Java IDE and Infrastructure |
36 | SCUSTOM | Flight customers | 5 | STREET | Street | nvarchar | 30 | 0 | | |
37 | STRAVELAG | Travel agency | 4 | STREET | Street | nvarchar | 30 | 0 | | |
TOPAddress ManagementBusiness Address |
38 | ADRC | Addresses (Business Address Services) | 36 | STREET | Street | nvarchar | 60 | 0 | | |
39 | ADRCS | Shadow Table: Addresses (Business Address Services) | 37 | STREET | Street | nvarchar | 60 | 0 | | |
40 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 38 | STREET | Street | nvarchar | 60 | 0 | | |
41 | ADRDIF_ST | Street Difference Table for Quarterly Adjustment | 19 | STREET | Street | nvarchar | 60 | 0 | | |
42 | ADRSTREETT | Streets (long texts) | 6 | STREET | Street | nvarchar | 60 | 0 | | |
TOPBank Customer Accounts |
43 | BCA_US_BC_ADDR | Addresses Associated with Bank Cheques | 42 | STREET | Street | nvarchar | 60 | 0 | | |
TOPBasic Functions |
44 | FSLSA | Foreign Trade: Legal Control-Sanctioned Party List-Address | 13 | STREET | Street | nvarchar | 60 | 0 | | |
TOPBasis Components |
45 | /XFT/INV_Q | Invoice receipt queue: Header | 98 | STREET | House number and street | nvarchar | 35 | 0 | | |
46 | /XFT/INV_Q_S | Invoice receipt queue: Header | 98 | STREET | House number and street | nvarchar | 35 | 0 | | |
47 | ZDS400_TAB1 | Exercise table | 5 | STREET | CHAR40 for SYST | nvarchar | 40 | 0 | | |
TOPBusiness Objects, Common Components |
48 | EHDMOD_ADR_ROOT | Address - Root | 12 | STREET | Street | nvarchar | 30 | 0 | | |
TOPBusiness Server Pages |
49 | AUUSER | User Table for the eRhine Auction House | 6 | STREET | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | | |
TOPClaims Management |
50 | ICLX_PARTICIPANT | Error Table for Participants with XI Input | 18 | STREET | Participant: Participant Street | nvarchar | 60 | 0 | | |
TOPCollectionsDisbursements |
51 | VVSCPOSESR | Payment Plan Item: ISR Attachment | 13 | STREET | Street | nvarchar | 60 | 0 | | |
TOPContract Accounts Receivable and Payable |
52 | DFKKESR | POR Payment Supplement | 11 | STREET | Street | nvarchar | 60 | 0 | | |
53 | DFKKGP_SHORT | Data Extract: BP Data | 14 | STREET | Street | nvarchar | 60 | 0 | | |
54 | DFKKZAX | Repayment Request (Address Data for Check) | 9 | STREET | Street | nvarchar | 60 | 0 | | |
55 | FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) | 22 | STREET | Street | nvarchar | 60 | 0 | | |
TOPDealer Portal |
56 | /SAPDII/SPPSHIPA | Maintaining Alternate shipping locations | 13 | STREET | | nvarchar | 35 | 0 | | |
TOPDownloadUpload |
57 | /DSD/HH_RACAD | DSD Route Settlement: Customer Address Data (One-Time Only) | 10 | STREET | House number and street | nvarchar | 35 | 0 | | |
TOPDSD Connector |
58 | /DSD/ME_CONTACT | DSD Connector: Contact Person | 17 | STREET | DSD Connector: Street | nvarchar | 35 | 0 | | |
59 | /DSD/ME_CUST_CPD | DSD CN: One-time Customer | 7 | STREET | DSD Connector: Street | nvarchar | 35 | 0 | | |
60 | /DSD/ME_CUST_HD | DSD CN: Customer Details | 8 | STREET | DSD Connector: Street | nvarchar | 35 | 0 | | |
TOPeCATT Extended Computer Aided Test Tool |
61 | DEMO_SCUSTOM | Create Control Table Flight Customers | 5 | STREET | Street | nvarchar | 30 | 0 | | |
TOPEnvironment, Health and Safety |
62 | /TDAG/CPT_ORGIDS | IMDS Organisation | 5 | STREET | Street | nvarchar | 50 | 0 | | |
TOPExcise Duty |
63 | /BEV2/CS_BP | EMCS Process: Partners | 6 | STREET | EMCS: Street Name | nvarchar | 40 | 0 | | |
64 | /BEV2/CS_BP_H | EMCS Process: Partners - History | 7 | STREET | EMCS: Street Name | nvarchar | 40 | 0 | | |
TOPFast Search Infrastructure |
65 | SFSRFW_TEST_TRIG | Tabelle zum Testen von DB Trigger | 5 | STREET | Straße | nvarchar | 30 | 0 | | |
TOPFinancial Accounting |
66 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 36 | STREET | Straße | nvarchar | 60 | 0 | | |
67 | FOTRFDITM | VAT Refund Items | 47 | STREET | Street | nvarchar | 60 | 0 | | |
68 | FOTRFDITMCHG | Change Documents, VAT Refund Item | 21 | STREET | Street | nvarchar | 60 | 0 | | |
TOPGeneral Object Relations |
69 | SFLITPASS | Attribute Table: Transit Passenger | 6 | STREET | Street | nvarchar | 30 | 0 | | |
TOPGlobal Trade Services |
70 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 43 | STREET | Street | nvarchar | 60 | 0 | | |
71 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 76 | STREET | Street | nvarchar | 60 | 0 | | |
TOPIntercompany Data Exchange |
72 | EIDESWTMSGDATA | Message Data for Switch Document | 14 | STREET | Street | nvarchar | 60 | 0 | | |
73 | EIDESWTMSGTMP | Temporary Switch Document Message Data | 13 | STREET | Street | nvarchar | 60 | 0 | | |
TOPLocalization |
74 | J_1BNFCPD | Nota Fiscal one-time accounts | 56 | STREET | Street | nvarchar | 60 | 0 | | |
75 | J_1BNFDOC | Nota Fiscal Header | 95 | STREET | Street | nvarchar | 60 | 0 | | |
76 | J_1BNFNAD | Nota Fiscal partners | 35 | STREET | Street | nvarchar | 60 | 0 | | |
TOPLocations Location Structure |
77 | EHFNDD_LOC_REV | Location - Revisions | 28 | STREET | Street Address | nvarchar | 60 | 0 | | |
TOPMaintenance Orders |
78 | /MRSS/D_ADDRESS | Stores Primary/Secondary address | 5 | STREET | Street | nvarchar | 60 | 0 | | |
79 | /MRSS/D_GEO_ZIP | Postal Codes for Georeferencing | 5 | STREET | Street | nvarchar | 60 | 0 | | |
TOPMaster Data |
80 | EBP_ADDR_SERVICE | Search Index for Business Partner Service Addresses | 9 | STREET | Street name in upper case for search help | nvarchar | 25 | 0 | | |
81 | EFISEL | Field Selection Control for Address Data | 11 | STREET | Street Name | nvarchar | 1 | 0 | | |
82 | TECHSTR | Changes to Street Names | 6 | STREET | Street | nvarchar | 60 | 0 | | |
TOPMove-InOut |
83 | ECAMIOPRADDR | IS-U: Parked Document: Addresses (Business Partner) | 6 | STREET | Street | nvarchar | 60 | 0 | | |
TOPNetWeaver Demonstration |
84 | SDEMO_BP_AD | SAP NetWeaver Demo Model - Business Partner Address | 5 | STREET | Street | nvarchar | 60 | 0 | | |
85 | SNWD_AD | EPM: Address Table | 5 | STREET | EPM: Street | nvarchar | 60 | 0 | | |
TOPNetWeaver Enterprise Search |
86 | ESH_TST_CUST_ADR | ES Test Object Customer Address | 9 | STREET | ES Test Object: Street | nvarchar | 35 | 0 | | |
TOPOffer and Rental Request |
87 | VIOROO | Offered Object | 66 | STREET | Street | nvarchar | 60 | 0 | | |
88 | VIORRR | Rental Request | 78 | STREET | Street | nvarchar | 60 | 0 | | |
TOPPatient Accounting |
89 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 20 | STREET | Street | nvarchar | 60 | 0 | | |
TOPPayment Transactions |
90 | TFIBLFFPVAR | Online Payment: Variants | 19 | STREET | House number and street | nvarchar | 35 | 0 | | |
TOPPayroll |
91 | T5HPBS06 | Technikai azonosító (1) - Közigazgatási szerv | 8 | STREET | Utca | nvarchar | 60 | 0 | | |
92 | T5HPBS07 | Szervezeti egységek címe | 6 | STREET | Utca | nvarchar | 60 | 0 | | |
93 | T7ROG1 | EE register - ER history | 13 | STREET | Character 100 | nvarchar | 100 | 0 | | |
94 | T7UA1656 | Infotype 1656 Fields: Legal properties (Ukraine) | 9 | STREET | Address Street | nvarchar | 30 | 0 | | |
TOPPortfolio |
95 | VDBILL_RES_HEAD | Bill Results Header | 29 | STREET | Street | nvarchar | 60 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
96 | DFMCA_BRF540 | BRF: Create Address for Business Partner | 20 | STREET | BRF: Expression | nvarchar | 20 | 0 | | |
97 | DFMCA_BRF650 | BRF: Business Partner Reading | 25 | STREET | BRF: Expression | nvarchar | 20 | 0 | | |
98 | DFMCA_BRF750 | BRF: Address Check | 17 | STREET | BRF: Expression | nvarchar | 20 | 0 | | |
99 | DFMCA_BRF760 | BRF: Read Location | 12 | STREET | BRF: Expression | nvarchar | 20 | 0 | | |
100 | DFMCA_BRF770 | BRF: Create Location | 21 | STREET | BRF: Expression | nvarchar | 20 | 0 | | |
101 | DFMCA_BRF820 | BRF: Address Autocorrection | 19 | STREET | Field Name | nvarchar | 30 | 0 | | |
102 | DFMCA_BRF890 | BRF: Business Partner Determination from Form | 26 | STREET | BRF: Expression | nvarchar | 20 | 0 | | |
103 | DFMCA_TF_WHT_L | Line Item Table of Withholding Tax | 20 | STREET | Street | nvarchar | 60 | 0 | | |
TOPReal Estate Management |
104 | VIAR01 | RE: REse@rch - Offered RE Objects | 49 | STREET | House number and street | nvarchar | 35 | 0 | | |
105 | VIAR02 | RE: REse@rch - RE Requests | 52 | STREET | House number and street | nvarchar | 35 | 0 | | |
106 | VIAR03 | RE: REsearch - Offering/Searching Party (Web User) | 29 | STREET | House number and street | nvarchar | 35 | 0 | | |
TOPSales Promotions |
107 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 23 | STREET | Street | nvarchar | 60 | 0 | | |
TOPSAP NetWeaver Mobile - Use subcomponents |
108 | MEREP_ADDRESS | Address (Sample Application) | 6 | STREET | Street (Sample Application) | nvarchar | 40 | 0 | | |
TOPStakeholder Relationship Management |
109 | USC_CONT_ADD | SRM Contact: Event Info | 9 | STREET | Street | nvarchar | 60 | 0 | | |
TOPTransaction Tax Engine |
110 | TTED_ACQUISI_COM | Acquisition | 14 | STREET | Street | nvarchar | 30 | 0 | | |
111 | TTED_PARTNER_COM | Partner | 20 | STREET | Street | nvarchar | 30 | 0 | | |
112 | TTED_PARTN_O_COM | Partner in OutputDocument | 20 | STREET | Street | nvarchar | 30 | 0 | | |
113 | TTEPD3_PARTNER | Partner | 19 | STREET | Street | nvarchar | 30 | 0 | | |
TOPTravel Expenses |
114 | PTRV_VATDETAIL | Supplier Data for VAT Refund in Travel Management | 11 | STREET | Street | nvarchar | 60 | 0 | | |
115 | T706_VAT_FLDS | Country-Dependent Field Control for Receipt Data | 14 | STREET | Street | nvarchar | 1 | 0 | | |
TOPTravel Management |
116 | TA23ADR | Predefined Addresses in Travel Management | 8 | STREET | Street | nvarchar | 60 | 0 | | |
TOPTravel Planning |
117 | FTPT_HOTEL_DATA | Hotel Data | 12 | STREET | Street | nvarchar | 60 | 0 | | |
118 | FTPT_REQUEST | Travel Plan Requests | 29 | STREET | Street | nvarchar | 60 | 0 | | |
119 | TA23HOTELS | Hotel Data | 12 | STREET | Street | nvarchar | 60 | 0 | | |
TOPWaste Management |
120 | EEWA_CIC_FILTAB | IS-U CIC for Waste: Store Filter Data | 3 | STREET | Street | nvarchar | 60 | 0 | | |
121 | EHSWAT_APPBP | MD: Waste Permit Partner | 39 | STREET | Street | nvarchar | 60 | 0 | | |
122 | EHSWAT_MNBP | Waste Manifest/Delivery Note: Partners | 36 | STREET | Street | nvarchar | 60 | 0 | | |
123 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 11 | STREET | Street Name | nvarchar | 1 | 0 | | |
124 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 11 | STREET | Street Name | nvarchar | 1 | 0 | | |