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

26 columns | Print definition?ERP 6.0  | EXPIRY_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_BAT_HDRBatch master - Header table12EXPIRY_DATEShelf Life Expiration or Best-Before Datenvarchar80
2/IWBEP/SU_ERRLOGSUTIL Error Log8EXPIRY_DATEnvarchar80
3/IWBEP/SU_TPERFSUTIL Performance Trace6EXPIRY_DATEnvarchar80
4/IWBEP/SU_TPLOADSUTIL Payload Trace7EXPIRY_DATEnvarchar80
5/IWFND/SU_ERRLOGSUTIL Error Log8EXPIRY_DATEnvarchar80
6/IWFND/SU_TPERFSUTIL Performance Trace6EXPIRY_DATEnvarchar80
7/IWFND/SU_TPLOADSUTIL Payload Trace7EXPIRY_DATEnvarchar80
8/OTEI/RP_T_VARDTEFM Report Variants - Document types5EXPIRY_DATEOldest allowed datenvarchar80
9/XLSO/WAITLISTxLSO Table for maintaining waitlist related data9EXPIRY_DATEDatenvarchar80
10SWLT_STATIC_HSWLT: Static data - header11EXPIRY_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
11ZSRMPROTOCOLSRM protocol entries12EXPIRY_DATEExpiration Date of Lognvarchar80
TOPAuto-ID Infrastructure
12/AIN/DM_DOCTable with Document information.8EXPIRY_DATEExpiration Datedecimal150
TOPProcess Monitoring Infrastructure
13SSPIADMEVHISTORYHistory of Metrics Configuration4EXPIRY_DATEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPProduction and Revenue Accounting
14OIUT2_INTDObsolete: Ownership Interface Detail9EXPIRY_DATEExpiry Datenvarchar80
TOPProject System
15PSHLPDB_CACHE_CPStore changepointers for local cache6EXPIRY_DATEDate from Which Cached Data Is Invalidnvarchar80
16PSHLPDB_HIER_TMPTable to store temporary hierarchy data41EXPIRY_DATEDate from Which Cached Data Is Invalidnvarchar80
17PSHLPDB_OBJECTTable for storing object information for TREX indexing7EXPIRY_DATEDate from Which Cached Data Is Invalidnvarchar80
18PSHLP_CACHE_DBMaintains Project Cache Information11EXPIRY_DATECache Expiry Datenvarchar80
19PSHLP_CACHE_DB_NMaintains Project Cache Information11EXPIRY_DATECache Expiry Datenvarchar80
20PSHLP_HIER_DBLocal cache:Project/Independent Network hierarchy37EXPIRY_DATEDate from Which Cached Data Is Invalidnvarchar80
TOPRuntime Analysis
21SATR_DIRECTORYDirectory of SAT Trace Containers7EXPIRY_DATESAT: Delete Date of a Data Containernvarchar80
TOPSAP Records Management
22SRMPROTOCOLSRM protocol entries12EXPIRY_DATEExpiration Date of Lognvarchar80
TOPSAP Retail Store
23WSGR_ITEM_DB_TMPSRS GR: Temporary Persistence for Item Data10EXPIRY_DATEShelf Life Expiration or Best-Before Datenvarchar80
TOPTechnical Objects
24FLEETFleet Attributes9EXPIRY_DATEValidity end datenvarchar80
TOPWeb Dynpro ALV for ABAP
25SALV_CSQ_TR_HEADTrace heads20EXPIRY_DATEExpiry datenvarchar60
TOPWeb Service and SOAP - ABAP
26SRT_MMASTERWS message (Master table)14EXPIRY_DATESystem Datenvarchar80