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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

47 columns | Print definition?ERP 6.0  | UPDATED_ON

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/PWS_AGG_MPMaster Project Overall Aggregation Data6UPDATED_ONChanged Ondecimal150
2/GRCPI/GRIACTGRPMaintain Controller Group and FF ID/Role Assignment7UPDATED_ONTimestamp when the Field was Last Updateddecimal150
3/GRCPI/GRIACTRLMaintain assignment of FF ID or Role to Controllers9UPDATED_ONTimestamp when the Field was Last Updateddecimal150
4/GRCPI/GRIAFFOBJMaintain SPM Firefighter ID and Role details8UPDATED_ONTimestamp when the Field was Last Updateddecimal150
5/GRCPI/GRIAFFOWNMaster table for Fire fighter Owners and FF ID/Roles7UPDATED_ONTimestamp when the Field was Last Updateddecimal150
6/GRCPI/GRIAFFUSRMaintain SPM Firefighter Assignment to FF ID/Roles12UPDATED_ONTimestamp when the Field was Last Updateddecimal150
7/GRCPI/GRIARCODEMaster table for Reason Codes7UPDATED_ONTimestamp when the Field was Last Updateddecimal150
8BBPD_CMS_DOC_INTCMS Documents - Internal Versions7UPDATED_ONTime Stampdecimal150
9GRACANALYZEDOBJAnalyzed Objects9UPDATED_ONTime Stampdecimal150
10GRACBUSROLEPROVTable to store busniess role provisioning information5UPDATED_ONTime Stampdecimal150
11GRACBUSROLEUSERSBusiness Role User Reassignment10UPDATED_ONTime Stampdecimal150
12GRACCTGRPMaster table for SPM Controller Groups5UPDATED_ONTime Stampdecimal150
13GRACCTGRPDTLMaintain Controllers assigned to Controller Groups6UPDATED_ONTime Stampdecimal150
14GRACFFCTRLMaintain assignment of FF ID or Role to Controllers9UPDATED_ONTime Stampdecimal150
15GRACFFCTRLGRPMaintain Controller Group and FF ID/Role Assignment7UPDATED_ONTime Stampdecimal150
16GRACFFOBJECTMaintain SPM Firefighter ID and Role details8UPDATED_ONTime Stampdecimal150
17GRACFFOWNERMaster table for Fire fighter Owners and FF ID/Roles7UPDATED_ONTime Stampdecimal150
18GRACFFUSERMaintain SPM Firefighter Assignment to FF ID/Roles12UPDATED_ONTime Stampdecimal150
19GRACMITOBJECTMitigating control assignment13UPDATED_ONTime Stampdecimal150
20GRACMITPROFProfile mitigating control assignment12UPDATED_ONTime Stampdecimal150
21GRACMITROLERole mitigating control assignment12UPDATED_ONTime Stampdecimal150
22GRACMITROLEORGRole Org mitigating control assignment13UPDATED_ONTime Stampdecimal150
23GRACMITUSERUser mitigating control assignment12UPDATED_ONTime Stampdecimal150
24GRACMITUSERARUser mitigating control assignment for Access Request13UPDATED_ONTime Stampdecimal150
25GRACMITUSERGPUser Group mitigating control assignment12UPDATED_ONTime Stampdecimal150
26GRACMITUSERORGUser Org mitigating control assignment13UPDATED_ONTime Stampdecimal150
27GRACMITUSERORGARUser Org mitigating control assignment for Access Request14UPDATED_ONTime Stampdecimal150
28GRACMITUSER_ARObsolete12UPDATED_ONTime Stampdecimal150
29GRACMITUSRORG_ARObsolete13UPDATED_ONTime Stampdecimal150
30GRACORGRULEHDROrganization Rule Header7UPDATED_ONTimestamp when the Field was Last Updateddecimal150
31GRACOWNERMaster table for Central Owner Administration10UPDATED_ONTime Stampdecimal150
32GRACPDPROFILESPD profile details4UPDATED_ONTime Stampdecimal150
33GRACPROFILEProfile4UPDATED_ONTime Stampdecimal150
34GRACREASONCODMaster table for Reason Codes7UPDATED_ONTime Stampdecimal150
35GRACREASONSYSReason Code and System assignments5UPDATED_ONTime Stampdecimal150
36GRACREQPROVLOGRequest Provsioning Log12UPDATED_ONTime Stampdecimal150
37GRACRLCONNStore roles in backend system, incl roles not maint. in ERM6UPDATED_ONTime Stampdecimal150
38GRACSODREPSTATUSReport status6UPDATED_ONTimestamp when the Field was Last Updateddecimal150
39GRACSUPPRULEHDRSupplement Rule Header11UPDATED_ONTimestamp when the Field was Last Updateddecimal150
40GRACSUPRULEHDARCSupplement Rule Header-Archive11UPDATED_ONTimestamp when the Field was Last Updateddecimal150
41GRACUSERUser Table9UPDATED_ONTime Stampdecimal150
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
42SATC_RT_RUNMovement data (runtime repository) - Header8UPDATED_ONLast modification on .. timestampdecimal150
43SATC_RT_RUN_EXEMovement data (runtime repository) - Runs / reruns11UPDATED_ONLast modification on .. timestampdecimal150
44SATC_RT_RUN_PEUMovement data (runtime repository) - 'Phase Execution Unit'11UPDATED_ONLast modification on .. timestampdecimal150
45SATC_RT_RUN_PHSMovement data (runtime repository) - Phases11UPDATED_ONLast modification on .. timestampdecimal150
TOPPackage Tools
46AKB_JOBSTATEObsolete: Job Status6UPDATED_ONDate of Last Changenvarchar80
TOPPortfolio Management
47RPM_CTEMPLATECustom Development Template8UPDATED_ONDatenvarchar80