	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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

61 columns | ERP 6.0 | CITY_CODE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/FLDQ/AD_CHKSTAT	Table to temporarily hold the check status values	7	CITY_CODE	City code for city/street file	nvarchar	12	0
2	/FLDQ/AD_QTRRVW	Cleansed addresses from RSADRQU2 to review before comitting	21	CITY_CODE	City code for city/street file	nvarchar	12	0
3	/FLDQ/AD_QU_INDX	QU2 Index Table	17	CITY_CODE	City code for city/street file	nvarchar	12	0
4	/FLDQ/HNACLNSOUT	DQM for SAP output table for transactional cleanse TASK	8	CITY_CODE	City code for city/street file	nvarchar	12	0
5	/FLDQ/HNACLNSTSK	DQM for SAP input table for transactional cleanse TASK	8	CITY_CODE	City code for city/street file	nvarchar	12	0
6	/FLDQ/HNA_PREQU2	staging table for RSADRQU2 report	17	CITY_CODE	City code for city/street file	nvarchar	12	0
7	/FLDQ/HNA_PSTQU2	Result Table for RSADRQU2 report	17	CITY_CODE	City code for city/street file	nvarchar	12	0
8	/SMD/MD_____00ME	SID-Tabelle fuer District	4	CITY_CODE	City Code for City/Street File	nvarchar	12	0
9	/SMD/MD_____00MF	SID-Tabelle fuer City Code	4	CITY_CODE	City Code for City/Street File	nvarchar	12	0
10	/SMD/MD_____00MJ	SID-Tabelle fuer City Code	4	CITY_CODE	City Code for City/Street File	nvarchar	12	0
11	/SMD/MD_____00N4	SID-Tabelle fuer City Code	4	CITY_CODE	City Code for City/Street File	nvarchar	12	0
12	DIAN_A_1001_08	Cached Data of DIAN Format 1001 version 08	16	CITY_CODE	DIAN City Code	nvarchar	3	0
13	DIAN_A_1003_07	Cached Data of DIAN Format 1003 version 07	16	CITY_CODE	DIAN City Code	nvarchar	3	0
14	DIAN_A_1008_07	Cached Data of DIAN Format 1003 version 07	15	CITY_CODE	DIAN City Code	nvarchar	3	0
15	DIAN_A_1009_07	Cached Data of DIAN Format 1009 version 07	15	CITY_CODE	DIAN City Code	nvarchar	3	0
16	T7BREFD_EEADDR	Employee address	12	CITY_CODE	Municipality code	nvarchar	7	0
TOPAddress ManagementBusiness Address
17	ADRC	Addresses (Business Address Services)	15	CITY_CODE	City code for city/street file	nvarchar	12	0
18	ADRCITY	Postal cities	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
19	ADRCITYPRT	Postal districts	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
20	ADRCITYT	Postal districts (long texts)	4	CITY_CODE	City Code for City/Street File	nvarchar	12	0
21	ADRCS	Shadow Table: Addresses (Business Address Services)	16	CITY_CODE	City code for city/street file	nvarchar	12	0
22	ADRCS2	Shadow Table 2: Addresses (Business Address Services)	17	CITY_CODE	City code for city/street file	nvarchar	12	0
23	ADRDIF_CP	District Difference Table for Quarterly Adjustment	8	CITY_CODE	City Code for City/Street File	nvarchar	12	0
24	ADRDIF_CT	City Difference Table for Quarterly Adjustment	7	CITY_CODE	City Code for City/Street File	nvarchar	12	0
25	ADRDIF_PC	Postal Code Difference Table for Quarterly Adjustment	7	CITY_CODE	City Code for City/Street File	nvarchar	12	0
26	ADRDIF_PO	PO Box Difference Table for Quarterly Adjustment	10	CITY_CODE	City Code for City/Street File	nvarchar	12	0
27	ADRDIF_ST	Street Difference Table for Quarterly Adjustment	14	CITY_CODE	City Code for City/Street File	nvarchar	12	0
28	ADRPCDCITY	Postal code/city: Assignment table	4	CITY_CODE	City Code for City/Street File	nvarchar	12	0
29	ADRPOBOX	PO Boxes	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
30	ADRSTREET	Streets	4	CITY_CODE	City Code for City/Street File	nvarchar	12	0
31	ADRSTREETT	Streets (long texts)	5	CITY_CODE	City Code for City/Street File	nvarchar	12	0
TOPBank Customer Accounts
32	BCA_US_BC_ADDR	Addresses Associated with Bank Cheques	34	CITY_CODE	City code for city/street file	nvarchar	12	0
TOPBasis Components
33	ZDS400_TAB1	Exercise table	3	CITY_CODE	CHAR10 for SYST	nvarchar	10	0
TOPContract Accounts Receivable and Payable
34	FKK_GPSHAD	Data Extract: Business Partner Data (Faster Access)	40	CITY_CODE	City code for city/street file	nvarchar	12	0
TOPDealer Portal
35	/SAPDII/SPPSHIPA	Maintaining Alternate shipping locations	12	CITY_CODE		nvarchar	4	0
TOPDevice Management
36	EGTUR	Periodic Replacement List	11	CITY_CODE	City Code for City/Street File	nvarchar	12	0
TOPDSD Connector
37	/DSD/ME_CUST_HD	DSD CN: Customer Details	86	CITY_CODE	City Code	nvarchar	4	0
TOPFinancial Accounting
38	AC400ADRC	P01 Adressen für Programm AC400DEBITOR	15	CITY_CODE	Codierung des Orts für Orts- und Straßendatei	nvarchar	12	0
TOPGlobal Trade Services
39	/SAPSLL/PREVDAUD	SLL: Preference: Vend.Decl. for Customer Purp.: Audit	22	CITY_CODE	City code for city/street file	nvarchar	12	0
40	/SAPSLL/SPLAUD	Legal Control - SPL - Audit	55	CITY_CODE	City code for city/street file	nvarchar	12	0
TOPIntercompany Data Exchange
41	EADRCITYGRID	Allocation of Grid to City	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
42	EADRCITYGRID_NEW	Allocation of Grid in Utilities Industry to Location (New)	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
TOPLocalization
43	J_1BNFCPD	Nota Fiscal one-time accounts	35	CITY_CODE	City code for city/street file	nvarchar	12	0
TOPMove-InOut
44	ECAMIOPRADDR	IS-U: Parked Document: Addresses (Business Partner)	13	CITY_CODE	City code for city/street file	nvarchar	12	0
TOPProcess Controls
45	GRPC_BW_EVT_LOC	PC Events: BI Location Id -> Region/Country/... mapping	7	CITY_CODE	City Code for City/Street File	nvarchar	12	0
TOPProcessing
46	EWMINSPDETAIL	Inspection List Detail	12	CITY_CODE	City Code for City/Street File	nvarchar	12	0
TOPRegional structure
47	ADRCITYCCS	Division-Dependent Data for City	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
48	ADRCITYKON	Franch. Contracts for City	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
49	ADRCITYMRU	MRUs for City	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
50	EADRCITYAMS	AMS for Locations	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
51	EADRCITYROUTE	Routes for City	3	CITY_CODE	City Code for City/Street File	nvarchar	12	0
TOPStatistics
52	S441	IS-U Industry Statistics	8	CITY_CODE	City code for city/street file	nvarchar	12	0
53	S441E	S441: Structure Information	3	CITY_CODE	City code for city/street file	nvarchar	12	0
TOPTravel Expenses
54	PTRV_TRIPCHN_46C	Table of all Trip Destinations f. Processing Recurring Dest.	30	CITY_CODE	Code Number for Location (e.g. Community Code Number)	nvarchar	12	0
55	PTRV_TRIP_CHAIN	Table of all Trip Destinations f. Processing Recurring Dest.	30	CITY_CODE	Code Number for Location (e.g. Community Code Number)	nvarchar	12	0
56	T706_CITY_CD_46C	Table for Specifying the City Code/Community Code Number	6	CITY_CODE	City code for city/street file	nvarchar	12	0
57	T706_CITY_CD_D	Definition: City Codes / Community Code No., Date-Dependent	8	CITY_CODE	Code Number for Location (e.g. Community Code Number)	nvarchar	12	0
58	T706_CITY_CD_D_2	Definition: City Codes / Community Code No., Date-Dependent	8	CITY_CODE	City code for city/street file	nvarchar	12	0
59	T706_CITY_CODE	Table for Specifying the City Code/Community Code Number	6	CITY_CODE	City code for city/street file	nvarchar	12	0
TOPTravel Planning
60	FTPT_PNR_ADDRESS	PNR delivery / billing addresses	12	CITY_CODE	City	nvarchar	40	0
61	FTPT_QT_HOTEL	Quicktrip Travel Request Item - Flight Service	8	CITY_CODE	Hotel Location	nvarchar	3	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

61 columns | ERP 6.0 | CITY_CODE