TXI_ITM

Transparent Table Application Table
25 Fields 3 CDS Views

China Tax Invoice Item

TXI_ITM is an SAP database table in S/4HANA. China Tax Invoice Item. It contains 25 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CN_TaxInputInvoiceItem view from EXTENSION Extension of Incoming VAT Invoice Item
I_CN_GoldenTaxInvoiceItem view from BASIC Golden Tax Invoice Item
P_CN_TaxInputInvoiceItem view from BASIC Incoming VAT Invoice Item

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY invc_item_uuid eiv_item_uuid Invoice Item UUID
invc_uuid ficntaxinvc_uuid Invoice UUID
invc_code ficntaxinvc_code VAT Invoice Code
invc_nmbr ficntaxinvc_nmbr VAT Invoice No.
invc_item_nmbr ficntaxinvc_itm_nmbr Line Item No.
disc_ind gtdisind Discount ind.
matl_nmbr matnr Material
matl_desc ficntaxinvc_itm_gdssrvcname Goods Service Name
matl_spec ficntaxinvc_itm_specmod Specification Model
unit_of_msr meins Base Unit
unit_of_msr_desc gtuomdesc Uni.Measure
blld_qty ficntaxinvc_itm_quantity Item Quantity
net_amount ficntaxinvc_amnt_net Net Amount
tax_amount ficntaxinvc_amnt_tax Tax Amount
unit_price ficntaxinvc_itm_unitprice Unit Price
tax_ctlg_code gtcpde Tax Catalog
deductions idgt_deduct_amt Deduction Amount
goods_nmbr ficntaxinvc_itm_goodsnmbr Goods Number
tax_rate gttaxrate Tax Rate
toll_car_licplate ficntaxinvc_itm_toll_car_licpt Toll Car Lic. Plate
toll_cat_category ficntaxinvc_itm_toll_cat_cate Toll Car Category
toll_start_datetime ficntaxinvc_itm_toll_start_dt Toll Start Date Time
toll_end_datetime ficntaxinvc_itm_toll_end_dt Toll End Date Time
mark_as_delete ficntaxinvc_dele_flag Deleted

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.

-- China Tax Invoice Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TXI_ITM (
    MANDT,                -- Client [mandt]
    INVC_ITEM_UUID,       -- Invoice Item UUID [eiv_item_uuid]
    INVC_UUID,            -- Invoice UUID [ficntaxinvc_uuid]
    INVC_CODE,            -- VAT Invoice Code [ficntaxinvc_code]
    INVC_NMBR,            -- VAT Invoice No. [ficntaxinvc_nmbr]
    INVC_ITEM_NMBR,       -- Line Item No. [ficntaxinvc_itm_nmbr]
    DISC_IND,             -- Discount ind. [gtdisind]
    MATL_NMBR,            -- Material [matnr]
    MATL_DESC,            -- Goods Service Name [ficntaxinvc_itm_gdssrvcname]
    MATL_SPEC,            -- Specification Model [ficntaxinvc_itm_specmod]
    UNIT_OF_MSR,          -- Base Unit [meins]
    UNIT_OF_MSR_DESC,     -- Uni.Measure [gtuomdesc]
    BLLD_QTY,             -- Item Quantity [ficntaxinvc_itm_quantity]
    NET_AMOUNT,           -- Net Amount [ficntaxinvc_amnt_net]
    TAX_AMOUNT,           -- Tax Amount [ficntaxinvc_amnt_tax]
    UNIT_PRICE,           -- Unit Price [ficntaxinvc_itm_unitprice]
    TAX_CTLG_CODE,        -- Tax Catalog [gtcpde]
    DEDUCTIONS,           -- Deduction Amount [idgt_deduct_amt]
    GOODS_NMBR,           -- Goods Number [ficntaxinvc_itm_goodsnmbr]
    TAX_RATE,             -- Tax Rate [gttaxrate]
    TOLL_CAR_LICPLATE,    -- Toll Car Lic. Plate [ficntaxinvc_itm_toll_car_licpt]
    TOLL_CAT_CATEGORY,    -- Toll Car Category [ficntaxinvc_itm_toll_cat_cate]
    TOLL_START_DATETIME,  -- Toll Start Date Time [ficntaxinvc_itm_toll_start_dt]
    TOLL_END_DATETIME,    -- Toll End Date Time [ficntaxinvc_itm_toll_end_dt]
    MARK_AS_DELETE,       -- Deleted [ficntaxinvc_dele_flag]
    PRIMARY KEY (MANDT, INVC_ITEM_UUID)
);

Learn More