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  | DEFTAX_ITEM
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
Financial Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DEFTAX_ITEM517Data for Deferred TaxesFinancial Accounting
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, BELNR, GJAHR, BUZEI, KTOSL, ZBUKR, ZBELN, ZGJAH, ZBUZE, MWSKZ, SHKZG, HKONT, LIFNR, KUNNR, KBETR, HWBTR, FWBTR, HWSTE, FWSTE, LWBTR, LWSTE, HZBET, FZBET, LZBET, HTEIL, FTEIL, LTEIL, HTEIS, FTEIS, LTEIS, HSKON, FSKON, LSKON, HSTRU, FSTRU, LSTRU, LWAER, XAUSG, STMD1, STMD2, STMT2, REFERENCE, LINE_TYPE, UMSKZ, CBELN, CGJAH, TBELN, TGJAH, RBELN, RGJAH FROM DEFTAX_ITEM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
4GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
5BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
6KTOSLTransaction Keynvarchar30CHAR(N' ')NoKTOSL Allow NULL? 
7ZBUKRCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
8ZBELNAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
9ZGJAHFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
10ZBUZENumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
11MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')YesT007AMWSKZ Allow NULL? 
12SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
13HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')YesSKB1HKONT Allow NULL? 
14LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
15KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
16KBETRTax Ratedecimal112CURR((0))YesKBETR_TAX
17HWBTRGross Amount in Local Currencydecimal152CURR((0))YesHWBTR_DEFTAX_ITEM
18FWBTRGross Amount in Document Currencydecimal152CURR((0))YesFWBTR_DEFTAX_ITEM
19HWSTETax Amount in Local Currencydecimal132CURR((0))YesHWSTE
20FWSTETax Amount in Document Currencydecimal132CURR((0))YesFWSTE
21LWBTRGross Amount in National Currencydecimal152CURR((0))YesLWBTR_DEFTAX_ITEM
22LWSTETax Amount in Country Currencydecimal132CURR((0))YesLWSTE_BSET
23HZBETTax Base Amount in Local Currencydecimal152CURR((0))YesHWBAS_BSES
24FZBETTax base amount in document currencydecimal152CURR((0))YesFWBAS_BSES
25LZBETTax Base in Country Currencydecimal152CURR((0))YesLWBAS_BSET
26HTEILPart. Amt of Gross Amount in Local Currency to be Reporteddecimal152CURR((0))YesHTEIL_DEFTAX_ITEM
27FTEILPart.Amt of Gross Amount in Document Currency to be Reporteddecimal152CURR((0))YesFTEIL_DEFTAX_ITEM
28LTEILPart. Amt of Gross Amt in National Currency to be Reporteddecimal152CURR((0))YesLTEIL_DEFTAX_ITEM
29HTEISPartial Amt of Tax Amount in Local Currency to be Reporteddecimal152CURR((0))YesHTEIS_DEFTAX_ITEM
30FTEISPartial Amount of Tax Amount in Document Currency to be Rep.decimal152CURR((0))YesFTEIS_DEFTAX_ITEM
31LTEISPart. Amt of Tax Amount in National Currency to be Reporteddecimal152CURR((0))YesLTEIS_DEFTAX_ITEM
32HSKONCash Discount Amount of Payment in Local Currencydecimal152CURR((0))YesHSKON_DEFTAX_ITEM
33FSKONCash Discount Amount of Payment in Document Currencydecimal152CURR((0))YesFSKON_DEFTAX_ITEM
34LSKONCash Discount Amount of Payment in National Currencydecimal152CURR((0))YesLSKON_DEFTAX_ITEM
35HSTRUBackdated Tax Calculation Amount in Local Currencydecimal152CURR((0))YesHSTRU_DEFTAX_ITEM
36FSTRUBackdated Tax Calculation Amount in Document Currencydecimal152CURR((0))YesFSTRU_DEFTAX_ITEM
37LSTRUBackdated Tax Calculation Amount in National Currencydecimal152CURR((0))YesLSTRU_DEFTAX_ITEM
38LWAERCountry currencynvarchar50CUKY(N' ')Yes*WAERS_005 Allow NULL? 
39XAUSGRelevant Document Has Been Clearedchar10CHAR(N' ')YesXAUSE Allow NULL? 
40STMD1Date from which Advance Tax Reporting Must Be Executednvarchar80DATS(N'00000000')YesSTMD1 Allow NULL? 
41STMD2Date on Which the Tax Return Was Madenvarchar80DATS(N'00000000')YesSTMDT_BSET Allow NULL? 
42STMT2Time of Program Run for the Tax Returnnvarchar60CHAR(N' ')YesSTMTI_BSET Allow NULL? 
43REFERENCEReference Fieldnvarchar200CHAR(N' ')YesREF_DEFTAX_ITEM Allow NULL? 
44LINE_TYPELine categorynvarchar20CHAR(N' ')NoREF_LINE_TYPE Allow NULL? 
45UMSKZSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
46CBELNClearing document numbernvarchar100CHAR(N' ')YesBELNR_C Allow NULL? 
47CGJAHClearing document fiscal yearnvarchar40NUMC(N'0000')YesGJAHR_C Allow NULL? 
48TBELNTax transfer documentnvarchar100CHAR(N' ')YesBELNR_T Allow NULL? 
49TGJAHTransfer document fiscal yearnvarchar40NUMC(N'0000')YesGJAHR_T Allow NULL? 
50RBELNTax transfer reversal documentnvarchar100CHAR(N' ')YesBELNR_R Allow NULL? 
51RGJAHReversal document yearnvarchar40NUMC(N'0000')YesGJAHR_R Allow NULL? 
NamePrimaryUniqueTypeColumns
DEFTAX_ITEM~0YesYesCLUSTEREDZBUZE, ZGJAH, ZBELN, ZBUKR, KTOSL, BUZEI, GJAHR, BELNR, BUKRS, MANDT
DEFTAX_ITEM~001NoNoNONCLUSTEREDLINE_TYPE, ZGJAH, ZBELN, ZBUKR, MANDT
DEFTAX_ITEM~002NoNoNONCLUSTEREDGJAHR, BELNR, BUKRS, LINE_TYPE, MANDT
DEFTAX_ITEM~003NoNoNONCLUSTEREDSTMD1, REFERENCE, MANDT
DEFTAX_ITEM~004NoNoNONCLUSTEREDCGJAH, CBELN, MANDT
DEFTAX_ITEM~005NoNoNONCLUSTEREDTGJAH, TBELN, MANDT
DEFTAX_ITEM~6NoNoNONCLUSTEREDLINE_TYPE, TGJAH, TBELN, BUKRS, MANDT

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