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  | TF692
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
Enterprise Controlling :: Consolidation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TF6921011Global Chart of Accounts-Based Settings for C/IConsolidation
SQL:  selectupdate insert create

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

SELECT MANDT, DIMEN, ITCLG, GWAAQDI, GWAAQDT, GWAAQDS, GWAAQCTPYS, GWAAQCTCYS, GWAOFFSDI, GWAOFFSDT, GWAOFFSDS, GWAOFFSCS, GWAAQCI, GWAAQCT, GWADPCS, GWADPDS, GWADPCTPYS, GWADPCTCYS, GWAAMDI, GWAAMDT, GWAAMDS, GWAAMCI, GWAAMCT, GWAAMCS, GWASTAT, GWASTATCT, GWASTATOFFS, GWRAQDI, GWRAQDT, GWRAQDS, GWRAQCS, GWROFFSDI, GWROFFSDT, GWROFFSDS, GWROFFSCS, GWRAMDI, GWRAMDT, GWRAMDS, GWRAMCI, GWRAMCT, GWRAMCS, GWRSTAT, GWRSTATOFFS, GWDAQDI, GWDAQDT, GWDAQDS, GWDOFFSDI, GWDOFFSDT, GWDOFFSDS, GWDOFFSCS, GWDSTAT, GWDSTATOFFS, NGAAQDI, NGAAQDT, NGAAQDS, NGAAMCTPYS, NGAAMCTCYS, NGAOFFSDI, NGAOFFSDT, NGAOFFSDS, NGAOFFSCS, NGAAQCI, NGAAQCT, NGADPCS, NGADPDS, NGADPCTPYS, NGADPCTCYS, NGAAMDI, NGAAMDT, NGAAMDS, NGAAMCI, NGAAMCT, NGAAMCS, NGASTAT, NGASTATCT, NGASTATOFFS, NGRAQDI, NGRAQDT, NGRAQDS, NGRAQCS, NGROFFSDI, NGROFFSDT, NGROFFSDS, NGROFFSCS, NGRAMDI, NGRAMDT, NGRAMDS, NGRAMCI, NGRAMCT, NGRAMCS, NGRSTAT, NGRSTATOFFS, NGDAQCI, NGDAQCT, NGDAQCS, NGDOFFSDI, NGDOFFSDT, NGDOFFSDS, NGDOFFSCS, NGDSTAT, NGDSTATOFFS FROM TF692
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DIMENDimensionnvarchar20 Allow NULL? 
3ITCLGConsolidation chart of accountsnvarchar20 Allow NULL? 
4GWAAQDIItem for the acquisition cost of goodwillnvarchar100 Allow NULL? 
5GWAAQDTSubitem category for the acquisition cost of goodwillnvarchar30 Allow NULL? 
6GWAAQDSSubitem for the acquisition cost of goodwillnvarchar100 Allow NULL? 
7GWAAQCTPYSSubitem Goodwill Amortization CTD Orig.Cost, Opening Balancenvarchar100 Allow NULL? 
8GWAAQCTCYSSubitem Goodwill Amortization CTD Orig.Cost, Current Yearnvarchar100 Allow NULL? 
9GWAOFFSDIOffsetting Item, Goodwill Amortization, Acquisition Costnvarchar100 Allow NULL? 
10GWAOFFSDTSubitem Categ.: Offsetting Entry, Goodwill Amort., Acq.Costnvarchar30 Allow NULL? 
11GWAOFFSDSSubitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Debitnvarchar100 Allow NULL? 
12GWAOFFSCSSubitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Creditnvarchar100 Allow NULL? 
13GWAAQCIItem for the accumulated amortization of goodwillnvarchar100 Allow NULL? 
14GWAAQCTSubitem category for accumulated amortization of goodwillnvarchar30 Allow NULL? 
15GWADPCSSubitem for the amortization of goodwillnvarchar100 Allow NULL? 
16GWADPDSSubitem for writeups of goodwillnvarchar100 Allow NULL? 
17GWADPCTPYSSubitem Goodwill Amortization CTD Val.Allow., Opening Bal.nvarchar100 Allow NULL? 
18GWADPCTCYSSubitem Goodwill Amortization CTD Val.Allow., Current Yearnvarchar100 Allow NULL? 
19GWAAMDIItem for the amortization of goodwillnvarchar100 Allow NULL? 
20GWAAMDTSubitem category for the amortization of goodwillnvarchar30 Allow NULL? 
21GWAAMDSSubitem for the amortization of goodwillnvarchar100 Allow NULL? 
22GWAAMCIItem for goodwill writeupsnvarchar100 Allow NULL? 
23GWAAMCTSubitem category for goodwill writeupsnvarchar30 Allow NULL? 
24GWAAMCSSubitem for writeups of goodwillnvarchar100 Allow NULL? 
25GWASTATItem for Goodwill Val.Allowances: Amortization, Statisticalnvarchar100 Allow NULL? 
26GWASTATCTItem Goodwill Amortization CTD, Statisticalnvarchar100 Allow NULL? 
27GWASTATOFFSOffsetting Item, Goodwill Amortization, Statisticalnvarchar100 Allow NULL? 
28GWRAQDIBal.sheet item: periodic reduction of goodwillnvarchar100 Allow NULL? 
29GWRAQDTSubitem category for B/S item for periodic reduction of GWnvarchar30 Allow NULL? 
30GWRAQDSSubitem for periodic reduction of goodwill - acquisitionnvarchar100 Allow NULL? 
31GWRAQCSSubitem for periodic reduction of goodwill - divestiturenvarchar100 Allow NULL? 
32GWROFFSDIOffset.Item: Goodwill Periodic Reduction, Acquisition Costnvarchar100 Allow NULL? 
33GWROFFSDTSubitem Cat.: Offset.Entry, Goodwill Periodic Reduction, APCnvarchar30 Allow NULL? 
34GWROFFSDSSubitem: Offset.Entry, Goodwill Periodic Reduction, Debitnvarchar100 Allow NULL? 
35GWROFFSCSSubitem: Offset.Entry, Goodwill Periodic Reduction, Creditnvarchar100 Allow NULL? 
36GWRAMDIItem for periodic reduction of goodwill: debitsnvarchar100 Allow NULL? 
37GWRAMDTSubitem category for periodic reduction of goodwill: debitsnvarchar30 Allow NULL? 
38GWRAMDSSubitem for periodic reduction of goodwill: debitsnvarchar100 Allow NULL? 
39GWRAMCIItem for periodic reduction of goodwill: creditsnvarchar100 Allow NULL? 
40GWRAMCTSubitem category for periodic reduction of goodwill: creditsnvarchar30 Allow NULL? 
41GWRAMCSSubitem for periodic reduction of goodwill: creditsnvarchar100 Allow NULL? 
42GWRSTATItem for Goodwill Val.Allow.: Periodic Reduction, Stat.nvarchar100 Allow NULL? 
43GWRSTATOFFSOffsetting Item: Goodwill Periodic Reduction, Statisticalnvarchar100 Allow NULL? 
44GWDAQDIItem for the direct elimination of goodwillnvarchar100 Allow NULL? 
45GWDAQDTSubitem category for the direct elimination of goodwillnvarchar30 Allow NULL? 
46GWDAQDSSubitem for the direct elimination of goodwillnvarchar100 Allow NULL? 
47GWDOFFSDIOffset.Item, Goodwill Direct Elimination, Acquisition Costnvarchar100 Allow NULL? 
48GWDOFFSDTSubitem Cat.: Offset.Entry, Goodwill Direct Elimination, APCnvarchar30 Allow NULL? 
49GWDOFFSDSSubitem: Offset.Entry, Goodwill Direct Elimination, Debitnvarchar100 Allow NULL? 
50GWDOFFSCSSubitem: Offset.Entry, Goodwill Direct Elimination, Creditnvarchar100 Allow NULL? 
51GWDSTATItem for Goodwill Val.Allow.: Direct Elimination, Stat.nvarchar100 Allow NULL? 
52GWDSTATOFFSOffsetting Item: Goodwill Direct Elimination, Statisticalnvarchar100 Allow NULL? 
53NGAAQDIItem for acquisition cost of negative goodwillnvarchar100 Allow NULL? 
54NGAAQDTSubitem category for acquisition cost of negative goodwillnvarchar30 Allow NULL? 
55NGAAQDSSubitem for acquisition cost of negative goodwillnvarchar100 Allow NULL? 
56NGAAMCTPYSSubitem: Neg. Goodwill Amort., C/T Diff. OC, Opening Balancenvarchar100 Allow NULL? 
57NGAAMCTCYSSubitem: Neg. Goodwill Amort., C/T Diff. OC Current Yearnvarchar100 Allow NULL? 
58NGAOFFSDIOffsetting Item: Negative Goodwill Amortization, Acq.Costnvarchar100 Allow NULL? 
59NGAOFFSDTSubitem Categ.: Offset.Entry, Negative Goodwill Amort. APCnvarchar30 Allow NULL? 
60NGAOFFSDSSubitem: Offset.Entry, Negative Goodwill Amort. APC, Debitnvarchar100 Allow NULL? 
61NGAOFFSCSSubitem: Offset.Entry, Negative Goodwill Amort. APC, Creditnvarchar100 Allow NULL? 
62NGAAQCIItem for accumulated amortization of negative goodwillnvarchar100 Allow NULL? 
63NGAAQCTSubitem category for accum.amortization of negative goodwillnvarchar30 Allow NULL? 
64NGADPCSSubitem for the amortization of negative goodwillnvarchar100 Allow NULL? 
65NGADPDSSubitem for writeups of negative goodwillnvarchar100 Allow NULL? 
66NGADPCTPYSSubitem: Neg. Goodwill Amort., CTD Val.All., Opening Balancenvarchar100 Allow NULL? 
67NGADPCTCYSSubitem: Neg. Goodwill Amort., CTD Val.Allowance, Curr.Yearnvarchar100 Allow NULL? 
68NGAAMDIItem for the amortization of negative goodwillnvarchar100 Allow NULL? 
69NGAAMDTSubitem category for amortization of negative goodwillnvarchar30 Allow NULL? 
70NGAAMDSSubitem for the amortization of negative goodwillnvarchar100 Allow NULL? 
71NGAAMCIItem for writeups of negative goodwillnvarchar100 Allow NULL? 
72NGAAMCTSubitem category for goodwill writeupsnvarchar30 Allow NULL? 
73NGAAMCSSubitem for writeups of negative goodwillnvarchar100 Allow NULL? 
74NGASTATItem for Neg.Goodwill Val.Allow.: Amortization, Stat.nvarchar100 Allow NULL? 
75NGASTATCTItem: Negative Goodwill Amortization, C/T Diff, Statisticalnvarchar100 Allow NULL? 
76NGASTATOFFSOffsetting Item: Negative Goodwill Amortization, Statisticalnvarchar100 Allow NULL? 
77NGRAQDIB/S item for periodic reduction of negative GWnvarchar100 Allow NULL? 
78NGRAQDTSubitem cat. for B/S item for periodic reduction of neg. GWnvarchar30 Allow NULL? 
79NGRAQDSSubitem for periodic reduction of negative GW: acquisitionsnvarchar100 Allow NULL? 
80NGRAQCSSubitem for periodic reduction of negative GW: divestiturenvarchar100 Allow NULL? 
81NGROFFSDIOffsetting Item: Neg.Goodwill Periodic Reduction, Acq.Costnvarchar100 Allow NULL? 
82NGROFFSDTSI Cat.: Offset.Entry, Neg.Goodwill Periodic Reduct., APCnvarchar30 Allow NULL? 
83NGROFFSDSSubitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Debitnvarchar100 Allow NULL? 
84NGROFFSCSSubitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Creditnvarchar100 Allow NULL? 
85NGRAMDIItem for periodic reduction of negative GW: debitsnvarchar100 Allow NULL? 
86NGRAMDTSubitem cat. for periodic reduction of negative GW: debitsnvarchar30 Allow NULL? 
87NGRAMDSSubitem for periodic reduction of negative goodwill: debitsnvarchar100 Allow NULL? 
88NGRAMCIItem for periodic reduction of negative goodwill: creditnvarchar100 Allow NULL? 
89NGRAMCTSubitem cat. for periodic reduction of negative GW: creditsnvarchar30 Allow NULL? 
90NGRAMCSSubitem for periodic reduction of negative goodwill: creditsnvarchar100 Allow NULL? 
91NGRSTATItem for Neg.Goodwill Val.Allow.: Periodic Reduction, Stat.nvarchar100 Allow NULL? 
92NGRSTATOFFSOffset.Item: Neg.Goodwill Periodic Reduction, Statisticalnvarchar100 Allow NULL? 
93NGDAQCIItem for direct elimination of negative goodwillnvarchar100 Allow NULL? 
94NGDAQCTSubitem category for direct elimination of negative goodwillnvarchar30 Allow NULL? 
95NGDAQCSSubitem for the direct elimination of negative goodwillnvarchar100 Allow NULL? 
96NGDOFFSDIOffsetting Item: Neg.Goodwill Direct Elimination, Acq.Costnvarchar100 Allow NULL? 
97NGDOFFSDTSubitem Cat.: Offset.Entry, Neg.Goodwill Direct Elim., APCnvarchar30 Allow NULL? 
98NGDOFFSDSSubitem: Offsetting Entry, Neg.Goodwill Direct Elim., Debitnvarchar100 Allow NULL? 
99NGDOFFSCSSubitem: Offset.Entry, Neg.Goodwill Direct Elim., Creditnvarchar100 Allow NULL? 
100NGDSTATItem for Neg.Goodwill Val.Allow.: Direct Elimination, Stat.nvarchar100 Allow NULL? 
101NGDSTATOFFSOffsetting Item: Neg.Goodwill Direct Elim., Statisticalnvarchar100 Allow NULL? 
NamePrimaryUniqueTypeColumns
TF692~0YesYesCLUSTEREDMANDT, DIMEN, ITCLG

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