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
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2DIMENDimensionnvarchar20CHAR(N' ')NoTF150FC_DIMEN Allow NULL? 
3ITCLGConsolidation chart of accountsnvarchar20CHAR(N' ')NoTF120FC_ITCLG Allow NULL? 
4GWAAQDIItem for the acquisition cost of goodwillnvarchar100CHAR(N' ')YesTF100FC_GWAAQDI Allow NULL? 
5GWAAQDTSubitem category for the acquisition cost of goodwillnvarchar30CHAR(N' ')YesTF110FC_GWAAQDT Allow NULL? 
6GWAAQDSSubitem for the acquisition cost of goodwillnvarchar100CHAR(N' ')YesTF115FC_GWAAQDS Allow NULL? 
7GWAAQCTPYSSubitem Goodwill Amortization CTD Orig.Cost, Opening Balancenvarchar100CHAR(N' ')YesTF115FC_GWAAQCTPYS Allow NULL? 
8GWAAQCTCYSSubitem Goodwill Amortization CTD Orig.Cost, Current Yearnvarchar100CHAR(N' ')YesTF115FC_GWAAQCTCYS Allow NULL? 
9GWAOFFSDIOffsetting Item, Goodwill Amortization, Acquisition Costnvarchar100CHAR(N' ')YesTF100FC_GWAOFFSDI Allow NULL? 
10GWAOFFSDTSubitem Categ.: Offsetting Entry, Goodwill Amort., Acq.Costnvarchar30CHAR(N' ')YesTF110FC_GWAOFFSDT Allow NULL? 
11GWAOFFSDSSubitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Debitnvarchar100CHAR(N' ')YesTF115FC_GWAOFFSDS Allow NULL? 
12GWAOFFSCSSubitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Creditnvarchar100CHAR(N' ')YesTF115FC_GWAOFFSCS Allow NULL? 
13GWAAQCIItem for the accumulated amortization of goodwillnvarchar100CHAR(N' ')YesTF100FC_GWAAQCI Allow NULL? 
14GWAAQCTSubitem category for accumulated amortization of goodwillnvarchar30CHAR(N' ')YesTF110FC_GWAAQCT Allow NULL? 
15GWADPCSSubitem for the amortization of goodwillnvarchar100CHAR(N' ')YesTF115FC_GWADPCS Allow NULL? 
16GWADPDSSubitem for writeups of goodwillnvarchar100CHAR(N' ')YesTF115FC_GWADPDS Allow NULL? 
17GWADPCTPYSSubitem Goodwill Amortization CTD Val.Allow., Opening Bal.nvarchar100CHAR(N' ')YesTF115FC_GWADPCTPYS Allow NULL? 
18GWADPCTCYSSubitem Goodwill Amortization CTD Val.Allow., Current Yearnvarchar100CHAR(N' ')YesTF115FC_GWADPCTCYS Allow NULL? 
19GWAAMDIItem for the amortization of goodwillnvarchar100CHAR(N' ')YesTF100FC_GWAAMDI Allow NULL? 
20GWAAMDTSubitem category for the amortization of goodwillnvarchar30CHAR(N' ')YesTF110FC_GWAAMDT Allow NULL? 
21GWAAMDSSubitem for the amortization of goodwillnvarchar100CHAR(N' ')YesTF115FC_GWAAMDS Allow NULL? 
22GWAAMCIItem for goodwill writeupsnvarchar100CHAR(N' ')YesTF100FC_GWAAMCI Allow NULL? 
23GWAAMCTSubitem category for goodwill writeupsnvarchar30CHAR(N' ')YesTF110FC_GWAAMCT Allow NULL? 
24GWAAMCSSubitem for writeups of goodwillnvarchar100CHAR(N' ')YesTF115FC_GWAAMCS Allow NULL? 
25GWASTATItem for Goodwill Val.Allowances: Amortization, Statisticalnvarchar100CHAR(N' ')YesTF100FC_GWASTAT Allow NULL? 
26GWASTATCTItem Goodwill Amortization CTD, Statisticalnvarchar100CHAR(N' ')YesTF100FC_GWASTATCT Allow NULL? 
27GWASTATOFFSOffsetting Item, Goodwill Amortization, Statisticalnvarchar100CHAR(N' ')YesTF100FC_GWASTATOFFS Allow NULL? 
28GWRAQDIBal.sheet item: periodic reduction of goodwillnvarchar100CHAR(N' ')YesTF100FC_GWRAQDI Allow NULL? 
29GWRAQDTSubitem category for B/S item for periodic reduction of GWnvarchar30CHAR(N' ')YesTF110FC_GWRAQDT Allow NULL? 
30GWRAQDSSubitem for periodic reduction of goodwill - acquisitionnvarchar100CHAR(N' ')YesTF115FC_GWRAQDS Allow NULL? 
31GWRAQCSSubitem for periodic reduction of goodwill - divestiturenvarchar100CHAR(N' ')YesTF115FC_GWRAQCS Allow NULL? 
32GWROFFSDIOffset.Item: Goodwill Periodic Reduction, Acquisition Costnvarchar100CHAR(N' ')YesTF100FC_GWROFFSDI Allow NULL? 
33GWROFFSDTSubitem Cat.: Offset.Entry, Goodwill Periodic Reduction, APCnvarchar30CHAR(N' ')YesTF110FC_GWROFFSDT Allow NULL? 
34GWROFFSDSSubitem: Offset.Entry, Goodwill Periodic Reduction, Debitnvarchar100CHAR(N' ')YesTF115FC_GWROFFSDS Allow NULL? 
35GWROFFSCSSubitem: Offset.Entry, Goodwill Periodic Reduction, Creditnvarchar100CHAR(N' ')YesTF115FC_GWROFFSCS Allow NULL? 
36GWRAMDIItem for periodic reduction of goodwill: debitsnvarchar100CHAR(N' ')YesTF100FC_GWRAMDI Allow NULL? 
37GWRAMDTSubitem category for periodic reduction of goodwill: debitsnvarchar30CHAR(N' ')YesTF110FC_GWRAMDT Allow NULL? 
38GWRAMDSSubitem for periodic reduction of goodwill: debitsnvarchar100CHAR(N' ')YesTF115FC_GWRAMDS Allow NULL? 
39GWRAMCIItem for periodic reduction of goodwill: creditsnvarchar100CHAR(N' ')YesTF100FC_GWRAMCI Allow NULL? 
40GWRAMCTSubitem category for periodic reduction of goodwill: creditsnvarchar30CHAR(N' ')YesTF110FC_GWRAMCT Allow NULL? 
41GWRAMCSSubitem for periodic reduction of goodwill: creditsnvarchar100CHAR(N' ')YesTF115FC_GWRAMCS Allow NULL? 
42GWRSTATItem for Goodwill Val.Allow.: Periodic Reduction, Stat.nvarchar100CHAR(N' ')YesTF100FC_GWRSTAT Allow NULL? 
43GWRSTATOFFSOffsetting Item: Goodwill Periodic Reduction, Statisticalnvarchar100CHAR(N' ')YesTF100FC_GWRSTATOFFS Allow NULL? 
44GWDAQDIItem for the direct elimination of goodwillnvarchar100CHAR(N' ')YesTF100FC_GWDAQDI Allow NULL? 
45GWDAQDTSubitem category for the direct elimination of goodwillnvarchar30CHAR(N' ')YesTF110FC_GWDAQDT Allow NULL? 
46GWDAQDSSubitem for the direct elimination of goodwillnvarchar100CHAR(N' ')YesTF115FC_GWDAQDS Allow NULL? 
47GWDOFFSDIOffset.Item, Goodwill Direct Elimination, Acquisition Costnvarchar100CHAR(N' ')YesTF100FC_GWDOFFSDI Allow NULL? 
48GWDOFFSDTSubitem Cat.: Offset.Entry, Goodwill Direct Elimination, APCnvarchar30CHAR(N' ')YesTF110FC_GWDOFFSDT Allow NULL? 
49GWDOFFSDSSubitem: Offset.Entry, Goodwill Direct Elimination, Debitnvarchar100CHAR(N' ')YesTF115FC_GWDOFFSDS Allow NULL? 
50GWDOFFSCSSubitem: Offset.Entry, Goodwill Direct Elimination, Creditnvarchar100CHAR(N' ')YesTF115FC_GWDOFFSCS Allow NULL? 
51GWDSTATItem for Goodwill Val.Allow.: Direct Elimination, Stat.nvarchar100CHAR(N' ')YesTF100FC_GWDSTAT Allow NULL? 
52GWDSTATOFFSOffsetting Item: Goodwill Direct Elimination, Statisticalnvarchar100CHAR(N' ')YesTF100FC_GWDSTATOFFS Allow NULL? 
53NGAAQDIItem for acquisition cost of negative goodwillnvarchar100CHAR(N' ')YesTF100FC_NGAAQDI Allow NULL? 
54NGAAQDTSubitem category for acquisition cost of negative goodwillnvarchar30CHAR(N' ')YesTF110FC_NGAAQDT Allow NULL? 
55NGAAQDSSubitem for acquisition cost of negative goodwillnvarchar100CHAR(N' ')YesTF115FC_NGAAQDS Allow NULL? 
56NGAAMCTPYSSubitem: Neg. Goodwill Amort., C/T Diff. OC, Opening Balancenvarchar100CHAR(N' ')YesTF115FC_NGAAMCTPYS Allow NULL? 
57NGAAMCTCYSSubitem: Neg. Goodwill Amort., C/T Diff. OC Current Yearnvarchar100CHAR(N' ')YesTF115FC_NGAAMCTCYS Allow NULL? 
58NGAOFFSDIOffsetting Item: Negative Goodwill Amortization, Acq.Costnvarchar100CHAR(N' ')YesTF100FC_NGAOFFSDI Allow NULL? 
59NGAOFFSDTSubitem Categ.: Offset.Entry, Negative Goodwill Amort. APCnvarchar30CHAR(N' ')YesTF110FC_NGAOFFSDT Allow NULL? 
60NGAOFFSDSSubitem: Offset.Entry, Negative Goodwill Amort. APC, Debitnvarchar100CHAR(N' ')YesTF115FC_NGAOFFSDS Allow NULL? 
61NGAOFFSCSSubitem: Offset.Entry, Negative Goodwill Amort. APC, Creditnvarchar100CHAR(N' ')YesTF115FC_NGAOFFSCS Allow NULL? 
62NGAAQCIItem for accumulated amortization of negative goodwillnvarchar100CHAR(N' ')YesTF100FC_NGAAQCI Allow NULL? 
63NGAAQCTSubitem category for accum.amortization of negative goodwillnvarchar30CHAR(N' ')YesTF110FC_NGAAQCT Allow NULL? 
64NGADPCSSubitem for the amortization of negative goodwillnvarchar100CHAR(N' ')YesTF115FC_NGADPCS Allow NULL? 
65NGADPDSSubitem for writeups of negative goodwillnvarchar100CHAR(N' ')YesTF115FC_NGADPDS Allow NULL? 
66NGADPCTPYSSubitem: Neg. Goodwill Amort., CTD Val.All., Opening Balancenvarchar100CHAR(N' ')YesTF115FC_NGADPCTPYS Allow NULL? 
67NGADPCTCYSSubitem: Neg. Goodwill Amort., CTD Val.Allowance, Curr.Yearnvarchar100CHAR(N' ')YesTF115FC_NGADPCTCYS Allow NULL? 
68NGAAMDIItem for the amortization of negative goodwillnvarchar100CHAR(N' ')YesTF100FC_NGAAMDI Allow NULL? 
69NGAAMDTSubitem category for amortization of negative goodwillnvarchar30CHAR(N' ')YesTF110FC_NGAAMDT Allow NULL? 
70NGAAMDSSubitem for the amortization of negative goodwillnvarchar100CHAR(N' ')YesTF115FC_NGAAMDS Allow NULL? 
71NGAAMCIItem for writeups of negative goodwillnvarchar100CHAR(N' ')YesTF100FC_NGAAMCI Allow NULL? 
72NGAAMCTSubitem category for goodwill writeupsnvarchar30CHAR(N' ')YesTF110FC_NGAAMCT Allow NULL? 
73NGAAMCSSubitem for writeups of negative goodwillnvarchar100CHAR(N' ')YesTF115FC_NGAAMCS Allow NULL? 
74NGASTATItem for Neg.Goodwill Val.Allow.: Amortization, Stat.nvarchar100CHAR(N' ')YesTF100FC_NGASTAT Allow NULL? 
75NGASTATCTItem: Negative Goodwill Amortization, C/T Diff, Statisticalnvarchar100CHAR(N' ')YesTF100FC_NGASTATCT Allow NULL? 
76NGASTATOFFSOffsetting Item: Negative Goodwill Amortization, Statisticalnvarchar100CHAR(N' ')YesTF100FC_NGASTATOFFS Allow NULL? 
77NGRAQDIB/S item for periodic reduction of negative GWnvarchar100CHAR(N' ')YesTF100FC_NGRAQDI Allow NULL? 
78NGRAQDTSubitem cat. for B/S item for periodic reduction of neg. GWnvarchar30CHAR(N' ')YesTF110FC_NGRAQDT Allow NULL? 
79NGRAQDSSubitem for periodic reduction of negative GW: acquisitionsnvarchar100CHAR(N' ')YesTF115FC_NGRAQDS Allow NULL? 
80NGRAQCSSubitem for periodic reduction of negative GW: divestiturenvarchar100CHAR(N' ')YesTF115FC_NGRAQCS Allow NULL? 
81NGROFFSDIOffsetting Item: Neg.Goodwill Periodic Reduction, Acq.Costnvarchar100CHAR(N' ')YesTF100FC_NGROFFSDI Allow NULL? 
82NGROFFSDTSI Cat.: Offset.Entry, Neg.Goodwill Periodic Reduct., APCnvarchar30CHAR(N' ')YesTF110FC_NGROFFSDT Allow NULL? 
83NGROFFSDSSubitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Debitnvarchar100CHAR(N' ')YesTF115FC_NGROFFSDS Allow NULL? 
84NGROFFSCSSubitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Creditnvarchar100CHAR(N' ')YesTF115FC_NGROFFSCS Allow NULL? 
85NGRAMDIItem for periodic reduction of negative GW: debitsnvarchar100CHAR(N' ')YesTF100FC_NGRAMDI Allow NULL? 
86NGRAMDTSubitem cat. for periodic reduction of negative GW: debitsnvarchar30CHAR(N' ')YesTF110FC_NGRAMDT Allow NULL? 
87NGRAMDSSubitem for periodic reduction of negative goodwill: debitsnvarchar100CHAR(N' ')YesTF115FC_NGRAMDS Allow NULL? 
88NGRAMCIItem for periodic reduction of negative goodwill: creditnvarchar100CHAR(N' ')YesTF100FC_NGRAMCI Allow NULL? 
89NGRAMCTSubitem cat. for periodic reduction of negative GW: creditsnvarchar30CHAR(N' ')YesTF110FC_NGRAMCT Allow NULL? 
90NGRAMCSSubitem for periodic reduction of negative goodwill: creditsnvarchar100CHAR(N' ')YesTF115FC_NGRAMCS Allow NULL? 
91NGRSTATItem for Neg.Goodwill Val.Allow.: Periodic Reduction, Stat.nvarchar100CHAR(N' ')YesTF100FC_NGRSTAT Allow NULL? 
92NGRSTATOFFSOffset.Item: Neg.Goodwill Periodic Reduction, Statisticalnvarchar100CHAR(N' ')YesTF100FC_NGRSTATOFFS Allow NULL? 
93NGDAQCIItem for direct elimination of negative goodwillnvarchar100CHAR(N' ')YesTF100FC_NGDAQCI Allow NULL? 
94NGDAQCTSubitem category for direct elimination of negative goodwillnvarchar30CHAR(N' ')YesTF110FC_NGDAQCT Allow NULL? 
95NGDAQCSSubitem for the direct elimination of negative goodwillnvarchar100CHAR(N' ')YesTF115FC_NGDAQCS Allow NULL? 
96NGDOFFSDIOffsetting Item: Neg.Goodwill Direct Elimination, Acq.Costnvarchar100CHAR(N' ')YesTF100FC_NGDOFFSDI Allow NULL? 
97NGDOFFSDTSubitem Cat.: Offset.Entry, Neg.Goodwill Direct Elim., APCnvarchar30CHAR(N' ')YesTF110FC_NGDOFFSDT Allow NULL? 
98NGDOFFSDSSubitem: Offsetting Entry, Neg.Goodwill Direct Elim., Debitnvarchar100CHAR(N' ')YesTF115FC_NGDOFFSDS Allow NULL? 
99NGDOFFSCSSubitem: Offset.Entry, Neg.Goodwill Direct Elim., Creditnvarchar100CHAR(N' ')YesTF115FC_NGDOFFSCS Allow NULL? 
100NGDSTATItem for Neg.Goodwill Val.Allow.: Direct Elimination, Stat.nvarchar100CHAR(N' ')YesTF100FC_NGDSTAT Allow NULL? 
101NGDSTATOFFSOffsetting Item: Neg.Goodwill Direct Elim., Statisticalnvarchar100CHAR(N' ')YesTF100FC_NGDSTATOFFS 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