TXI_ITM

Transparent Table Application Table
26 Fields 3 CDS Views

China Tax Invoice Item

TXI_ITM is an SAP database table in S/4HANA. China Tax Invoice Item. It contains 26 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

Fields (26)

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
dummy_ficntxi_itm_incl_eew_ps CFD_DUMMY Dummy

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]
    DUMMY_FICNTXI_ITM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, INVC_ITEM_UUID)
);

Learn More