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

43 columns | Print definition?ERP 6.0  | BWBER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____003HSID-Tabelle fuer Valuation Area3BWBERValuation Area for FI Year-End Closingnvarchar20
2/SMD/MD_____00ZKSID-Tabelle fuer Valuation Area3BWBERValuation Area for FI Year-End Closingnvarchar20
3/SMD/MD_____011RSID-Tabelle fuer Value adjustment4BWBERValuation Area for FI Year-End Closingnvarchar20
4CNV_10510_FCVMAPMappingtable for conversion of foreign currencies7BWBERFI depreciation areasnvarchar20
5DFKK_ACCADJAdjustment Postings when Implementing Acct Assgmt Chars24BWBERValuation Area for FI-CA Year-End Closingnvarchar30
6DFKK_NEWACCADJObsolete: See DFKK_ACCADJ24BWBERValuation Area for FI-CA Year-End Closingnvarchar30
7FAGL_BSBW_HISTLGValuation History of Ledger-Group-Specific Items7BWBERValuation Area for FI Year-End Closingnvarchar20
8T030HBAcct Determ.for Open Item Exch.Rate Differences3BWBERValuation Area for FI Year-End Closingnvarchar20
9T033UAccount Determ.for Balance Sheet Transfer Postings4BWBERValuation Area for FI Year-End Closingnvarchar20
TOPContract Accounts Receivable and Payable
10DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment9BWBERValuation Area for FI-CA Year-End Closingnvarchar30
11DFKKFWBEWManagement Data for Foreign Currency Valuations12BWBERValuation Area for FI-CA Year-End Closingnvarchar30
12DFKKFWBEW_LDManagement Data for Ledger-Specific Foreign Crcy Valuations13BWBERValuation Area for FI-CA Year-End Closingnvarchar30
13DFKKZWDoubtful/Individual Val. Adjust. for Receivables - Trigger29BWBERValuation Area for FI-CA Year-End Closingnvarchar30
14DFKKZWFHDoubtful/Individually Adjusted Receivables: History5BWBERValuation Area for FI-CA Year-End Closingnvarchar30
15DFKKZWFPDoubtful/Individually Adjusted Receivables: Tfrd Receivables6BWBERValuation Area for FI-CA Year-End Closingnvarchar30
16DFKKZWFPTLog Table for Mass Activ. for Tfr Posting of Dbt Rec/IVAs8BWBERValuation Area for FI-CA Year-End Closingnvarchar30
17DFKKZWFTDoubtful/Individually Adjusted Receivables: Trigger Table5BWBERValuation Area for FI-CA Year-End Closingnvarchar30
18DFKK_DUEGRIDOI - Reclassifications29BWBERValuation Area for FI-CA Year-End Closingnvarchar30
19DFKK_RECLASSOI - Reclassifications23BWBERValuation Area for FI-CA Year-End Closingnvarchar30
20TFK020VKFS Preparation: Summarization Accounts for Reclassification3BWBERValuation Area for FI-CA Year-End Closingnvarchar30
21TFK044FI-CA Valuation Area3BWBERValuation Area for FI-CA Year-End Closingnvarchar30
22TFK044DFI-CA Company Code Valuation7BWBERValuation Area for FI-CA Year-End Closingnvarchar30
23TFK044TName of Valuation Area4BWBERValuation Area for FI-CA Year-End Closingnvarchar30
TOPFinancial Accounting
24BSBMDocument Valuation Fields7BWBERValuation Area for FI Year-End Closingnvarchar20
25BSBMTText for Valuation Adjustment or Deductible per Item7BWBERValuation Area for FI Year-End Closingnvarchar20
26BSBWDocument Valuation Fields7BWBERValuation Area for FI Year-End Closingnvarchar20
27F107_TPROVProvisions6BWBERValuation Area for FI Year-End Closingnvarchar20
28SLPBLog Table for Valuation7BWBERValuation Area for FI Year-End Closingnvarchar20
29T030UAccount Determ.for Balance Sheet Transfer Postings3BWBERValuation Area for FI Year-End Closingnvarchar20
30T033FI Depreciation Area2BWBERValuation Area for FI Year-End Closingnvarchar20
31T033TFI Depreciation Area3BWBERValuation Area for FI Year-End Closingnvarchar20
32T044HTFlat-rate Value Adjustment of Individual Documents (Text)8BWBERValuation Area for FI Year-End Closingnvarchar20
33TACC_BWBER_PRAssignment of Accounting Principle to Target Ledger2BWBERValuation Area for FI Year-End Closingnvarchar20
TOPGeneral Ledger Accounting
34FAGL_BSBW_HISTRYValuation History for Documents7BWBERValuation Area for FI Year-End Closingnvarchar20
35FAGL_BSBW_HST_BLValuation History of Balances6BWBERValuation Area for FI Year-End Closingnvarchar20
36FAGL_DRPROV_ACCProvisions for Doubtful Receivables: Account Determination3BWBERValuation Area for FI Year-End Closingnvarchar20
37FAGL_DRPROV_METHProvision Method for Provisons for Doubtful Receivables2BWBERValuation Area for FI Year-End Closingnvarchar20
38FAGL_DRPROV_PERCProvisions for Doubtful Receivables: Percentages2BWBERValuation Area for FI Year-End Closingnvarchar20
39FAGL_T030TRCustomizing for Balance Translation3BWBERValuation Area for FI Year-End Closingnvarchar20
TOPGeneral Ledger Reorganization
40FAGL_R_APARReorganization: Object List for Receivables and Payables37BWBERValuation Area for FI Year-End Closingnvarchar20
TOPInformation System
41BWPOSValuations for Open Items15BWBERValuation Area for FI Year-End Closingnvarchar20
42T044GValuation Adjustment Key3BWBERValuation Area for FI Year-End Closingnvarchar20
43T044JPreference Key for Reading Valuation Results5BWBERValuation Area for FI Year-End Closingnvarchar20