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

47 columns | Print definition?ERP 6.0  | TIME_STAMP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/HDB_MON_HISHistory Monitoring Data4TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
2/UI2/CACHE_STATSUI2 cache statistics2TIME_STAMPTime stampdecimal150
3DMC_MDS_STATUSStatus table for all maintenance events5TIME_STAMPSystem Timenvarchar60
4FIBKRUD_BALANCEFI Banking Russia: Totals Records4TIME_STAMPTime Stamp for Totals Record in Cash Journalnvarchar200
5GRFNADJUSTMENTSLog of executed adjustments3TIME_STAMPTime Stampdecimal150
6GRRMANALDRS5DRS5 Risk Analysis3TIME_STAMPDSR5 Analysis - Time Stamp (UTC)decimal150
7GRRMANALYSIS_TSAnalysis Table3TIME_STAMPTime Stampdecimal150
8GRRMANASSMNTAssessment Table4TIME_STAMPTime Stampdecimal150
9GRRMANDATAAnalysis Data3TIME_STAMPTime Stampdecimal150
10GRRMANLSAUTEHSRAAnalysis Automation - EH&S Risk Assessment Mapping5TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
11GRRMANMITIGMitigation values3TIME_STAMPTime Stampdecimal150
12GRRMANRESPAnalysis response values3TIME_STAMPTime Stampdecimal150
13GRRMRESPResponse attributes3TIME_STAMPTime Stampdecimal150
14GRRMRESPOBJSTResponse automation status tracking4TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
15GRRMRESPTEXTResponse long texts3TIME_STAMPTime Stampdecimal150
16SRT_CC_CHANGES_HCentral Configuration Med Changes - History2TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
17TLRT_TARO_MMFMismatched fields reported by trade repository4TIME_STAMPnvarchar250
18ZPPMC_CPL_T_COSTplanning positions of project for bapis18TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPAccounts Receivable Accounting Process Integration
19FDM_BW_INV_DELTADelta Queue for BI Invoice Extractor6TIME_STAMPTime Stamp for Upload of BI Deltadecimal150
TOPApplication-Specific Upgrade
20UACC_RESTARTTable for restart logic of steps5TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPBank Accounting
21TCJ_BALANCEFI Cash Journal: Totals Records5TIME_STAMPTime Stamp for Totals Record in Cash Journalnvarchar200
TOPBusiness Partners
22TNBPMIGPARAMSParameters for BP Migration11TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPDSD Connector
23/DSD/ME_TRANS_HDDSD Connector: Administration of the Transmission14TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPEnd User Technology
24RSVHSVALUESETValue help services user setting A segment16TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPFinancial Accounting
25/OPT/VIM_1HEADDocument Header195TIME_STAMPAFTCS Validation TimeStampdecimal150
TOPFSCM In-House Cash
26IHC_TAB_ARCH_IDXIHC: Archive Index Table5TIME_STAMPIHC: Archive Index, Time Stampnvarchar210
TOPMonitoring
27ALSLDCTRLCCMS Access to Standard SLD - X Not Possible, 0 Possible4TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPNetWeaver Business Content
28BIZC_AREA_REGBusiness Content: Usage => Shared Objects Server4TIME_STAMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPNetWeaver Demonstration
29SDEMO_DGRUNProtocol Table for Data Generator Runs2TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
30SNWD_DG_RESULTSEPM: Data Generator Results2TIME_STAMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPNetWeaver Enterprise Search
31ESH_TST_HBT_SIMAutomated Hub Tests: Simulation: Recording8TIME_STAMPAutomated Hub Tests: Timestamp of Recordingdecimal150
TOPOLAP Technology
32RSDDTZA_STATISTTREX Service Statistics1TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPPersonnel Time Management
33T7TIM_IF_OBJ_ADMAdministration of Generated Interface Objects5TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
34T7TIM_MAP_RPTIMEInformation on Implementation of DO_IMPORT5TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPPlanning
35RSPLS_PM_LOGPlanning Modeler: Log4TIME_STAMPField of type TIMSnvarchar60
TOPPortfolio Management
36/RPM/OBJ_MIGRDocuments, which xRPM 2.0 objects were migrated5TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPPurchasing
37CRS_PURCHITM_MAPMapping of CRM purchase assignments to preq items6TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPRemaining Beverage - Obsolete Objects
38/DSD/ME_TOUR_STIDSD Connector: Tour Status - Detail Administration3TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSAP Business Workflow
39WFSTOWorkflow: Work list5TIME_STAMPWorkflow: Time stampnvarchar140
TOPSearch
40/PLMB/SEA_QUERYSearch query head6TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPVendor Master
41CDATAChange Data7TIME_STAMPTime changednvarchar60
TOPWeb Dynpro ABAP
42WDY_CONFIG_APPLConfiguration Data for Web Dynpro Components11TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPWorkbench Tools Editors, Painters, Modelers
43ADT_EXCEPTIONLOGURI mapping exceptions protocoll3TIME_STAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPWorkforce Management Application
44WFAFC_FCST_STATHistory of forecasting3TIME_STAMPTime Stampdecimal150
TOPWorkforce Management Core
45WFMFC_FCST_STATHistory of forecasting3TIME_STAMPTime Stampdecimal150
46WFMFC_FORCST_STAForecasting Status (obsolete)4TIME_STAMPTime Stampdecimal150
47WFMFC_OPTIMZLOGSOptimization Logs3TIME_STAMPStart Time Stampdecimal150