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

Home | ERP 6.0  | TF600
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
Enterprise Controlling :: Consolidation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TF600631Consolidation of Investments MethodsConsolidation
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DIMEN, COIMETH, COITP, USGAAP, GWPROC, NGPROC, GWLCFLG, GWIEFLG, HIREXC, GWNEXC, GWAEXC, GWDEXC, GWREXC, NGNEXC, NGAEXC, NGDEXC, NGREXC, NEQEXC, NINVFLG, NMINFLG, HRREV, HRSHA, HRSITYP, HRAQDSI, HRDPCSI, HRDPDSI, NHSITYP, NHAQCSI, NHDPDSI, NHDPCSI, GWAYR, GWAPE, GWABG, GWARFLG, GWALFLG, GWALVAL, GWALCUR, GWAMETH, GWRYR, GWRPE, GWRBG, GWRRFLG, GWRLFLG, GWRLVAL, GWRLCUR, GWRMETH, NGAYR, NGAPE, NGABG, NGARFLG, NGALFLG, NGALVAL, NGALCUR, NGAMETH, NGRYR, NGRPE, NGRBG, NGRRFLG, NGRLFLG, NGRLVAL, NGRLCUR, NGRMETH FROM TF600
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2DIMENDimensionnvarchar20CHAR(N' ')NoTF150FC_DIMEN Allow NULL? 
3COIMETHMethodnvarchar50CHAR(N' ')NoTF550FC_CMETH Allow NULL? 
4COITPAccounting technique for the consolidation of investmentschar10CHAR(N' ')YesFC_COITP Allow NULL? 
5USGAAPCalculate acquisitions with direct shares/group shareschar10CHAR(N' ')YesFC_USGAAP Allow NULL? 
6GWPROCTreatment of Goodwillchar10CHAR(N' ')YesFC_GWPROC Allow NULL? 
7NGPROCTreatment of negative goodwillchar10CHAR(N' ')YesFC_NGPROC Allow NULL? 
8GWLCFLGCarry Goodwill in Local Currencychar10CHAR(N' ')YesFC_GWLCFLG Allow NULL? 
9GWIEFLGPost Goodwill at Investee Unitchar10CHAR(N' ')YesFC_GWIEFLG Allow NULL? 
10HIREXCException for fair value adjustmentschar10CHAR(N' ')YesFC_HIREXC Allow NULL? 
11GWNEXCException Goodwill Extraordinary Amortizationchar10CHAR(N' ')YesFC_GWNEXC Allow NULL? 
12GWAEXCException Goodwill Ordinary Amortizationchar10CHAR(N' ')YesFC_GWAEXC Allow NULL? 
13GWDEXCException for direct elimination of goodwillchar10CHAR(N' ')YesFC_GWDEXC Allow NULL? 
14GWREXCException for periodic reduction of goodwillchar10CHAR(N' ')YesFC_GWREXC Allow NULL? 
15NGNEXCException Negative Goodwill Extraordinary Amortizationchar10CHAR(N' ')YesFC_NGNEXC Allow NULL? 
16NGAEXCException Negative Goodwill Ordinary Amortizationchar10CHAR(N' ')YesFC_NGAEXC Allow NULL? 
17NGDEXCException for direct elimination of negative goodwillchar10CHAR(N' ')YesFC_NGDEXC Allow NULL? 
18NGREXCException for periodic reduction of negative goodwillchar10CHAR(N' ')YesFC_NGREXC Allow NULL? 
19NEQEXCException for Negative Stockholders' Equitychar10CHAR(N' ')YesFC_NEQEXC Allow NULL? 
20NINVFLGEnable negative investmentschar10CHAR(N' ')YesFC_NINVFLG Allow NULL? 
21NMINFLGNo calculation of minority interestchar10CHAR(N' ')YesFC_NMINFLG Allow NULL? 
22HRREVProcedure for eliminating hidden reserves/contingencies(FVA)char10CHAR(N' ')YesFC_HRREV Allow NULL? 
23HRSHAScope of elimination of hidden reserves/contingencieschar10CHAR(N' ')YesFC_HRSHA Allow NULL? 
24HRSITYPSubitem category for hidden reserves (fair value adjustment)nvarchar30CHAR(N' ')YesTF110FC_HRSITYP Allow NULL? 
25HRAQDSISubitem for transferring hidden reserves (fair value adj.)nvarchar100CHAR(N' ')YesTF115FC_HRAQDSI Allow NULL? 
26HRDPCSISubitem for amortization of hidden reserves (fair value adj)nvarchar100CHAR(N' ')YesTF115FC_HRDPCSI Allow NULL? 
27HRDPDSISubitem for writeups of hidden reserves (fair value adj.)nvarchar100CHAR(N' ')YesTF115FC_HRDPDSI Allow NULL? 
28NHSITYPSubitem category for hidden contingencies (fair value adj.)nvarchar30CHAR(N' ')YesTF110FC_NHSITYP Allow NULL? 
29NHAQCSISubitem for transferring hidden contingencies (fair val.adj)nvarchar100CHAR(N' ')YesTF115FC_NHAQCSI Allow NULL? 
30NHDPDSISubitem for changes to hidden contingencies - debitnvarchar100CHAR(N' ')YesTF115FC_NHDPDSI Allow NULL? 
31NHDPCSISubitem for changes to hidden contingencies - creditnvarchar100CHAR(N' ')YesTF115FC_NHDPCSI Allow NULL? 
32GWAYRLife of goodwill amortization in yearsnvarchar20NUMC(N'00')YesFC_GWAYR Allow NULL? 
33GWAPELife of goodwill amortization in monthsnvarchar30NUMC(N'000')YesFC_GWAPE Allow NULL? 
34GWABGStart date for the amortization of new goodwillchar10CHAR(N' ')YesFC_GWABG Allow NULL? 
35GWARFLGAmortize new goodwill over remaining lifechar10CHAR(N' ')YesFC_GWARFLG Allow NULL? 
36GWALFLGThreshold value for the amortization of goodwillchar10CHAR(N' ')YesFC_GWALFLG Allow NULL? 
37GWALVALThreshold value for the amortization of goodwilldecimal172CURR((0))YesFC_GWALVAL
38GWALCURGroup currency for threshold for goodwill amortizationnvarchar50CUKY(N' ')YesTCURCFC_GWALCUR Allow NULL? 
39GWAMETHAmortization methodchar10NUMC(N'0')YesFC_DEPMETH Allow NULL? 
40GWRYRLife of the periodic reduction of goodwill - yearsnvarchar20NUMC(N'00')YesFC_GWRYR Allow NULL? 
41GWRPELife of periodic reduction of goodwill - monthsnvarchar30NUMC(N'000')YesFC_GWRPE Allow NULL? 
42GWRBGBeginning date of the periodic reduction of new goodwillchar10CHAR(N' ')YesFC_GWRBG Allow NULL? 
43GWRRFLGReduce the new goodwill over its remaining lifechar10CHAR(N' ')YesFC_GWRRFLG Allow NULL? 
44GWRLFLGThreshold value for the periodic reduction of goodwillchar10CHAR(N' ')YesFC_GWRLFLG Allow NULL? 
45GWRLVALThreshold value for the periodic reduction of goodwilldecimal172CURR((0))YesFC_GWRLVAL
46GWRLCURGroup currency for threshold for periodic reduction of GWnvarchar50CUKY(N' ')YesTCURCFC_GWRLCUR Allow NULL? 
47GWRMETHAmortization methodchar10NUMC(N'0')YesFC_DEPMETH Allow NULL? 
48NGAYRLife of amortization of negative goodwill in yearsnvarchar20NUMC(N'00')YesFC_NGAYR Allow NULL? 
49NGAPELife of amortization of negative goodwill in monthsnvarchar30NUMC(N'000')YesFC_NGAPE Allow NULL? 
50NGABGBeginning date of amortization of new negative goodwillchar10CHAR(N' ')YesFC_NGABG Allow NULL? 
51NGARFLGAmortization of new negative goodwill over remain. lifechar10CHAR(N' ')YesFC_NGARFLG Allow NULL? 
52NGALFLGThreshold for amortization of negative goodwillchar10CHAR(N' ')YesFC_NGALFLG Allow NULL? 
53NGALVALThreshold for amortization of negative goodwilldecimal172CURR((0))YesFC_NGALVAL
54NGALCURGroup currency f. threshold of neg. goodwill amortizationnvarchar50CUKY(N' ')YesTCURCFC_NGALCUR Allow NULL? 
55NGAMETHAmortization methodchar10NUMC(N'0')YesFC_DEPMETH Allow NULL? 
56NGRYRLife of periodic reduction of negative goodwill - yearsnvarchar20NUMC(N'00')YesFC_NGRYR Allow NULL? 
57NGRPELife of periodic reduction of negative goodwill - monthsnvarchar30NUMC(N'000')YesFC_NGRPE Allow NULL? 
58NGRBGBeginning date of the reduction of new negative goodwillchar10CHAR(N' ')YesFC_NGRBG Allow NULL? 
59NGRRFLGReduce new negative goodwill over its remaining lifechar10CHAR(N' ')YesFC_NGRRFLG Allow NULL? 
60NGRLFLGThreshold for periodic reduction of negative goodwillchar10CHAR(N' ')YesFC_NGRLFLG Allow NULL? 
61NGRLVALThreshold for periodic reduction of negative goodwilldecimal172CURR((0))YesFC_NGRLVAL
62NGRLCURGroup currency of threshold for periodic reduction of neg.GWnvarchar50CUKY(N' ')YesTCURCFC_NGRLCUR Allow NULL? 
63NGRMETHAmortization methodchar10NUMC(N'0')YesFC_DEPMETH Allow NULL? 
NamePrimaryUniqueTypeColumns
TF600~0YesYesCLUSTEREDMANDT, DIMEN, COIMETH

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy