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

58 columns | Print definition?ERP 6.0  | ROLEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X021Key Determination Templates for Product Roles3ROLEIDResponsible Partynvarchar150
2/OPT/Y021Key Determination Templates for Product Roles3ROLEIDResponsible Partynvarchar150
3/OPT/Z021Key Determination Templates for Product Roles3ROLEIDResponsible Partynvarchar150
4ACMRULEACM: Rule Persistence2ROLEIDACM: UUID of a Rolevarbinary160
5ACMTSTRULEACMTST: Rule (Expected test-results)2ROLEIDACM: UUID of a Rolevarbinary160
6GRACHROBJACTVLHR Object Action Violation Table11ROLEIDRole IDnvarchar320
7GRACHROBJCRPVLHR Object Critical Role/Profile Violation Table6ROLEIDRole IDnvarchar320
8GRACHROBJPRMVLUser Permission Violation Table15ROLEIDRole IDnvarchar320
9GRACRLCOMPANYRole Company2ROLEIDRole IDnvarchar320
10GRACRLCONNSTARole generation status2ROLEIDUUID of the GRC object (char32)nvarchar320
11GRACRLCONNVALRole Connector (system) Validity2ROLEIDRole IDnvarchar320
12GRACRLCONSTASYSTTable to store descriptions of roles per system.2ROLEIDUUID of the GRC object (char32)nvarchar320
13GRACRLCUSTPRFTemplate role custom profile details2ROLEIDRole IDnvarchar320
14GRACRLORGLVMPGRole - Org Level Mapping Association table2ROLEIDRole IDnvarchar320
15GRACRLPREREQRole Prerequisites2ROLEIDRole IDnvarchar320
16GRACROLERole2ROLEIDRole IDnvarchar320
17GRACROLEACTRole Action Table2ROLEIDUUID of the GRC object (char32)nvarchar320
18GRACROLEACTVLRole Action Violation Table3ROLEIDRole IDnvarchar320
19GRACROLEACTVLEXTRole Action Violations for Extended Objects3ROLEIDRole IDnvarchar320
20GRACROLEAPPRVRRole Approver2ROLEIDRole IDnvarchar320
21GRACROLEARCRole Archiving table for deleted roles2ROLEIDRole IDnvarchar320
22GRACROLECRITRole with risk violation2ROLEIDRole IDnvarchar320
23GRACROLECRPVLRole Critical Role/Profile Violation Table3ROLEIDRole IDnvarchar320
24GRACROLEFARole Function Area2ROLEIDRole IDnvarchar320
25GRACROLEFUNCRole Function2ROLEIDRole IDnvarchar320
26GRACROLEJOBRole Mangement Job Log5ROLEIDObject IDnvarchar500
27GRACROLEORGFLDRole Global Org Fields2ROLEIDUUID of the GRC object (char32)nvarchar320
28GRACROLEORGLVLDerived Role Leading Org Level Information2ROLEIDRole IDnvarchar320
29GRACROLEPERMRole Permission Table2ROLEIDUUID of the GRC object (char32)nvarchar320
30GRACROLEPERMAUTHRole Permission Authorization Table3ROLEIDUUID of the GRC object (char32)nvarchar320
31GRACROLEPRMVLRole Permission Violation Table3ROLEIDRole IDnvarchar320
32GRACROLEPRMVLEXTRole Permission Violation Table3ROLEIDRole IDnvarchar320
33GRACROLEREAFFIRMRole Reaffirm2ROLEIDRole IDnvarchar320
34GRACROLEREQRole Request Details2ROLEIDRole IDnvarchar320
35GRACROLESTEPRole Step2ROLEIDRole IDnvarchar320
36GRACROLETRole Descriptions3ROLEIDRole IDnvarchar320
37GRACROLETICKETTicket for role2ROLEIDRole IDnvarchar320
38GRACROLETSTRole Testing Header2ROLEIDUUID of the GRC object (char32)nvarchar320
39GRACRRACTIONSTable for Role Reaffirm Actions3ROLEIDRole IDnvarchar320
40GRACSTDROLESYSDefault Role - Role and Systems3ROLEIDRole IDnvarchar320
41GRACUSERACTVLUser Action Violation Table10ROLEIDRole IDnvarchar320
42GRACUSERACTVLEXTUser Action Violations for Extended Objects10ROLEIDRole IDnvarchar320
43GRACUSERCRPVLUser Critical Role/Profile Violation Table5ROLEIDRole IDnvarchar320
44GRACUSERPRMVLUser Permission Violation Table14ROLEIDRole IDnvarchar320
45GRACUSERPRMVLEXTUser Permission Violations for Extended Objects14ROLEIDRole IDnvarchar320
46YLP_TX_MAST_LINKTransaction table to store Master Link4ROLEIDROLE IDsmallint50
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
47CRMAHRData on Persons11ROLEIDUser Rolenvarchar100
48CRMAHRROLRoles1ROLEIDUser Rolenvarchar100
49CRMAHRROLTRoles text table2ROLEIDUser Rolenvarchar100
TOPBusiness Package for Manager Self-Service HR
50EREC_GENERALGeneral Requisition Form Settings6ROLEIDObject ID of Standard Objectnvarchar80
51TWPC_PCR_GENERALGeneral PCR Settings7ROLEIDObject ID of Standard Objectnvarchar80
TOPCross-Application Components
52/OPT/CP_T912Key Determination Templates for Product Roles3ROLEIDResponsible Partynvarchar150
TOPDSD Connector
53/DSD/ME_ROLEDSD CN: Role for Mobile Devices, group specific2ROLEIDKey for DSD Cockpit Rolesnvarchar200
54/DSD/ME_ROLETDSD CN: Description of DSD Role for Mobile Devices3ROLEIDKey for DSD Cockpit Rolesnvarchar200
55/DSD/ME_ROLE_GRPDSD CN: Assignment of roles to a group of devices3ROLEIDKey for DSD Cockpit Rolesnvarchar200
TOPGeneral Object Relations
56SRRELROLESObject Relationship Service: Roles6ROLEIDObject Relationship Service : Role GUIDnvarchar220
TOPRemaining Beverage - Obsolete Objects
57/DSD/ME_CPT_ROLEDSD Roles2ROLEIDKey for DSD Cockpit Rolesnvarchar200
TOPWithout Description
58RSBCTCBROLEMAPContent Browser: Role Numbers2ROLEIDint100