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

57 columns | Print definition?ERP 6.0  | RISKID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRACACTRULESOD Action Rule Detail2RISKIDAccess Risk IDnvarchar80
2GRACACTRULEEXTSOD Action Rule Detail For Extended Objects2RISKIDAccess Risk IDnvarchar80
3GRACACTRULHDRAction Rule Header2RISKIDAccess Risk IDnvarchar80
4GRACALHDRAlerts Header Info7RISKIDAccess Risk IDnvarchar80
5GRACHROBJACTVLHR Object Action Violation Table6RISKIDAccess Risk IDnvarchar80
6GRACHROBJPRMVLUser Permission Violation Table6RISKIDAccess Risk IDnvarchar80
7GRACMGRISKDRisk Analysis Mgmt Sum data for Batch Risk Analysis.8RISKIDAccess Risk IDnvarchar80
8GRACMITMSMPVALIMitigation Assignment Workflow Validation5RISKIDAccess Risk IDnvarchar80
9GRACMITOBJECTMitigating control assignment5RISKIDAccess Risk IDnvarchar80
10GRACMITPROFProfile mitigating control assignment4RISKIDAccess Risk IDnvarchar80
11GRACMITROLERole mitigating control assignment4RISKIDAccess Risk IDnvarchar80
12GRACMITROLEORGRole Org mitigating control assignment5RISKIDAccess Risk IDnvarchar80
13GRACMITUSERUser mitigating control assignment4RISKIDAccess Risk IDnvarchar80
14GRACMITUSERARUser mitigating control assignment for Access Request5RISKIDAccess Risk IDnvarchar80
15GRACMITUSERGPUser Group mitigating control assignment4RISKIDAccess Risk IDnvarchar80
16GRACMITUSERORGUser Org mitigating control assignment5RISKIDAccess Risk IDnvarchar80
17GRACMITUSERORGARUser Org mitigating control assignment for Access Request6RISKIDAccess Risk IDnvarchar80
18GRACMITUSER_ARObsolete4RISKIDAccess Risk IDnvarchar80
19GRACMITUSRORG_ARObsolete5RISKIDAccess Risk IDnvarchar80
20GRACORGRULEHDROrganization Rule Header5RISKIDAccess Risk IDnvarchar80
21GRACPROFACTVLEXTProfile Action Violations for Extended Objects5RISKIDAccess Risk IDnvarchar80
22GRACPROFILEACTVLProfile Action Violation Table5RISKIDAccess Risk IDnvarchar80
23GRACPROFILEPRMVLProfile Permission Violation Table5RISKIDAccess Risk IDnvarchar80
24GRACPROFMGVCOUNTProfile Level Management Violation Data4RISKIDAccess Risk IDnvarchar80
25GRACPROFPRMVLEXTProfile Permission Violations for Extended Objects5RISKIDAccess Risk IDnvarchar80
26GRACROLEACTVLRole Action Violation Table6RISKIDAccess Risk IDnvarchar80
27GRACROLEACTVLEXTRole Action Violations for Extended Objects6RISKIDAccess Risk IDnvarchar80
28GRACROLEMGVCOUNTRole Level Management Violation Count4RISKIDAccess Risk IDnvarchar80
29GRACROLEPRMVLRole Permission Violation Table6RISKIDAccess Risk IDnvarchar80
30GRACROLEPRMVLEXTRole Permission Violation Table6RISKIDAccess Risk IDnvarchar80
31GRACSODREVIEWItem Table for SOD Request6RISKIDAccess Risk IDnvarchar80
32GRACSODRISKSOD Risk2RISKIDAccess Risk IDnvarchar80
33GRACSODRISKCONNRisk - Connector Relationship2RISKIDAccess Risk IDnvarchar80
34GRACSODRISKFUNCSOD Risk Function Relationship2RISKIDAccess Risk IDnvarchar80
35GRACSODRISKOWNSOD Risk Owner2RISKIDAccess Risk IDnvarchar80
36GRACSODRISKRSRisk - Rule Set Relationship2RISKIDAccess Risk IDnvarchar80
37GRACSODRISKTSOD Risk Description3RISKIDAccess Risk IDnvarchar80
38GRACSUPPRULEHDRSupplement Rule Header4RISKIDAccess Risk IDnvarchar80
39GRACSUPRULEHDARCSupplement Rule Header-Archive4RISKIDAccess Risk IDnvarchar80
40GRACSYSRULESystem Specific Rule Mapping3RISKIDAccess Risk IDnvarchar80
41GRACUSERACTVLUser Action Violation Table5RISKIDAccess Risk IDnvarchar80
42GRACUSERACTVLEXTUser Action Violations for Extended Objects5RISKIDAccess Risk IDnvarchar80
43GRACUSERMGVCOUNTManagement User Violation Count4RISKIDAccess Risk IDnvarchar80
44GRACUSERPRMVLUser Permission Violation Table5RISKIDAccess Risk IDnvarchar80
45GRACUSERPRMVLEXTUser Permission Violations for Extended Objects5RISKIDAccess Risk IDnvarchar80
46GRACXSRULEMAPX System Rule logical System Mapping.3RISKIDAccess Risk IDnvarchar80
TOPGRC Access Control Plug-In
47/VIRSA/FUNCTRISKFunction and Risk Relation3RISKIDIDnvarchar40
48/VIRSA/MGMTCRTRUser based Critical TCode & Role analysis details4RISKIDNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
49/VIRSA/MGMTRISKDUser & Role analysis Risk details5RISKIDIDnvarchar40
50/VIRSA/MGMTRISKSUser & Role analysis Risks Total by Risk IDs.5RISKIDNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
51/VIRSA/RISKOWNERRisk Owner2RISKIDIDnvarchar40
52/VIRSA/RISKSRisk Definition2RISKIDIDnvarchar40
53/VIRSA/RISKSTRisk Definition Text2RISKIDIDnvarchar40
54/VIRSA/RSKWKFLOWRisk Workflow2RISKIDIDnvarchar40
TOPPlant Maintenance
55EAMWS_RESPONSESRisk Respones for Safety Checklist5RISKIDRisk IDnvarchar500
56EAMWS_RISKSRisks for Safety Checklist4RISKIDRisk IDnvarchar500
57EAMWS_SAFETYMEASSafety Measures for Safety Checklist7RISKIDRisk IDnvarchar500