	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

39 columns | ERP 6.0 | PLAN_TYPE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	FAGL_R_ARCH_DEF	Definition of Residence Time for Archiving	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
TOPControl Plan
2	QPCPD_CPLAN	Control Plan - Header	8	PLAN_TYPE	Control Plan Type	nvarchar	3	0
TOPGeneral Ledger Reorganization
3	FAGL_R_BLART	Reorganization: Document Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
4	FAGL_R_COMP_AA	Activation of Asset Accounting by Plan Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
5	FAGL_R_COMP_AA0	Entities for Activation of Asset Accounting	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
6	FAGL_R_DERH	Reorganization: Derivation Hierarchy	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
7	FAGL_R_DERH_VER	Reorganization: Version of a Derivation Hierarchy	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
8	FAGL_R_DERH_VER0	Reorganization: Version of a Derivation Hierarchy	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
9	FAGL_R_DERH_VERT	Reorganization: Text of a Hierarchy Version	3	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
10	FAGL_R_JBSIZE	Reorg: Size of a Partition of Object Types to Be Processed	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
11	FAGL_R_OBJTY	Reorganization: Object Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
12	FAGL_R_OBJTY_DI0	Reorganization: Display Chars of an Obj. Type (SAP Entries)	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
13	FAGL_R_OBJTY_DIS	Reorganization: Display Characteristics of an Object Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
14	FAGL_R_OBJTY_RE0	Reorganization: Restriction Characteristics of an Obj. Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
15	FAGL_R_OBJTY_RES	Reorganization: Restriction Characteristics of an Obj. Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
16	FAGL_R_OBJTY_T	Reorganization: Text of an Object Type	3	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
17	FAGL_R_PL	Reorganization Plan	3	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
18	FAGL_R_PLTY	Reorganization: Plan Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
19	FAGL_R_PLTY0	Entities for Activation of Plan Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
20	FAGL_R_PLTY0_T	Reorganization: Text of a Plan Type	3	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
21	FAGL_R_PLTY_RES	Reorganization: Restriction Characteristics of a Plan Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
22	FAGL_R_PLTY_RES0	Reorganization: Restriction Characteristics of a Plan Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
23	FAGL_R_RMVCT	Reorganization: Transaction Type	2	PLAN_TYPE	Reorganization Plan Type	nvarchar	3	0
TOPNursing
24	N1NRSPH	Nursing Plan: Header Data	4	PLAN_TYPE	ISHMED: Nursing Plan - Nursing Plan Type	nvarchar	1	0
25	N1SNP	OBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data	6	PLAN_TYPE		nvarchar	10	0
TOPPortfolio Management
26	/RPM/CAP_B_PLAN	Demand planning for buckets periodic values	3	PLAN_TYPE	Plan Type	nvarchar	2	0
27	/RPM/CAP_PLAN	xRPM Demand planning periodic values	3	PLAN_TYPE	Capacity View Type	nvarchar	2	0
28	/RPM/CO_DOWNLOAD	CO Download persisted data	3	PLAN_TYPE	Financial View Type	nvarchar	2	0
29	/RPM/FIN_B_PLAN	Financial planning for buckets periodic values	3	PLAN_TYPE	Financial View Type	nvarchar	2	0
30	/RPM/FIN_PLAN	xRPM 4.0 Financial Planning	3	PLAN_TYPE	Financial View Type	nvarchar	2	0
31	/RPM/FIN_PLA_INT	FI Intermediate table(with exchratedate)	3	PLAN_TYPE	Financial View Type	nvarchar	2	0
32	RPM_CAPBPLAN_ARC	Demand planning for buckets archive table	3	PLAN_TYPE	Plan Type	nvarchar	2	0
33	RPM_CAPPLAN_ARC	xRPM Demand planning archive table	3	PLAN_TYPE	Capacity View Type	nvarchar	2	0
34	RPM_CAP_B_PLN_CD	Bucket demand periodic values - Pseudo table for change docu	3	PLAN_TYPE	Plan Type	nvarchar	2	0
35	RPM_CAP_PLAN_CD	Cap planning periodic values-Pseudo table for change docu	3	PLAN_TYPE	Capacity View Type	nvarchar	2	0
36	RPM_FINBPLAN_ARC	Financial planning for buckets archive table	3	PLAN_TYPE	Plan Type	nvarchar	2	0
37	RPM_FINPLAN_ARC	xRPM Financial Planning archive table	3	PLAN_TYPE	Financial View Type	nvarchar	2	0
38	RPM_FIN_B_PLN_CD	Bucket financial periodic values-Pseudo table for change doc	3	PLAN_TYPE	Plan Type	nvarchar	2	0
39	RPM_FIN_PLAN_CD	Fin planning periodic values-Pseudo table for change docu	3	PLAN_TYPE	Financial View Type	nvarchar	2	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 | PLAN_TYPE