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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

53 columns | Print definition?ERP 6.0  | DELTA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20317_DATBIDetermination for date dependent tables16DELTADelta Entry - inserted in Downtimenvarchar10
2IUUC_TRACK_HDRIUUC: Tracking for Delta Replay6DELTAMWB: Number of Recordsdecimal120
3T5FDSNREMTemp table for PAYFR_RESULT-REM26DELTAPaie : Montant de la DELTA rémunérationdecimal152
4T5QR0Australia tax - Retro processing characteristics and BF / CF9DELTADelta formation on the basis of Model or technical wagetypenvarchar10
5WFAFC_CALCPARAMSForecasting method parameters - Y*,Z* reserved for customers12DELTAMAD (mean absolute deviation) smoothing using delta factordecimal32
6T7PIQOFFERPATDEFSession Pattern Definition5DELTAInterval in Academic Yearsnvarchar10
TOPBasic Functions
7BIW_EMMA_CASEDelta Queue for Process Statistics for Clarification Cases2DELTAGUID in 'RAW' formatvarbinary160
8T863XSelections for reporting13DELTADelta selection indicatornvarchar10
9T884MCurrency translation methods used in Consolidation11DELTAOnly post diff. between group cur. value and reference valuenvarchar10
TOPBusiness Package for Manager Self-Service FI
10FPB_LP6_FOL_UTTexts for Folder for User6DELTASingle-Character Indicatornvarchar10
11FPB_LP6_F_R_UCFolder <---> Reports Assignment7DELTASingle-Character Indicatornvarchar10
12FPB_LP6_O_F_UCContexts <--> Folder for User Assignment5DELTASingle-Character Indicatornvarchar10
13FPB_LP6_REP_U_TTexts for Reports for Users7DELTASingle-Character Indicatornvarchar10
14FPB_LP6_R_RW_UCParameters for Report Writer for Users11DELTASingle-Character Indicatornvarchar10
15FPB_LP6_R_TRA_UCParameters for Transactions for Users11DELTASingle-Character Indicatornvarchar10
TOPBW Service API
16RODELTAMBW Delta Process1DELTADelta Process for a DataSourcenvarchar40
17RODELTAMTBW Delta Process (Text)2DELTADelta Process for a DataSourcenvarchar40
18ROOSOURCETable Header for SAP BW OLTP Sources (Relevant From 2.0)6DELTADelta Process for a DataSourcenvarchar40
TOPCATT Computer Aided Test Tool
19CAT_FDATACATT contents for field lists in CAT_FINFO5DELTASingle-Character Indicatornvarchar10
TOPCost Center Accounting
20COPLNCTRLControl Data for Planning Source9DELTAIndicator: Add up New and Existing Valuesnvarchar10
TOPData Staging
21RSDSDataSource in BW11DELTADelta Process for a DataSourcenvarchar40
22RSDSSHDataSource in BW - Shadow Table9DELTADelta Process for a DataSourcenvarchar40
23RSOLTPSOURCEReplicate Table for OLTP Sources in BW7DELTADelta Process for a DataSourcenvarchar40
24RSOLTPSOURCESHShadow Table: Replica Table for OLTP Sources in BW7DELTADelta Process for a DataSourcenvarchar40
25RSSRCTYPE_MAPBehavior of Source System Types9DELTASource system can deliver deltanvarchar10
TOPFinancials Basis
26UGR31021FIN Master Data: Buffer Table for DataSource Properties5DELTAFIN Master Data: DataSource Delta Processnvarchar40
TOPFunds Management
27BPVKDocument Header for Parked Documents12DELTAUpdate of Delta Valuesnvarchar10
TOPGeneral Ledger Accounting
28FAGL_FCV_ADMINForeign Currency Valuation: ID Numbers of Valuation Runs14DELTAYear-End Valuation (No Reversal)nvarchar10
TOPInformation system
29FMBWDELTACustomizing Table for Controlling Delta-Update3DELTAFlag: Delta update supportednvarchar10
TOPInformation System
30FTI_MARKET_VALSReporting: Buffer Table for Market Values - Position Crcy23DELTADelta, 1st derivation of premium based on underlying ratedecimal1510
31T881ISFI-SL Ledger4DELTASingle-Character Indicatornvarchar10
32T881IS_PIAssignment of TT/SI DataSource for FI-SL Ledger (Plug-In)4DELTASingle-Character Indicatornvarchar10
TOPIntegration Engine
33SXMSQUEUE_REORGStorage Location for Queues That Are Being Reorganized5DELTAdecimal100
TOPInventory Controlling
34PROPForecast parameters16DELTAMAD (mean absolute deviation) smoothing using delta factordecimal32
TOPMaterial Master
35MPOP_TMPFile for Incorrect Data in Direct Input18DELTAMAD (mean absolute deviation) smoothing using delta factordecimal32
36MPRPForecast Profiles19DELTAMAD (mean absolute deviation) smoothing using delta factordecimal32
37MVOPMaterial data material versions15DELTAMAD (mean absolute deviation) smoothing using delta factordecimal32
TOPMonitoring
38ALPFREP_DATTable for PerfDB Report Data5DELTANatural Numberint100
TOPNetwork and Activity
39MLSTMilestone31DELTAOffset for milestone datedecimal50
40SMLSStandard milestone13DELTAOffset between standard milestone and activity datesdecimal50
TOPOLAP Technology
41RSDDBIDXSTATStatus Table of Index in BIA6DELTABooleannvarchar10
TOPOperational Data Provisioning ODP
42RODPS_REPL_SELSelections on Queues for Enterprise Search4DELTADelta Using Selective Deletion and Insertionnvarchar10
TOPPatient Accounting
43TN27IS-H: Revenue Accrual Posting Parameters10DELTAIS-H: Interval after Discharge for Accrual Closingnvarchar30
TOPPegging, Grouping, and Distribution
44DIS_ADMINDistribution - Administration Table27DELTAProcessing Mode: "X" - Only Changed Objects Selectednvarchar10
TOPPlanning
45RSPLS_CR_PROPCharacteristic Relationships: Settings9DELTABooleannvarchar10
TOPPosition Budgeting and Control
46HRBWDELTACustomizing Table for Controlling Delta-Update3DELTAFlag: Delta update supportednvarchar10
TOPProduction Planning for Process Industries
47DTEFWDowntime Values Entered17DELTALast Changeddecimal133
TOPProject System
48PLM_PS_MA_MLST_CPLM PS MiniApp for Milestone Customizing2DELTAWarning Interval of Milestonedecimal50
TOPRisk Analysis
49JBRBDSVARRM-BDS: VaR Data8DELTARM Report Data Memory: Delta Positionfloat1516
TOPSimulation
50VSMLST_CNVersion: Milestone32DELTAOffset for milestone datedecimal50
TOPTime Sheet
51TCATX_COMPONENTSCATX: Task Components9DELTAIncrementdecimal83
52TCATX_COMP_DTLCATX: Component Details8DELTAIncrementdecimal83
TOPWarranties
53BGMZWarranty Counter12DELTAWarranty counter valuefloat1516