	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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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

54 columns | ERP 6.0 | HOUSE_NUM1

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/FLDQ/AD_CHKSTAT	Table to temporarily hold the check status values	32	HOUSE_NUM1	House Number	nvarchar	10	0
2	/FLDQ/AD_INI_ERR	Record records which encounter an error in RSADRINI	26	HOUSE_NUM1	House Number	nvarchar	10	0
3	/FLDQ/AD_INI_IDX	Copy of Shadow Table /fldq/ad_mtc_sh	26	HOUSE_NUM1	House Number	nvarchar	10	0
4	/FLDQ/AD_MTCCODE	FirstLogic Match Code Index Table	26	HOUSE_NUM1	House Number	nvarchar	10	0
5	/FLDQ/AD_MTCRSLT	Match Results table to store results from RSADRINI program	27	HOUSE_NUM1	House Number	nvarchar	10	0
6	/FLDQ/AD_MTC_SH	FirstLogic Shadow table for /FLDQ/AD_MTCCODE	26	HOUSE_NUM1	House Number	nvarchar	10	0
7	/FLDQ/AD_MTC_SH2	FirstLogic Shadow table for /FLDQ/AD_MTCCODE	26	HOUSE_NUM1	House Number	nvarchar	10	0
8	/FLDQ/AD_PUPDATE	Matchcode Records pending to be updated	26	HOUSE_NUM1	House Number	nvarchar	10	0
9	/FLDQ/AD_QTRRVW	Cleansed addresses from RSADRQU2 to review before comitting	39	HOUSE_NUM1	House Number	nvarchar	10	0
10	/FLDQ/AD_QU_INDX	QU2 Index Table	39	HOUSE_NUM1	House Number	nvarchar	10	0
11	/FLDQ/HNACLNSOUT	DQM for SAP output table for transactional cleanse TASK	33	HOUSE_NUM1	House Number	nvarchar	10	0
12	/FLDQ/HNACLNSTSK	DQM for SAP input table for transactional cleanse TASK	33	HOUSE_NUM1	House Number	nvarchar	10	0
13	/FLDQ/HNA_BM_IN	HANA task Batch Match Input Records	19	HOUSE_NUM1	House Number	nvarchar	10	0
14	/FLDQ/HNA_PREQU2	staging table for RSADRQU2 report	39	HOUSE_NUM1	house num1 with increased size to stop truncation	nvarchar	100	0
15	/FLDQ/HNA_PSTQU2	Result Table for RSADRQU2 report	39	HOUSE_NUM1	house num1 with increased size to stop truncation	nvarchar	100	0
16	CNVTDMS_11_SCADR	Scrambling Addresses	20	HOUSE_NUM1	House Number	nvarchar	10	0
TOPAddress ManagementBusiness Address
17	ADRC	Addresses (Business Address Services)	40	HOUSE_NUM1	House Number	nvarchar	10	0
18	ADRCS	Shadow Table: Addresses (Business Address Services)	41	HOUSE_NUM1	House Number	nvarchar	10	0
19	ADRCS2	Shadow Table 2: Addresses (Business Address Services)	42	HOUSE_NUM1	House Number	nvarchar	10	0
TOPBank Customer Accounts
20	BCA_US_BC_ADDR	Addresses Associated with Bank Cheques	45	HOUSE_NUM1	House Number	nvarchar	10	0
TOPBasic Functions
21	FSLSA	Foreign Trade: Legal Control-Sanctioned Party List-Address	14	HOUSE_NUM1	House Number	nvarchar	10	0
TOPBasis Components
22	/XFT/INV_Q_6	PO details (header) for an invoice receipt process	40	HOUSE_NUM1	House Number	nvarchar	10	0
23	/XFT/INV_Q_6_S	PO details (header) for an invoice receipt process	40	HOUSE_NUM1	House Number	nvarchar	10	0
TOPClaims Management
24	ICLX_PARTICIPANT	Error Table for Participants with XI Input	19	HOUSE_NUM1	Participant: Participant House Number	nvarchar	10	0
TOPCollectionsDisbursements
25	VVSCPOSESR	Payment Plan Item: ISR Attachment	14	HOUSE_NUM1	House Number	nvarchar	10	0
TOPContract Accounts Receivable and Payable
26	DFKKESR	POR Payment Supplement	12	HOUSE_NUM1	House Number	nvarchar	10	0
27	DFKKGP_SHORT	Data Extract: BP Data	15	HOUSE_NUM1	House Number	nvarchar	10	0
28	DFKKZAX	Repayment Request (Address Data for Check)	10	HOUSE_NUM1	House Number	nvarchar	10	0
29	FKK_GPSHAD	Data Extract: Business Partner Data (Faster Access)	23	HOUSE_NUM1	House Number	nvarchar	10	0
TOPFinancial Accounting
30	AC400ADRC	P01 Adressen für Programm AC400DEBITOR	40	HOUSE_NUM1	Hausnummer	nvarchar	10	0
TOPGlobal Trade Services
31	/SAPSLL/PREVDAUD	SLL: Preference: Vend.Decl. for Customer Purp.: Audit	47	HOUSE_NUM1	House Number	nvarchar	10	0
32	/SAPSLL/SPLAUD	Legal Control - SPL - Audit	80	HOUSE_NUM1	House Number	nvarchar	10	0
TOPLocalization
33	J_1BNFCPD	Nota Fiscal one-time accounts	60	HOUSE_NUM1	House Number	nvarchar	10	0
34	J_1BNFDOC	Nota Fiscal Header	96	HOUSE_NUM1	House Number	nvarchar	10	0
35	J_1BNFNAD	Nota Fiscal partners	36	HOUSE_NUM1	House Number	nvarchar	10	0
TOPMaster Data
36	EBP_ADDR_SERVICE	Search Index for Business Partner Service Addresses	16	HOUSE_NUM1	House Number	nvarchar	10	0
37	EFISEL	Field Selection Control for Address Data	23	HOUSE_NUM1	House Number	nvarchar	1	0
TOPMove-InOut
38	ECAMIOPRADDR	IS-U: Parked Document: Addresses (Business Partner)	7	HOUSE_NUM1	House Number	nvarchar	10	0
TOPOffer and Rental Request
39	VIOROO	Offered Object	67	HOUSE_NUM1	House Number	nvarchar	10	0
40	VIORRR	Rental Request	79	HOUSE_NUM1	House Number	nvarchar	10	0
TOPPublic Sector Contract Accounts Receivable and Payable
41	DFMCA_BRF540	BRF: Create Address for Business Partner	21	HOUSE_NUM1	BRF: Expression	nvarchar	20	0
42	DFMCA_BRF650	BRF: Business Partner Reading	26	HOUSE_NUM1	BRF: Expression	nvarchar	20	0
43	DFMCA_BRF750	BRF: Address Check	18	HOUSE_NUM1	BRF: Expression	nvarchar	20	0
44	DFMCA_BRF760	BRF: Read Location	13	HOUSE_NUM1	BRF: Expression	nvarchar	20	0
45	DFMCA_BRF770	BRF: Create Location	22	HOUSE_NUM1	BRF: Expression	nvarchar	20	0
46	DFMCA_BRF820	BRF: Address Autocorrection	20	HOUSE_NUM1	Field Name	nvarchar	30	0
47	DFMCA_BRF890	BRF: Business Partner Determination from Form	27	HOUSE_NUM1	BRF: Expression	nvarchar	20	0
TOPSales Promotions
48	SADLSTRECB	Dynamic Part of Address List (Record Body)	24	HOUSE_NUM1	House Number	nvarchar	10	0
TOPUse AP-MD-BP Components
49	BUTADRSEARCH	Mass Search Help: Business Partner	16	HOUSE_NUM1	House Number	nvarchar	10	0
TOPWaste Management
50	EEWA_CIC_FILTAB	IS-U CIC for Waste: Store Filter Data	4	HOUSE_NUM1	House Number	nvarchar	10	0
51	EHSWAT_APPBP	MD: Waste Permit Partner	40	HOUSE_NUM1	House Number	nvarchar	10	0
52	EHSWAT_MNBP	Waste Manifest/Delivery Note: Partners	37	HOUSE_NUM1	House Number	nvarchar	10	0
53	EPROP_ADRFLD_SEL	Field Selection Control for Address Screen of Property	23	HOUSE_NUM1	House Number	nvarchar	1	0
54	EROB_ADDRFLD_SEL	Field Selection Control for Add. Screen of Cleaning Object	23	HOUSE_NUM1	House Number	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

54 columns | ERP 6.0 | HOUSE_NUM1