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

25 columns | Print definition?ERP 6.0  | REQUNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DBESTA_BWTRIGOrder for Updating BW Sales Statistics9REQUNRRequest Number of Creation of BI Extraction Ordernvarchar300
2DBESTA_BWTRIGESingle Order for Updating BW Sales Statistics6REQUNRRequest Number of Creation of BI Extraction Ordernvarchar300
TOPBilling in Contract Accounts Receivable and Payable
3DFKKBI_BWTRIGHBI: History Records for Extraction6REQUNRRequest number for the data transfernvarchar300
TOPBusiness Accounting
4URBWTSRealigner: Processed Time Intervals3REQUNRRequest number for the data transfernvarchar300
TOPBW Service API
5ROREQUESTPRMSRequest Attributes (Source System)1REQUNRRequest number for the data transfernvarchar300
6RORQSTATTRRequest Attributes1REQUNRRequest number for the data transfernvarchar300
7RORQSTPRMSProtokolltable Request1REQUNRRequest number for the data transfernvarchar300
8ROSTOPInterruption of Current Load Process1REQUNRRequest number for the data transfernvarchar300
TOPData Basis
9RSDMDENQLocking of master data tables / text tables3REQUNRRequest number for the data transfernvarchar300
TOPGeneral Ledger Accounting
10FAGL_BW_LOG_HEADFI-GL: Log for BW Extraction: Control Data3REQUNRRequest number for the data transfernvarchar300
11FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items3REQUNRRequest number for the data transfernvarchar300
12FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records3REQUNRRequest number for the data transfernvarchar300
13FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis52REQUNRRequest number for the data transfernvarchar300
TOPHR Information Systems
14HRMS_BIW_PPDELTABW: Delta management for posting-data extractors6REQUNRRequest number for the data transfernvarchar300
TOPInvoicing in Contract Accounts Receivable and Payable
15DFKKINV_BWTRIGHBI: History Record for Extraction of Invoicing Documents6REQUNRRequest number for the data transfernvarchar300
TOPMarketing
16ERCHV_BW_PROTLog of BW Extraction for Consumptions6REQUNRRequest number for the data transfernvarchar300
TOPProfitability Analysis
17TKEBWLGNCO-PA Connectn to SAP BW: Status Information for InfoSource14REQUNRRequest number for the data transfernvarchar300
18TKEBWLOGActivity Log CO-PA Extractor for SAP BW5REQUNRRequest number for the data transfernvarchar300
19TKEBWLOGNActivity Log CO-PA Extractor for SAP BW6REQUNRRequest number for the data transfernvarchar300
20TKEBWTSCO-PA Connection to SAP BW: Processed Time Intervals3REQUNRRequest number for the data transfernvarchar300
21TKEBWTSNCO-PA Connection to SAP BW: Processed Time Intervals5REQUNRRequest number for the data transfernvarchar300
TOPStatistics
22DBESTA_BWPROTLog Recordc for BW Sales Statistics Update8REQUNRRequest Number of Creation of BI Extraction Ordernvarchar300
23DBESTA_BWPROTESingle Document Log Record of BW Sales Statistics5REQUNRRequest Number of Creation of BI Extraction Ordernvarchar300
24DBESTA_BWPROTHHistory Record for Extraction to BW Sales Statistics5REQUNRRequest number for the data transfernvarchar300
TOPWithout Description
25RSENQMDREQULock table for master data upload4REQUNRRequest number for the data transfernvarchar300