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  | TF602
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.0TF6021021C/I Methods: Cons Chart of Accounts-Based SettingsConsolidation
SQL:  selectupdate insert create

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

SELECT MANDT, DIMEN, ITCLG, COIMETH, 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 TF602
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DIMENDimensionnvarchar20 Allow NULL? 
3ITCLGConsolidation chart of accountsnvarchar20 Allow NULL? 
4COIMETHMethodnvarchar50 Allow NULL? 
5GWAAQDIItem for the acquisition cost of goodwillnvarchar100 Allow NULL? 
6GWAAQDTSubitem category for the acquisition cost of goodwillnvarchar30 Allow NULL? 
7GWAAQDSSubitem for the acquisition cost of goodwillnvarchar100 Allow NULL? 
8GWAAQCTPYSSubitem Goodwill Amortization CTD Orig.Cost, Opening Balancenvarchar100 Allow NULL? 
9GWAAQCTCYSSubitem Goodwill Amortization CTD Orig.Cost, Current Yearnvarchar100 Allow NULL? 
10GWAOFFSDIOffsetting Item, Goodwill Amortization, Acquisition Costnvarchar100 Allow NULL? 
11GWAOFFSDTSubitem Categ.: Offsetting Entry, Goodwill Amort., Acq.Costnvarchar30 Allow NULL? 
12GWAOFFSDSSubitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Debitnvarchar100 Allow NULL? 
13GWAOFFSCSSubitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Creditnvarchar100 Allow NULL? 
14GWAAQCIItem for the accumulated amortization of goodwillnvarchar100 Allow NULL? 
15GWAAQCTSubitem category for accumulated amortization of goodwillnvarchar30 Allow NULL? 
16GWADPCSSubitem for the amortization of goodwillnvarchar100 Allow NULL? 
17GWADPDSSubitem for writeups of goodwillnvarchar100 Allow NULL? 
18GWADPCTPYSSubitem Goodwill Amortization CTD Val.Allow., Opening Bal.nvarchar100 Allow NULL? 
19GWADPCTCYSSubitem Goodwill Amortization CTD Val.Allow., Current Yearnvarchar100 Allow NULL? 
20GWAAMDIItem for the amortization of goodwillnvarchar100 Allow NULL? 
21GWAAMDTSubitem category for the amortization of goodwillnvarchar30 Allow NULL? 
22GWAAMDSSubitem for the amortization of goodwillnvarchar100 Allow NULL? 
23GWAAMCIItem for goodwill writeupsnvarchar100 Allow NULL? 
24GWAAMCTSubitem category for goodwill writeupsnvarchar30 Allow NULL? 
25GWAAMCSSubitem for writeups of goodwillnvarchar100 Allow NULL? 
26GWASTATItem for Goodwill Val.Allowances: Amortization, Statisticalnvarchar100 Allow NULL? 
27GWASTATCTItem Goodwill Amortization CTD, Statisticalnvarchar100 Allow NULL? 
28GWASTATOFFSOffsetting Item, Goodwill Amortization, Statisticalnvarchar100 Allow NULL? 
29GWRAQDIBal.sheet item: periodic reduction of goodwillnvarchar100 Allow NULL? 
30GWRAQDTSubitem category for B/S item for periodic reduction of GWnvarchar30 Allow NULL? 
31GWRAQDSSubitem for periodic reduction of goodwill - acquisitionnvarchar100 Allow NULL? 
32GWRAQCSSubitem for periodic reduction of goodwill - divestiturenvarchar100 Allow NULL? 
33GWROFFSDIOffset.Item: Goodwill Periodic Reduction, Acquisition Costnvarchar100 Allow NULL? 
34GWROFFSDTSubitem Cat.: Offset.Entry, Goodwill Periodic Reduction, APCnvarchar30 Allow NULL? 
35GWROFFSDSSubitem: Offset.Entry, Goodwill Periodic Reduction, Debitnvarchar100 Allow NULL? 
36GWROFFSCSSubitem: Offset.Entry, Goodwill Periodic Reduction, Creditnvarchar100 Allow NULL? 
37GWRAMDIItem for periodic reduction of goodwill: debitsnvarchar100 Allow NULL? 
38GWRAMDTSubitem category for periodic reduction of goodwill: debitsnvarchar30 Allow NULL? 
39GWRAMDSSubitem for periodic reduction of goodwill: debitsnvarchar100 Allow NULL? 
40GWRAMCIItem for periodic reduction of goodwill: creditsnvarchar100 Allow NULL? 
41GWRAMCTSubitem category for periodic reduction of goodwill: creditsnvarchar30 Allow NULL? 
42GWRAMCSSubitem for periodic reduction of goodwill: creditsnvarchar100 Allow NULL? 
43GWRSTATItem for Goodwill Val.Allow.: Periodic Reduction, Stat.nvarchar100 Allow NULL? 
44GWRSTATOFFSOffsetting Item: Goodwill Periodic Reduction, Statisticalnvarchar100 Allow NULL? 
45GWDAQDIItem for the direct elimination of goodwillnvarchar100 Allow NULL? 
46GWDAQDTSubitem category for the direct elimination of goodwillnvarchar30 Allow NULL? 
47GWDAQDSSubitem for the direct elimination of goodwillnvarchar100 Allow NULL? 
48GWDOFFSDIOffset.Item, Goodwill Direct Elimination, Acquisition Costnvarchar100 Allow NULL? 
49GWDOFFSDTSubitem Cat.: Offset.Entry, Goodwill Direct Elimination, APCnvarchar30 Allow NULL? 
50GWDOFFSDSSubitem: Offset.Entry, Goodwill Direct Elimination, Debitnvarchar100 Allow NULL? 
51GWDOFFSCSSubitem: Offset.Entry, Goodwill Direct Elimination, Creditnvarchar100 Allow NULL? 
52GWDSTATItem for Goodwill Val.Allow.: Direct Elimination, Stat.nvarchar100 Allow NULL? 
53GWDSTATOFFSOffsetting Item: Goodwill Direct Elimination, Statisticalnvarchar100 Allow NULL? 
54NGAAQDIItem for acquisition cost of negative goodwillnvarchar100 Allow NULL? 
55NGAAQDTSubitem category for acquisition cost of negative goodwillnvarchar30 Allow NULL? 
56NGAAQDSSubitem for acquisition cost of negative goodwillnvarchar100 Allow NULL? 
57NGAAMCTPYSSubitem: Neg. Goodwill Amort., C/T Diff. OC, Opening Balancenvarchar100 Allow NULL? 
58NGAAMCTCYSSubitem: Neg. Goodwill Amort., C/T Diff. OC Current Yearnvarchar100 Allow NULL? 
59NGAOFFSDIOffsetting Item: Negative Goodwill Amortization, Acq.Costnvarchar100 Allow NULL? 
60NGAOFFSDTSubitem Categ.: Offset.Entry, Negative Goodwill Amort. APCnvarchar30 Allow NULL? 
61NGAOFFSDSSubitem: Offset.Entry, Negative Goodwill Amort. APC, Debitnvarchar100 Allow NULL? 
62NGAOFFSCSSubitem: Offset.Entry, Negative Goodwill Amort. APC, Creditnvarchar100 Allow NULL? 
63NGAAQCIItem for accumulated amortization of negative goodwillnvarchar100 Allow NULL? 
64NGAAQCTSubitem category for accum.amortization of negative goodwillnvarchar30 Allow NULL? 
65NGADPCSSubitem for the amortization of negative goodwillnvarchar100 Allow NULL? 
66NGADPDSSubitem for writeups of negative goodwillnvarchar100 Allow NULL? 
67NGADPCTPYSSubitem: Neg. Goodwill Amort., CTD Val.All., Opening Balancenvarchar100 Allow NULL? 
68NGADPCTCYSSubitem: Neg. Goodwill Amort., CTD Val.Allowance, Curr.Yearnvarchar100 Allow NULL? 
69NGAAMDIItem for the amortization of negative goodwillnvarchar100 Allow NULL? 
70NGAAMDTSubitem category for amortization of negative goodwillnvarchar30 Allow NULL? 
71NGAAMDSSubitem for the amortization of negative goodwillnvarchar100 Allow NULL? 
72NGAAMCIItem for writeups of negative goodwillnvarchar100 Allow NULL? 
73NGAAMCTSubitem category for goodwill writeupsnvarchar30 Allow NULL? 
74NGAAMCSSubitem for writeups of negative goodwillnvarchar100 Allow NULL? 
75NGASTATItem for Neg.Goodwill Val.Allow.: Amortization, Stat.nvarchar100 Allow NULL? 
76NGASTATCTItem: Negative Goodwill Amortization, C/T Diff, Statisticalnvarchar100 Allow NULL? 
77NGASTATOFFSOffsetting Item: Negative Goodwill Amortization, Statisticalnvarchar100 Allow NULL? 
78NGRAQDIB/S item for periodic reduction of negative GWnvarchar100 Allow NULL? 
79NGRAQDTSubitem cat. for B/S item for periodic reduction of neg. GWnvarchar30 Allow NULL? 
80NGRAQDSSubitem for periodic reduction of negative GW: acquisitionsnvarchar100 Allow NULL? 
81NGRAQCSSubitem for periodic reduction of negative GW: divestiturenvarchar100 Allow NULL? 
82NGROFFSDIOffsetting Item: Neg.Goodwill Periodic Reduction, Acq.Costnvarchar100 Allow NULL? 
83NGROFFSDTSI Cat.: Offset.Entry, Neg.Goodwill Periodic Reduct., APCnvarchar30 Allow NULL? 
84NGROFFSDSSubitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Debitnvarchar100 Allow NULL? 
85NGROFFSCSSubitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Creditnvarchar100 Allow NULL? 
86NGRAMDIItem for periodic reduction of negative GW: debitsnvarchar100 Allow NULL? 
87NGRAMDTSubitem cat. for periodic reduction of negative GW: debitsnvarchar30 Allow NULL? 
88NGRAMDSSubitem for periodic reduction of negative goodwill: debitsnvarchar100 Allow NULL? 
89NGRAMCIItem for periodic reduction of negative goodwill: creditnvarchar100 Allow NULL? 
90NGRAMCTSubitem cat. for periodic reduction of negative GW: creditsnvarchar30 Allow NULL? 
91NGRAMCSSubitem for periodic reduction of negative goodwill: creditsnvarchar100 Allow NULL? 
92NGRSTATItem for Neg.Goodwill Val.Allow.: Periodic Reduction, Stat.nvarchar100 Allow NULL? 
93NGRSTATOFFSOffset.Item: Neg.Goodwill Periodic Reduction, Statisticalnvarchar100 Allow NULL? 
94NGDAQCIItem for direct elimination of negative goodwillnvarchar100 Allow NULL? 
95NGDAQCTSubitem category for direct elimination of negative goodwillnvarchar30 Allow NULL? 
96NGDAQCSSubitem for the direct elimination of negative goodwillnvarchar100 Allow NULL? 
97NGDOFFSDIOffsetting Item: Neg.Goodwill Direct Elimination, Acq.Costnvarchar100 Allow NULL? 
98NGDOFFSDTSubitem Cat.: Offset.Entry, Neg.Goodwill Direct Elim., APCnvarchar30 Allow NULL? 
99NGDOFFSDSSubitem: Offsetting Entry, Neg.Goodwill Direct Elim., Debitnvarchar100 Allow NULL? 
100NGDOFFSCSSubitem: Offset.Entry, Neg.Goodwill Direct Elim., Creditnvarchar100 Allow NULL? 
101NGDSTATItem for Neg.Goodwill Val.Allow.: Direct Elimination, Stat.nvarchar100 Allow NULL? 
102NGDSTATOFFSOffsetting Item: Neg.Goodwill Direct Elim., Statisticalnvarchar100 Allow NULL? 
NamePrimaryUniqueTypeColumns
TF602~0YesYesCLUSTEREDMANDT, DIMEN, ITCLG, 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