	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

123 columns | ERP 6.0 | ANDAT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/IBS/TRB_ECF_BVC	RBD ECF - Book Value Components	8	ANDAT	RBD: Date of First Entry	nvarchar	8	0
2	/IBS/TRB_ECF_HD	RBD ECF - Value Adjustment Header Data	45	ANDAT	RBD: Date of First Entry	nvarchar	8	0
3	/IBS/TRB_ECF_PCF	RBD ECF - Provision Cash Flow	22	ANDAT	RBD: Date of First Entry	nvarchar	8	0
4	/IBS/TRB_ECF_PCO	RBD ECF - Provision Collateral	27	ANDAT	RBD: Date of First Entry	nvarchar	8	0
5	/IBS/TRB_ECF_PUT	RBD ECF - Provision Utilization	20	ANDAT	RBD: Date of First Entry	nvarchar	8	0
6	/IBS/TRB_ECF_VCF	RBD ECF - Value Adjustment - Cash Flow	20	ANDAT	RBD: Date of First Entry	nvarchar	8	0
7	/IBS/TRB_ECF_VCO	RBD ECF - Value Adjustment - Collateral	25	ANDAT	RBD: Date of First Entry	nvarchar	8	0
8	/IBS/TRB_ECH_BAL	RBD ECF - Positions History	54	ANDAT	RBD: Date of First Entry	nvarchar	8	0
9	/IBS/TRB_ECH_BVC	RBD ECF - Book Value Components History	9	ANDAT	RBD: Date of First Entry	nvarchar	8	0
10	/IBS/TRB_ECH_HD	RBD ECF - Value Adjustment History - Header Data	46	ANDAT	RBD: Date of First Entry	nvarchar	8	0
11	/IBS/TRB_ECH_PCF	RBD ECF - Provision History - Cash Flow	23	ANDAT	RBD: Date of First Entry	nvarchar	8	0
12	/IBS/TRB_ECH_PCO	RBD ECF - Provision History - Collateral	28	ANDAT	RBD: Date of First Entry	nvarchar	8	0
13	/IBS/TRB_ECH_PUT	RBD ECF - Provision History - Utilization	21	ANDAT	RBD: Date of First Entry	nvarchar	8	0
14	/IBS/TRB_ECH_VCF	RBD ECF - Value Adjustment History - Cash Flow	21	ANDAT	RBD: Date of First Entry	nvarchar	8	0
15	/IBS/TRB_ECH_VCO	RBD ECF - Value Adjustment History - Collateral	26	ANDAT	RBD: Date of First Entry	nvarchar	8	0
16	/IBS/TRB_ECM_HD	RBD ECF: Manual Contract Management - Header Data	27	ANDAT	RBD: Date of First Entry	nvarchar	8	0
TOPABAP List-Based PI Sheet
17	COCHP	PI sheet: Control Recipe Header	10	ANDAT	Creation date of the PI sheet	nvarchar	8	0
TOPBasic Data
18	MKAL_AEND	Change History of Production Version (Recipes Only)	9	ANDAT	Date record created on	nvarchar	8	0
TOPBills of Material
19	CLST	Link class - BOM	6	ANDAT	Date record created on	nvarchar	8	0
20	CSORDER_MAT	Administration of generated materials per sales order	13	ANDAT	Date record created on	nvarchar	8	0
21	CSPRJ_MAT	Management of generated materials to project	12	ANDAT	Date record created on	nvarchar	8	0
22	DOST	Document to BOM Link	9	ANDAT	Date record created on	nvarchar	8	0
23	EQST	Equipment to BOM Link	7	ANDAT	Date record created on	nvarchar	8	0
24	KDST	Sales Order to BOM Link	9	ANDAT	Date record created on	nvarchar	8	0
25	MAST	Material to BOM Link	9	ANDAT	Date record created on	nvarchar	8	0
26	PRST	Project - BOM link	8	ANDAT	Date record created on	nvarchar	8	0
27	PSGR	Master item group	4	ANDAT	Date record created on	nvarchar	8	0
28	PSVR	Master alternative items	5	ANDAT	Date record created on	nvarchar	8	0
29	STAS	BOMs - Item Selection	11	ANDAT	Date record created on	nvarchar	8	0
30	STKO	BOM Header	12	ANDAT	Date record created on	nvarchar	8	0
31	STPO	BOM item	12	ANDAT	Date record created on	nvarchar	8	0
32	STST	Standard BOM Link	7	ANDAT	Date record created on	nvarchar	8	0
33	TPST	Link Between Functional Location and BOM	7	ANDAT	Date record created on	nvarchar	8	0
TOPComputer Aided Process Planning
34	PLPH	CAPP: Sub-operations	10	ANDAT	Date record created on	nvarchar	8	0
35	VERFK	Process header data	5	ANDAT	Date record created on	nvarchar	8	0
36	VFORK	Formula header data	5	ANDAT	Date record created on	nvarchar	8	0
37	VMETK	Method header data	11	ANDAT	Date record created on	nvarchar	8	0
TOPCross-Application Components
38	MMAPL	Allocation of task lists to materials	14	ANDAT	Date record created on	nvarchar	8	0
39	PLLPO	Task list - operation/activity	11	ANDAT	Date record created on	nvarchar	8	0
TOPDB2 for AS4
40	DB4INDEX_HIST	History of Index Sizes in the Database	4	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
41	DB4INDEX_STAT	Index Sizes in the Database	5	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
42	DB4TABLE_HIST	History of Table Sizes in the Database	4	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
43	DB4TABLE_STAT	Table Sizes in the Database	5	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
44	DBSTAIHDB4	History of Index Sizes in the Database	2	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
45	DBSTATHDB4	History of Table Sizes in the Database	2	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
46	DBSTATIDB4	Index Sizes in the Database	2	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
47	DBSTATTDB4	Table Sizes in the Database	2	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
TOPDB2 Universal Database for UNIX NT
48	DBSTATHDB6	DB6: Statistical History of Application Monitor	3	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
49	DBSTATIDB6	DB6: Statistics for Indexes (Application Monitor)	5	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
50	DBSTATTDB6	DB6: Table Statistics for Application Monitor	3	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
TOPEarly Warning System
51	MCYA	Early Warning: Exceptions	5	ANDAT	Created on	nvarchar	8	0
TOPEngineering Change Management
52	AEDT	Engineering Change Management: Alternative Dates	5	ANDAT	Date record created on	nvarchar	8	0
53	AEEF	ECM: effectivity	17	ANDAT	Date record created on	nvarchar	8	0
54	AEHI	Change hierarchy	4	ANDAT	Date record created on	nvarchar	8	0
55	AENR	Change Master	7	ANDAT	Date record created on	nvarchar	8	0
56	AENV	ECH: Object Types for Change Master	11	ANDAT	Date record created on	nvarchar	8	0
57	AEOI	ECH: Object Management Records for Change Master	11	ANDAT	Date record created on	nvarchar	8	0
58	AEPF	ECM: effectivity	16	ANDAT	Date record created on	nvarchar	8	0
59	AEPREC	Identical object in explosion (header)	8	ANDAT	Date record created on	nvarchar	8	0
60	ECM_ADM	Administrative Data	5	ANDAT	Created On	decimal	15	0
61	TECS	Master Effectivity Object	3	ANDAT	Date record created on	nvarchar	8	0
TOPFlow Manufacturing
62	LDLBH	Line balance/planned rate header record	14	ANDAT	Date record created on	nvarchar	8	0
63	LDLH	Line hierarchy header	4	ANDAT	Date record created on	nvarchar	8	0
TOPLine Maintenance
64	/ISDFPS/LM_ACC_H	LM - Accident Header	11	ANDAT	Date record created on	nvarchar	8	0
TOPMaintenance
65	/ISDFPS/PM_MB_H	PM Maintenance Book - Header	10	ANDAT	Date record created on	nvarchar	8	0
TOPMaintenance Task Lists
66	EAPL	Allocation of task lists to pieces of equipment	16	ANDAT	Date record created on	nvarchar	8	0
67	PLWP	Allocation of maintenance packages to task list operations	17	ANDAT	Date record created on	nvarchar	8	0
68	TAPL	Allocation of task lists to functional locations	14	ANDAT	Date record created on	nvarchar	8	0
TOPMaster Data Distribution
69	/ISDFPS/TL1	Task List - Operation/Activity	11	ANDAT	Date record created on	nvarchar	8	0
TOPMaster Recipe
70	PLFT	Process Instructions	11	ANDAT	Date record created on	nvarchar	8	0
71	PLFV	PI Characteristics/Sub-Operation Parameter Values	12	ANDAT	Date record created on	nvarchar	8	0
TOPNetwork and Activity
72	PLAB	Relationships	26	ANDAT	Date record created on	nvarchar	8	0
TOPPerformance Monitors TCC
73	AMDS	Effective size of tables and indexes in the database	2	ANDAT	Analysis date for application monitor	nvarchar	8	0
74	AMSK	SQL trace header info in application monitor	6	ANDAT	Analysis date for application monitor	nvarchar	8	0
75	AMSP	SQL trace position info in application monitor	6	ANDAT	Analysis date for application monitor	nvarchar	8	0
76	DBSTAIHADA	Actual size of indices on the database (history)	3	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
77	DBSTAIHORA	Actual size of indices on the database (history)	3	ANDAT	Update Time Stamp	nvarchar	14	0
78	DBSTATHADA	Actual size of tables on the database (history)	2	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
79	DBSTATHORA	Actual size of tables on the database (history)	2	ANDAT	Update Time Stamp	nvarchar	14	0
80	DBSTATIADA	Actual size of indices on the database	3	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
81	DBSTATIORA	Actual size of indices on the database	3	ANDAT	Update Time Stamp	nvarchar	14	0
82	DBSTATTADA	Actual size of tables on the database	2	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	0
83	DBSTATTORA	Actual size of tables on the database	2	ANDAT	Update Time Stamp	nvarchar	14	0
TOPProcess Management
84	COCH	Process Management: Control Recipe Header	10	ANDAT	Date on Which Record Was Created	nvarchar	8	0
TOPProduct Data Management
85	KLFB	Assignment: Class to template	9	ANDAT	Date record created on	nvarchar	8	0
TOPProduction Planning for Process Industries
86	DTEFW	Downtime Values Entered	12	ANDAT	Creation Date of Downtime	nvarchar	8	0
TOPProduction ResourcesTools
87	CRFH	CIM production resource/tool master data	13	ANDAT	Date record created on	nvarchar	8	0
TOPPublic Sector
88	T5QPBS2A	Parameter setting for Prior Service and Leave Management	12	ANDAT	Anniversary date	nvarchar	2	0
TOPRemaining Beverage - Obsolete Objects
89	/BEV1/CLSCH	Ship Information	8	ANDAT	Arrival Date	nvarchar	8	0
TOPReporting
90	MCRSV	Selection versions: Header data	5	ANDAT	Date on Which Record Was Created	nvarchar	8	0
91	MCSHIERK	Header of general hierarchy	13	ANDAT	Date on Which Record Was Created	nvarchar	8	0
TOPResourcen Management
92	MRTRST_HDR	RMS-MRTRS : MR Transformation Header	29	ANDAT	Date record created on	nvarchar	8	0
93	MRTRST_POP_REL	RMS-MRTRS : General Recipe Operation to Master Recipe Phase	13	ANDAT	Date record created on	nvarchar	8	0
94	MRTRST_PRI_REL	RMS-MRTRS : Equipment Requirement to Primary Resource	11	ANDAT	Date record created on	nvarchar	8	0
95	MRTRST_PST_REL	RMS-MRTRS: General Recipe Stage to Master Recipe Operation	13	ANDAT	Date record created on	nvarchar	8	0
96	MRTRST_QM_REL	RMS-MRTRS : QM of GR Element to QM of MR Element	22	ANDAT	Date record created on	nvarchar	8	0
97	MRTRST_SEC_REL	RMS-MRTRS: Equipment Requirement to Secondary Resource	14	ANDAT	Date record created on	nvarchar	8	0
98	MRTRST_STR_MAT	RMS-MRTRS: Assignment of Stream to Material	13	ANDAT	Date record created on	nvarchar	8	0
99	MRTRST_STR_REL	RMS-MRTRS: Stream with QM to Master Recipe Phase	10	ANDAT	Date record created on	nvarchar	8	0
TOPRouting
100	MAPL	Assignment of Task Lists to Materials	14	ANDAT	Date record created on	nvarchar	8	0
101	PLAS	Task list - selection of operations/activities	13	ANDAT	Date record created on	nvarchar	8	0
102	PLFL	Task list - sequences	12	ANDAT	Date record created on	nvarchar	8	0
103	PLKO	Task list - header	11	ANDAT	Date record created on	nvarchar	8	0
104	PLMZ	Allocation of bill of material items to operations	26	ANDAT	Date record created on	nvarchar	8	0
105	PLPO	Task list - operation/activity	11	ANDAT	Date record created on	nvarchar	8	0
TOPSwitzerland
106	PA0980	HR Master Record Infotype 0980	26	ANDAT	System Date	nvarchar	8	0
TOPValue Adjustment
107	/IBS/TRB_SCHIST	RBD IAS - History Value Adjustment Collateral	24	ANDAT	RBD: Date of First Entry	nvarchar	8	0
108	/IBS/TRB_SCHISTR	RBD IAS - History Provision Collaterals	26	ANDAT	RBD: Date of First Entry	nvarchar	8	0
109	/IBS/TRB_SHCOL	RBD IAS - Value Adjustment Collateral	23	ANDAT	RBD: Date of First Entry	nvarchar	8	0
110	/IBS/TRB_SHCOL_R	RBD IAS - Provision Collaterals	25	ANDAT	RBD: Date of First Entry	nvarchar	8	0
111	/IBS/TRB_SHEET	RBD IAS - Value Adjustment Cash Flow Positions	16	ANDAT	RBD: Date of First Entry	nvarchar	8	0
112	/IBS/TRB_SHEETH	RBD IAS - Header Data of Valuation Sheet	68	ANDAT	RBD: Date of First Entry	nvarchar	8	0
113	/IBS/TRB_SHEET_I	RBD IAS - Provision Utilization	14	ANDAT	RBD: Date of First Entry	nvarchar	8	0
114	/IBS/TRB_SHEET_R	RBD IAS - Provision Cash Flow Positions	16	ANDAT	RBD: Date of First Entry	nvarchar	8	0
115	/IBS/TRB_SHIST	RBD IAS - History Value Adjustment Cash Flow Positions	17	ANDAT	RBD: Date of First Entry	nvarchar	8	0
116	/IBS/TRB_SHISTH	RBD IAS - History Header Data Valuation Sheet	69	ANDAT	RBD: Date of First Entry	nvarchar	8	0
117	/IBS/TRB_SHIST_I	RBD IAS - History Provision Utilization	15	ANDAT	RBD: Date of First Entry	nvarchar	8	0
118	/IBS/TRB_SHIST_R	RBD IAS - History Provision Cash Flow Positions	17	ANDAT	RBD: Date of First Entry	nvarchar	8	0
119	/IBS/TRB_UE	RBD RBD Individual Documents	51	ANDAT	RBD: Date of First Entry	nvarchar	8	0
120	/IBS/TRB_UE_HIST	RBD RBD History of Individual Documents	52	ANDAT	RBD: Date of First Entry	nvarchar	8	0
121	/IBS/TRB_UI	RBD: RBD Record Data Table (Actual)	40	ANDAT	RBD: Date of First Entry	nvarchar	8	0
122	/IBS/TRB_UP	RBD RBD Record Data Table (PLANNED)	34	ANDAT	RBD: Date of First Entry	nvarchar	8	0
123	/IBS/TRB_VS_SALD	RBD Individual Document Table	18	ANDAT	RBD: Date of First Entry	nvarchar	8	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

123 columns | ERP 6.0 | ANDAT