	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

124 columns | ERP 6.0 | STREET

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

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

124 columns | ERP 6.0 | STREET