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

Home | ERP 6.0 
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

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

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy