TAX_REG_ITEM

Transparent Table Application Table
54 Fields 2 CDS Views

Tax Item Posting

TAX_REG_ITEM is an SAP database table in S/4HANA. Tax Item Posting. It contains 54 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TransactionalTaxItem view_entity from BASIC Transactional Tax Item
P_TransactionalTaxItem view_entity from BASIC Transactional tax item

Fields (54)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY taxitem_uuid TXRG_TAX_ITEM_UUID Tax Item UUID
taxitem_source TXRG_TAXITEM_SOURCE Source of Tax Item
bukrs BUKRS Company Code
belnr BELNR_D Document Number
gjahr GJAHR Fiscal Year
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
taxation_type TXRG_TXN_TYPE Taxation Type
awtyp AWTYP Ref. procedure
awsys AWSYS Logical System
aworg AWORG Refer. Org.Unit
awref AWREF Reference Doc.
xreversing FINS_XREVERSING Is Reversing
xreversed FINS_XREVERSED Is Reversed
awtyp_rev AWTYP_REV ReversalRefTran
awref_rev AWREF_REV Reversal Ref.
aworg_rev AWORG_REV Reversal Org.
line_item_status TXRG_LINE_ITEM_STATUS Line Item Status
tax_recon_account TXRG_TAX_RECON_ACCOUNT Tax GL Account Number
ktosl KTOSL Transaction
condition_type KSCHL Condition Type
due_category TXRG_DUE_CATEGORY Due Category
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
tax_rate TXRG_TAX_RATE Tax Rate
budat BUDAT Posting Date
bldat BLDAT Document Date
shkzg SHKZG Debit/Credit
blart BLART Document Type
fulfilldate FOT_FULFILLDATE Tax Fulfill. Date
tax_reporting_date TXRG_TX_RPTG_DATE Tax Reporting Date
xreportable TXRG_XREPORTABLE Is Reportable
tax_group TXGRP Group Indicator
tax_position TAX_POSNR Tax doc. item number
base_amt_co_crcy TXRG_BASE_AMT_CO_CRCY Tax Base Amount in Company Code Currency
tax_amt_co_crcy TXRG_TX_AMT_CO_CRCY Tax Amount in Company Code Currency
company_code_currency FINS_CURRH CompanyCode Currency
base_amt_trans_crcy TXRG_BASE_AMT_TRANS_CRCY Tax Base Amount in Transaction Currency
tax_amt_trans_crcy TXRG_TX_AMT_TRANS_CRCY Tax Amount in Transaction Currency
transaction_currency FINS_CURRW Transaction Currency
base_amt_rptg_crcy TXRG_BASE_AMT_RPTG_CRCY Tax Base Amount in Reporting Currency
tax_amt_rptg_crcy TXRG_TX_AMT_RPTG_CRCY Tax Amount in Reporting Currency
reporting_currency TXRG_CURRTR Reporting Currency
tax_pybl_doc_nmbr TXRG_TAXPYBL_DOCN Tax Payable Document Number
tax_pybl_doc_year TXRG_TAXPYBL_DOC_YEAR Tax Payable Document Year
tax_line_payable_status TXRG_TAX_LINE_ITEM_PYBL_STATUS Status
oi_ref_type FINS_OI_REF_TYPE Open Item Ref Type
oi_ref_id FINS_OI_REF_ID Open Item Ref ID
mwskz MWSKZ Tax Code
tax_deductibility TXRG_TAX_DEDUCTIBILITY Deductibility
created_at TXRG_TAX_ITEM_CREATEDAT Created On
created_by TXRG_TAX_ITEM_CREATEDBY Created By
lastchangedat TXRG_TAX_ITEM_LASTCHANGEDAT Last Changed On
lastchangedby TXRG_TAX_ITEM_LASTCHANGEDBY Last Changed By
migration_uuid TXRG_TXITEM_MIGRATION_UUID Migration UUID

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.

-- Tax Item Posting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TAX_REG_ITEM (
    MANDT,                    -- Client [MANDT]
    TAXITEM_UUID,             -- Tax Item UUID [TXRG_TAX_ITEM_UUID]
    TAXITEM_SOURCE,           -- Source of Tax Item [TXRG_TAXITEM_SOURCE]
    BUKRS,                    -- Company Code [BUKRS]
    BELNR,                    -- Document Number [BELNR_D]
    GJAHR,                    -- Fiscal Year [GJAHR]
    TAX_COUNTRY,              -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    TAXATION_TYPE,            -- Taxation Type [TXRG_TXN_TYPE]
    AWTYP,                    -- Ref. procedure [AWTYP]
    AWSYS,                    -- Logical System [AWSYS]
    AWORG,                    -- Refer. Org.Unit [AWORG]
    AWREF,                    -- Reference Doc. [AWREF]
    XREVERSING,               -- Is Reversing [FINS_XREVERSING]
    XREVERSED,                -- Is Reversed [FINS_XREVERSED]
    AWTYP_REV,                -- ReversalRefTran [AWTYP_REV]
    AWREF_REV,                -- Reversal Ref. [AWREF_REV]
    AWORG_REV,                -- Reversal Org. [AWORG_REV]
    LINE_ITEM_STATUS,         -- Line Item Status [TXRG_LINE_ITEM_STATUS]
    TAX_RECON_ACCOUNT,        -- Tax GL Account Number [TXRG_TAX_RECON_ACCOUNT]
    KTOSL,                    -- Transaction [KTOSL]
    CONDITION_TYPE,           -- Condition Type [KSCHL]
    DUE_CATEGORY,             -- Due Category [TXRG_DUE_CATEGORY]
    TXDAT_FROM,               -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    TAX_RATE,                 -- Tax Rate [TXRG_TAX_RATE]
    BUDAT,                    -- Posting Date [BUDAT]
    BLDAT,                    -- Document Date [BLDAT]
    SHKZG,                    -- Debit/Credit [SHKZG]
    BLART,                    -- Document Type [BLART]
    FULFILLDATE,              -- Tax Fulfill. Date [FOT_FULFILLDATE]
    TAX_REPORTING_DATE,       -- Tax Reporting Date [TXRG_TX_RPTG_DATE]
    XREPORTABLE,              -- Is Reportable [TXRG_XREPORTABLE]
    TAX_GROUP,                -- Group Indicator [TXGRP]
    TAX_POSITION,             -- Tax doc. item number [TAX_POSNR]
    BASE_AMT_CO_CRCY,         -- Tax Base Amount in Company Code Currency [TXRG_BASE_AMT_CO_CRCY]
    TAX_AMT_CO_CRCY,          -- Tax Amount in Company Code Currency [TXRG_TX_AMT_CO_CRCY]
    COMPANY_CODE_CURRENCY,    -- CompanyCode Currency [FINS_CURRH]
    BASE_AMT_TRANS_CRCY,      -- Tax Base Amount in Transaction Currency [TXRG_BASE_AMT_TRANS_CRCY]
    TAX_AMT_TRANS_CRCY,       -- Tax Amount in Transaction Currency [TXRG_TX_AMT_TRANS_CRCY]
    TRANSACTION_CURRENCY,     -- Transaction Currency [FINS_CURRW]
    BASE_AMT_RPTG_CRCY,       -- Tax Base Amount in Reporting Currency [TXRG_BASE_AMT_RPTG_CRCY]
    TAX_AMT_RPTG_CRCY,        -- Tax Amount in Reporting Currency [TXRG_TX_AMT_RPTG_CRCY]
    REPORTING_CURRENCY,       -- Reporting Currency [TXRG_CURRTR]
    TAX_PYBL_DOC_NMBR,        -- Tax Payable Document Number [TXRG_TAXPYBL_DOCN]
    TAX_PYBL_DOC_YEAR,        -- Tax Payable Document Year [TXRG_TAXPYBL_DOC_YEAR]
    TAX_LINE_PAYABLE_STATUS,  -- Status [TXRG_TAX_LINE_ITEM_PYBL_STATUS]
    OI_REF_TYPE,              -- Open Item Ref Type [FINS_OI_REF_TYPE]
    OI_REF_ID,                -- Open Item Ref ID [FINS_OI_REF_ID]
    MWSKZ,                    -- Tax Code [MWSKZ]
    TAX_DEDUCTIBILITY,        -- Deductibility [TXRG_TAX_DEDUCTIBILITY]
    CREATED_AT,               -- Created On [TXRG_TAX_ITEM_CREATEDAT]
    CREATED_BY,               -- Created By [TXRG_TAX_ITEM_CREATEDBY]
    LASTCHANGEDAT,            -- Last Changed On [TXRG_TAX_ITEM_LASTCHANGEDAT]
    LASTCHANGEDBY,            -- Last Changed By [TXRG_TAX_ITEM_LASTCHANGEDBY]
    MIGRATION_UUID,           -- Migration UUID [TXRG_TXITEM_MIGRATION_UUID]
    PRIMARY KEY (MANDT, TAXITEM_UUID)
);

Learn More