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

78 columns | Print definition?ERP 6.0  | DESCN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GRCPI/GRIAFFOBTText table for Firefighter ID and Role details6DESCNDescriptionnvarchar1320
2/GRCPI/GRIAFFOWTText table for Fire fighter Owners7DESCNDescriptionnvarchar1320
3/GRCPI/GRIAFFUSTDetails related to FF ID or role assignment to Firefighter7DESCNDescriptionnvarchar1320
4/GRCPI/GRIARCODTText table for GRACREASONCOD table4DESCNLong Descriptionnvarchar2550
5GRACACFIELDTText table AC fields3DESCNDescriptionnvarchar1320
6GRACACTIONSYSTAction Connector Text Table5DESCNLong Descriptionnvarchar2550
7GRACACTIONTAction Text Table4DESCNLong Descriptionnvarchar2550
8GRACACTIONTYPETText table for Action Type3DESCNDescriptionnvarchar1320
9GRACAPPLTYPETApplication type3DESCNDescriptionnvarchar1320
10GRACAUTHPERMTAuthorization Permission Text Table4DESCNLong Descriptionnvarchar2550
11GRACAUTHPMSYSTAuthorization Permission Connector Text Table5DESCNLong Descriptionnvarchar2550
12GRACBPROCTBusiness Process Text4DESCNBusiness processnvarchar1320
13GRACBSUBPROCTBusiness Subprocess5DESCNDescriptionnvarchar1320
14GRACCFFCTRLTText table for GRACFFCTRL table7DESCNDescriptionnvarchar1320
15GRACCLASSSYSTAuthorization Class Connector Text Table6DESCNLong Descriptionnvarchar2550
16GRACCLASSTAuthorization Class Text Table5DESCNLong Descriptionnvarchar2550
17GRACCNDGPTYPETGRC ERM Condition Group Type Text3DESCNCondition Group Type Descriptionnvarchar1320
18GRACCOMPANYTCompany text4DESCNDescriptionnvarchar1320
19GRACCONACTTConnector Action Text3DESCNConnector Descriptionnvarchar1320
20GRACCONFIGTConfiguration Text Table3DESCNDescriptionnvarchar1320
21GRACCRITICLTYTText table for Criticality levels4DESCNDescriptionnvarchar1320
22GRACCRITILVLTCritical Level Text4DESCNDescriptionnvarchar1320
23GRACCRPROFILETText Table for Critical Profile6DESCNDescriptionnvarchar1320
24GRACCRROLETText table for Critical Role6DESCNDescriptionnvarchar1320
25GRACCTGRPDTLTText Table for GRACCTGRPDTL table5DESCNDescriptionnvarchar1320
26GRACCUSTGRPTCustom group text table4DESCNLong Descriptionnvarchar2550
27GRACEMPTYPETText table for Employee Type4DESCNDescriptionnvarchar1320
28GRACEUPTEnd User Personalization Description4DESCNDescriptionnvarchar1320
29GRACFFCTRLGRPTText Table for GRACFFCTRLGRP table7DESCNDescriptionnvarchar1320
30GRACFFOBJECTTText table for Firefighter ID and Role details6DESCNDescriptionnvarchar1320
31GRACFFOWNERTFire fighter Owners7DESCNDescriptionnvarchar1320
32GRACFFUSERTDetails related to FF ID or role assignment to Firefighter7DESCNDescriptionnvarchar1320
33GRACFLDSYSTTable for System and Field5DESCNLong Descriptionnvarchar2550
34GRACFLDTText Table for Field table5DESCNLong Descriptionnvarchar2550
35GRACFLDVALTText Table Field Value4DESCNLong Descriptionnvarchar2550
36GRACFUNCTFunction Description Translations4DESCNDescriptionnvarchar1320
37GRACFUNCTAREATFunctional Area text table4DESCNDescriptionnvarchar1320
38GRACGRCPITable to Activate GRCPI3DESCNDescriptionnvarchar1320
39GRACHRACTTCUP HR Action Description Text Table5DESCNLong Descriptionnvarchar2550
40GRACMTHACTIONTGRC ERM Methodology Action Text3DESCNDescriptionnvarchar1320
41GRACMTHTGRC ERM Methodology Text4DESCNMethodology Descriptionnvarchar1320
42GRACNAMECONVTNaming Convention text table4DESCNDescriptionnvarchar1320
43GRACORGLVLMPTOrg value Mapping Text Table4DESCNDescriptionnvarchar1320
44GRACORGRULETOrganization Rules text table4DESCNDescriptionnvarchar1320
45GRACOWNERTOwners Text7DESCNDescriptionnvarchar1320
46GRACPDPROFILETTable to store descriptions of pdprofile4DESCNLong Descriptionnvarchar2550
47GRACPRIORITYTPriority Description4DESCNDescriptionnvarchar1320
48GRACPROFILESYSTObselete -Table to store descriptions of profile per system.5DESCNLong Descriptionnvarchar2550
49GRACPROFILETTable to store descriptions of profile per system Type.5DESCNLong Descriptionnvarchar2550
50GRACPROJRELTProject Release Text Table4DESCNProject Release Descriptionnvarchar1320
51GRACPSSHRTPSS HR Verification Texts4DESCNLong Descriptionnvarchar2550
52GRACQUESTIONTQuestion Texts for Challenge Response4DESCNDescriptionnvarchar1320
53GRACREASONCODTText table for GRACREASONCOD table4DESCNDescriptionnvarchar2550
54GRACREJREASONTRejection reason text table4DESCNLong Descriptionnvarchar2550
55GRACREQTEMPLATETAccess request Templates Text Table4DESCNLong Descriptionnvarchar2550
56GRACREQTYPETRequest Type Short Description4DESCNDescriptionnvarchar1320
57GRACRISKLEVELTRisk Level Descriptions4DESCNDescriptionnvarchar1320
58GRACRLCMPLVLTComparison Level Text4DESCNComparison Level Descriptionnvarchar1320
59GRACRLCONNSTATTable to store descriptions of roles per system Type5DESCNLong Descriptionnvarchar2550
60GRACRLCONNTTable to store role description in backend system4DESCNDescriptionnvarchar1320
61GRACRLCONSTASTTable to store desc of roles per system in diff system5DESCNLong Descriptionnvarchar2550
62GRACRLCONSTASYSTTable to store descriptions of roles per system.5DESCNLong Descriptionnvarchar2550
63GRACRLMNTNTRole Maintenance Text3DESCNRole Maintenance Descriptionnvarchar1320
64GRACRLSENSTRole Sensitivity Text4DESCNDescriptionnvarchar1320
65GRACROLEPERMAUTHRole Permission Authorization Table6DESCNLong Descriptionnvarchar2550
66GRACROLETRole Descriptions4DESCNDescriptionnvarchar1320
67GRACROLETYPECRole type table for Customizing4DESCNDescriptionnvarchar1320
68GRACROLETYPETRole Type Text Table3DESCNRole Typenvarchar1320
69GRACROLSTATUSTRole Status Text table4DESCNRole Statusnvarchar1320
70GRACRULESETTRule Set Description4DESCNDescriptionnvarchar1320
71GRACSLATText Table for CUP SLA5DESCNLong Descriptionnvarchar2550
72GRACSODRISKTSOD Risk Description4DESCNDescriptionnvarchar1320
73GRACSTEPTGRC ERM Methodology Step Text4DESCNStep Descriptionnvarchar1320
74GRACSUPPRULETSupplement Rule Header4DESCNDescriptionnvarchar1320
75GRACUSERDEFAULTTText tabel for user default4DESCNLong Descriptionnvarchar2550
76GRFNDASHBTDashboard Information Text Table3DESCNDescriptionnvarchar1320
TOPGlobal Trade Services
77/SAPSLL/TDASHBOTInformation for Dashboards - Texts3DESCNDescriptive Text 80 Characters Longnvarchar800
TOPGRC Access Control Plug-In
78/GRCPI/GRIA_CONTConfiguration Text Table3DESCNdescriptionnvarchar1320