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

27 columns | Print definition?ERP 6.0  | QUEUE_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/PERS_QMSGAIF Persistence: Runtime Queue9QUEUE_NAMERuntime Config. Group IDnvarchar30
2/AIF/PERS_RTCFGRAIF Persistence: Runtime Configuration Group3QUEUE_NAMERuntime Config. Group IDnvarchar30
3/AIF/PERS_RTCFGTAIF Persistence: Runtime Configuration Group3QUEUE_NAMERuntime Config. Group IDnvarchar30
4/AIF/PERS_RUNAIF Persistence: Run5QUEUE_NAMERuntime Config. Group IDnvarchar30
5QRFC_I_QIN_LOCKLock Table for Parallel Entries in QRFC_I_QIN3QUEUE_NAMEQueue Name for Background RFCnvarchar400
6QRFC_O_QOUT_LOCKLock Table for Parallel Entries in QRFC_O_QOUT3QUEUE_NAMEQueue Name for Background RFCnvarchar400
TOPALE Integration Technology
7BDEOIO_INEOIO: Queue Management in IDoc Inbound Processing2QUEUE_NAMEEOIO: Technical Queue Namenvarchar320
8BDEOIO_OUTEOIO: Queue Management in IDoc Outbound Processing6QUEUE_NAMEEOIO: Technical Queue Namenvarchar320
TOPBackground RFC bgRFC
9BGRFC_IUNIT_HISTHistory of Inbound bgRFC Unit7QUEUE_NAMEQueue Name for Background RFCnvarchar400
10BGRFC_OUNIT_HISTHistory of Outbound bgRFC Unit7QUEUE_NAMEQueue Name for Background RFCnvarchar400
11BGRFC_SRV_STATEServer Status of bgRFC Units4QUEUE_NAMEQueue Name for Background RFCnvarchar400
12QRFC_I_QINInbound qRFC: Queue Order4QUEUE_NAMEQueue Name for Background RFCnvarchar400
13QRFC_I_QIN_TOPInbound qRFC Queue (Top Unit)3QUEUE_NAMEQueue Name for Background RFCnvarchar400
14QRFC_N_QOUTObsolete Table (No-send scenario not implemented) Do not use4QUEUE_NAMEQueue Name for Background RFCnvarchar400
15QRFC_N_QOUT_TOPObsolete Table (No-send scenario not implemented) Do not use3QUEUE_NAMEQueue Name for Background RFCnvarchar400
16QRFC_O_QINInbound qRFC: Queue Order2QUEUE_NAMEQueue Name for Background RFCnvarchar400
17QRFC_O_QOUTOutbound qRFC: Queue Order4QUEUE_NAMEQueue Name for Background RFCnvarchar400
18QRFC_O_QOUT_TOPOutbound qRFC Queue (Top Unit)3QUEUE_NAMEQueue Name for Background RFCnvarchar400
TOPMaintenance Processing
19MSAM_BGRFC_QUEUEdatabase table to configure BGRFC queues3QUEUE_NAMEMSAM Queue namesnvarchar300
TOPMass Load
20MDGD_LOG_HEADERMDG DataLoad Application Log Header10QUEUE_NAMECharacter Field of Length 12nvarchar120
TOPMaster Data Synchronization
21MDSE_CTRL_OPTSynchronization Options5QUEUE_NAMEQueue Name for Initial Loadnvarchar240
22MDSM_SYNC_HISTLoad History8QUEUE_NAMEName of tRFC Queuenvarchar240
TOPRFC
23LDQ_PROGRESSPointer Table of Local Data Queue (Start, Progress, End)3QUEUE_NAMEQueue Name for Local Data Queuenvarchar400
24LDQ_STATEStatus Values of LOCAL DATA QUEUE3QUEUE_NAMEQueue Name for Local Data Queuenvarchar400
TOPWeb Service and SOAP - ABAP
25SRT_EVENT_QUEUErelation between Parent Event message ID and bgRFC Queue ID2QUEUE_NAMEQueue Name for Background RFCnvarchar400
26SRT_UTIL_ERRLOGSRT Utilities: Error Log Data21QUEUE_NAMEQueue Name for Background RFCnvarchar400
27SRT_UTIL_LOGSRT Utilities: Error Log Data19QUEUE_NAMEQueue Name for Background RFCnvarchar400