| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /AIF/TEST_BP_IDX | Standard index table | 33 | CITY | City | nvarchar | 25 | 0 | | |
2 | /CCEE/FISC_BS | Fiscalization Croatia: Business Space Master Data | 8 | CITY | City | nvarchar | 40 | 0 | | |
3 | /IXOS/DC_EX_ADDR | Addresses of a customer | 4 | CITY | City of the Customer | nvarchar | 40 | 0 | | |
4 | /SAPQUERY/TA02 | Flight customers | 8 | CITY | City | nvarchar | 25 | 0 | | |
5 | /SAPQUERY/TA03 | Geographical position of a city | 2 | CITY | City | nvarchar | 20 | 0 | | |
6 | ACMTST_DB_AD | ACMTST: Address (DB-Table) | 6 | CITY | | nvarchar | 40 | 0 | | |
7 | BBP_PCPOS | Procurement Card Statement: Position Data | 12 | CITY | City | nvarchar | 40 | 0 | | |
8 | BBP_SUS_STG_ADR | Staging address table | 5 | CITY | City | nvarchar | 40 | 0 | | |
9 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 6 | CITY | City | nvarchar | 40 | 0 | | |
10 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 6 | CITY | City | nvarchar | 40 | 0 | | |
11 | DSH_GEOCITY | Check table for GEOCITY stuff | 1 | CITY | City | nvarchar | 20 | 0 | | |
12 | EHFNDD_VEN_DETLS | Vendor - Details | 13 | CITY | Vendor - City | nvarchar | 40 | 0 | | |
13 | EHPRCD_ORGIDS | Organisation | 9 | CITY | City | nvarchar | 50 | 0 | | |
14 | HRP1660 | DB Table for Infotype 1660 | 22 | CITY | Duty Station City | nvarchar | 4 | 0 | | |
15 | J_1GWTR0 | Vendor Tax Data | 12 | CITY | City | nvarchar | 35 | 0 | | |
16 | PA0623 | HR Master Record: Infotype 0623 | 27 | CITY | City | nvarchar | 40 | 0 | | |
17 | PB0623 | HR Master Record: Infotype 0623 | 27 | CITY | City | nvarchar | 40 | 0 | | |
18 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 48 | CITY | City | nvarchar | 40 | 0 | | |
19 | T5UPBSDSCITY | US Duty Station Cities | 4 | CITY | Duty Station City | nvarchar | 4 | 0 | | |
20 | T5UPBSDSCITYT | US Federal Duty Station City Texts | 5 | CITY | Duty Station City | nvarchar | 4 | 0 | | |
21 | T7OM08 | Table for Employer Registration Number for Social Insurance | 11 | CITY | City | nvarchar | 40 | 0 | | |
22 | T7UNPF_HR_ADDR | Address | 11 | CITY | City | nvarchar | 40 | 0 | | |
23 | TIVXCESPTDISCHRG | Municipal Property Tax - Discharges | 2 | CITY | Municipality Code | nvarchar | 22 | 0 | | |
24 | TIVXCESPTDISCHRT | Municipal Property Tax - Discharges | 2 | CITY | Municipality Code | nvarchar | 22 | 0 | | |
25 | TIVXCESPTTAXRATE | Municipal Property Tax Rate | 3 | CITY | Municipality Code | nvarchar | 22 | 0 | | |
26 | TIVXCITF24PYMNT | F24 Payment Data | 12 | CITY | City | nvarchar | 40 | 0 | | |
27 | TIVXCITTASIRATE | TASI City rates | 3 | CITY | City | nvarchar | 40 | 0 | | |
28 | VERGEOCITY | Context-Veri: Geographische Lage einer Stadt | 2 | CITY | Ort | nvarchar | 20 | 0 | | |
29 | VIXCCHEGID | Localization Switzerland: EGID | 9 | CITY | City | nvarchar | 40 | 0 | | |
30 | VIXCESIBIDATA | IBI master data | 9 | CITY | Municipality Code | nvarchar | 5 | 0 | | |
31 | VIXCITCADAO | Temporary architectural object data | 98 | CITY | City | nvarchar | 40 | 0 | | |
32 | ZAIF_D01_SIDX_01 | Single index table for DEMO BUPA_IN | 34 | CITY | City | nvarchar | 25 | 0 | | |
33 | ZEHPRC_SMELTERS | Smelters | 6 | CITY | Location | nvarchar | 25 | 0 | | |
34 | ZZIP | ZIP Codes USA | 2 | CITY | Ort | nvarchar | 40 | 0 | | |
35 | PIQDB_NL_ADDR | Maintain GBA Address | 8 | CITY | City | nvarchar | 40 | 0 | | |
TOPABAP Workbench, Java IDE and Infrastructure |
36 | SCITAIRP | City-Airport assignment | 2 | CITY | City | nvarchar | 20 | 0 | | |
37 | SCUSTOM | Flight customers | 8 | CITY | City | nvarchar | 25 | 0 | | |
38 | SGEOCITY | Geographical position of a city | 2 | CITY | City | nvarchar | 20 | 0 | | |
39 | STRAVELAG | Travel agency | 7 | CITY | City | nvarchar | 25 | 0 | | |
TOPBasic Functions |
40 | LECI_EVENT_DATA | Activity Data Within the Check-in/Check-out Process | 25 | CITY | City | nvarchar | 40 | 0 | | |
41 | T850K | Company correspondence data | 12 | CITY | City where company is located | nvarchar | 30 | 0 | | |
TOPBasis Components |
42 | /XFT/INV_Q | Invoice receipt queue: Header | 96 | CITY | City | nvarchar | 35 | 0 | | |
43 | /XFT/INV_Q_S | Invoice receipt queue: Header | 96 | CITY | City | nvarchar | 35 | 0 | | |
44 | ZDS400_PLNT | Tabelle für Beispielprogramm des ZDS400 | 4 | CITY | Ankunftstadt | nvarchar | 20 | 0 | | |
45 | ZDS400_TAB1 | Exercise table | 4 | CITY | CHAR20 for SYST | nvarchar | 20 | 0 | | |
TOPBusiness Objects, Common Components |
46 | EHDMOD_ADR_ROOT | Address - Root | 10 | CITY | City | nvarchar | 40 | 0 | | |
TOPBusiness Server Pages |
47 | AUUSER | User Table for the eRhine Auction House | 8 | CITY | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | | |
TOPBW Service API |
48 | ROVERCUSTA | Attributes for Customers in Verification Scenario | 3 | CITY | Location in Verification Scenario | nvarchar | 35 | 0 | | |
TOPClaims Management |
49 | ICLCCEVENTR | Claim Bundle - Region - Assignment | 7 | CITY | City Code for City/Street File | nvarchar | 12 | 0 | | |
50 | ICSCCEVENTR | Claim Bundle - Region - Assignment | 7 | CITY | City Code for City/Street File | nvarchar | 12 | 0 | | |
TOPConsolidation |
51 | TF162 | Consolidation Unit Correspondence | 8 | CITY | City | nvarchar | 30 | 0 | | |
TOPCross-Application Components |
52 | /OPT/VPR_ADDR | Vendor Address for Registered Vendor and Partner | 9 | CITY | Name of different postal city for city/street file | nvarchar | 40 | 0 | | |
TOPDealer Portal |
53 | /SAPDII/SPPSHIPA | Maintaining Alternate shipping locations | 7 | CITY | | nvarchar | 35 | 0 | | |
TOPDownloadUpload |
54 | /DSD/HH_RACAD | DSD Route Settlement: Customer Address Data (One-Time Only) | 6 | CITY | City | nvarchar | 35 | 0 | | |
TOPDSD Connector |
55 | /DSD/ME_CONTACT | DSD Connector: Contact Person | 18 | CITY | DSD Connector: City | nvarchar | 35 | 0 | | |
56 | /DSD/ME_CUST_CPD | DSD CN: One-time Customer | 8 | CITY | DSD Connector: City | nvarchar | 35 | 0 | | |
57 | /DSD/ME_CUST_HD | DSD CN: Customer Details | 9 | CITY | DSD Connector: City | nvarchar | 35 | 0 | | |
TOPE-Recruiting |
58 | HRP5103 | DB Table for Infotype 5103 | 19 | CITY | City | nvarchar | 40 | 0 | | |
59 | HRP5104 | DB Table for Infotype 5104 | 21 | CITY | City | nvarchar | 40 | 0 | | |
60 | HRP5107 | DB Table for Infotype 5107 | 20 | CITY | Desired Work Location - City | nvarchar | 40 | 0 | | |
61 | HRP5126 | DB Table for Infotype 5126 | 24 | CITY | City of Branch | nvarchar | 40 | 0 | | |
62 | HRP9901 | eQuest Posting Information | 48 | CITY | City of Branch | nvarchar | 40 | 0 | | |
TOPeCATT Extended Computer Aided Test Tool |
63 | DEMO_SCUSTOM | Create Control Table Flight Customers | 8 | CITY | City | nvarchar | 25 | 0 | | |
TOPEnvironment, Health and Safety |
64 | /TDAG/CPT_ORGIDS | IMDS Organisation | 9 | CITY | City | nvarchar | 50 | 0 | | |
TOPExcise Duty |
65 | /BEV2/CS_BP | EMCS Process: Partners | 9 | CITY | EMCS: City | nvarchar | 40 | 0 | | |
66 | /BEV2/CS_BP_H | EMCS Process: Partners - History | 10 | CITY | EMCS: City | nvarchar | 40 | 0 | | |
TOPFast Search Infrastructure |
67 | SFSRFW_TEST_TRIG | Tabelle zum Testen von DB Trigger | 6 | CITY | Ort | nvarchar | 25 | 0 | | |
TOPFinancial Accounting |
68 | FOTRFDITM | VAT Refund Items | 50 | CITY | City | nvarchar | 40 | 0 | | |
69 | FOTRFDITMCHG | Change Documents, VAT Refund Item | 24 | CITY | City | nvarchar | 40 | 0 | | |
70 | J_1GMYF0 | MYF data | 9 | CITY | City | nvarchar | 10 | 0 | | |
71 | J_1GWTC0 | Withholding tax certificates data | 10 | CITY | City | nvarchar | 35 | 0 | | |
TOPFlexible Real Estate Management |
72 | TIVXCITICIPARAM | ICI/IMU City parameter | 2 | CITY | City | nvarchar | 40 | 0 | | |
73 | TIVXCITICIRATE | ICI City rate | 3 | CITY | City | nvarchar | 40 | 0 | | |
74 | VIXCITICIDATA | ICI master data | 8 | CITY | City | nvarchar | 40 | 0 | | |
TOPFunctions for U.S. Federal Government |
75 | FMCCRTVENDOR | CCR Vendor Table | 14 | CITY | | nvarchar | 35 | 0 | | |
76 | FMCCRTVENDORPOC | CCR Vendor Points of Contact | 9 | CITY | | nvarchar | 35 | 0 | | |
TOPGeneral Object Relations |
77 | SFLITPASS | Attribute Table: Transit Passenger | 9 | CITY | City | nvarchar | 25 | 0 | | |
TOPGL transfer |
78 | TBKKC_BUKRS | BCA Locally Duplicated Values for Corresponding FI | 4 | CITY | City | nvarchar | 25 | 0 | | |
TOPIncident Recording |
79 | EHHSSD_INC_BINFA | Incident - Basic Information All | 29 | CITY | City of Incident | nvarchar | 40 | 0 | | |
80 | EHHSSD_INC_PROP | Incident - Property | 16 | CITY | City of Involved Property | nvarchar | 40 | 0 | | |
TOPIntercompany Data Exchange |
81 | EIDESWTMSGDATA | Message Data for Switch Document | 18 | CITY | City | nvarchar | 40 | 0 | | |
82 | EIDESWTMSGTMP | Temporary Switch Document Message Data | 17 | CITY | City | nvarchar | 40 | 0 | | |
TOPLoans Management |
83 | VDCBR_RES_DATA | Table of Data Reported to Credit Bureau (Per Loan) | 49 | CITY | City (Metro2 Format) | nvarchar | 20 | 0 | | |
84 | VDCBR_RES_PART | Partner Data Reported to Credit Bureau (Pro Loan) | 23 | CITY | City (Metro2 Format) | nvarchar | 20 | 0 | | |
TOPLocalization |
85 | TIVXCPTPTTAXRATE | Municipal Property Tax Rate | 3 | CITY | Municipality Code | nvarchar | 22 | 0 | | |
86 | TIVXCPTTAXRATE | Municipal Property Tax Rate for Portugal (obsolete) | 3 | CITY | Hierarchical Location | nvarchar | 22 | 0 | | |
87 | VIXCPTIMIDATA | IMI Master Data | 7 | CITY | Municipality Code | nvarchar | 4 | 0 | | |
TOPMaintenance Orders |
88 | /MRSS/D_ADDRESS | Stores Primary/Secondary address | 7 | CITY | City | nvarchar | 40 | 0 | | |
89 | /MRSS/D_GEO_ZIP | Postal Codes for Georeferencing | 4 | CITY | City | nvarchar | 40 | 0 | | |
TOPNetWeaver Demonstration |
90 | SDEMO_BP_AD | SAP NetWeaver Demo Model - Business Partner Address | 3 | CITY | City | nvarchar | 40 | 0 | | |
91 | SNWD_AD | EPM: Address Table | 3 | CITY | EPM: City | nvarchar | 40 | 0 | | |
TOPNetWeaver Enterprise Search |
92 | ESH_TST_CUST_ADR | ES Test Object Customer Address | 8 | CITY | ES Test Object: City | nvarchar | 35 | 0 | | |
TOPPatient Accounting |
93 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 18 | CITY | City | nvarchar | 40 | 0 | | |
TOPPayment Transactions |
94 | TFIBLFFPVAR | Online Payment: Variants | 17 | CITY | City | nvarchar | 35 | 0 | | |
TOPPayroll |
95 | PA0773 | Personel ana verileri: Bilgi tipi 0773 | 29 | CITY | Il (devlet, il, ilçe, mahalle) | nvarchar | 3 | 0 | | |
96 | T7TRG01 | General information about company. | 20 | CITY | Province | nvarchar | 3 | 0 | | |
97 | T7UA1656 | Infotype 1656 Fields: Legal properties (Ukraine) | 8 | CITY | Address City | nvarchar | 30 | 0 | | |
TOPPersonnel Administration |
98 | T7GR1HR10T | Employer Department (Texts) | 10 | CITY | City | nvarchar | 50 | 0 | | |
TOPPortfolio |
99 | VDBILL_RES_HEAD | Bill Results Header | 31 | CITY | City | nvarchar | 40 | 0 | | |
TOPPrint Workbench |
100 | EFG_FLIGHT_DATA | Data by Data Dispatch | 5 | CITY | City | nvarchar | 25 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
101 | DFMCA_BRF650 | BRF: Business Partner Reading | 31 | CITY | BRF: Expression | nvarchar | 20 | 0 | | |
102 | DFMCA_BRF890 | BRF: Business Partner Determination from Form | 32 | CITY | BRF: Expression | nvarchar | 20 | 0 | | |
103 | DFMCA_TF_WHT_L | Line Item Table of Withholding Tax | 19 | CITY | City | nvarchar | 25 | 0 | | |
TOPSales and Distribution |
104 | ZZDEA_MST | Drug Enforcement Administration (DEA) | 11 | CITY | City | nvarchar | 40 | 0 | | |
TOPSchedule Manager |
105 | T880 | Global Company Data (for KONS Ledger) | 10 | CITY | City where company is located | nvarchar | 30 | 0 | | |
TOPSingapore |
106 | PA0412 | HR Master Record: Infotype 0412 [View to I0021] (SG) | 37 | CITY | City | nvarchar | 25 | 0 | | |
TOPStructures Workbench |
107 | /ISDFPS/CMDZONDT | Relocation Zone Determination | 4 | CITY | City | nvarchar | 40 | 0 | | |
TOPTalent Management |
108 | HRP7402 | Internal Work Experience | 25 | CITY | City | nvarchar | 40 | 0 | | |
109 | HRP7403 | External Work Experience | 19 | CITY | City | nvarchar | 40 | 0 | | |
110 | HRP7404 | Education | 21 | CITY | City | nvarchar | 40 | 0 | | |
TOPTariffs, Duties and Permits |
111 | OIH_J1B_COP | Brazil: Controled prices table | 4 | CITY | City Code | nvarchar | 4 | 0 | | |
112 | OIH_J_1BTXIS1 | Tax calc.: ISS rules for sales exeptions | 5 | CITY | City Code | nvarchar | 4 | 0 | | |
113 | OIH_J_1BTXIX1 | Tax calc.: ISS rules for sales and purchasing exeptions | 5 | CITY | City Code | nvarchar | 4 | 0 | | |
TOPTransaction Tax Engine |
114 | TTED_ACQUISI_COM | Acquisition | 12 | CITY | City | nvarchar | 30 | 0 | | |
115 | TTED_PARTNER_COM | Partner | 18 | CITY | City | nvarchar | 30 | 0 | | |
116 | TTED_PARTN_O_COM | Partner in OutputDocument | 18 | CITY | City | nvarchar | 30 | 0 | | |
117 | TTEPD3_PARTNER | Partner | 17 | CITY | City | nvarchar | 30 | 0 | | |
118 | TTEPDT_ITEMPART | Persistency TTE Document item partner | 9 | CITY | City | nvarchar | 30 | 0 | | |
119 | TTEPDT_PARTNER | Persistency TTE Document business partner | 7 | CITY | City | nvarchar | 30 | 0 | | |
120 | TTESDT_ITEMPART | Document item partner | 9 | CITY | City | nvarchar | 30 | 0 | | |
121 | TTESDT_PARTNER | Document business partner | 7 | CITY | City | nvarchar | 30 | 0 | | |
TOPTravel Expenses |
122 | PTRV_VATDETAIL | Supplier Data for VAT Refund in Travel Management | 14 | CITY | City | nvarchar | 40 | 0 | | |
123 | T706_VAT_FLDS | Country-Dependent Field Control for Receipt Data | 17 | CITY | City | nvarchar | 1 | 0 | | |
TOPTravel Management |
124 | TA23ADR | Predefined Addresses in Travel Management | 6 | CITY | City | nvarchar | 40 | 0 | | |
TOPTravel Planning |
125 | FTPT_HOTEL_DATA | Hotel Data | 10 | CITY | City | nvarchar | 40 | 0 | | |
126 | FTPT_REQUEST | Travel Plan Requests | 27 | CITY | City | nvarchar | 40 | 0 | | |
127 | TA23HOTELS | Hotel Data | 10 | CITY | City | nvarchar | 40 | 0 | | |
128 | TA23OFFICE_ADR | Sales Office Addresses | 7 | CITY | Sales Office Address: City | nvarchar | 60 | 0 | | |
TOPUSA |
129 | T5UP2 | Establishment/stores for tip processing | 10 | CITY | City | nvarchar | 25 | 0 | | |
TOPWeb Dynpro ABAP |
130 | WDR_TEST_SCIRP7 | City-Airport assignment | 2 | CITY | City | nvarchar | 20 | 0 | | |
131 | WDR_TEST_SCIRP8 | City-Airport assignment | 2 | CITY | City | nvarchar | 20 | 0 | | |
TOPWorkbench Utilities |
132 | CUSTOMERS | ABAP Book: Customers | 5 | CITY | City | nvarchar | 25 | 0 | | |
133 | GEOCITY | ABAP/4 book: Geographical position of a city | 2 | CITY | City | nvarchar | 20 | 0 | | |