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

59 columns | Print definition?ERP 6.0  | REQUEST_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/SU_ERRLOGSUTIL Error Log41REQUEST_IDnvarchar1000
2/IWBEP/SU_TPERFSUTIL Performance Trace17REQUEST_IDnvarchar1000
3/IWBEP/SU_TPLOADSUTIL Payload Trace19REQUEST_IDnvarchar1000
4/IWFND/SU_ERRLOGSUTIL Error Log41REQUEST_IDnvarchar1000
5/IWFND/SU_TPERFSUTIL Performance Trace22REQUEST_IDnvarchar1000
6/IWFND/SU_TPLOADSUTIL Payload Trace20REQUEST_IDnvarchar1000
7DMC_CONN_ODQMWB: Connection to ODQ system4REQUEST_IDODQ request iddecimal239
8DODR_DB_STMTDBOSC-DR: Direct SQL Request Statements4REQUEST_IDDBOSC-CR: Namenvarchar300
9DORQ_FIELDDBOSC-RQ: Request Fields5REQUEST_IDDBOSC-CR: Generated ID (30)nvarchar300
10DORQ_OPTIONDBOSC-RQ: Request Options5REQUEST_IDDBOSC-CR: Generated ID (30)nvarchar300
11DORQ_PROPDBOSC-RQ: Request Properties3REQUEST_IDDBOSC-CR: Generated ID (30)nvarchar300
12DORQ_REQUESTDBOSC-RQ: Request5REQUEST_IDDBOSC-CR: Generated ID (30)nvarchar300
13DOUI_MAP_FIELDDBOS Cockpit: Mapping Between UI and Request5REQUEST_IDDBOSC-CR: Generated ID (30)nvarchar300
14DOUI_MAP_KEYVALDBOS Cockpit: Mapping Between UI and Request5REQUEST_IDDBOSC-CR: Generated ID (30)nvarchar300
15DOUI_MAP_RQSTDBOS Cockpit: Mapping Between UI and Request4REQUEST_IDDBOSC-CR: Generated ID (30)nvarchar300
16GRFNMWRTINSTAPPLMSMP Runtime - Application Specific Attributes4REQUEST_IDObject IDnvarchar500
17IUUC_ODQ_PARAMODQ queue selection parameters1REQUEST_IDODQ request iddecimal239
18IUUC_ODQ_PRJODQ request parameters1REQUEST_IDODQ request iddecimal239
19IUUC_ODQ_TABLEStables for processing as ODQ provider1REQUEST_IDODQ request iddecimal239
20IUUC_ODQ_TAB_HIShistory of requests2REQUEST_IDODQ request iddecimal239
21MRP_REQ_LINEDate and Quantity Values for Change Requests2REQUEST_IDGlobally Unique Identifiervarbinary160
22MRP_REQ_NOTERequests and Notes for MRP Cockpit2REQUEST_IDGlobally Unique Identifiervarbinary160
23PTREQ_APPROVERApprovers for Leave Request2REQUEST_IDDocument IDnvarchar320
24PTREQ_ATTACHMENTAttachment2REQUEST_IDDocument IDnvarchar320
25SCTS_TRACK_DGPONDGP: Objects to be enabled for DGP2REQUEST_IDRequest/Tasknvarchar200
26SCTS_TRACK_LOCKcCTS: abstraction of TLOCK persistence2REQUEST_IDRequest/Tasknvarchar200
27SCTS_TRACK_MAINcCTS: Main persistence for object level tracking2REQUEST_IDRequest/Tasknvarchar200
28SCTS_TRACK_UPQUEcCTS: Object tracking update queue1REQUEST_IDRequest/Tasknvarchar200
TOPArchiveLink
29OAPRISAP ArchiveLink: Temporary table for print parameters1REQUEST_IDSAP ArchiveLink: Reference characternvarchar400
30TOAR7SAP ArchiveLink: Request table (asynchronous storage)3REQUEST_IDSAP ArchiveLink: Unique request numbernvarchar100
TOPAuthentication and SSO
31SAML2_REQUESTStorage Table for SAML2 Requests and RelayState6REQUEST_IDSAML2 Request Identifierntext10737418230
TOPBusiness Context Viewer
32/BCV/C_ESCONEnterprise Search Connectors4REQUEST_IDSearch Request IDnvarchar320
33/BCV/D_QREQRESQuery mapping between requests and results2REQUEST_IDQuery Request IDnvarchar320
TOPCommunication Services Mail, Fax, SMS, Telephony
34BCSD_ENVIDMapping Envelope ID - Request ID2REQUEST_IDGlobally Unique Identifiervarbinary160
TOPData Basis
35RSODSODELFSRequests (in Faststores) that are regarded as deleted2REQUEST_IDRequest ID (Request Number)nvarchar300
TOPData Replication Framework
36FOX3_EXPLODER_DBFOX Explosions2REQUEST_IDFOX Request IDnvarchar100
37FOX3_REQUEST_DBFOX Requests2REQUEST_IDFOX Request IDnvarchar100
TOPGuided Procedure
38EUP_TSP_REQGuided Procedure Transport Requests2REQUEST_IDCharacter field, length 32nvarchar320
39EUP_TSP_REQ_CONTGuided Procedure Transport Request Content2REQUEST_IDCharacter field, length 32nvarchar320
40EUP_TSP_REQ_TXTGuided Procedure Transport Request Texts2REQUEST_IDCharacter field, length 32nvarchar320
TOPInformation System
41FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW167REQUEST_IDRequest number for the data transfernvarchar300
TOPPatient Management
42N1TC_ACCESS_LOGLog of Access to Treatment Contracts Applied for3REQUEST_IDID of Treatment Contract Applicationnvarchar320
43N1TC_BUFFERTable for Saving Treatment Contract Checks9REQUEST_IDID of Treatment Contract Applicationnvarchar320
44N1TC_BUFFER_PAPTable of TC Checks for Patients with Provisional Data7REQUEST_IDID of Treatment Contract Applicationnvarchar320
45N1TC_REQUESTTemporary Treatment Contracts Applied for2REQUEST_IDID of Treatment Contract Applicationnvarchar320
TOPPersonnel Time Management
46PTARQ_DEDUCTIONDeduction Data for Attendances and Absences2REQUEST_IDDocument IDnvarchar320
47PTREQ_HEADERRequest Header2REQUEST_IDDocument IDnvarchar320
48PTREQ_NOTICENote for Request2REQUEST_IDDocument IDnvarchar320
TOPPlanning
49RSPLS_LOG_REQMapping save ID and InfoCube to corresponding request3REQUEST_IDRequest number for the data transfernvarchar300
TOPPosition Budgeting and Control
50HRFPM_FPM_POSHRFPM: FPM Documents - Items49REQUEST_IDChange Identificationnvarchar160
TOPQuery Management
51/PLMPCV/D_REQ_IDQuery request ID3REQUEST_IDQuery Request IDnvarchar320
52/PLMPCV/D_RESULTQuery result cluster3REQUEST_IDQuery Request IDnvarchar320
TOPSearch Integration
53/PLMPCV/C_ESCONEnterprise Search Connectors4REQUEST_IDSearch Request IDnvarchar320
TOPStructures Workbench
54/ISDFPS/FDP_WFSTWorkflow Status for Cross-System Material Requisitions2REQUEST_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPTransport Organizer
55CTS_IMP_Q_STATEState of import queue for last dependency calculation2REQUEST_IDRequest/Tasknvarchar200
TOPTransport Registry
56TRN_REG_REQUESTSTransport Requests/Tasks per Application/Service Group4REQUEST_IDRequest/Tasknvarchar200
57TRN_REG_TASKSTransport Requests/Tasks per Application and Service Group5REQUEST_IDTransport Requestnvarchar200
TOPWeb Service and SOAP - ABAP
58SRT_MIDOCWS message (specific for adapter type IDoc)3REQUEST_IDIDoc Request IDnvarchar160
TOPWorkforce Management Core
59WFMFC_PER_REQMANPersistence Request Manager for Forecasting2REQUEST_IDForecasting Manager Request Idnvarchar320