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

187 columns | Print definition?ERP 6.0  | CONNECTOR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GRCPI/GRIACTGRPMaintain Controller Group and FF ID/Role Assignment4CONNECTORConnector Idnvarchar320
2/GRCPI/GRIACTRLMaintain assignment of FF ID or Role to Controllers4CONNECTORConnector Idnvarchar320
3/GRCPI/GRIAFFLOGDetails related to Firefighter ID Log On Information4CONNECTORConnector Idnvarchar320
4/GRCPI/GRIAFFOBJMaintain SPM Firefighter ID and Role details4CONNECTORConnector Idnvarchar320
5/GRCPI/GRIAFFOBTText table for Firefighter ID and Role details5CONNECTORConnector Idnvarchar320
6/GRCPI/GRIAFFOWNMaster table for Fire fighter Owners and FF ID/Roles4CONNECTORConnector Idnvarchar320
7/GRCPI/GRIAFFOWTText table for Fire fighter Owners5CONNECTORConnector Idnvarchar320
8/GRCPI/GRIAFFUSRMaintain SPM Firefighter Assignment to FF ID/Roles4CONNECTORConnector Idnvarchar320
9/GRCPI/GRIAFFUSTDetails related to FF ID or role assignment to Firefighter5CONNECTORConnector Idnvarchar320
10/GRCPI/GRIARLLOGDetails related to Firefighter ID Log On Information4CONNECTORConnector Idnvarchar320
11/PERSOS/SYSCONTable System Configuration7CONNECTORConnector to SAP Systemnvarchar160
12GRACACTIONSYSTAction Connector Text Table3CONNECTORConnector Idnvarchar320
13GRACACTPERMSYSConnector Specific Action Permission Relations2CONNECTORConnector Idnvarchar320
14GRACACTRULESOD Action Rule Detail5CONNECTORConnector Idnvarchar320
15GRACACTRULEEXTSOD Action Rule Detail For Extended Objects5CONNECTORConnector Idnvarchar320
16GRACACTUSAGEAction Usage3CONNECTORConnector Idnvarchar320
17GRACALACTLOGAlerts Action Log2CONNECTORConnector Idnvarchar320
18GRACALDETAILSAlerts detailed Info5CONNECTORConnector Idnvarchar320
19GRACALHDRAlerts Header Info6CONNECTORConnector Idnvarchar320
20GRACANALYZEDOBJAnalyzed Objects3CONNECTORConnector Idnvarchar320
21GRACAUDITLOGSecurity Audit Log table5CONNECTORConnector Idnvarchar320
22GRACAUTHPMSYSTAuthorization Permission Connector Text Table3CONNECTORConnector Idnvarchar320
23GRACBGTECHROLEStores values for Background Job Parameter Value12CONNECTORConnector Idnvarchar320
24GRACBUSROLEUSERSBusiness Role User Reassignment3CONNECTORConnector Idnvarchar320
25GRACCFFCTRLTText table for GRACFFCTRL table6CONNECTORConnector Idnvarchar320
26GRACCHANGELOGData Change Log table9CONNECTORConnector Idnvarchar320
27GRACCLASSSYSTAuthorization Class Connector Text Table3CONNECTORConnector Idnvarchar320
28GRACCLMQUERYCLM query mapping3CONNECTORConnector Idnvarchar320
29GRACCONNSTATGRC Connector Status2CONNECTORConnector Idnvarchar320
30GRACCRPROFILECritical Profile Rule3CONNECTORConnector Idnvarchar320
31GRACCRPROFILETText Table for Critical Profile3CONNECTORConnector Idnvarchar320
32GRACCRROLECritical Role Rule3CONNECTORConnector Idnvarchar320
33GRACCRROLETText table for Critical Role3CONNECTORConnector Idnvarchar320
34GRACEXCLUDEDOBJSAC batch Risk Analysis Excluded objects.5CONNECTORConnector Idnvarchar320
35GRACFFCTRLMaintain assignment of FF ID or Role to Controllers4CONNECTORConnector Idnvarchar320
36GRACFFCTRLGRPMaintain Controller Group and FF ID/Role Assignment4CONNECTORConnector Idnvarchar320
37GRACFFCTRLGRPTText Table for GRACFFCTRLGRP table5CONNECTORConnector Idnvarchar320
38GRACFFLOGDetails related to Firefighter ID Log On Information4CONNECTORConnector Idnvarchar320
39GRACFFOBJECTMaintain SPM Firefighter ID and Role details4CONNECTORConnector Idnvarchar320
40GRACFFOBJECTTText table for Firefighter ID and Role details5CONNECTORConnector Idnvarchar320
41GRACFFOWNERMaster table for Fire fighter Owners and FF ID/Roles4CONNECTORConnector Idnvarchar320
42GRACFFOWNERTFire fighter Owners5CONNECTORConnector Idnvarchar320
43GRACFFUSERMaintain SPM Firefighter Assignment to FF ID/Roles4CONNECTORConnector Idnvarchar320
44GRACFFUSERTDetails related to FF ID or role assignment to Firefighter5CONNECTORConnector Idnvarchar320
45GRACFLDSYSConnector Specific Field Name3CONNECTORConnector Idnvarchar320
46GRACFLDSYSTTable for System and Field3CONNECTORConnector Idnvarchar320
47GRACFLDVALSYSConnector Specific Field values4CONNECTORConnector Idnvarchar320
48GRACFUNCACTFunction Action Relationship4CONNECTORConnector Idnvarchar320
49GRACFUNCACTEXARCFunction Action Relationship For Extended Objects3CONNECTORConnector Idnvarchar320
50GRACFUNCACTEXTFunction Action Relationship For Extended Objects3CONNECTORConnector Idnvarchar320
51GRACFUNCPRMFunction Action Permission relationship4CONNECTORConnector Idnvarchar320
52GRACFUNCPRMARCFunction Action Permission Archive4CONNECTORConnector Idnvarchar320
53GRACFUNCPRMEXARCFunction Action Permission relationship for Ext Objs-Archive4CONNECTORConnector Idnvarchar320
54GRACFUNCPRMEXTFunction Action Permission relationship for Extended Objects4CONNECTORConnector Idnvarchar320
55GRACFUNCPRMEXTNFunction Action Permission Extension5CONNECTORConnector Idnvarchar320
56GRACFUNCPRMEXTNEFunction Action Permission Extension for Extended Objects5CONNECTORConnector Idnvarchar320
57GRACFUNUSAGESOD Function Usage5CONNECTORConnector Idnvarchar320
58GRACGRCPITable to Activate GRCPI2CONNECTORConnector Idnvarchar320
59GRACHROBJACTVLHR Object Action Violation Table9CONNECTORConnector Idnvarchar320
60GRACHROBJPRMVLUser Permission Violation Table9CONNECTORConnector Idnvarchar320
61GRACHRSYSCUP HR System3CONNECTORConnector Idnvarchar320
62GRACIDMREQConsists of idm requests of batch request3CONNECTORConnector Idnvarchar320
63GRACIDMRESPResponse data4CONNECTORConnector Idnvarchar320
64GRACIDMSCHEMABUFGrac : Buffer Schema for connection id2CONNECTORConnector Idnvarchar320
65GRACMGALERTSManagement Alerts3CONNECTORConnector Idnvarchar320
66GRACMGMTACTUSAGEManagement Action usage3CONNECTORConnector Idnvarchar320
67GRACMGRULECOUNTManagement Report Rule Count by Period and Connector.3CONNECTORConnector Idnvarchar320
68GRACMITMSMPVALIMitigation Assignment Workflow Validation6CONNECTORConnector Idnvarchar320
69GRACMITOBJECTMitigating control assignment4CONNECTORConnector Idnvarchar320
70GRACMITPROFProfile mitigating control assignment3CONNECTORConnector Idnvarchar320
71GRACMITROLERole mitigating control assignment3CONNECTORConnector Idnvarchar320
72GRACMITROLEORGRole Org mitigating control assignment4CONNECTORConnector Idnvarchar320
73GRACMITUSERUser mitigating control assignment3CONNECTORConnector Idnvarchar320
74GRACMITUSERARUser mitigating control assignment for Access Request4CONNECTORConnector Idnvarchar320
75GRACMITUSERGPUser Group mitigating control assignment3CONNECTORConnector Idnvarchar320
76GRACMITUSERORGUser Org mitigating control assignment4CONNECTORConnector Idnvarchar320
77GRACMITUSERORGARUser Org mitigating control assignment for Access Request5CONNECTORConnector Idnvarchar320
78GRACMITUSER_ARObsolete3CONNECTORConnector Idnvarchar320
79GRACMITUSRORG_ARObsolete4CONNECTORConnector Idnvarchar320
80GRACNONGRCPIGlobally activate Non-GRC PI2CONNECTORConnector Idnvarchar320
81GRACNONGRCPIMAPActivate Non-GRC PI2CONNECTORConnector Idnvarchar320
82GRACOBJECTAUTHcontains object(user/role/profile) auth for legacy system2CONNECTORLogical Destination (Specified in Function Call)nvarchar320
83GRACOSCMDLOGOperating System Command Log table5CONNECTORConnector Idnvarchar320
84GRACPDPROFILESPD profile details2CONNECTORConnector Idnvarchar320
85GRACPERMCLSSYSConnector Specific Permission Class Relation2CONNECTORConnector Idnvarchar320
86GRACPERMFLDSYSConnector Specific Permission Fields2CONNECTORConnector Idnvarchar320
87GRACPERMFLDVALsu24 Permission field value3CONNECTORConnector Idnvarchar320
88GRACPPDATARisk Analysis PPF Runtime Package Data.7CONNECTORConnector Idnvarchar320
89GRACPROFACTVLEXTProfile Action Violations for Extended Objects8CONNECTORConnector Idnvarchar320
90GRACPROFILEProfile2CONNECTORConnector Idnvarchar320
91GRACPROFILEACTVLProfile Action Violation Table8CONNECTORConnector Idnvarchar320
92GRACPROFILEPRMVLProfile Permission Violation Table8CONNECTORConnector Idnvarchar320
93GRACPROFILESYSTObselete -Table to store descriptions of profile per system.4CONNECTORConnector Idnvarchar320
94GRACPROFILETTable to store descriptions of profile per system Type.4CONNECTORConnector Idnvarchar320
95GRACPROFMGMTSUMProfile Management Total3CONNECTORConnector Idnvarchar320
96GRACPROFMGRLCOUNManagement Violated Profile Data3CONNECTORConnector Idnvarchar320
97GRACPROFMGVCOUNTProfile Level Management Violation Data3CONNECTORConnector Idnvarchar320
98GRACPROFPRMVLEXTProfile Permission Violations for Extended Objects8CONNECTORConnector Idnvarchar320
99GRACPROVCONFIGProvisioning configuration2CONNECTORConnector Idnvarchar320
100GRACPSSHRPSS HR Verification3CONNECTORConnector Idnvarchar320
101GRACREASONSYSReason Code and System assignments3CONNECTORConnector Idnvarchar320
102GRACREQOMOBJITEMHR OM Object assigned to request6CONNECTORApplication or Connectornvarchar320
103GRACREQPROVITEMLine Items Associated with Request4CONNECTORApplication or Connectornvarchar320
104GRACREQPROVLOGRequest Provsioning Log6CONNECTORConnector Idnvarchar320
105GRACREQSYSTEMApplication Associated with Request3CONNECTORApplication or Connectornvarchar320
106GRACREVITEMReview Request related items5CONNECTORApplication or Connectornvarchar320
107GRACRLCMPLVLTComparison Level Text2CONNECTORConnector Idnvarchar320
108GRACRLCONNStore roles in backend system, incl roles not maint. in ERM3CONNECTORLogical Destination (Specified in Function Call)nvarchar320
109GRACRLCONNSTARole generation status3CONNECTORConnector Idnvarchar320
110GRACRLCONNVALRole Connector (system) Validity3CONNECTORConnector Idnvarchar320
111GRACRLCONSTASTTable to store desc of roles per system in diff system3CONNECTORConnector Idnvarchar320
112GRACRLCONSTASYSTTable to store descriptions of roles per system.3CONNECTORLogical Destination (Specified in Function Call)nvarchar320
113GRACRLCUARELATCUA Role Relationship4CONNECTORConnector Idnvarchar320
114GRACROLEACTVLRole Action Violation Table9CONNECTORConnector Idnvarchar320
115GRACROLEACTVLEXTRole Action Violations for Extended Objects9CONNECTORConnector Idnvarchar320
116GRACROLECMPLVLRole Comparison Level1CONNECTORConnector Idnvarchar320
117GRACROLEFFLOGDetails related to Firefighter ID Log On Information4CONNECTORConnector Idnvarchar320
118GRACROLEMAPRole Mapping table5CONNECTORConnector Idnvarchar320
119GRACROLEMGMTSUMRole Management Total3CONNECTORConnector Idnvarchar320
120GRACROLEMGRLCOUNManagement Violated Role Data3CONNECTORConnector Idnvarchar320
121GRACROLEMGVCOUNTRole Level Management Violation Count3CONNECTORConnector Idnvarchar320
122GRACROLEORGRole ORG Level3CONNECTORLogical Destination (Specified in Function Call)nvarchar320
123GRACROLEPRMVLRole Permission Violation Table9CONNECTORConnector Idnvarchar320
124GRACROLEPRMVLEXTRole Permission Violation Table9CONNECTORConnector Idnvarchar320
125GRACROLEREAFFIRMRole Reaffirm4CONNECTORApplication or Connectornvarchar320
126GRACROLERELATEBackend Composite to Single Role relation3CONNECTORConnector Idnvarchar320
127GRACROLESYSACTRole System Action Table3CONNECTORConnector Idnvarchar320
128GRACROLEUSAGERole Usage3CONNECTORConnector Idnvarchar320
129GRACRRACTIONSTable for Role Reaffirm Actions4CONNECTORApplication or Connectornvarchar320
130GRACRTROLELOGLog of user reason for profile gen with conflicts2CONNECTORConnector Idnvarchar320
131GRACSODREVIEWItem Table for SOD Request4CONNECTORConnector Idnvarchar320
132GRACSODRISKCONNRisk - Connector Relationship3CONNECTORConnector Idnvarchar320
133GRACSODUSERROLEUser Roles For SOD Functions5CONNECTORConnector Idnvarchar320
134GRACSTDROLESYSDefault Role - Role and Systems4CONNECTORConnector Idnvarchar320
135GRACSUPPRULEHDRSupplement Rule Header5CONNECTORConnector Idnvarchar320
136GRACSUPRULEHDARCSupplement Rule Header-Archive5CONNECTORConnector Idnvarchar320
137GRACSYSCONACTNConnector-Action assignment4CONNECTORConnector Idnvarchar320
138GRACSYSRULESystem Specific Rule Mapping2CONNECTORConnector Idnvarchar320
139GRACSYSRULEOBJSystem Rule Permissions2CONNECTORConnector Idnvarchar320
140GRACSYSTEMLOGSystem Security Log table5CONNECTORConnector Idnvarchar320
141GRACTASKEXECSTMPExecuted background jobs Table3CONNECTORLogical Destination (Specified in Function Call)nvarchar320
142GRACUSERUser Table2CONNECTORConnector Idnvarchar320
143GRACUSERACTVLUser Action Violation Table8CONNECTORConnector Idnvarchar320
144GRACUSERACTVLEXTUser Action Violations for Extended Objects8CONNECTORConnector Idnvarchar320
145GRACUSERASSIGNMEObselete - User Assignment Table -( To be deleted )2CONNECTORLogical Destination (Specified in Function Call)nvarchar320
146GRACUSERCONNTable to store connector specific user2CONNECTORLogical Destination (Specified in Function Call)nvarchar320
147GRACUSERDEFAULTUser default3CONNECTORConnector Idnvarchar320
148GRACUSERMAPThis table holds master user to connector specific user2CONNECTORConnector Idnvarchar320
149GRACUSERMGMTSUMUser Management Total3CONNECTORConnector Idnvarchar320
150GRACUSERMGRLCOUNManagement Violated User Data3CONNECTORConnector Idnvarchar320
151GRACUSERMGVCOUNTManagement User Violation Count3CONNECTORConnector Idnvarchar320
152GRACUSERORGUser ORG Level3CONNECTORLogical Destination (Specified in Function Call)nvarchar320
153GRACUSERPRMVLUser Permission Violation Table8CONNECTORConnector Idnvarchar320
154GRACUSERPRMVLEXTUser Permission Violations for Extended Objects8CONNECTORConnector Idnvarchar320
155GRACUSERPROFILEUser Profile assignment table2CONNECTORConnector Idnvarchar320
156GRACUSERROLEUser Role Assignment Table3CONNECTORConnector Idnvarchar320
157GRACUSERSOURCETable for Data source3CONNECTORConnector Idnvarchar320
158GRACUSRCONNECTORUser default connector details2CONNECTORConnector Idnvarchar320
159GRACUSRPDPROFILEUser PDProfile assignment table2CONNECTORConnector Idnvarchar320
160GRACXSRULEMAPX System Rule logical System Mapping.2CONNECTORConnector Idnvarchar320
161GRFNCCICONNECTORCCI Connector2CONNECTORConnector Idnvarchar320
162GRFNCCIFILEPATHLogical File Path5CONNECTORConnector Idnvarchar320
163GRFNCCISUBSEQCONSubsequent Connector2CONNECTORConnector Idnvarchar320
164GRFNCGRPCONLKConnector Group and Connector Type Link3CONNECTORConnector Idnvarchar320
165GRFNCONNSCNLKConnector Scenario Link2CONNECTORConnector Idnvarchar320
166GRFNJOBPOLSPSNPJob Step OLSP Snapshot5CONNECTORConnector Idnvarchar320
167GRFNPLANRCPTScheduler Recipient relation5CONNECTORLogical Destination (Specified in Function Call)nvarchar320
168GRFNPOLICYRCPTDB table for recipient information in policy management5CONNECTORLogical Destination (Specified in Function Call)nvarchar320
169GRPCSPTCONN_TEMPRule Script Connector Assignment3CONNECTORTarget Connectornvarchar320
TOPGRC Risk Management
170HRP1849DB Table for Infotype 184919CONNECTORConnector IDnvarchar200
TOPMaxDB
171SDBDBMRFC2SAP DB: Current DBMRFC Sessions8CONNECTORUser Namenvarchar120
TOPOperational Data Provisioning ODP
172RODPSLOADHEADODP Activation (Header)5CONNECTORConnector Existsnvarchar10
173RODPSODPEHEADODP Activation (Header)5CONNECTORConnector Existsnvarchar10
TOPProcess Controls
174GRPCACRESULTAutomated control test result4CONNECTORTarget Connectornvarchar320
175GRPCCONNECTORRegister Connector in GRC2CONNECTORTarget Connectornvarchar320
176GRPCJOBLOGJob Log from Scheduler9CONNECTORTarget Connectornvarchar320
177GRPCORGUGCONNECTOrganization Level System Parameter Connectors3CONNECTORTarget Connectornvarchar320
178GRPCORGUGRLCRAssign Organization unit value to Organization Unit Group4CONNECTORTarget Connectornvarchar320
179GRPCRLCRSYSARule Criteria System Type Assignment4CONNECTORTarget Connectornvarchar320
180GRPCRULERule6CONNECTORTarget Connectornvarchar320
181GRPCRULE_SNPRule for Snapshot7CONNECTORTarget Connectornvarchar320
182GRPCRULE_TEMPRule - Temporary table for installation6CONNECTORTarget Connectornvarchar320
183GRPCSCRIPTScript5CONNECTORTarget Connectornvarchar320
184GRPCSCRIPTCONNRule Script Connector Assignment3CONNECTORTarget Connectornvarchar320
185GRPCSCRIPT_TEMPScript - Temporary table for installation5CONNECTORTarget Connectornvarchar320
186GRPCWSCONNECTORConnector for Web Service4CONNECTORTarget Connectornvarchar320
187GRPC_OLSP_SNPAssign Organization unit value to Organization Unit Group5CONNECTORTarget Connectornvarchar320