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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

44 columns | Print definition?ERP 6.0  | REQ_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHHSSD_PRQ_REQProcess Control - RAS Request11REQ_IDRequester ID for Risk Assessment Requestnvarchar400
2EHPRCD_ICH4Chapter 4 Data45REQ_IDRequest IDnvarchar90
3EHPRCD_PBB_CR_RQRequested + ass. relevant Comp. Requirem10REQ_IDCompliance Requirement (Check)nvarchar100
4GRACBUSROLESNAPBusiness Role Snapshot2REQ_IDUUID of the GRC object (char32)nvarchar320
5GRACEXTRISKExternal Risk2REQ_IDUUID of the GRC object (char32)nvarchar320
6GRACFUNUSAGESOD Function Usage2REQ_IDUUID of the GRC object (char32)nvarchar320
7GRACMITUSERARUser mitigating control assignment for Access Request3REQ_IDReport IDnvarchar500
8GRACMITUSERORGARUser Org mitigating control assignment for Access Request4REQ_IDReport IDnvarchar500
9GRACMITUSER_ARObsolete13REQ_IDUUID of the GRC object (char32)nvarchar320
10GRACMITUSRORG_ARObsolete14REQ_IDUUID of the GRC object (char32)nvarchar320
11GRACREQRequest Header2REQ_IDUUID of the GRC object (char32)nvarchar320
12GRACREQOMOBJITEMHR OM Object assigned to request2REQ_IDUUID of the GRC object (char32)nvarchar320
13GRACREQOWNERRequest Owners Details2REQ_IDUUID of the GRC object (char32)nvarchar320
14GRACREQPROVITEMLine Items Associated with Request2REQ_IDUUID of the GRC object (char32)nvarchar320
15GRACREQPROVLOGRequest Provsioning Log4REQ_IDUUID of the GRC object (char32)nvarchar320
16GRACREQSYSTEMApplication Associated with Request2REQ_IDUUID of the GRC object (char32)nvarchar320
17GRACREQUSERUser Associated with Request2REQ_IDUUID of the GRC object (char32)nvarchar320
18GRACREQUSERADRUser Communication Fields2REQ_IDUUID of the GRC object (char32)nvarchar320
19GRACREQUSERGROUPObselete -- User Groups2REQ_IDUUID of the GRC object (char32)nvarchar320
20GRACREQUSERGRPUser Groups2REQ_IDUUID of the GRC object (char32)nvarchar320
21GRACREQUSERPARAMObselete -- Request User Parameters2REQ_IDUUID of the GRC object (char32)nvarchar320
22GRACREQUSERPRMRequest User Parameters2REQ_IDUUID of the GRC object (char32)nvarchar320
23GRACREQUSERSYSRequest Licence Data2REQ_IDUUID of the GRC object (char32)nvarchar320
24GRACREQUSRPASSRequest User Password3REQ_IDUUID of the GRC object (char32)nvarchar320
25GRACREVITEMReview Request related items2REQ_IDUUID of the GRC object (char32)nvarchar320
26GRACREVREJUSERReject user table for UAR requests2REQ_IDUUID of the GRC object (char32)nvarchar320
27GRACSODREVIEWItem Table for SOD Request2REQ_IDUUID of the GRC object (char32)nvarchar320
28GRACSODUSERROLEUser Roles For SOD Functions3REQ_IDUUID of the GRC object (char32)nvarchar320
29HRP1107DB Table for Infotype 110718REQ_IDRequisition IDnvarchar480
30HRSFI_D_RCT_LOGSuccessFactors: Staging Area for Recruiting Import4REQ_IDRequisition IDnvarchar480
31HRSFI_D_RCT_REQChange Pointer Table for Job Requisitions13REQ_IDRequisition IDnvarchar480
TOPBusiness Process Change Analyzer
32E2ET_AT_REC_TRIDTBOM Recording by eCATT: Trace IDs7REQ_IDNatural Numberint100
TOPCommunication Services Mail, Fax, SMS, Telephony
33SRIRREQATTBCOM Interaction Routing: Request Attributes3REQ_IDBCOM Routing: Request IDnvarchar320
34SRIRREQUESTBCOM Interaction Routing: Requests3REQ_IDBCOM Routing: Request IDnvarchar320
TOPEnvironment, Health and Safety
35/TDAG/CPA_ICH4Chapter 4 Data43REQ_IDRequest IDnvarchar90
TOPSAP Business Workflow
36SWP_HEADERWorkflow Instances: Header Data of a Workflow Execution9REQ_IDWorkflow instances: ID of the requester of a workflow exec.nvarchar900
TOPWeb Service and SOAP - ABAP
37SRT_MONILOG_DATASOAP Runtime Table for Monitoring and Log Data Records36REQ_IDGUID in 'CHAR' Format in Uppercasenvarchar320
38SRT_MONLOG_DATA2SOAP Runtime Table for Monitoring and Log Data Records36REQ_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPWorkforce Management Application
39WFACS_REQACTIONSrequest actions3REQ_IDrequest idnvarchar320
40WFACS_REQMSGSrequest messages: warnings, errors, etc3REQ_IDrequest idnvarchar320
41WFACS_REQUESTScalculation requests3REQ_IDrequest idnvarchar320
TOPWorkforce Management Core
42WFDCS_REQACTIONSrequest actions3REQ_IDrequest idnvarchar320
43WFDCS_REQMSGSrequest messages: warnings, errors, etc3REQ_IDrequest idnvarchar320
44WFDCS_REQUESTScalculation requests3REQ_IDrequest idnvarchar320