| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 46 | BUILDING | | nvarchar | 6 | 0 | | |
2 | /FLDQ/AD_CHKSTAT | Table to temporarily hold the check status values | 39 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
3 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 21 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
4 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 21 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
5 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 21 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
6 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 22 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
7 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 21 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
8 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 21 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
9 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 21 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
10 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 45 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
11 | /FLDQ/AD_QU_INDX | QU2 Index Table | 45 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
12 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 40 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
13 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 40 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
14 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 14 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
15 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 45 | BUILDING | building with increased size to stop truncation | nvarchar | 200 | 0 | | |
16 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 45 | BUILDING | building with increased size to stop truncation | nvarchar | 200 | 0 | | |
17 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 46 | BUILDING | Building Number | nvarchar | 8 | 0 | | |
18 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 47 | BUILDING | Building Number | nvarchar | 8 | 0 | | |
19 | BBP_PCPOS | Procurement Card Statement: Position Data | 28 | BUILDING | old: building (no. or abbreviation) | nvarchar | 10 | 0 | | |
20 | BBP_SUS_STG_ADR | Staging address table | 29 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
21 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 30 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
22 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 30 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
23 | GRACREQUSERADR | User Communication Fields | 12 | BUILDING | Building | nvarchar | 10 | 0 | | |
24 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 70 | BUILDING | old: building (no. or abbreviation) | nvarchar | 10 | 0 | | |
25 | ZROOMBOOKED | Table with all reservations | 3 | BUILDING | Name of building | nvarchar | 20 | 0 | | |
26 | ZROOMS | Table stores all rooms that are available | 3 | BUILDING | Name of building | nvarchar | 20 | 0 | | |
27 | PIQDBEVOBOFFER3 | Scheduled Assessment: Location/Time | 9 | BUILDING | Building | nvarchar | 8 | 0 | | |
28 | PIQDB_NL_ADDR | Maintain GBA Address | 32 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector |
29 | CRMAHR | Data on Persons | 8 | BUILDING | Building (number or code) | nvarchar | 10 | 0 | | |
TOPAddress ManagementBusiness Address |
30 | ADCP | Person/Address Assignment (Business Address Services) | 11 | BUILDING | Building (number or code) | nvarchar | 10 | 0 | | |
31 | ADCPS | Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) | 12 | BUILDING | Building (number or code) | nvarchar | 10 | 0 | | |
32 | ADRC | Addresses (Business Address Services) | 47 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
33 | ADRCS | Shadow Table: Addresses (Business Address Services) | 48 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
34 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 49 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
TOPBasic Functions |
35 | FSLSA | Foreign Trade: Legal Control-Sanctioned Party List-Address | 15 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
36 | LECI_EVENT_DATA | Activity Data Within the Check-in/Check-out Process | 27 | BUILDING | Building (number or code) | nvarchar | 10 | 0 | | |
TOPBasis Components |
37 | /XFT/INV_Q_6 | PO details (header) for an invoice receipt process | 46 | BUILDING | old: building (no. or abbreviation) | nvarchar | 10 | 0 | | |
38 | /XFT/INV_Q_6_S | PO details (header) for an invoice receipt process | 46 | BUILDING | old: building (no. or abbreviation) | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
39 | CACNS_RESERVE_T | Reserve Table in a Room | 2 | BUILDING | Telebox number | nvarchar | 15 | 0 | | |
TOPDSD Connector |
40 | /DSD/ME_CONTACT | DSD Connector: Contact Person | 14 | BUILDING | DSD Connector: Building | nvarchar | 20 | 0 | | |
TOPFinancial Accounting |
41 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 47 | BUILDING | Gebäude (Nummer oder Kürzel) | nvarchar | 20 | 0 | | |
TOPGlobal Trade Services |
42 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 54 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
43 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 87 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
TOPIndustrial Hygiene and Safety |
44 | CCIHC_BUILDING | EHS: Building | 2 | BUILDING | Building | nvarchar | 20 | 0 | | |
45 | CCIHC_BUILDINGTX | EHS: Building | 2 | BUILDING | Building | nvarchar | 20 | 0 | | |
TOPKnowledge Warehouse |
46 | IWBKEPDEST | KEPlicator Data for Logical Destinations | 14 | BUILDING | Building | nvarchar | 8 | 0 | | |
TOPLocalization |
47 | /KJRTAX01/A05 | Property Tax Report: Declaration Key | 27 | BUILDING | Ownership of Office Building | nvarchar | 1 | 0 | | |
48 | J_1BNFCPD | Nota Fiscal one-time accounts | 67 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
TOPMaintenance Orders |
49 | /MRSS/D_ADDRESS | Stores Primary/Secondary address | 26 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
TOPMaster Data |
50 | EBP_ADDR_SERVICE | Search Index for Business Partner Service Addresses | 15 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
51 | EFISEL | Field Selection Control for Address Data | 30 | BUILDING | Building (Number or Code) | nvarchar | 1 | 0 | | |
TOPMove-InOut |
52 | ECAMIOPRADDR | IS-U: Parked Document: Addresses (Business Partner) | 23 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | |
TOPNetWeaver Demonstration |
53 | SDEMO_BP_AD | SAP NetWeaver Demo Model - Business Partner Address | 6 | BUILDING | Building | nvarchar | 10 | 0 | | |
54 | SNWD_AD | EPM: Address Table | 6 | BUILDING | EPM: Building | nvarchar | 10 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
55 | DFMCA_BRF540 | BRF: Create Address for Business Partner | 22 | BUILDING | BRF: Expression | nvarchar | 20 | 0 | | |
56 | DFMCA_BRF750 | BRF: Address Check | 19 | BUILDING | BRF: Expression | nvarchar | 20 | 0 | | |
57 | DFMCA_BRF770 | BRF: Create Location | 23 | BUILDING | BRF: Expression | nvarchar | 20 | 0 | | |
58 | DFMCA_BRF820 | BRF: Address Autocorrection | 21 | BUILDING | Field Name | nvarchar | 30 | 0 | | |
TOPWaste Management |
59 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 30 | BUILDING | Building (Number or Code) | nvarchar | 1 | 0 | | |
60 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 30 | BUILDING | Building (Number or Code) | nvarchar | 1 | 0 | | |