	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 | CHNGBY

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