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  | UCF6300
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
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

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