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

64 columns | Print definition?ERP 6.0  | TF_YEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRFNCASEISCase table of Issue13TF_YEARYearnvarchar40
2GRFNJOBJob7TF_YEARTimeframe Yearnvarchar40
3GRFNJOBCASECase Data for Job6TF_YEARYearnvarchar40
4GRFNJOBDETAILJob Step7TF_YEARTimeframe Yearnvarchar40
5GRPCDBBUFDashboard buffer5TF_YEARTimeframe Yearnvarchar40
6GRPCSIGNOFFPLANSign-Off Guid5TF_YEARTimeframe Yearnvarchar40
7GRRMRESPResponse attributes16TF_YEARyearnvarchar40
8GRRMRISKCONSPLANInfomation for one plan of risk consolidation.9TF_YEARTimeframe Yearnvarchar40
TOPGovernance, Risk and Compliance
9GRFNDMLOGDatamart: Central Log5TF_YEARTimeframe Yearnvarchar40
10GRFNMDCRMaster Data Change Request7TF_YEARTimeframe Yearnvarchar40
11GRFNTASKPLANData for task plan7TF_YEARTimeframe Yearnvarchar40
12GRPCACCVERSIONVersion of Central Account Group6TF_YEARYearnvarchar40
TOPGRC Risk Management
13GRRMFACTREPFact Report Header5TF_YEARTimeframe Yearnvarchar40
14GRRMRESPONSETable for Response15TF_YEARyearnvarchar40
TOPManagement of Internal Controls
15FOPCCASEASAssessment6TF_YEARYearnvarchar40
16FOPCCASETEAttributes: Testing6TF_YEARYearnvarchar40
17FOPCCASETLTest log6TF_YEARYearnvarchar40
18FOPCCLOSINGClose9TF_YEARYearnvarchar40
19FOPCDEFICANAMIC: Deficiency Analysis13TF_YEARYearnvarchar40
20FOPCDEFICSELMIC: Selection Conditions for Deficiency Analysis10TF_YEARYearnvarchar40
21FOPCMTESTERASGNMass Tester Assignment5TF_YEARYearnvarchar40
22FOPCMTESTERASGNSMass Tester Assignment - Settings5TF_YEARYearnvarchar40
23FOPCPRTUSERPARAUser Parameters for Print7TF_YEARYearnvarchar40
24FOPCRBFLOGReporting Buffers: Central Log4TF_YEARYearnvarchar40
25FOPCRBFTLReporting Buffer: Cases - Test Logs20TF_YEARYearnvarchar40
26FOPCSHM2Activate Shared Objects Memory4TF_YEARYearnvarchar40
27FOPCSIGNOFFSign-Off4TF_YEARYearnvarchar40
28FOPCTASKFREQ_TFTimeframes of Tasks That Can Be Scheduled at Corporate Level5TF_YEARYearnvarchar40
29FOPCTASKFREQ_TFCControls for Timeframes of Tasks that Can Be Scheduled5TF_YEARYearnvarchar40
30FOPCUSERDATAUser-Specific Settings7TF_YEARYearnvarchar40
31FOPC_ORM_PROTORM Transfer: Log3TF_YEARYearnvarchar40
32HRP1814DB Table for InfoType 181419TF_YEARYearnvarchar40
TOPProcess Controls
33GRPCAODINFOaod infos5TF_YEARYearnvarchar40
34GRPCCASEASAssessment6TF_YEARYearnvarchar40
35GRPCCASECPCAPA Plan6TF_YEARYearnvarchar40
36GRPCCASEISIssue6TF_YEARYearnvarchar40
37GRPCCASEPLRemediation Plan6TF_YEARYearnvarchar40
38GRPCCASETEAttributes: Testing6TF_YEARYearnvarchar40
39GRPCCASETLTest log6TF_YEARYearnvarchar40
40GRPCCLOSINGClosed/Frozen organizations10TF_YEARYearnvarchar40
41GRPCDEFICANAPC: Deficiency Analysis13TF_YEARYearnvarchar40
42GRPCDEFICSELPC: Selection Conditions for Deficiency Analysis10TF_YEARYearnvarchar40
43GRPCEVENTAGGROBSOLETE Event Monitoring Aggregation6TF_YEARYearnvarchar40
44GRPCEVENTRLEVEvent Monitoring: Rule evaluation results12TF_YEARYearnvarchar40
45GRPCJOBCASECase Data for Job5TF_YEARYearnvarchar40
46GRPCJOBLOGJob Log from Scheduler7TF_YEARYearnvarchar40
47GRPCMTESTERASGNObsolete: Mass Tester Assignment5TF_YEARYearnvarchar40
48GRPCMTESTERASGNSObsolete: Mass Tester Assignment - Settings5TF_YEARYearnvarchar40
49GRPCPRTUSERPARAUser Parameters for Print7TF_YEARYearnvarchar40
50GRPCRBFASReporting Buffer: Cases - Assessments10TF_YEARYearnvarchar40
51GRPCRBFLOGReporting Buffers: Central Log4TF_YEARYearnvarchar40
52GRPCRBFTLReporting Buffer: Cases - Test Logs20TF_YEARYearnvarchar40
53GRPCSCHEDULERScheduler12TF_YEARYearnvarchar40
54GRPCSHM2Activate Shared Objects Memory4TF_YEARYearnvarchar40
55GRPCSIGNOFFSign-Off4TF_YEARYearnvarchar40
56GRPCTASKFREQ_TFObsolete: Tasks That Can Be Scheduled at Corporate Level5TF_YEARYearnvarchar40
57GRPCTASKFREQ_TFCObsolete: Timeframes of Tasks that Can Be Scheduled5TF_YEARYearnvarchar40
58GRPCTASKPLANObsolete: Data for task plan7TF_YEARYearnvarchar40
59GRPCUSERDATAUser-Specific Settings7TF_YEARYearnvarchar40
60GRPC_ACCOUNT_GRPAccount Group Scoping Info.7TF_YEARYearnvarchar40
61GRPC_MCF_REF_TSTReferenced test results for controls9TF_YEARYearnvarchar40
62GRPC_ORM_PROTORM Transfer: Log3TF_YEARYearnvarchar40
63GRPC_SCOP_THRESHScoping Threshold3TF_YEARYearnvarchar40
64HRP5314DB Table for Infotype 531419TF_YEARYearnvarchar40