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

21 columns | Print definition?ERP 6.0  | CONTROL_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSONAS/SCRIPTDB table containing all scripts created with script editor.5CONTROL_IDFlavor Control IDntext10737418230
2/PERSONAS/SCRP_VDB table containing all script versions6CONTROL_IDFlavor Control IDntext10737418230
3GRRMRESPResponse attributes28CONTROL_IDObject IDnvarchar500
4N1MCI_MSGMessage Log15CONTROL_IDMessage Control IDnvarchar500
TOPGRC Risk Management
5GRRMRESPONSETable for Response27CONTROL_IDObject IDnvarchar500
TOPProcess Controls
6GRPCAODDATAaod data5CONTROL_IDObject IDnvarchar80
7GRPCAODGRPCTRLrelation table for aod group and it's controls7CONTROL_IDObject IDnvarchar80
8GRPCCRASSControl Risk Assessment4CONTROL_IDObject IDnvarchar80
9GRPCCRASSFACTORFactor for the control risk assessment4CONTROL_IDObject IDnvarchar80
10GRPCCTRLPROPOSALGRPC:Control Proposal6CONTROL_IDGRPC ID of the individual objectnvarchar500
11GRPCEVENT1AGGREvent Monitoring Aggregation2CONTROL_IDPC Reporting: Control IDnvarchar90
12GRPCEVENTAGGROBSOLETE Event Monitoring Aggregation3CONTROL_IDPC Reporting: Control IDnvarchar90
13GRPCEVENTENABLEEvent Monitoring: Monitoring Enabling2CONTROL_IDPC Reporting: Control IDnvarchar90
14GRPCEVENTENABLELEvent Monitoring: Monitoring Enabling change log2CONTROL_IDPC Reporting: Control IDnvarchar90
15GRPCEVENTMAPEvent Monitoring : Event to Control Rule mapping3CONTROL_IDPC Reporting: Control IDnvarchar90
16GRPCEVENTRLEVEvent Monitoring: Rule evaluation results8CONTROL_IDGRPC ID of the individual objectnvarchar500
17GRPCJOBCASECase Data for Job3CONTROL_IDGRPC ID of the individual objectnvarchar500
18GRPCJOBLOGJob Log from Scheduler5CONTROL_IDGRPC ID of the individual objectnvarchar500
19GRPCVIOLATIONEvent Monitoring: Violations2CONTROL_IDPC Reporting: Control IDnvarchar90
20GRPC_MCF_REF_TSTReferenced test results for controls2CONTROL_IDGRPC ID of the individual objectnvarchar500
21GRPC_S_EVENTEvent3CONTROL_IDGRPC ID of the individual objectnvarchar500