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
Financials :: Corporate Governance :: Management of Internal Controls
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FOPCRBFSTR521Reporting Buffer: Buffered StructuresManagement of Internal Controls
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, GUID, ORGUNIT, PRGROUP, PROCESS, CONTROL, PROCESS_TRTYPE, PROCESS_TRTYPE_O, PROCESS_INDUSTRY, CONTROL_SIG, CONTROL_PURP, CONTROL_MATAR, CONTROL_AUTOM, CONTROL_FREQ, CONTROL_NATURE, CONTROL_TEST, CONTROL_TTECH, CONTROL_DTEVT, CONTROL_TSTAUT, PD_STATUS, PD_RATING, PD_ISSUES, PD_PLANS, PD_CASEGUID, PD_DATE, CD_STATUS, CD_RATING, CD_ISSUES, CD_PLANS, CD_CASEGUID, CD_DATE, CE_STATUS, CE_RATING, CE_ISSUES, CE_PLANS, CE_CASEGUID, CE_DATE, TE_STATUS, TE_RATING, TE_ISSUES, TE_PLANS, TE_CF_STATUS, TE_CASEGUID, CONTROL_TPROC, PD_OPENED, CD_OPENED, CE_OPENED, TE_OPENED, PD_PROC, CD_PROC, CE_PROC, TE_PROC FROM FOPCRBFSTR
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2GUIDGUID of Buffered Versionnvarchar320 Allow NULL? 
3ORGUNITOrganizational Unit IDnvarchar80 Allow NULL? 
4PRGROUPProcess Group IDnvarchar80 Allow NULL? 
5PROCESSMIC Reporting: Process IDnvarchar80 Allow NULL? 
6CONTROLMIC Reporting: Control IDnvarchar90 Allow NULL? 
7PROCESS_TRTYPETransaction Type IDnvarchar100 Allow NULL? 
8PROCESS_TRTYPE_OTransaction Type IDnvarchar100 Allow NULL? 
9PROCESS_INDUSTRYIndustrynvarchar100 Allow NULL? 
10CONTROL_SIGControl Significance (ID)nvarchar100 Allow NULL? 
11CONTROL_PURPControl Purpose IDnvarchar100 Allow NULL? 
12CONTROL_MATARMIC Reporting: ID of Control Maturity Targetnvarchar100 Allow NULL? 
13CONTROL_AUTOMControl Automation (ID)nvarchar100 Allow NULL? 
14CONTROL_FREQFrequency (ID)nvarchar100 Allow NULL? 
15CONTROL_NATURENature of Control (ID)nvarchar100 Allow NULL? 
16CONTROL_TESTControl Documentation: Control To Be Tested (Indicator)char10 Allow NULL? 
17CONTROL_TTECHControl Documentation: Testing Techniquenvarchar100 Allow NULL? 
18CONTROL_DTEVTDate or Eventnvarchar100 Allow NULL? 
19CONTROL_TSTAUTTest Automationnvarchar100 Allow NULL? 
20PD_STATUSProcess Design Statusnvarchar50 Allow NULL? 
21PD_RATINGProcess Design Ratingchar10 Allow NULL? 
22PD_ISSUESMIC Reporting: Number of Process Design Issuesint100 Allow NULL? 
23PD_PLANSNumber of Remediation Plans for Process Design Issuesint100 Allow NULL? 
24PD_CASEGUIDTechnical Case Key (Case GUID)nvarchar320 Allow NULL? 
25PD_DATEAssessment Datenvarchar80 Allow NULL? 
26CD_STATUSControl Design Statusnvarchar50 Allow NULL? 
27CD_RATINGControl Design Ratingchar10 Allow NULL? 
28CD_ISSUESMIC Reporting: Number of Control Design Issuesint100 Allow NULL? 
29CD_PLANSNumber of Remediation Plans for Control Design Issuesint100 Allow NULL? 
30CD_CASEGUIDTechnical Case Key (Case GUID)nvarchar320 Allow NULL? 
31CD_DATEAssessment Datenvarchar80 Allow NULL? 
32CE_STATUSControl Efficiency Statusnvarchar50 Allow NULL? 
33CE_RATINGControl Efficiency Ratingchar10 Allow NULL? 
34CE_ISSUESNumber of Control Efficiency Issuesint100 Allow NULL? 
35CE_PLANSNumber of Remediation Plans for Efficiency Issuesint100 Allow NULL? 
36CE_CASEGUIDTechnical Case Key (Case GUID)nvarchar320 Allow NULL? 
37CE_DATEAssessment Datenvarchar80 Allow NULL? 
38TE_STATUSControl Effectiveness Statusnvarchar50 Allow NULL? 
39TE_RATINGControl Effectiveness Ratingchar10 Allow NULL? 
40TE_ISSUESMIC Reporting: Number of Effectiveness Issuesint100 Allow NULL? 
41TE_PLANSNumber of Remediation Plans for Effectiveness Issuesint100 Allow NULL? 
42TE_CF_STATUSCarryforward Statuschar10 Allow NULL? 
43TE_CASEGUIDTechnical Case Key (Case GUID)nvarchar320 Allow NULL? 
44CONTROL_TPROCNamenvarchar1000 Allow NULL? 
45PD_OPENEDMIC Reporting: Number of Process Design Issuesint100 Allow NULL? 
46CD_OPENEDMIC Reporting: Number of Control Design Issuesint100 Allow NULL? 
47CE_OPENEDNumber of Control Efficiency Issuesint100 Allow NULL? 
48TE_OPENEDMIC Reporting: Number of Effectiveness Issuesint100 Allow NULL? 
49PD_PROCProcessornvarchar120 Allow NULL? 
50CD_PROCProcessornvarchar120 Allow NULL? 
51CE_PROCProcessornvarchar120 Allow NULL? 
52TE_PROCProcessornvarchar120 Allow NULL? 
NamePrimaryUniqueTypeColumns
FOPCRBFSTR~0YesYesCLUSTEREDCONTROL, PROCESS, PRGROUP, ORGUNIT, GUID, MANDT