	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

39 columns | ERP 6.0 | HOUSE_NUM2

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/FLDQ/AD_CHKSTAT	Table to temporarily hold the check status values	33	HOUSE_NUM2	House number supplement	nvarchar	10	0
2	/FLDQ/AD_INI_ERR	Record records which encounter an error in RSADRINI	27	HOUSE_NUM2	House number supplement	nvarchar	10	0
3	/FLDQ/AD_INI_IDX	Copy of Shadow Table /fldq/ad_mtc_sh	27	HOUSE_NUM2	House number supplement	nvarchar	10	0
4	/FLDQ/AD_MTCCODE	FirstLogic Match Code Index Table	27	HOUSE_NUM2	House number supplement	nvarchar	10	0
5	/FLDQ/AD_MTCRSLT	Match Results table to store results from RSADRINI program	28	HOUSE_NUM2	House number supplement	nvarchar	10	0
6	/FLDQ/AD_MTC_SH	FirstLogic Shadow table for /FLDQ/AD_MTCCODE	27	HOUSE_NUM2	House number supplement	nvarchar	10	0
7	/FLDQ/AD_MTC_SH2	FirstLogic Shadow table for /FLDQ/AD_MTCCODE	27	HOUSE_NUM2	House number supplement	nvarchar	10	0
8	/FLDQ/AD_PUPDATE	Matchcode Records pending to be updated	27	HOUSE_NUM2	House number supplement	nvarchar	10	0
9	/FLDQ/AD_QTRRVW	Cleansed addresses from RSADRQU2 to review before comitting	40	HOUSE_NUM2	House number supplement	nvarchar	10	0
10	/FLDQ/AD_QU_INDX	QU2 Index Table	40	HOUSE_NUM2	House number supplement	nvarchar	10	0
11	/FLDQ/HNACLNSOUT	DQM for SAP output table for transactional cleanse TASK	34	HOUSE_NUM2	House number supplement	nvarchar	10	0
12	/FLDQ/HNACLNSTSK	DQM for SAP input table for transactional cleanse TASK	34	HOUSE_NUM2	House number supplement	nvarchar	10	0
13	/FLDQ/HNA_BM_IN	HANA task Batch Match Input Records	20	HOUSE_NUM2	House number supplement	nvarchar	10	0
14	/FLDQ/HNA_PREQU2	staging table for RSADRQU2 report	40	HOUSE_NUM2	house num2 with increased size to stop truncation	nvarchar	100	0
15	/FLDQ/HNA_PSTQU2	Result Table for RSADRQU2 report	40	HOUSE_NUM2	house num2 with increased size to stop truncation	nvarchar	100	0
TOPAddress ManagementBusiness Address
16	ADRC	Addresses (Business Address Services)	41	HOUSE_NUM2	House number supplement	nvarchar	10	0
17	ADRCS	Shadow Table: Addresses (Business Address Services)	42	HOUSE_NUM2	House number supplement	nvarchar	10	0
18	ADRCS2	Shadow Table 2: Addresses (Business Address Services)	43	HOUSE_NUM2	House number supplement	nvarchar	10	0
TOPBank Customer Accounts
19	BCA_US_BC_ADDR	Addresses Associated with Bank Cheques	46	HOUSE_NUM2	House number supplement	nvarchar	10	0
TOPBasis Components
20	/XFT/INV_Q_6	PO details (header) for an invoice receipt process	41	HOUSE_NUM2	House number supplement	nvarchar	10	0
21	/XFT/INV_Q_6_S	PO details (header) for an invoice receipt process	41	HOUSE_NUM2	House number supplement	nvarchar	10	0
TOPContract Accounts Receivable and Payable
22	DFKKGP_SHORT	Data Extract: BP Data	16	HOUSE_NUM2	House number supplement	nvarchar	10	0
23	FKK_GPSHAD	Data Extract: Business Partner Data (Faster Access)	24	HOUSE_NUM2	House number supplement	nvarchar	10	0
TOPFinancial Accounting
24	AC400ADRC	P01 Adressen für Programm AC400DEBITOR	41	HOUSE_NUM2	Ergänzung zur Hausnummer	nvarchar	10	0
TOPGlobal Trade Services
25	/SAPSLL/PREVDAUD	SLL: Preference: Vend.Decl. for Customer Purp.: Audit	48	HOUSE_NUM2	House number supplement	nvarchar	10	0
26	/SAPSLL/SPLAUD	Legal Control - SPL - Audit	81	HOUSE_NUM2	House number supplement	nvarchar	10	0
TOPLocalization
27	J_1BNFCPD	Nota Fiscal one-time accounts	61	HOUSE_NUM2	House number supplement	nvarchar	10	0
28	J_1BNFDOC	Nota Fiscal Header	97	HOUSE_NUM2	House number supplement	nvarchar	10	0
29	J_1BNFNAD	Nota Fiscal partners	37	HOUSE_NUM2	House number supplement	nvarchar	10	0
TOPMaster Data
30	EBP_ADDR_SERVICE	Search Index for Business Partner Service Addresses	17	HOUSE_NUM2	House number supplement	nvarchar	10	0
31	EFISEL	Field Selection Control for Address Data	25	HOUSE_NUM2	House number affix	nvarchar	1	0
TOPMove-InOut
32	ECAMIOPRADDR	IS-U: Parked Document: Addresses (Business Partner)	8	HOUSE_NUM2	House number supplement	nvarchar	10	0
TOPPublic Sector Contract Accounts Receivable and Payable
33	DFMCA_BRF650	BRF: Business Partner Reading	27	HOUSE_NUM2	BRF: Expression	nvarchar	20	0
34	DFMCA_BRF890	BRF: Business Partner Determination from Form	28	HOUSE_NUM2	BRF: Expression	nvarchar	20	0
TOPSales Promotions
35	SADLSTRECB	Dynamic Part of Address List (Record Body)	25	HOUSE_NUM2	House number supplement	nvarchar	10	0
TOPWaste Management
36	EHSWAT_APPBP	MD: Waste Permit Partner	46	HOUSE_NUM2	House number supplement	nvarchar	10	0
37	EHSWAT_MNBP	Waste Manifest/Delivery Note: Partners	43	HOUSE_NUM2	House number supplement	nvarchar	10	0
38	EPROP_ADRFLD_SEL	Field Selection Control for Address Screen of Property	25	HOUSE_NUM2	House number affix	nvarchar	1	0
39	EROB_ADDRFLD_SEL	Field Selection Control for Add. Screen of Cleaning Object	25	HOUSE_NUM2	House number affix	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

39 columns | ERP 6.0 | HOUSE_NUM2