DEFTAX_ITEM

Transparent Table Application Table
51 Fields 4 CDS Views

Daten zu gestundeten Steuern

DEFTAX_ITEM is an SAP database table in S/4HANA. Daten zu gestundeten Steuern. It contains 51 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_DEFTAX_ITEM view from BASIC Deferred Tax Item Details
P_MX_DefTaxItem view from BASIC Deferred Tax Item Details
P_PaytRcptDeferredTaxItem view_entity from BASIC Payment Receipt Deferred Tax Item
P_SK_StRpVATCSDfrrdTaxItemBas view from BASIC SK VAT Control Statement Deferred Tax Item Basic

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY belnr belnr_d Document Number
KEY gjahr gjahr Fiscal Year
KEY buzei buzei Item
KEY ktosl ktosl Transaction
KEY zbukr bukrs Company Code
KEY zbeln belnr_d Document Number
KEY zgjah gjahr Fiscal Year
KEY zbuze buzei Item
mwskz mwskz Tax Code
shkzg shkzg Debit/Credit
hkont hkont G/L Acct
lifnr lifnr Supplier
kunnr kunnr Customer
kbetr kbetr_tax Percent
hwbtr hwbtr_deftax_item LC Gross
fwbtr fwbtr_deftax_item FC Gross
hwste hwste LC Tax
fwste fwste Amount
lwbtr lwbtr_deftax_item CC Gross
lwste lwste_bset Tax Rept. Crcy
hzbet hwbas_bses LC Base
fzbet fwbas_bses Base Amount
lzbet lwbas_bset Base Amount
hteil hteil_deftax_item LC Part. Amt
fteil fteil_deftax_item FC Part. Amt
lteil lteil_deftax_item NC Part. Amt
hteis hteis_deftax_item LC PartTax
fteis fteis_deftax_item FC Part. Tax
lteis lteis_deftax_item NC Part. Tax
hskon hskon_deftax_item LC Discount
fskon fskon_deftax_item FC Cash Disc
lskon lskon_deftax_item NC Discount
hstru hstru_deftax_item LC Backdated
fstru fstru_deftax_item FC Backdated
lstru lstru_deftax_item NC Back. Tax
lwaer waers_005 Reporting Crcy
xausg xause Cleared
stmd1 stmd1 Report From
stmd2 stmdt_bset Return On
stmt2 stmti_bset Return At
reference ref_deftax_item Reference Field
line_type ref_line_type Line Category
umskz umskz Special G/L Ind
cbeln belnr_c Clearing document
cgjah gjahr_c Clearing doc year
tbeln belnr_t Tax transfer doc
tgjah gjahr_t Transfer doc year
rbeln belnr_r Tax transfer revers
rgjah gjahr_r Reversal doc year

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Daten zu gestundeten Steuern
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEFTAX_ITEM (
    MANDT,      -- Client [mandt]
    BUKRS,      -- Company Code [bukrs]
    BELNR,      -- Document Number [belnr_d]
    GJAHR,      -- Fiscal Year [gjahr]
    BUZEI,      -- Item [buzei]
    KTOSL,      -- Transaction [ktosl]
    ZBUKR,      -- Company Code [bukrs]
    ZBELN,      -- Document Number [belnr_d]
    ZGJAH,      -- Fiscal Year [gjahr]
    ZBUZE,      -- Item [buzei]
    MWSKZ,      -- Tax Code [mwskz]
    SHKZG,      -- Debit/Credit [shkzg]
    HKONT,      -- G/L Acct [hkont]
    LIFNR,      -- Supplier [lifnr]
    KUNNR,      -- Customer [kunnr]
    KBETR,      -- Percent [kbetr_tax]
    HWBTR,      -- LC Gross [hwbtr_deftax_item]
    FWBTR,      -- FC Gross [fwbtr_deftax_item]
    HWSTE,      -- LC Tax [hwste]
    FWSTE,      -- Amount [fwste]
    LWBTR,      -- CC Gross [lwbtr_deftax_item]
    LWSTE,      -- Tax Rept. Crcy [lwste_bset]
    HZBET,      -- LC Base [hwbas_bses]
    FZBET,      -- Base Amount [fwbas_bses]
    LZBET,      -- Base Amount [lwbas_bset]
    HTEIL,      -- LC Part. Amt [hteil_deftax_item]
    FTEIL,      -- FC Part. Amt [fteil_deftax_item]
    LTEIL,      -- NC Part. Amt [lteil_deftax_item]
    HTEIS,      -- LC PartTax [hteis_deftax_item]
    FTEIS,      -- FC Part. Tax [fteis_deftax_item]
    LTEIS,      -- NC Part. Tax [lteis_deftax_item]
    HSKON,      -- LC Discount [hskon_deftax_item]
    FSKON,      -- FC Cash Disc [fskon_deftax_item]
    LSKON,      -- NC Discount [lskon_deftax_item]
    HSTRU,      -- LC Backdated [hstru_deftax_item]
    FSTRU,      -- FC Backdated [fstru_deftax_item]
    LSTRU,      -- NC Back. Tax [lstru_deftax_item]
    LWAER,      -- Reporting Crcy [waers_005]
    XAUSG,      -- Cleared [xause]
    STMD1,      -- Report From [stmd1]
    STMD2,      -- Return On [stmdt_bset]
    STMT2,      -- Return At [stmti_bset]
    REFERENCE,  -- Reference Field [ref_deftax_item]
    LINE_TYPE,  -- Line Category [ref_line_type]
    UMSKZ,      -- Special G/L Ind [umskz]
    CBELN,      -- Clearing document [belnr_c]
    CGJAH,      -- Clearing doc year [gjahr_c]
    TBELN,      -- Tax transfer doc [belnr_t]
    TGJAH,      -- Transfer doc year [gjahr_t]
    RBELN,      -- Tax transfer revers [belnr_r]
    RGJAH,      -- Reversal doc year [gjahr_r]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI, KTOSL, ZBUKR, ZBELN, ZGJAH, ZBUZE)
);

Learn More