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

34 columns | Print definition?ERP 6.0  | METHD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10510_FCVMAPMappingtable for conversion of foreign currencies8METHDRevaluation methods in FInvarchar30
2FAGL_BSBW_HISTLGValuation History of Ledger-Group-Specific Items8METHDValuation Methods in Financial Accountingnvarchar30
3T5QT1Australia Tax - Calculation methods6METHDTax Methodnvarchar50
4TCMAC07EException for Due Date Schedule8METHDInstallment Procedure for Due Date Schedule Exceptionnvarchar10
5TCMAC07MTDefinition for methods of DDS2METHDInstallment Procedure for Due Date Schedule Exceptionnvarchar10
TOPCanada
6PA0095HR Master Record: Infotype 0095 (Tax Canada)30METHDTaxation methodnvarchar10
TOPCompensation Management
7T71GDDimension Table5METHDMethods for compensation matrix dimensionsnvarchar10
8T71GMMethods for Matrix Dimensions2METHDMethods for compensation matrix dimensionsnvarchar10
9T71GMTText Table for Dimension Method3METHDMethods for compensation matrix dimensionsnvarchar10
TOPFinancial Accounting
10BSBMDocument Valuation Fields8METHDValuation Methods in Financial Accountingnvarchar30
11BSBMTText for Valuation Adjustment or Deductible per Item8METHDValuation Methods in Financial Accountingnvarchar30
12BSBWDocument Valuation Fields8METHDValuation Methods in Financial Accountingnvarchar30
13SLPBLog Table for Valuation8METHDValuation Methods in Financial Accountingnvarchar30
14T044HTFlat-rate Value Adjustment of Individual Documents (Text)9METHDValuation Methods in Financial Accountingnvarchar30
TOPFinland
15T7FISSeniority Allowance Attributes (Finland)4METHDSeniority allowance handling method (Finland)nvarchar30
TOPGeneral Ledger Accounting
16FAGL_BSBW_HISTRYValuation History for Documents8METHDValuation Methods in Financial Accountingnvarchar30
17FAGL_BSBW_HST_BLValuation History of Balances7METHDValuation Methods in Financial Accountingnvarchar30
TOPIndia
18T7INP3Method and form fayout for states6METHDMethod to be callednvarchar80
TOPInformation System
19T044KTFurther Specifications for Sorted List3METHDSort Methodnvarchar40
20T044LSorted List of Open Items2METHDSort Methodnvarchar40
21T044LHSort Methods2METHDSort Methodnvarchar40
22T044LTSorted List of Open Items3METHDSort Methodnvarchar40
TOPJapan
23T5JR0Definition of Retirement Liquidation/Allowance Items(JP)8METHDMethodnvarchar300
TOPPayroll General Parts
24T506DConditions for Employee Loans18METHDInterest Calculation Methodnvarchar10
TOPPension fund General Parts
25T5CA6PC Method Types4METHDPC method typenvarchar20
26T5CA7PC Method Type Names5METHDPC method typenvarchar20
27T5CA8PC Method Determination7METHDPC method typenvarchar20
28T5CA9PC Method Variant Determination5METHDPC method typenvarchar20
29T5CAGPC Method Definitions6METHDPC method typenvarchar20
30T5CAOLine Selection of Processing Schedules6METHDPC method typenvarchar20
31T5CC0PC Method Steps Add-Ons6METHDPC method typenvarchar20
TOPReuse Services for Country Development
32T799BPP03Pension Calculation Methods3METHDPension Calculation Method IDnvarchar40
33T799BPP03TTexts for Pension Calculation Methods4METHDPension Calculation Method IDnvarchar40
34T799BPP04Pension Calculation Schema8METHDPension Calculation Method IDnvarchar40