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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financials :: Strategic Enterprise Management :: Business Consolidation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0UCF63001001C/I: MethodsBusiness Consolidation
SQL:  selectupdate insert create

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

SELECT MANDT, METHID, COITP, USGAAP, EQIGSH, GWLCFLG, GWIEFLG, GWIEFLG_INDI, GWMINADJ_INDI, GWFULLFLG, GWPROC, NGPROC, GWNEXC, GWAEXC, GWWEXC, GWDEXC, GWREXC, NGNEXC, NGAEXC, NGWEXC, NGDEXC, NGREXC, NEQEXC, NINVFLG, NMINFLG, GWAYR, GWAPE, GWABG, GWARFLG, GWALFLG, GWAMETH, GWAPCNT, GWRYR, GWRPE, GWRBG, GWRRFLG, GWRLFLG, GWRMETH, GWRPCNT, NGAYR, NGAPE, NGABG, NGARFLG, NGALFLG, NGAMETH, NGAPCNT, NGRYR, NGRPE, NGRBG, NGRRFLG, NGRLFLG, NGRMETH, NGRPCNT, GWAACC1, GWAACC1M, GWAACC1BG, GWAACC1CY, GWAACC2, GWAACC2BG, GWAACC2CY, GWAACC3, GWAACC4, GWAACC5, GWAACC7, GWDACC1, GWDACC1M, GWDACC2, GWDACC4, GWRACC1, GWRACC1M, GWRACC1BG, GWRACC1CY, GWRACC2, GWRACC3, GWRACC4, NGAACC1, NGAACC1M, NGAACC1BG, NGAACC1CY, NGAACC2, NGAACC2BG, NGAACC2CY, NGAACC3, NGAACC4, NGAACC5, NGAACC7, NGDACC1, NGDACC1M, NGDACC2, NGDACC4, NGRACC1, NGRACC1M, NGRACC1BG, NGRACC1CY, NGRACC2, NGRACC3, NGRACC4, CLREQUACC, CLRMINACC, NINVRESACC FROM UCF6300
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2METHIDGUID for Identifying the Methodnvarchar220CHAR(N' ')NoUC_METHID Allow NULL? 
3COITPAccounting Technique for Consolidation of Investmentschar10CHAR(N' ')YesUC_COITP Allow NULL? 
4USGAAPCalculate Acquisitions with Direct Shares or Group Shareschar10CHAR(N' ')YesUC_USGAAP Allow NULL? 
5EQIGSHEquity Adjustment with Group Share or Direct Investmentchar10CHAR(N' ')YesUC_EQIGSH Allow NULL? 
6GWLCFLGRecord Goodwill in Local Currencychar10CHAR(N' ')YesUC_GWLCFLG Allow NULL? 
7GWIEFLGPost Goodwill to Investee Unitchar10CHAR(N' ')YesUC_GWIEFLG Allow NULL? 
8GWIEFLG_INDIPost Indirect Differential to Investee Unitchar10CHAR(N' ')YesUC_GWIEFLG_INDI Allow NULL? 
9GWMINADJ_INDIMinority Interest in Differential in Indirect Activitieschar10CHAR(N' ')YesUC_GWMINADJ_INDI Allow NULL? 
10GWFULLFLGActivate Full Goodwillchar10CHAR(N' ')YesUC_GWFULLFLG Allow NULL? 
11GWPROCTreatment of Goodwillchar10CHAR(N' ')YesUC_GWPROC Allow NULL? 
12NGPROCTreatment of Negative Goodwillchar10CHAR(N' ')YesUC_NGPROC Allow NULL? 
13GWNEXCException for Extraordinary Amortizion of Goodwillchar10CHAR(N' ')YesUC_GWNEXC Allow NULL? 
14GWAEXCException for Ordinary Amortization of Goodwillchar10CHAR(N' ')YesUC_GWAEXC Allow NULL? 
15GWWEXCException for Direct Writeoff of Goodwillchar10CHAR(N' ')YesUC_GWWEXC Allow NULL? 
16GWDEXCException for Direct Elimination of Goodwillchar10CHAR(N' ')YesUC_GWDEXC Allow NULL? 
17GWREXCException for Periodic Reduction of Goodwillchar10CHAR(N' ')YesUC_GWREXC Allow NULL? 
18NGNEXCException for Extraordinary Amortization of Neg. Goodwillchar10CHAR(N' ')YesUC_NGNEXC Allow NULL? 
19NGAEXCException for Ordinary Amortization of Negative Goodwillchar10CHAR(N' ')YesUC_NGAEXC Allow NULL? 
20NGWEXCException for Direct Writeoff of Negative Goodwillchar10CHAR(N' ')YesUC_NGWEXC Allow NULL? 
21NGDEXCException for Direct Elimination of Negative Goodwillchar10CHAR(N' ')YesUC_NGDEXC Allow NULL? 
22NGREXCException for Periodic Reduction of Negative Goodwillchar10CHAR(N' ')YesUC_NGREXC Allow NULL? 
23NEQEXCException for Negative Stockholders' Equitychar10CHAR(N' ')YesUC_NEQEXC Allow NULL? 
24NINVFLGAllow Negative Investmentschar10CHAR(N' ')YesUC_NINVFLG Allow NULL? 
25NMINFLGNo Calculation of Minority Interestchar10CHAR(N' ')YesUC_NMINFLG Allow NULL? 
26GWAYRLife of Goodwill Amortization in Yearsnvarchar20NUMC(N'00')YesUC_GWAYR Allow NULL? 
27GWAPELife of Goodwill Amortization in Periodsnvarchar30NUMC(N'000')YesUC_GWAPE Allow NULL? 
28GWABGStart of Amortization of New Goodwillchar10CHAR(N' ')YesUC_GWABG Allow NULL? 
29GWARFLGAmortization of New Goodwill over Remaining Lifechar10CHAR(N' ')YesUC_GWARFLG Allow NULL? 
30GWALFLGLimit for Amortization of Goodwillchar10CHAR(N' ')YesUC_GWALFLG Allow NULL? 
31GWAMETHAmortization Methodchar10NUMC(N'0')YesUC_DEPMETH Allow NULL? 
32GWAPCNTPercentage Rate of Amortizationdecimal118DEC((0))YesUC_DEPPCNT
33GWRYRLife of Periodic Reduction of Goodwill in Yearsnvarchar20NUMC(N'00')YesUC_GWRYR Allow NULL? 
34GWRPELife of Periodic Reduction of Goodwill in Periodsnvarchar30NUMC(N'000')YesUC_GWRPE Allow NULL? 
35GWRBGStart of Periodic Reduction of New Goodwillchar10CHAR(N' ')YesUC_GWRBG Allow NULL? 
36GWRRFLGReduce New Goodwill over Its Remaining Lifechar10CHAR(N' ')YesUC_GWRRFLG Allow NULL? 
37GWRLFLGLimit for Periodic Reduction of Goodwillchar10CHAR(N' ')YesUC_GWRLFLG Allow NULL? 
38GWRMETHAmortization Methodchar10NUMC(N'0')YesUC_DEPMETH Allow NULL? 
39GWRPCNTPercentage Rate of Amortizationdecimal118DEC((0))YesUC_DEPPCNT
40NGAYRLife of Amortization of Negative Goodwill in Yearsnvarchar20NUMC(N'00')YesUC_NGAYR Allow NULL? 
41NGAPELife of Amortization of Negative Goodwill in Periodsnvarchar30NUMC(N'000')YesUC_NGAPE Allow NULL? 
42NGABGStart of Amortization of New Negative Goodwillchar10CHAR(N' ')YesUC_NGABG Allow NULL? 
43NGARFLGAmortize New Negative Goodwill over Remaining Useful Lifechar10CHAR(N' ')YesUC_NGARFLG Allow NULL? 
44NGALFLGLimit for Amortization of Negative Goodwillchar10CHAR(N' ')YesUC_NGALFLG Allow NULL? 
45NGAMETHAmortization Methodchar10NUMC(N'0')YesUC_DEPMETH Allow NULL? 
46NGAPCNTPercentage Rate of Amortizationdecimal118DEC((0))YesUC_DEPPCNT
47NGRYRLife of Periodic Reduction of Negative Goodwill in Yearsnvarchar20NUMC(N'00')YesUC_NGRYR Allow NULL? 
48NGRPELife of Periodic Reduction of Negative Goodwill in Periodsnvarchar30NUMC(N'000')YesUC_NGRPE Allow NULL? 
49NGRBGStart of Reduction of New Negative Goodwillchar10CHAR(N' ')YesUC_NGRBG Allow NULL? 
50NGRRFLGReduce New Negative Goodwill over Its Remaining Useful Lifechar10CHAR(N' ')YesUC_NGRRFLG Allow NULL? 
51NGRLFLGLimit for Periodic Reduction of Negative Goodwillchar10CHAR(N' ')YesUC_NGRLFLG Allow NULL? 
52NGRMETHAmortization Methodchar10NUMC(N'0')YesUC_DEPMETH Allow NULL? 
53NGRPCNTPercentage Rate of Amortizationdecimal118DEC((0))YesUC_DEPPCNT
54GWAACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
55GWAACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
56GWAACC1BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
57GWAACC1CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
58GWAACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
59GWAACC2BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
60GWAACC2CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
61GWAACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
62GWAACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
63GWAACC5GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
64GWAACC7GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
65GWDACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
66GWDACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
67GWDACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
68GWDACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
69GWRACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
70GWRACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
71GWRACC1BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
72GWRACC1CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
73GWRACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
74GWRACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
75GWRACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
76NGAACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
77NGAACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
78NGAACC1BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
79NGAACC1CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
80NGAACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
81NGAACC2BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
82NGAACC2CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
83NGAACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
84NGAACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
85NGAACC5GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
86NGAACC7GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
87NGDACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
88NGDACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
89NGDACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
90NGDACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
91NGRACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
92NGRACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
93NGRACC1BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
94NGRACC1CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
95NGRACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
96NGRACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
97NGRACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
98CLREQUACCGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
99CLRMINACCGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
100NINVRESACCGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
NamePrimaryUniqueTypeColumns
UCF6300~0YesYesCLUSTEREDMANDT, METHID