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

79 columns | Print definition?ERP 6.0  | TIMEFRAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRFNCASEISCase table of Issue12TIMEFRAMETimeframenvarchar100
2GRFNEXTRACTLOGExtraction log3TIMEFRAMECompounded timeframe IDnvarchar320
3GRFNJOBJob6TIMEFRAMETimeframenvarchar100
4GRFNJOBCASECase Data for Job5TIMEFRAMETimeframenvarchar100
5GRPCDBBUFDashboard buffer4TIMEFRAMETimeframenvarchar100
6GRPCSIGNOFFPLANSign-Off Guid4TIMEFRAMETimeframenvarchar100
7GRRMRESPResponse attributes15TIMEFRAMETimeframenvarchar100
8GRRMRISKCONSPLANInfomation for one plan of risk consolidation.8TIMEFRAMETimeframenvarchar100
TOPGovernance, Risk and Compliance
9GRFNDMLOGDatamart: Central Log4TIMEFRAMETimeframenvarchar100
10GRFNMDCRMaster Data Change Request6TIMEFRAMETimeframenvarchar100
11GRFNTASKPLANData for task plan6TIMEFRAMETimeframenvarchar100
12GRFNTIMEFRAMETimeframes2TIMEFRAMETimeframenvarchar100
13GRFNTIMEFRAMETTimeframes3TIMEFRAMETimeframenvarchar100
14GRPCACCVERSIONVersion of Central Account Group5TIMEFRAMETimeframenvarchar100
TOPGRC Risk Management
15/ORM/ORMT_PRY_CTRisk priority matrix2TIMEFRAMESpeed of Onsetnvarchar40
16/ORM/ORMT_TIMEFRSpeed of Onset2TIMEFRAMESpeed of Onsetnvarchar40
17/ORM/ORMT_TMFR_TSpeed of Onset Texts3TIMEFRAMESpeed of Onsetnvarchar40
18GRRMANALYSISAnalysis Table10TIMEFRAMESpeed of Onsetnvarchar40
19GRRMFACTREPFact Report Header6TIMEFRAMETimeframenvarchar100
20GRRMRESPONSETable for Response14TIMEFRAMETimeframenvarchar100
TOPManagement of Internal Controls
21FOPCCASEASAssessment5TIMEFRAMETimeframenvarchar100
22FOPCCASETEAttributes: Testing5TIMEFRAMETimeframenvarchar100
23FOPCCASETLTest log5TIMEFRAMETimeframenvarchar100
24FOPCCLOSINGClose8TIMEFRAMETimeframenvarchar100
25FOPCDEFICANAMIC: Deficiency Analysis12TIMEFRAMETimeframenvarchar100
26FOPCDEFICSELMIC: Selection Conditions for Deficiency Analysis9TIMEFRAMETimeframe for the Selection of Issuesnvarchar100
27FOPCMTESTERASGNMass Tester Assignment4TIMEFRAMETimeframenvarchar100
28FOPCMTESTERASGNSMass Tester Assignment - Settings4TIMEFRAMETimeframenvarchar100
29FOPCPRTUSERPARAUser Parameters for Print6TIMEFRAMETimeframenvarchar100
30FOPCRBFLOGReporting Buffers: Central Log3TIMEFRAMETimeframenvarchar100
31FOPCRBFTLReporting Buffer: Cases - Test Logs19TIMEFRAMETimeframenvarchar100
32FOPCSHM2Activate Shared Objects Memory3TIMEFRAMETimeframenvarchar100
33FOPCSIGNOFFSign-Off3TIMEFRAMETimeframenvarchar100
34FOPCTASKFREQ_TFTimeframes of Tasks That Can Be Scheduled at Corporate Level4TIMEFRAMETimeframenvarchar100
35FOPCTASKFREQ_TFCControls for Timeframes of Tasks that Can Be Scheduled4TIMEFRAMETimeframenvarchar100
36FOPCTIMEFRAMETimeframe4TIMEFRAMETimeframenvarchar100
37FOPCTIMEFRAMETTimeframe5TIMEFRAMETimeframenvarchar100
38FOPCUSERDATAUser-Specific Settings6TIMEFRAMETimeframenvarchar100
39FOPC_ORM_PROTORM Transfer: Log2TIMEFRAMETimeframenvarchar100
40HRP1814DB Table for InfoType 181418TIMEFRAMETimeframenvarchar100
TOPProcess Controls
41GRPCAODINFOaod infos4TIMEFRAMETimeframenvarchar100
42GRPCCASEASAssessment5TIMEFRAMETimeframenvarchar100
43GRPCCASECPCAPA Plan5TIMEFRAMETimeframenvarchar100
44GRPCCASEISIssue5TIMEFRAMETimeframenvarchar100
45GRPCCASEPLRemediation Plan5TIMEFRAMETimeframenvarchar100
46GRPCCASETEAttributes: Testing5TIMEFRAMETimeframenvarchar100
47GRPCCASETLTest log5TIMEFRAMETimeframenvarchar100
48GRPCCLOSINGClosed/Frozen organizations9TIMEFRAMETimeframenvarchar100
49GRPCDEFICANAPC: Deficiency Analysis12TIMEFRAMETimeframenvarchar100
50GRPCDEFICSELPC: Selection Conditions for Deficiency Analysis9TIMEFRAMETimeframe for the Selection of Issuesnvarchar100
51GRPCEVENTAGGROBSOLETE Event Monitoring Aggregation5TIMEFRAMETimeframenvarchar100
52GRPCEVENTRLEVEvent Monitoring: Rule evaluation results11TIMEFRAMETimeframenvarchar100
53GRPCJOBCASECase Data for Job4TIMEFRAMETimeframenvarchar100
54GRPCJOBLOGJob Log from Scheduler6TIMEFRAMETimeframenvarchar100
55GRPCMTESTERASGNObsolete: Mass Tester Assignment4TIMEFRAMETimeframenvarchar100
56GRPCMTESTERASGNSObsolete: Mass Tester Assignment - Settings4TIMEFRAMETimeframenvarchar100
57GRPCPRTUSERPARAUser Parameters for Print6TIMEFRAMETimeframenvarchar100
58GRPCRBFASReporting Buffer: Cases - Assessments9TIMEFRAMETimeframenvarchar100
59GRPCRBFLOGReporting Buffers: Central Log3TIMEFRAMETimeframenvarchar100
60GRPCRBFTLReporting Buffer: Cases - Test Logs19TIMEFRAMETimeframenvarchar100
61GRPCSCHEDULERScheduler11TIMEFRAMETimeframenvarchar100
62GRPCSHM2Activate Shared Objects Memory3TIMEFRAMETimeframenvarchar100
63GRPCSIGNOFFSign-Off3TIMEFRAMETimeframenvarchar100
64GRPCTASKFREQ_TFObsolete: Tasks That Can Be Scheduled at Corporate Level4TIMEFRAMETimeframenvarchar100
65GRPCTASKFREQ_TFCObsolete: Timeframes of Tasks that Can Be Scheduled4TIMEFRAMETimeframenvarchar100
66GRPCTASKPLANObsolete: Data for task plan6TIMEFRAMETimeframenvarchar100
67GRPCTIMEFRAMETimeframe4TIMEFRAMETimeframenvarchar100
68GRPCTIMEFRAMETTimeframe5TIMEFRAMETimeframenvarchar100
69GRPCUSERDATAUser-Specific Settings6TIMEFRAMETimeframenvarchar100
70GRPC_ACCOUNT_GRPAccount Group Scoping Info.6TIMEFRAMETimeframenvarchar100
71GRPC_MCF_REF_TSTReferenced test results for controls8TIMEFRAMETimeframenvarchar100
72GRPC_ORM_PROTORM Transfer: Log2TIMEFRAMETimeframenvarchar100
73GRPC_SCOP_THRESHScoping Threshold2TIMEFRAMETimeframenvarchar100
74HRP5314DB Table for Infotype 531418TIMEFRAMETimeframenvarchar100
TOPWaste Management
75EEWA_BULK_DATABulk refuse order data48TIMEFRAMEService windownvarchar20
76EWAOBJHService Frequency -> Services (History for EWAOBJ)6TIMEFRAMEService windownvarchar20
77EWA_OBJADDRESSObject Address6TIMEFRAMEService windownvarchar20
78EWA_ORDER_OBJECTItem Table for Waste Disposal Order14TIMEFRAMEService windownvarchar20
79EWA_SERVADDRESSService Address7TIMEFRAMEService windownvarchar20