	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

118 columns | ERP 6.0 | CREADAT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	TCY40K	Definition of control	3	CREADAT	Creation Date of a Flow Control	nvarchar	8	0
TOPCommand and Support Relationships
2	/ISDFPS/FORCMD	Attributes of Task Organization	13	CREADAT	Date of Application	nvarchar	8	0
3	/ISDFPS/FORCMDID	Supply Relationship IDs	10	CREADAT	Date of Application	nvarchar	8	0
4	/ISDFPS/FORMNT	Attributes of Maintenance Relationships	13	CREADAT	Date of Application	nvarchar	8	0
5	/ISDFPS/FORMNTID	IDs of Maintenance Relationships	10	CREADAT	Date of Application	nvarchar	8	0
6	/ISDFPS/FOROTH	Attributes of Additional Relationships	13	CREADAT	Date of Application	nvarchar	8	0
7	/ISDFPS/FOROTHID	IDs of Other Relationships	10	CREADAT	Date of Application	nvarchar	8	0
8	/ISDFPS/FORSUP	Attributes of Supply Relationships	13	CREADAT	Date of Application	nvarchar	8	0
9	/ISDFPS/FORSUPID	Supply Relationship IDs	10	CREADAT	Date of Application	nvarchar	8	0
10	/ISDFPS/ORCMD	Task Organizations	19	CREADAT	Date of Application	nvarchar	8	0
11	/ISDFPS/ORCMD1	Task Organization, Basic Types of Dependent Attributes	4	CREADAT	Date of Application	nvarchar	8	0
12	/ISDFPS/ORMNT	Maintenance Relationships	19	CREADAT	Date of Application	nvarchar	8	0
13	/ISDFPS/ORMNT1	Maintenance Relationships, Basic Types, Dependent Attributes	4	CREADAT	Date of Application	nvarchar	8	0
14	/ISDFPS/OROTH	Additional Relationships	19	CREADAT	Date of Application	nvarchar	8	0
15	/ISDFPS/ORSUP	Supply Relationships	19	CREADAT	Date of Application	nvarchar	8	0
16	/ISDFPS/ORSUP1	Supply Relationships, Basic Types, Dependent Attributes	4	CREADAT	Date of Application	nvarchar	8	0
17	/ISDFPS/ORTOB	Technical Object Relationships (Maintenance)	19	CREADAT	Date of Application	nvarchar	8	0
TOPConfiguration Control
18	CCMHOLE	Structure Gap Table	8	CREADAT	Creation Date of Object	nvarchar	14	0
TOPEngineering Change Management
19	EDGE	Relation Between Change Numbers	8	CREADAT	Date record created on	nvarchar	8	0
20	ENODE	Nodes ECH	6	CREADAT	Date record created on	nvarchar	8	0
TOPForce Element
21	/ISDFPS/FORBE	Attributes of HR - BE Relationship	10	CREADAT	Date of Application	nvarchar	8	0
22	/ISDFPS/FORBEID	IDs of HR - BE Relationships	9	CREADAT	Date of Application	nvarchar	8	0
23	/ISDFPS/FORCE	Force Element (Database)	32	CREADAT	Date of Application	nvarchar	8	0
24	/ISDFPS/FORCEM	Authorized Materials	22	CREADAT	Date of Application	nvarchar	8	0
25	/ISDFPS/FORCEP	Material Packages	14	CREADAT	Date of Application	nvarchar	8	0
26	/ISDFPS/FORCER	Reference Force Element (Database)	8	CREADAT	Date of Application	nvarchar	8	0
27	/ISDFPS/FORCE_PR	Individual Threshold Values for Readiness	16	CREADAT	Date of Application	nvarchar	8	0
28	/ISDFPS/FORCN	Attributes of REC - HR Relationship	10	CREADAT	Date of Application	nvarchar	8	0
29	/ISDFPS/FORCNID	IDs of HR - REC Relationships	9	CREADAT	Date of Application	nvarchar	8	0
30	/ISDFPS/FORDEL	Planned Delimitation and Deletion Operations	13	CREADAT	Date of Application	nvarchar	8	0
31	/ISDFPS/FOREPA	Attributes of the Force Element - EPA Relationships	10	CREADAT	Date of Application	nvarchar	8	0
32	/ISDFPS/FOREPAID	IDs of the Force Element - EPA Relationships	9	CREADAT	Date of Application	nvarchar	8	0
33	/ISDFPS/FORIPO	FORCER: Authorized Infrastructure: Attributes	10	CREADAT	Date of Application	nvarchar	8	0
34	/ISDFPS/FORIPOID	FORCER: Authorized Infrastructure: IDs	9	CREADAT	Date of Application	nvarchar	8	0
35	/ISDFPS/FORMC	Attributes of the Material Container-Force Element Relatshp	10	CREADAT	Date of Application	nvarchar	8	0
36	/ISDFPS/FORMCH	Attributes of the Material Container - HR Relationship	10	CREADAT	Date of Application	nvarchar	8	0
37	/ISDFPS/FORMCHID	IDs of the HR - MC Relationships	9	CREADAT	Date of Application	nvarchar	8	0
38	/ISDFPS/FORMCID	IDs of Material Container - Force Element Relationships	9	CREADAT	Date of Application	nvarchar	8	0
39	/ISDFPS/FORMPH	Attributes of the HR - MPO Relationship	10	CREADAT	Date of Application	nvarchar	8	0
40	/ISDFPS/FORMPHID	IDs of the HR - MPO Relationships	9	CREADAT	Date of Application	nvarchar	8	0
41	/ISDFPS/FORMPO	Attributes of the Force Element - MPO Relationship	10	CREADAT	Date of Application	nvarchar	8	0
42	/ISDFPS/FORMPOID	IDs of the Force Element - MPO Relationships	9	CREADAT	Date of Application	nvarchar	8	0
43	/ISDFPS/FORRIC	Attributes of the Force Element - RIC Relationship	10	CREADAT	Date of Application	nvarchar	8	0
44	/ISDFPS/FORRICID	IDs of the Force Element - RIC Relationships	9	CREADAT	Date of Application	nvarchar	8	0
45	/ISDFPS/FORRR	FORCER: RE Search Request: Attributes	10	CREADAT	Date of Application	nvarchar	8	0
46	/ISDFPS/FORRRID	FORCER: RE Search Request: IDs	9	CREADAT	Date of Application	nvarchar	8	0
47	/ISDFPS/FORTOB	Attributes of Relationship to Technical Objects	13	CREADAT	Date of Application	nvarchar	8	0
48	/ISDFPS/FORTOBID	IDs of Relationship to Technical Objects	10	CREADAT	Date of Application	nvarchar	8	0
49	/ISDFPS/FORVPA	Attributes of the Force Element - PPA Relationships	10	CREADAT	Date of Application	nvarchar	8	0
50	/ISDFPS/FORVPAID	IDs of the Force Element - PPA Relationships	9	CREADAT	Date of Application	nvarchar	8	0
TOPIntegrated Product and Process Engineering
51	CPATYPE	Customizing Table for iPPE Alternative Types	10	CREADAT	Date of Application	nvarchar	8	0
52	CPNTYPE	Customizing Table for iPPE Node Type	21	CREADAT	Date of Application	nvarchar	8	0
53	CPPECNTL	General iPPE Customizing	23	CREADAT	Date of Application	nvarchar	8	0
54	CPRTYPE	Customizing: iPPE Relationships	23	CREADAT	Date of Application	nvarchar	8	0
55	CPVSMDL	Model Associations between the PVS Objects	8	CREADAT	Date of Application	nvarchar	8	0
56	CPVSMDLC	Model Associations between the Customer-Spec. PVS Objects	8	CREADAT	Date of Application	nvarchar	8	0
57	CPVTYPE	Customizing Table for the iPPE Variant Types	16	CREADAT	Date of Application	nvarchar	8	0
58	INSTANCEID	Geometric Instance: Identification	10	CREADAT	Date of Application	nvarchar	8	0
59	LINEBAL	Line Balance Versions in iPPE	7	CREADAT	Date of Application	nvarchar	8	0
60	MODMIXH	Model Mix Header Data	5	CREADAT	Date of Application	nvarchar	8	0
61	OMC_BASIC	Basic Settings: Enhanced Dependency Editor	3	CREADAT	Date of Application	nvarchar	8	0
62	OMC_MCDEP	Define Scheme for Enhanced Dependency Editor	55	CREADAT	Date of Application	nvarchar	8	0
63	OMC_MDEP	Enhanced Dependency Editor: Assign Scheme	28	CREADAT	Date of Application	nvarchar	8	0
64	PALTID	iPPE Alternative: Time-Independent ID and Attributes	10	CREADAT	Date of Application	nvarchar	8	0
65	PCOLMR	Color Key Master Record	3	CREADAT	Date of Application	nvarchar	8	0
66	PFOBJID	Assignment of Leading Focus Obj: Node to Focus Master Record	9	CREADAT	Date of Application	nvarchar	8	0
67	PFOBJR	Assignment of Focus Object: Relationship to Focus Master Rec	9	CREADAT	Date of Application	nvarchar	8	0
68	PFOBJV	Assignment of Focus Object: Variant to Focus Master Record	8	CREADAT	Date of Application	nvarchar	8	0
69	PFOCID	iPPE Focus Master Record	7	CREADAT	Date of Application	nvarchar	8	0
70	PNDALT	Alternativensegment zum Positionsknoten	6	CREADAT	Datum des Antrags	nvarchar	8	0
71	PNDREL	Positionsknotenbeziehung in der PVS	7	CREADAT	Datum des Antrags	nvarchar	8	0
72	PNODE	Positionsknoten in der PVS	8	CREADAT	Datum des Antrags	nvarchar	8	0
73	PNODID	iPPE Node: Identification	11	CREADAT	Date of Application	nvarchar	8	0
74	POSVID	iPPE Variant: Identification	10	CREADAT	Date of Application	nvarchar	8	0
75	PPEHDR	iPPE Access Object	18	CREADAT	Date of Application	nvarchar	8	0
76	PPESPRECOND	iPPE Status Precondition, Central Data	6	CREADAT	Date of Application	nvarchar	8	0
77	PPESSTATUS	iPPE Status, Central Data	9	CREADAT	Date of Application	nvarchar	8	0
78	PRELACT	Relationships for the SNP and Workshop Plan	15	CREADAT	Date of Application	nvarchar	8	0
79	PRELID	iPPE Relationship: Time-Independent ID and Attributes	12	CREADAT	Date of Application	nvarchar	8	0
80	PRGEN	GEN Relationships - Relationships Table	15	CREADAT	Date of Application	nvarchar	8	0
81	PROJID	iPPE Assignment Table: PS Objects	12	CREADAT	Date of Application	nvarchar	8	0
82	PRPVR	Relationship Between Variants: Identification and Attributes	13	CREADAT	Date of Application	nvarchar	8	0
83	PRSET	Set Relationships: Table of Links	14	CREADAT	Date of Application	nvarchar	8	0
84	PRTST	Test Relationships - Relationships Table	16	CREADAT	Date of Application	nvarchar	8	0
85	PVS_VSHEME	Variance Scheme for Structure Node	10	CREADAT	Date of Application	nvarchar	8	0
86	PXARCID	Table for Archiving Indicators for iPPE Objects	13	CREADAT	Date of Application	nvarchar	8	0
87	RPPNT	iPPE Reporting Points	5	CREADAT	Date of Application	nvarchar	8	0
88	USRTICLASS	Class Assignment for Tabular Maintenance of iPPE	7	CREADAT	Date of Application	nvarchar	8	0
TOPLine Maintenance
89	/ISDFPS/LM_MIS	Mission	6	CREADAT	Date of Application	nvarchar	8	0
TOPLOGFAS
90	/ISDFPS/GEOLOC	Geolocation Database Table	26	CREADAT	Date of Application	nvarchar	8	0
91	/ISDFPS/RIC	Reportable Item Code	14	CREADAT	Date of Application	nvarchar	8	0
TOPLogistical Requirements
92	/ISDFPS/PRMPAID	iPPE Relationship: Time-Independent ID and Attributes	12	CREADAT	Date of Application	nvarchar	8	0
TOPMaster Data Distribution
93	/ISDFPS/CCMHOLER	Replication Table CCMHOLE	8	CREADAT	Creation Date of Object	nvarchar	14	0
TOPMaterial
94	RSADD	Additional fields for reservation	26	CREADAT	Date on Which Record Was Created	nvarchar	8	0
TOPMaterial Categories
95	/ISDFPS/PRMPO	Attributes of BOM Relationships	11	CREADAT	Date of Application	nvarchar	8	0
96	/ISDFPS/PRMPOC	Attributes of Relationships Between Matl Container and MPO	12	CREADAT	Date of Application	nvarchar	8	0
97	/ISDFPS/PRMPOCID	iPPE Relationship: Time-Independent ID and Attributes	12	CREADAT	Date of Application	nvarchar	8	0
98	/ISDFPS/PRMPOID	iPPE Relationship: Time-Independent ID and Attributes	12	CREADAT	Date of Application	nvarchar	8	0
TOPProduct and Process Modeling
99	RLMFWOH	Release Order - Header Data	8	CREADAT	Created on	nvarchar	8	0
TOPResourcen Management
100	PREQR	RMS-RCP: iPPE Relationship: Equipment Requirement	14	CREADAT	Date of Application	nvarchar	8	0
101	PRPOBA	RMS-RCP: iPPE Relationship: Operation-Action	14	CREADAT	Date of Application	nvarchar	8	0
102	PRPOBI	RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items	14	CREADAT	Date of Application	nvarchar	8	0
103	PRPOBO	RMS-RCP: iPPE Relationship: Stage-Operation	14	CREADAT	Date of Application	nvarchar	8	0
104	PRPOBR	RMS-RCP: iPPE Relationship: Relationships Between Operations	14	CREADAT	Date of Application	nvarchar	8	0
105	PRPOBS	RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage	14	CREADAT	Date of Application	nvarchar	8	0
106	RMSAT_STD_LAY_H	RMS-ATL: Header Table Layout Standardization	3	CREADAT	Created On	nvarchar	8	0
107	RMSAT_STD_PARA_H	RMS-ATL: Header Table Parameter Standardization	10	CREADAT	Created On	nvarchar	8	0
108	RMSLA_HD	Header Data of Label Set	3	CREADAT	Created On	nvarchar	8	0
TOPRouting EBOM Assignment
109	/PLMI/RTGRCALNKH	Routing Component Assignment Link	16	CREADAT	Date on Which the Object Was Created	nvarchar	8	0
110	/PLMI/RTGRCASCOH	RCA Planning Scope Version	7	CREADAT	Date on Which the Object Was Created	nvarchar	8	0
TOPSAP Records Management
111	SRMDPDISP	Circular	7	CREADAT	Date Circular Created	nvarchar	8	0
TOPSimulation
112	VSRSADD_CN	Version: Additional fields for reservation	27	CREADAT	Date on Which Record Was Created	nvarchar	8	0
TOPWarranty Claim Processing
113	PNWTYH	Warranty Claim Header (PVS Node)	44	CREADAT	Date of Application	nvarchar	8	0
114	PNWTYV	Warranty Claim Version (PVS Node)	40	CREADAT	Date of Application	nvarchar	8	0
115	PRWTY	iPPE Relationship: Time-Ind. Ident./Attributes Warranty	12	CREADAT	Date of Application	nvarchar	8	0
116	PVWTY	Warranty Claim Item (PPE Variant)	49	CREADAT	Date of Application	nvarchar	8	0
117	WTY_PARTNER_TAB	Partner for Warranty Claim	10	CREADAT	Date of Application	nvarchar	8	0
118	WTY_RCLHST	Recall Actions	8	CREADAT	Date of Claim	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

118 columns | ERP 6.0 | CREADAT