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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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

24 columns | Print definition?ERP 6.0  | GUID1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DMC_PTT_03Performance Test Tool Table3GUID1GUID in 'RAW' formatvarbinary160
2J_3RF_BK_GUIDGUIDs for XML. Sales and Purchase Books8GUID1First GUIDnvarchar360
TOPIntegrated Product and Process Engineering
3PRELACTRelationships for the SNP and Workshop Plan8GUID1Internal Identification for PVS Objectsvarbinary160
4PRELDEXExternal Indicator Deleted iPPE Relationships4GUID1Internal Identification for PVS Objectsvarbinary160
5PRELIDiPPE Relationship: Time-Independent ID and Attributes4GUID1Internal Identification for PVS Objectsvarbinary160
6PRGENGEN Relationships - Relationships Table8GUID1Internal Identification for PVS Objectsvarbinary160
7PRPVRRelationship Between Variants: Identification and Attributes6GUID1Internal Identification for PVS Objectsvarbinary160
8PRSETSet Relationships: Table of Links7GUID1Internal Identification for PVS Objectsvarbinary160
9PRTSTTest Relationships - Relationships Table9GUID1Internal Identification for PVS Objectsvarbinary160
TOPLogistical Requirements
10/ISDFPS/PRMPAIDiPPE Relationship: Time-Independent ID and Attributes4GUID1Internal Identification for PVS Objectsvarbinary160
TOPManagement of Internal Controls
11FOPCCASERELAMIC: Relationship Between Cases2GUID1Technical Case Key (Case GUID)nvarchar320
TOPMaterial Categories
12/ISDFPS/MPO_PROTLog of Data Transfers into MPO27GUID1Internal Identification for PVS Objectsvarbinary160
13/ISDFPS/PRMPOCIDiPPE Relationship: Time-Independent ID and Attributes4GUID1Internal Identification for PVS Objectsvarbinary160
14/ISDFPS/PRMPOIDiPPE Relationship: Time-Independent ID and Attributes4GUID1Internal Identification for PVS Objectsvarbinary160
TOPPortfolio Management
15/RPM/RELATION_DPortofolio relation object persisted data4GUID1Guid for application objectsvarbinary160
16RPM_RELATION_CDPortofolio Relations - Pseudo table for change documents4GUID1Guid for application objectsvarbinary160
TOPProcess Controls
17GRPCCASERELAPC: Relationship Between Cases2GUID1Technical Case Key (Case GUID)nvarchar320
TOPResourcen Management
18PREQRRMS-RCP: iPPE Relationship: Equipment Requirement7GUID1Internal Identification for PVS Objectsvarbinary160
19PRPOBARMS-RCP: iPPE Relationship: Operation-Action7GUID1Internal Identification for PVS Objectsvarbinary160
20PRPOBIRMS-RCP: iPPE Relationship: Assignment Relationshps f. Items7GUID1Internal Identification for PVS Objectsvarbinary160
21PRPOBORMS-RCP: iPPE Relationship: Stage-Operation7GUID1Internal Identification for PVS Objectsvarbinary160
22PRPOBRRMS-RCP: iPPE Relationship: Relationships Between Operations7GUID1Internal Identification for PVS Objectsvarbinary160
23PRPOBSRMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage7GUID1Internal Identification for PVS Objectsvarbinary160
TOPWarranty Claim Processing
24PRWTYiPPE Relationship: Time-Ind. Ident./Attributes Warranty4GUID1Internal Number of iPPE Nodevarbinary160