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

36 columns | Print definition?ERP 6.0  | CHANGED_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_DLVY_HDRDelivery11CHANGED_DATEChange Datenvarchar80
2/GBT/O_HU_HDRHandling Unit Master - Header table11CHANGED_DATEChange Datenvarchar80
3/GBT/O_MDOC_HDRMaterial Document11CHANGED_DATEChange Datenvarchar80
4/GBT/O_PORD_HDRProduction Order for Tracking13CHANGED_DATEChange Datenvarchar80
5/GBT/O_PURO_HDRPurchasing Document11CHANGED_DATEChange Datenvarchar80
6/GBT/O_SALO_HDRSales Document11CHANGED_DATEChange Datenvarchar80
7/XFT/DIO_MON_AM1Alert Management: Local Settings for Process Type5CHANGED_DATEField of type DATSnvarchar80
8/XFT/DIO_MON_PTPJob Process: Local Settings for Process Type - Deactivation5CHANGED_DATEField of type DATSnvarchar80
9/XFT/DIO_MON_PTZJob Process: Local Setting Proc. Type - Execution Timeframe7CHANGED_DATEField of type DATSnvarchar80
10BBP_SUPP_MONIVendor Monitor for Changed Data13CHANGED_DATEDate of Last Changenvarchar80
11CNV_10993_FORMRSResult table for Forms20CHANGED_DATEDate of Changenvarchar80
12CNV_10993_RESHDRCoding Scan Result header table17CHANGED_DATEDate of Changenvarchar80
13CNV_10993_RESULTCoding Scan 10993 Search Run Result Table16CHANGED_DATESearch Datenvarchar80
14CRM_ICI_TRACES_Hstorage for SOAP traces in ICI: session level attributes14CHANGED_DATEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
15SNHI_DU_PROXYHANA Integration: Proxy for a HANA Delivery Unit7CHANGED_DATEField of type DATSnvarchar80
16TBAC_DCSDerivative contract specification customizing table10CHANGED_DATELast Changed onnvarchar80
TOPBasic Functions
17BIW_EMMA_CASEDelta Queue for Process Statistics for Clarification Cases21CHANGED_DATEChanged onnvarchar80
18EMMAC_CCAT_HDRClarification Case Categories23CHANGED_DATEChanged onnvarchar80
19EMMA_CASEClarification Case31CHANGED_DATEChanged onnvarchar80
TOPBatches
20MCHCLBatch Class Conversion9CHANGED_DATESystem Datenvarchar80
TOPMaintenance Orders
21/MRSS/D_SQM_KHQualification Catalog: Header Data13CHANGED_DATELast changed onnvarchar80
22/MRSS/D_SQM_MHQualification Matrix11CHANGED_DATELast changed onnvarchar80
TOPMarket Risk Analyzer
23TCCT_CCURVE_FUTCommodity Curve Futures Style Master Data10CHANGED_DATEChanged onnvarchar80
24TCCT_CCURVE_MASTCommodity Curve Master Data29CHANGED_DATEChanged onnvarchar80
TOPMobile Applications
25/ISDFPS/MECADCRFDocument Reference Data8CHANGED_DATEChanged onnvarchar80
TOPPersonnel Administration
26T599CReport Categories22CHANGED_DATEChanged onnvarchar80
TOPPersonnel Management
27/BKC/S21_T599CShadow table of T599C22CHANGED_DATEChanged onnvarchar80
TOPSAP Query
28TEXC_DEText ID: Exception Definiton using Data Element10CHANGED_DATEChanged Onnvarchar80
29TEXC_DE_CText ID: Exception Definiton using Data Element10CHANGED_DATEChanged Onnvarchar80
30TEXC_DOMText ID: Exception Definition using Domains10CHANGED_DATEChanged Onnvarchar80
31TEXC_DOM_CText ID: Exception Definition using Domains10CHANGED_DATEChanged Onnvarchar80
32TEXC_FLDText ID: Exception Definition using Table/Field11CHANGED_DATEChanged Onnvarchar80
33TEXC_FLD_CText ID: Exception Definition using Table/Field11CHANGED_DATEChanged Onnvarchar80
TOPTools
34HRPYO_D_STATSCHNReason for status change3CHANGED_DATEChanged Onnvarchar80
TOPTransaction Manager
35TRCOT_CTY_MASTERCommodity master data17CHANGED_DATEChanged onnvarchar80
TOPTreasury
36ATCOVOCommodity Price Volatilities8CHANGED_DATEChanged onnvarchar80