	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

114 columns | ERP 6.0 | SEQ_NO

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/MRE/APPL_DCN_RE	Application level MBO relationship	5	SEQ_NO	2 byte integer (signed)	smallint	5	0
2	/OPT/CT_MAILFLDT	Table to maintain Mail configuration field texts	3	SEQ_NO	Opentext: sequence number data element	nvarchar	3	0
3	/OPT/CT_MAIL_FLD	Table to maintain Mail configuration fields	3	SEQ_NO	Opentext: sequence number data element	nvarchar	3	0
4	/OPT/X200	Table to maintain Mail configuration field texts	3	SEQ_NO	Opentext: sequence number data element	nvarchar	3	0
5	/OPT/X202	Table to maintain Mail configuration fields	3	SEQ_NO	Opentext: sequence number data element	nvarchar	3	0
6	/OPT/Y200	Table to maintain Mail configuration field texts	3	SEQ_NO	Opentext: sequence number data element	nvarchar	3	0
7	/OPT/Y202	Table to maintain Mail configuration fields	3	SEQ_NO	Opentext: sequence number data element	nvarchar	3	0
8	/OPT/Z200	Table to maintain Mail configuration field texts	3	SEQ_NO	Opentext: sequence number data element	nvarchar	3	0
9	/OPT/Z202	Table to maintain Mail configuration fields	3	SEQ_NO	Opentext: sequence number data element	nvarchar	3	0
10	/SAPSRM/APPLTERR	Stores Applet Exceptions	18	SEQ_NO	Message sequence number	nvarchar	12	0
11	/SYCLO/PSH00OT	Push scenario outbound trigger assignment	3	SEQ_NO	Sequence no (5 char)	nvarchar	5	0
12	/SYCLO/WB003A	DevTool: Client Screen Set Screen Assignment	6	SEQ_NO	DevTool: Screen position in screen set	int	10	0
13	/TDAG/GFWWIC_PLS	Genifix: Enhält die Wertelisten für Parameter	3	SEQ_NO	Genifix: Sort number for parameter values	nvarchar	3	0
14	BBPD_LA_CLTSTAT	Client status	9	SEQ_NO	Message sequence number	nvarchar	12	0
15	BBPD_LA_MESSAGE	Message	6	SEQ_NO	Message sequence number	nvarchar	12	0
16	BKK_PE_DB_ITEM	Store Asynchronous Posting Response for Items	11	SEQ_NO	Sequence number	int	10	0
17	CNVHCM_I_OBJMAP	E-recruiting S-table - Object type Mapping	4	SEQ_NO	Two digit number	nvarchar	2	0
18	CNVMBTCOPYC	Copy Control Data for TDMS & CMIS packages	14	SEQ_NO	Sequential number for copy sequence in PCL packages	nvarchar	5	0
19	CNVMBTNOTTEVNT	Events Notification Table	4	SEQ_NO	Sequence of activities execution in PEB	nvarchar	4	0
20	CNVMBTPEBACTSET	Unique ID for set of activities	5	SEQ_NO	Sequence of activities execution in PEB	nvarchar	4	0
21	CNVMBTPEMCONTENT	Process Execution Content of an Object	6	SEQ_NO	Sequence Number	nvarchar	2	0
22	CNV_10993_VASURU	Validation and Substitution Rule	7	SEQ_NO	sequence number	nvarchar	2	0
23	CNV_TDMS_16_DCMP	DDIC Comparison results	3	SEQ_NO	Natural Number	int	10	0
24	CNV_TDMS_BPL_CON	BPL Conflicting records during data transfer	5	SEQ_NO	Natural Number	int	10	0
25	CNV_TDMS_BP_SEC	BPL Conflicting records during data transfer	5	SEQ_NO	Natural Number	int	10	0
26	EDOCUMENT	eDocument	3	SEQ_NO	eDocument Sequence Number	nvarchar	3	0
27	EDOCUMENTFILE	eDocument: File	4	SEQ_NO	eDocument Sequence Number	nvarchar	3	0
28	EDOCUMENTHISTORY	eDocument: History	3	SEQ_NO	eDocument Sequence Number	nvarchar	3	0
29	EDOPEBOLSUM	eDocument Peru: Daily Summary Boletas	4	SEQ_NO	Summary Sequence Number	nvarchar	3	0
30	FUDT_DOCVERACTL	Action logs of FI document verification	5	SEQ_NO	Sequence number of document verification action log	nvarchar	3	0
31	GHO_FORM_MEAS_I	Allocation Formula Measurements Item	3	SEQ_NO	Formula Sequence Number	nvarchar	3	0
32	IRW_ARCH_RELA	Relationship between tables through key fields- RW Specific	2	SEQ_NO		nvarchar	4	0
33	IRW_ARCH_STRUCT	Relationship between tables through key fields- RW Specific	2	SEQ_NO		nvarchar	4	0
34	J_1IEXIM_SUPDOC	EXIM : Supporting Document Sets	3	SEQ_NO	LoC Partial Shipment Sequence Number	nvarchar	3	0
35	J_1ILOCGOODS	EXIM : Letter of Credit Good	6	SEQ_NO	LoC Partial Shipment Sequence Number	nvarchar	3	0
36	MSSROWSET	MSSQL : DB performance snapshot data	4	SEQ_NO		nvarchar	8	0
37	REFXCN_TABLEKEY	Key in RECN table	4	SEQ_NO	Display Order for Key Field	tinyint	3	0
38	/BOBF/D_CC_LOG_H	BOPF Contract Compliance Check Log header	15	SEQ_NO		int	10	0
TOPAccounting Interface
39	GLE_ECS_DI_ADM0	Management of ECS Direct Input	3	SEQ_NO	Version of an ECS Posting Run (Supplement to Run ID)	nvarchar	4	0
40	GLE_ECS_ITEM_MSG	ECS: Error Messages for Error Correction Items	3	SEQ_NO	Sequence Number	nvarchar	6	0
TOPAssortment
41	WRF_APC_IBID	Purchasing List Inbound Interface Detailed Totals	8	SEQ_NO	Sequence Number For Purchasing Lists	nvarchar	2	0
42	WRF_APC_IBIT	Purchasing List Inbound Interface Totals	8	SEQ_NO	Sequence Number For Purchasing Lists	nvarchar	2	0
43	WRF_APC_PLH	Purchasing List Header Data	9	SEQ_NO	Sequence Number For Purchasing Lists	nvarchar	2	0
TOPBalancing
44	OIUBL01_COMMENT	Product balancing comments	3	SEQ_NO	Sequence number	nvarchar	3	0
TOPBank Customer Accounts
45	BCA_US_BKK44A	Current account master data: Amount-dependent blocks	5	SEQ_NO	Sequence number (for amount-dependent blocks)	nvarchar	2	0
46	BCA_US_OD_REL	Accounts - US specific overdraft relation details	4	SEQ_NO	Sequence number for Overdraft relationship	nvarchar	2	0
TOPBusiness Context Viewer
47	/BCV/C_QRESA	Query Result Field	4	SEQ_NO	Sequence Number of Query Result Field	nvarchar	4	0
48	/BCV/C_QVAR	Query Input Field	4	SEQ_NO	Sequence Number of Query Input Field	nvarchar	4	0
TOPCheck Input
49	OIUCI_DOC_CIREJ	Contains VL/RD rejects to be reported to Check Input	4	SEQ_NO	Sequence number	nvarchar	3	0
TOPClaims Management
50	ICLSCATTRIB	FS-CM: Attribute Values for Benefit/Service/Fees Catlg Items	4	SEQ_NO	Sequence No. Benefits/Services/Fees Catalog Attributes	nvarchar	5	0
TOPCollaborative Cross Applications
51	/POA/D_CLMDEPRES	Deplyment Results	4	SEQ_NO	Natural Number	int	10	0
TOPContent Activation
52	BSANLY_BCACT_LOG	Activation Log for Content Bundles	6	SEQ_NO		int	10	0
TOPContract Accounts Receivable and Payable
53	TFKK_INT_HIST	##Customizing table for interaction history	6	SEQ_NO	Sequence Number for interaction history	tinyint	3	0
TOPCross-Application Components
54	/OPT/S_PO_HIST	VSS Staging Table: PO history	8	SEQ_NO	Sequential Number of Account Assignment	nvarchar	2	0
TOPCustomer Interaction
55	CICFHCASSN	Call center framework hidden component modules	3	SEQ_NO	Sequence number of component assignment	nvarchar	2	0
TOPDMS Integration for ViewerCAD intergration
56	DMS_VEG_CUST	DMS VEG Conversion Specifications	3	SEQ_NO	Sequence Number	nvarchar	3	0
TOPFunds Management
57	FMDERIVE_SETS	Sets for different Strategies	4	SEQ_NO	Characteristic derivation: sequential number	nvarchar	4	0
TOPGeneral Application Functions
58	TABADRSF	Characteristic Derivation: Steps, Fields	8	SEQ_NO	Characteristic derivation: sequential number	nvarchar	4	0
TOPGeneral Ledger Accounting
59	FAGL_VAL_GRP	Sets for the Validation of Account Assignment Combinations	4	SEQ_NO	Characteristic derivation: sequential number	nvarchar	4	0
TOPList Processing
60	SABP_LISTTR_M	List Trace Manager	5	SEQ_NO		int	10	0
TOPOccupational Health
61	T7EHS00_PROTREG	Regulations for Protocol	4	SEQ_NO	Internal Number for Statutory Regulation	nvarchar	3	0
TOPOwnership
62	GHO_OWNDOI_ITMCK	Ownership : Division of Interest details in item work table	7	SEQ_NO	Ownership Sequence number	nvarchar	2	0
63	GHO_OWN_BG_ITMCK	Bearer Group Items table - work table	10	SEQ_NO	Ownership Sequence number	nvarchar	2	0
64	GHO_OWN_BG_ITMS	Bearer Group Items table	10	SEQ_NO	Ownership Sequence number	nvarchar	2	0
65	GHO_OWN_DOI_ITMS	Ownership : Division of Interest details	7	SEQ_NO	Ownership Sequence number	nvarchar	2	0
66	GHO_TRO_BG_ITMS	Temporary storage for Bearer group from transfer request	14	SEQ_NO	Ownership Sequence number	nvarchar	2	0
67	OIUOW_TR_WK	Tract Information - work table	3	SEQ_NO	Sequence number	nvarchar	4	0
TOPProduction
68	OIUPR_SSD	Supply Source Detail	8	SEQ_NO	Sequence number	nvarchar	3	0
TOPProduction Allocation
69	GHO_MRH_RULE_I	Measurement Retrieval Hierarchy Rules Item	3	SEQ_NO	MRH Sequence Number	nvarchar	3	0
70	GHO_NWRULE_I	Network Allocation Rules Item	5	SEQ_NO	Allocation Sequence Number	nvarchar	3	0
71	GHO_NW_RULE_I	OBSOLETE - Production Flow Network Allocation Rule Item	5	SEQ_NO	Allocation Sequence Number	nvarchar	3	0
72	GHO_PQCURVE_I	PQ Curve Details Item	3	SEQ_NO	Allocation Sequence Number	nvarchar	3	0
73	GHO_RULE_LOG_I	Allocation Rule Log Item	11	SEQ_NO	Allocation Sequence Number	nvarchar	3	0
74	GHO_SIMU_NWRI	Simulation: Network Allocation Rules Item	5	SEQ_NO	Allocation Sequence Number	nvarchar	3	0
TOPProduction and Revenue Accounting
75	OIUT2_INTD	Obsolete: Ownership Interface Detail	3	SEQ_NO	Sequence Number	nvarchar	6	0
76	OIUT2_INT_MESSG	Obsolete: Ownership Interface Messages (Application/Tech.)	3	SEQ_NO	Sequence Number	nvarchar	6	0
77	OIUT2_INT_TRACE	Obsolete: Ownership Interface Technical Trace	3	SEQ_NO	Sequence Number	nvarchar	6	0
78	OIUXI_INT_MESSG	Ownership Interface Messages (Application/Technical)	3	SEQ_NO	Sequence Number	nvarchar	6	0
79	OIU_DO_TR	Tract Information	3	SEQ_NO	Sequence number	nvarchar	4	0
80	OIU_PM_MAP	Customizing table for PRA / PM Integration mapping	3	SEQ_NO	Sequence number	nvarchar	3	0
81	OIU_PM_XREF	Cross reference for PRA / PM entities	4	SEQ_NO	Sequence number	nvarchar	3	0
82	OIU_PR_FRMD	Formula Rules Maintenance Detail	3	SEQ_NO	Sequence number	nvarchar	3	0
83	OIU_PR_FRMDW	Formular Rules DW	3	SEQ_NO	Sequence number	nvarchar	3	0
84	OIU_PR_HPPND	Volumetric Historical PPN Detail	3	SEQ_NO	Sequence number	nvarchar	3	0
85	OIU_PR_NGCA	Natural Gas Compound Alias	2	SEQ_NO	Sequence number	nvarchar	3	0
86	OIU_PR_PPCHC	Plant Product Cmpnt/Hydrocarbon Cmpnt Xref-TBLPR069,TBLOZ0	2	SEQ_NO	Sequence number	nvarchar	3	0
87	OIU_PR_PPND	Production Prior Period Notification Delivery Ntwk Det. T	3	SEQ_NO	Sequence number	nvarchar	3	0
88	OIU_PR_WCSSD	Well Completion Supply Source Detail	7	SEQ_NO	Sequence number	nvarchar	3	0
89	OIU_RV_FRMLD	Valuation Formula Detail	3	SEQ_NO	Sequence number	nvarchar	3	0
TOPProfitability Analysis
90	TKEDRSF	Characteristic Derivation: Steps, Fields	8	SEQ_NO	Characteristic derivation: sequential number	nvarchar	4	0
TOPQuery Management
91	/PLMPCV/D_QRESA	Query result attribute	4	SEQ_NO	Sequence Number of Query Result Attribute	nvarchar	4	0
92	/PLMPCV/D_QVAR	Query variable	10	SEQ_NO	Sequence Number of Query Variable	nvarchar	4	0
TOPRevenue
93	OIUAR_BAL_TRFR	Accounts Receivable Balance Transfer	3	SEQ_NO	Sequence number	nvarchar	3	0
94	OIURV03_DTL_ZE	Valuation Transactions Level 1 - Zero Volume	4	SEQ_NO	Document Line Number	nvarchar	5	0
TOPRisk Analysis
95	AFWCH_DRSF_SAMP	Sample Customizing for Derivation (Fields for Steps)	7	SEQ_NO	Characteristic derivation: sequential number	nvarchar	4	0
TOPRoyalty Reporting
96	OIUREP_AGY_LSE	Agency assigned Leases	9	SEQ_NO	Transaction code for Royalty reporting	nvarchar	2	0
97	OIUREP_CODE_RDNG	Reg Reporting Rounding Configuration	9	SEQ_NO	Sequence number	nvarchar	3	0
98	OIUREP_TEXT_XREF	Regulatory Reporting Texts for Diff Reporting Levels	6	SEQ_NO	Sequence number	nvarchar	3	0
99	OIUY1_GEN_CD_VAL	Maintain Code with Effective Dated	5	SEQ_NO	Sequence number	nvarchar	3	0
TOPSAP Ambulatory Care Management
100	TNHCO_CORD_SEL	HCO: Char. Sel. for Coll. Orders for Outpat. Case-Bsd Orders	5	SEQ_NO	Seq. Number for Characteristic Selection Collective Orders	nvarchar	2	0
TOPSAP Records Management
101	SRM_PROP_DATA	Obsolete!	4	SEQ_NO	Property - Attribute Number	smallint	5	0
TOPSAP Retail Store
102	TWIC1320	Assignment of menu items	6	SEQ_NO	Sequence Number in Menu	nvarchar	2	0
103	TWIC1320T	Assignment of menu item texts	7	SEQ_NO	Sequence Number in Menu	nvarchar	2	0
TOPServices
104	FINB_PR_TJOINS	Join conditions	8	SEQ_NO		nvarchar	3	0
105	FINB_PR_TMAP	Field Assignment Read Structure - Persistence Object	8	SEQ_NO		nvarchar	3	0
TOPShift Planning for Public Sector
106	PSPP_INFO_COL	Table for Info Columns Associated with a Variant	4	SEQ_NO	Two digit number	nvarchar	2	0
TOPUser and Authorization Management
107	LICENSE_HASH	Index Table to Allow Quicker Access to LICENSE_DATA	2	SEQ_NO	Number for Hash Collisions	nvarchar	3	0
TOPUser Interface
108	CRMT_RECENT_OBJ	recent objects	4	SEQ_NO		tinyint	3	0
TOPValuation
109	OIURV_DOC_DTL_ZE	Valuation Transactions Level 1 - Zero Volume	4	SEQ_NO	Document Line Number	nvarchar	5	0
110	OIURV_DOC_FRMLAU	Valuation Formula Alternate Use	5	SEQ_NO	Owner Interest Sequence Number	nvarchar	2	0
111	OIURV_TAXCONFD	State tax configuration detail	8	SEQ_NO	Sequence number	nvarchar	3	0
112	OIUVL_GASRPTD	Gas statement report detail	3	SEQ_NO	Sequence number	nvarchar	3	0
113	OIUVL_OILRPTD	Oil statement report detail	4	SEQ_NO	Sequence number	nvarchar	3	0
114	OIUVL_SCREJ	screj	5	SEQ_NO	Sequence number	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

114 columns | ERP 6.0 | SEQ_NO