	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

133 columns | ERP 6.0 | CITY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
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

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

133 columns | ERP 6.0 | CITY