SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

36 columns | Print definition?ERP 6.0  | PRGUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIntegrated Product and Process Engineering
1PRBALiPPE Relationships: Line Balance2PRGUIDInternal Number for PVS Relationshipvarbinary160
2PRELACTRelationships for the SNP and Workshop Plan2PRGUIDInternal Number for PVS Relationshipvarbinary160
3PRELDEXExternal Indicator Deleted iPPE Relationships2PRGUIDInternal Number for PVS Relationshipvarbinary160
4PRELIDiPPE Relationship: Time-Independent ID and Attributes2PRGUIDInternal Number for PVS Relationshipvarbinary160
5PRELIDHiPPE Relationship: Additional Table for Effectivity (ECH)2PRGUIDInternal Number for PVS Relationshipvarbinary160
6PRFLOApplication Data for FLO Relationships2PRGUIDInternal Number for PVS Relationshipvarbinary160
7PRGENGEN Relationships - Relationships Table2PRGUIDInternal Number for PVS Relationshipvarbinary160
8PRIOCPVS: Relationship I/O CMP-ACT2PRGUIDInternal Identification for PVS Objectsvarbinary160
9PRPVRRelationship Between Variants: Identification and Attributes2PRGUIDInternal Number for PVS Relationshipvarbinary160
10PRRESiPPE Relationships - Resource Capacity2PRGUIDInternal Number for PVS Relationshipvarbinary160
11PRSEQPVS: Relationship Precedence Graph with Attributes2PRGUIDInternal Identification for PVS Objectsvarbinary160
12PRSEQ2PVS: Relationship Precedence Graph with Attributes2PRGUIDInternal Identification for PVS Objectsvarbinary160
13PRSETSet Relationships: Table of Links2PRGUIDInternal Number for PVS Relationshipvarbinary160
14PRTSTTest Relationships - Relationships Table2PRGUIDInternal Number for PVS Relationshipvarbinary160
TOPLogistical Requirements
15/ISDFPS/PRMPAIDiPPE Relationship: Time-Independent ID and Attributes2PRGUIDInternal Number for PVS Relationshipvarbinary160
TOPMaterial Categories
16/ISDFPS/MPO_PROTLog of Data Transfers into MPO46PRGUIDInternal Identification for PVS Objectsvarbinary160
17/ISDFPS/PRMPOAttributes of BOM Relationships2PRGUIDInternal Identification for PVS Objectsvarbinary160
18/ISDFPS/PRMPOCAttributes of Relationships Between Matl Container and MPO2PRGUIDInternal Identification for PVS Objectsvarbinary160
19/ISDFPS/PRMPOCIDiPPE Relationship: Time-Independent ID and Attributes2PRGUIDInternal Number for PVS Relationshipvarbinary160
20/ISDFPS/PRMPOIDiPPE Relationship: Time-Independent ID and Attributes2PRGUIDInternal Number for PVS Relationshipvarbinary160
TOPMove-InOut
21ECAMIOPRCIIS-U: Parked Document: Contracts and Installations4PRGUIDGUID for Parked Document Error Handlingvarbinary160
22ECAMIOPRHEADIS-U: Parked Document: Header Data3PRGUIDGUID for Parked Document Error Handlingvarbinary160
TOPProcess Monitoring Infrastructure
23SSPICSE1Event Table for PMI Metrics Based on One Step4PRGUIDSPI: Process GUIDvarbinary160
24SSPICSE2Event Table for PMI Metrics Based on Two Steps4PRGUIDSPI: Process GUIDvarbinary160
25SSPICSPRHDSPI: Assembled Process Instances2PRGUIDSPI: Process GUIDvarbinary160
26SSPICSPRSTSPI: Steps of Assembled Process Instances2PRGUIDSPI: Process GUIDvarbinary160
27SSPICSSTPMI: Statistical Data for Assembled Process Instances2PRGUIDSPI: Process GUIDvarbinary160
28SSPICSTRPRSPI: Tracking Record / Instance of Lower-Level Process4PRGUIDSPI: Process GUIDvarbinary160
TOPResourcen Management
29PREQRRMS-RCP: iPPE Relationship: Equipment Requirement2PRGUIDInternal Number for PVS Relationshipvarbinary160
30PRPOBARMS-RCP: iPPE Relationship: Operation-Action2PRGUIDInternal Number for PVS Relationshipvarbinary160
31PRPOBIRMS-RCP: iPPE Relationship: Assignment Relationshps f. Items2PRGUIDInternal Number for PVS Relationshipvarbinary160
32PRPOBORMS-RCP: iPPE Relationship: Stage-Operation2PRGUIDInternal Number for PVS Relationshipvarbinary160
33PRPOBRRMS-RCP: iPPE Relationship: Relationships Between Operations2PRGUIDInternal Number for PVS Relationshipvarbinary160
34PRPOBSRMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage2PRGUIDInternal Number for PVS Relationshipvarbinary160
TOPRuntime WorkbenchMonitoring
35SXMSMSGPMIUsing XI Messages in PMI2PRGUIDSPI: Process GUIDvarbinary160
TOPWarranty Claim Processing
36PRWTYiPPE Relationship: Time-Ind. Ident./Attributes Warranty2PRGUIDInternal Number of iPPE Nodevarbinary160