TXI_HDR

Transparent Table Application Table
75 Fields 5 CDS Views

China Tax Invoice Header

TXI_HDR is an SAP database table in S/4HANA. China Tax Invoice Header. It contains 75 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_CN_TaxInputInvc view from EXTENSION Extension View of Incoming VAT Invoice
E_CN_TaxInputInvcMng view from EXTENSION Extension View of Incoming VAT Invoice
I_CN_GoldenTaxInvoiceBasic view from BASIC China Golden Tax Invoice Header
P_CN_TaxInputInvc view from BASIC
P_CN_TaxInputInvoiceItem view inner BASIC

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY invc_uuid FICNTAXINVC_UUID Invoice UUID
invc_code FICNTAXINVC_CODE VAT Invoice Code
invc_nmbr FICNTAXINVC_NMBR VAT Invoice No.
seller_tax_reg_nmbr FICNTAX_REG_NMBR Unfd Socl Crdt Code
buyer_tax_reg_nmbr FICNTAX_REG_NMBR Unfd Socl Crdt Code
invc_type FICNTAXINVC_TYPE VAT Invoice Type
invc_iss_date FICNTAXINVC_ISSR_DATE VAT Invoice Date
invc_crcy_code WAERS Currency
net_amount FICNTAXINVC_AMNT_NET Net Amount
tax_amount FICNTAXINVC_AMNT_TAX Tax Amount
cntax_entity_id FICNTAX_ENTITY_ID Tax Entity
disc_net_amount FICNTAXINVC_AMNT_NET Net Amount
disc_tax_amount FICNTAXINVC_AMNT_TAX Tax Amount
is_elec_flag FICNTAXINVC_ELEC_FLAG E-invoice
invc_drctn_flag FICNTAXINVC_DRCTN_FLAG Tax Direction
mark_as_delete FICNTAXINVC_DELE_FLAG Deleted
tax_rate GTTAXRATE Tax Rate
deduct_tax_amount FICNTAXINVC_AMNT_DEDUCT Deduct. Tax Amount
usage FICNTAXINVC_USAGE Usage
data_source FICNTAXINVC_DATA_SOURCE Data Source
expnrpt_nmbr FICNTAXINVC_EXPNRPT_NMBR ExpnRpt Nmbr
company_code FIS_BUKRS Company Code
invc_gts_status FICNTAXINVC_GTS_STATUS GT Status
invc_gts_sync_time FICNTAX_GTS_SYNC_TIME Sync. Time with GT
input_invc_proc_status FICNTAXINVC_INPUT_STATUS Processing Status
invc_deduct_type FICNTAXINVC_DEDUCT_TYPE Deduction Type
invc_fiscal_year GJAHR Fiscal Year
seller_name FICNTAXINVC_SELLER_NAME Seller Name
comments FICNTAXINVC_COMMENTS Comment
invc_origin FICNTAXINVC_ORIGIN Tax Invoice Source
purchase_org EKORG Purchasing Org.
purchase_grp EKGRP Purch. Group
supplier ELIFN Supplier
input_vat_cat FICNTAX_INPUT_VAT_CAT Input VAT Category
invc_decln_time FICNTAXDECLN_TIME Declaration Time
invc_decln_year FICNTAXDECLN_YEAR Year
invc_decln_month FICNTAXDECLN_MONTH Month
invc_posted_indicator FICNTAXINVC_POSTED_INDICATOR Invoice Posted
is_tax_rebate FICNTAXINVC_TAX_REBATE_FLAG Process Tax Rebate
decln_type FICNTAXINVC_DECLN_TYPE Declaration Type
vehicle_type FICNTAXINVC_VEHICLE_TYPE Vehicle Type
veh_factory_model FICNTAXINVC_VEH_FACTORY_MODEL Veh. Factory Model
veh_prodn_place FICNTAXINVC_VEH_PRODN_PLACE Veh. Prodn Place
veh_cert_nmbr FICNTAXINVC_VEH_CERT_NMBR Veh. Certfn Number
veh_imprtcert_nmbr FICNTAXINVC_VEH_IMPRTCERT_NMBR Imprt Certfn Nmbr
veh_insp_nmbr FICNTAXINVC_VEH_INSP_NMBR Veh. Inspection Nmbr
veh_engine_nmbr FICNTAXINVC_VEH_ENGINE_NMBR Veh. Engine Nmbr
vehicle_nmbr FICNTAXINVC_VEHICLE_NMBR Vehicle Number
veh_total_amount FICNTAXINVC_VEH_TOTAL_AMOUNT Vehicle Total Amount
veh_txn_recd_nmbr FICNTAXINVC_VEH_TXN_RECD_NMBR Veh. Taxation Nmbr
veh_tonnage FICNTAXINVC_VEH_TONNAGE Vehicle Tonnage
veh_pssengr_limit FICNTAXINVC_VEH_PSSENGR_LIMIT Veh. Pssngr Limit
is_goods_list GTLISTIND GT Goods List
print_date GTPRINTDAT Print Date
buyer_nmbr KUNNR Customer
buyer_name GTNAME1 Customer Name
buyer_bank EIV_BANK Customer Bank
buyer_addr_tel EIV_ADDR Customer Address
seller_bank EIV_BANK Customer Bank
seller_addr_tel EIV_ADDR Customer Address
red_note_nmbr GTREDNOTENR Red-Ltr. Notif. No.
note GTNOTE GT Note
deductions IDGT_DEDUCT_AMT Deduction Amount
eiv_invc_url EIV_INVC_URL PDF URL
eiv_h5invc_url EIV_H5INVC_URL H5 Invoice URL
eiv_invc_odf_url EIV_INVC_ODF_URL OFD URL
eiv_invc_xml_url EIV_INVC_XML_URL XML URL
create_user FICNTAX_CREATE_USER Created By
create_time FICNTAX_CREATE_TIME Creation Time
change_user FICNTAX_CHANGE_USER Changed By
change_time FICNTAX_CHANGE_TIME Changing Time
_dataaging DATA_TEMPERATURE Data Aging
dummy_ficntax_invc_incl_eew_ps CFD_DUMMY Dummy
dummy_ficntxi_mng_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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TXI_HDR (
    MANDT,                           -- Client [MANDT]
    INVC_UUID,                       -- Invoice UUID [FICNTAXINVC_UUID]
    INVC_CODE,                       -- VAT Invoice Code [FICNTAXINVC_CODE]
    INVC_NMBR,                       -- VAT Invoice No. [FICNTAXINVC_NMBR]
    SELLER_TAX_REG_NMBR,             -- Unfd Socl Crdt Code [FICNTAX_REG_NMBR]
    BUYER_TAX_REG_NMBR,              -- Unfd Socl Crdt Code [FICNTAX_REG_NMBR]
    INVC_TYPE,                       -- VAT Invoice Type [FICNTAXINVC_TYPE]
    INVC_ISS_DATE,                   -- VAT Invoice Date [FICNTAXINVC_ISSR_DATE]
    INVC_CRCY_CODE,                  -- Currency [WAERS]
    NET_AMOUNT,                      -- Net Amount [FICNTAXINVC_AMNT_NET]
    TAX_AMOUNT,                      -- Tax Amount [FICNTAXINVC_AMNT_TAX]
    CNTAX_ENTITY_ID,                 -- Tax Entity [FICNTAX_ENTITY_ID]
    DISC_NET_AMOUNT,                 -- Net Amount [FICNTAXINVC_AMNT_NET]
    DISC_TAX_AMOUNT,                 -- Tax Amount [FICNTAXINVC_AMNT_TAX]
    IS_ELEC_FLAG,                    -- E-invoice [FICNTAXINVC_ELEC_FLAG]
    INVC_DRCTN_FLAG,                 -- Tax Direction [FICNTAXINVC_DRCTN_FLAG]
    MARK_AS_DELETE,                  -- Deleted [FICNTAXINVC_DELE_FLAG]
    TAX_RATE,                        -- Tax Rate [GTTAXRATE]
    DEDUCT_TAX_AMOUNT,               -- Deduct. Tax Amount [FICNTAXINVC_AMNT_DEDUCT]
    USAGE,                           -- Usage [FICNTAXINVC_USAGE]
    DATA_SOURCE,                     -- Data Source [FICNTAXINVC_DATA_SOURCE]
    EXPNRPT_NMBR,                    -- ExpnRpt Nmbr [FICNTAXINVC_EXPNRPT_NMBR]
    COMPANY_CODE,                    -- Company Code [FIS_BUKRS]
    INVC_GTS_STATUS,                 -- GT Status [FICNTAXINVC_GTS_STATUS]
    INVC_GTS_SYNC_TIME,              -- Sync. Time with GT [FICNTAX_GTS_SYNC_TIME]
    INPUT_INVC_PROC_STATUS,          -- Processing Status [FICNTAXINVC_INPUT_STATUS]
    INVC_DEDUCT_TYPE,                -- Deduction Type [FICNTAXINVC_DEDUCT_TYPE]
    INVC_FISCAL_YEAR,                -- Fiscal Year [GJAHR]
    SELLER_NAME,                     -- Seller Name [FICNTAXINVC_SELLER_NAME]
    COMMENTS,                        -- Comment [FICNTAXINVC_COMMENTS]
    INVC_ORIGIN,                     -- Tax Invoice Source [FICNTAXINVC_ORIGIN]
    PURCHASE_ORG,                    -- Purchasing Org. [EKORG]
    PURCHASE_GRP,                    -- Purch. Group [EKGRP]
    SUPPLIER,                        -- Supplier [ELIFN]
    INPUT_VAT_CAT,                   -- Input VAT Category [FICNTAX_INPUT_VAT_CAT]
    INVC_DECLN_TIME,                 -- Declaration Time [FICNTAXDECLN_TIME]
    INVC_DECLN_YEAR,                 -- Year [FICNTAXDECLN_YEAR]
    INVC_DECLN_MONTH,                -- Month [FICNTAXDECLN_MONTH]
    INVC_POSTED_INDICATOR,           -- Invoice Posted [FICNTAXINVC_POSTED_INDICATOR]
    IS_TAX_REBATE,                   -- Process Tax Rebate [FICNTAXINVC_TAX_REBATE_FLAG]
    DECLN_TYPE,                      -- Declaration Type [FICNTAXINVC_DECLN_TYPE]
    VEHICLE_TYPE,                    -- Vehicle Type [FICNTAXINVC_VEHICLE_TYPE]
    VEH_FACTORY_MODEL,               -- Veh. Factory Model [FICNTAXINVC_VEH_FACTORY_MODEL]
    VEH_PRODN_PLACE,                 -- Veh. Prodn Place [FICNTAXINVC_VEH_PRODN_PLACE]
    VEH_CERT_NMBR,                   -- Veh. Certfn Number [FICNTAXINVC_VEH_CERT_NMBR]
    VEH_IMPRTCERT_NMBR,              -- Imprt Certfn Nmbr [FICNTAXINVC_VEH_IMPRTCERT_NMBR]
    VEH_INSP_NMBR,                   -- Veh. Inspection Nmbr [FICNTAXINVC_VEH_INSP_NMBR]
    VEH_ENGINE_NMBR,                 -- Veh. Engine Nmbr [FICNTAXINVC_VEH_ENGINE_NMBR]
    VEHICLE_NMBR,                    -- Vehicle Number [FICNTAXINVC_VEHICLE_NMBR]
    VEH_TOTAL_AMOUNT,                -- Vehicle Total Amount [FICNTAXINVC_VEH_TOTAL_AMOUNT]
    VEH_TXN_RECD_NMBR,               -- Veh. Taxation Nmbr [FICNTAXINVC_VEH_TXN_RECD_NMBR]
    VEH_TONNAGE,                     -- Vehicle Tonnage [FICNTAXINVC_VEH_TONNAGE]
    VEH_PSSENGR_LIMIT,               -- Veh. Pssngr Limit [FICNTAXINVC_VEH_PSSENGR_LIMIT]
    IS_GOODS_LIST,                   -- GT Goods List [GTLISTIND]
    PRINT_DATE,                      -- Print Date [GTPRINTDAT]
    BUYER_NMBR,                      -- Customer [KUNNR]
    BUYER_NAME,                      -- Customer Name [GTNAME1]
    BUYER_BANK,                      -- Customer Bank [EIV_BANK]
    BUYER_ADDR_TEL,                  -- Customer Address [EIV_ADDR]
    SELLER_BANK,                     -- Customer Bank [EIV_BANK]
    SELLER_ADDR_TEL,                 -- Customer Address [EIV_ADDR]
    RED_NOTE_NMBR,                   -- Red-Ltr. Notif. No. [GTREDNOTENR]
    NOTE,                            -- GT Note [GTNOTE]
    DEDUCTIONS,                      -- Deduction Amount [IDGT_DEDUCT_AMT]
    EIV_INVC_URL,                    -- PDF URL [EIV_INVC_URL]
    EIV_H5INVC_URL,                  -- H5 Invoice URL [EIV_H5INVC_URL]
    EIV_INVC_ODF_URL,                -- OFD URL [EIV_INVC_ODF_URL]
    EIV_INVC_XML_URL,                -- XML URL [EIV_INVC_XML_URL]
    CREATE_USER,                     -- Created By [FICNTAX_CREATE_USER]
    CREATE_TIME,                     -- Creation Time [FICNTAX_CREATE_TIME]
    CHANGE_USER,                     -- Changed By [FICNTAX_CHANGE_USER]
    CHANGE_TIME,                     -- Changing Time [FICNTAX_CHANGE_TIME]
    _DATAAGING,                      -- Data Aging [DATA_TEMPERATURE]
    DUMMY_FICNTAX_INVC_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    DUMMY_FICNTXI_MNG_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, INVC_UUID)
);

Learn More