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  | UCF6020
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.0UCF60201051C/I: Global SettingsBusiness Consolidation
SQL:  selectupdate insert create

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

SELECT MANDT, AREA, INVVAL, EQUVAL, EQIVAL, COILV, PUACHK, ESHFLG, NINVFLG, NMINFLG, ODAYR, ODAPE, ODAIND, ODAACC1, HISTPOST_RFSID, HISTPOST_RVSID, MINADJ_RFSID, MINADJ_RVSID, GWTBEGFLG, XRINDGWBS, XRINDGWIS, CTKEYGWIS, 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, GWAACC6, GWAACC7, GWDACC1, GWDACC1M, GWDACC2, GWDACC3, GWDACC4, GWRACC1, GWRACC1M, GWRACC1BG, GWRACC1CY, GWRACC2, GWRACC3, GWRACC4, GWRACC5, GWRACC6, NGAACC1, NGAACC1M, NGAACC1BG, NGAACC1CY, NGAACC2, NGAACC2BG, NGAACC2CY, NGAACC3, NGAACC4, NGAACC5, NGAACC6, NGAACC7, NGDACC1, NGDACC1M, NGDACC2, NGDACC3, NGDACC4, NGRACC1, NGRACC1M, NGRACC1BG, NGRACC1CY, NGRACC2, NGRACC3, NGRACC4, NGRACC5, NGRACC6, CLREQUACC, CLRMINACC, NINVRESACC FROM UCF6020
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AREAConsolidation Areanvarchar20CHAR(N' ')NoUCF600CUC_AREA Allow NULL? 
3INVVALLocation of Values - Investmentschar10CHAR(N' ')YesUC_INVVAL Allow NULL? 
4EQUVALLocation of Values - Equitychar10CHAR(N' ')YesUC_EQUVAL Allow NULL? 
5EQIVALLocation of Values - Equity Methodchar10CHAR(N' ')YesUC_EQIVAL Allow NULL? 
6COILVCalculation Base for Consolidation of Investmentschar10CHAR(N' ')YesUC_COILV Allow NULL? 
7PUACHKCheck Push-down Goodwillchar10CHAR(N' ')YesUC_PUACHK Allow NULL? 
8ESHFLGNet Display of Statement of Stockholders' Equitychar10CHAR(N' ')YesUC_ESHFLG Allow NULL? 
9NINVFLGAllow Negative Investmentschar10CHAR(N' ')YesUC_NINVFLG Allow NULL? 
10NMINFLGNo Calculation of Minority Interestchar10CHAR(N' ')YesUC_NMINFLG Allow NULL? 
11ODAYRFiscal Year of Legacy Data Transfernvarchar40NUMC(N'0000')YesUC_ODAYR Allow NULL? 
12ODAPEPeriod of Legacy Data Transfernvarchar30NUMC(N'000')YesUC_ODAPE Allow NULL? 
13ODAINDDifference from Legacy Data Transfer in Indirect Activitieschar10CHAR(N' ')YesUC_ODAIND Allow NULL? 
14ODAACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
15HISTPOST_RFSIDFIN Master Data: SID of Field Namesint100INT4((0))Yes*UG_FIELDNAME_SID Allow NULL? 
16HISTPOST_RVSIDFIN Master Data: Surrogate IDint100INT4((0))Yes*UG_SID Allow NULL? 
17MINADJ_RFSIDFIN Master Data: SID of Field Namesint100INT4((0))Yes*UG_FIELDNAME_SID Allow NULL? 
18MINADJ_RVSIDFIN Master Data: Surrogate IDint100INT4((0))Yes*UG_SID Allow NULL? 
19GWTBEGFLGGoodwill Currency Translation at Beginning of Periodchar10CHAR(N' ')YesUC_GWTBEGFLG Allow NULL? 
20XRINDGWBSGoodwill in LC: Exchange Rate Indicator for Balance Sheetchar10CHAR(N' ')Yes*UC_XRINDGWBS Allow NULL? 
21XRINDGWISGoodwill in LC: Exchange Rate Indicator for Income Statementchar10CHAR(N' ')Yes*UC_XRINDGWIS Allow NULL? 
22CTKEYGWISGoodwill in LC: Currency Translation Key - Income Statementnvarchar20CHAR(N' ')Yes*UC_CTKEYGWIS Allow NULL? 
23GWAYRLife of Goodwill Amortization in Yearsnvarchar20NUMC(N'00')YesUC_GWAYR Allow NULL? 
24GWAPELife of Goodwill Amortization in Periodsnvarchar30NUMC(N'000')YesUC_GWAPE Allow NULL? 
25GWABGStart of Amortization of New Goodwillchar10CHAR(N' ')YesUC_GWABG Allow NULL? 
26GWARFLGAmortization of New Goodwill over Remaining Lifechar10CHAR(N' ')YesUC_GWARFLG Allow NULL? 
27GWALFLGLimit for Amortization of Goodwillchar10CHAR(N' ')YesUC_GWALFLG Allow NULL? 
28GWAMETHAmortization Methodchar10NUMC(N'0')YesUC_DEPMETH Allow NULL? 
29GWAPCNTPercentage Rate of Amortizationdecimal118DEC((0))YesUC_DEPPCNT
30GWRYRLife of Periodic Reduction of Goodwill in Yearsnvarchar20NUMC(N'00')YesUC_GWRYR Allow NULL? 
31GWRPELife of Periodic Reduction of Goodwill in Periodsnvarchar30NUMC(N'000')YesUC_GWRPE Allow NULL? 
32GWRBGStart of Periodic Reduction of New Goodwillchar10CHAR(N' ')YesUC_GWRBG Allow NULL? 
33GWRRFLGReduce New Goodwill over Its Remaining Lifechar10CHAR(N' ')YesUC_GWRRFLG Allow NULL? 
34GWRLFLGLimit for Periodic Reduction of Goodwillchar10CHAR(N' ')YesUC_GWRLFLG Allow NULL? 
35GWRMETHAmortization Methodchar10NUMC(N'0')YesUC_DEPMETH Allow NULL? 
36GWRPCNTPercentage Rate of Amortizationdecimal118DEC((0))YesUC_DEPPCNT
37NGAYRLife of Amortization of Negative Goodwill in Yearsnvarchar20NUMC(N'00')YesUC_NGAYR Allow NULL? 
38NGAPELife of Amortization of Negative Goodwill in Periodsnvarchar30NUMC(N'000')YesUC_NGAPE Allow NULL? 
39NGABGStart of Amortization of New Negative Goodwillchar10CHAR(N' ')YesUC_NGABG Allow NULL? 
40NGARFLGAmortize New Negative Goodwill over Remaining Useful Lifechar10CHAR(N' ')YesUC_NGARFLG Allow NULL? 
41NGALFLGLimit for Amortization of Negative Goodwillchar10CHAR(N' ')YesUC_NGALFLG Allow NULL? 
42NGAMETHAmortization Methodchar10NUMC(N'0')YesUC_DEPMETH Allow NULL? 
43NGAPCNTPercentage Rate of Amortizationdecimal118DEC((0))YesUC_DEPPCNT
44NGRYRLife of Periodic Reduction of Negative Goodwill in Yearsnvarchar20NUMC(N'00')YesUC_NGRYR Allow NULL? 
45NGRPELife of Periodic Reduction of Negative Goodwill in Periodsnvarchar30NUMC(N'000')YesUC_NGRPE Allow NULL? 
46NGRBGStart of Reduction of New Negative Goodwillchar10CHAR(N' ')YesUC_NGRBG Allow NULL? 
47NGRRFLGReduce New Negative Goodwill over Its Remaining Useful Lifechar10CHAR(N' ')YesUC_NGRRFLG Allow NULL? 
48NGRLFLGLimit for Periodic Reduction of Negative Goodwillchar10CHAR(N' ')YesUC_NGRLFLG Allow NULL? 
49NGRMETHAmortization Methodchar10NUMC(N'0')YesUC_DEPMETH Allow NULL? 
50NGRPCNTPercentage Rate of Amortizationdecimal118DEC((0))YesUC_DEPPCNT
51GWAACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
52GWAACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
53GWAACC1BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
54GWAACC1CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
55GWAACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
56GWAACC2BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
57GWAACC2CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
58GWAACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
59GWAACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
60GWAACC5GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
61GWAACC6GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
62GWAACC7GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
63GWDACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
64GWDACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
65GWDACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
66GWDACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
67GWDACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
68GWRACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
69GWRACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
70GWRACC1BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
71GWRACC1CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
72GWRACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
73GWRACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
74GWRACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
75GWRACC5GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
76GWRACC6GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
77NGAACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
78NGAACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
79NGAACC1BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
80NGAACC1CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
81NGAACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
82NGAACC2BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
83NGAACC2CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
84NGAACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
85NGAACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
86NGAACC5GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
87NGAACC6GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
88NGAACC7GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
89NGDACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
90NGDACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
91NGDACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
92NGDACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
93NGDACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
94NGRACC1GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
95NGRACC1MGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
96NGRACC1BGGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
97NGRACC1CYGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
98NGRACC2GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
99NGRACC3GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
100NGRACC4GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
101NGRACC5GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
102NGRACC6GUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
103CLREQUACCGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
104CLRMINACCGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
105NINVRESACCGUID to Identify Posting Rulenvarchar220CHAR(N' ')YesUC_ACCID Allow NULL? 
NamePrimaryUniqueTypeColumns
UCF6020~0YesYesCLUSTEREDMANDT, AREA

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