TXI_TRANSF_ITM

Transparent Table Application Table

China Tax Invoice Tax Transfer Item

TXI_TRANSF_ITM is an SAP database table in S/4HANA. China Tax Invoice Tax Transfer Item. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CN_TaxTransfItem view from BASIC

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY transfer_uuid FICNTAX_TRANSF_ITM_UUID Transf. Item UUID
invc_uuid FICNTAXINVC_UUID Invoice UUID
decln_smmry_uuid FICNTAXDECLN_SMMRYUUID Decln Summary UUID
item_num FICNTAX_TRANSF_ITM_NMBR Transfer Item No.
transfer_type FICNTAX_TRANSF_TYPE Transfer Type
currency_code FICNTAXINVC_CRCY Currency
net_amount FICNTAXINVC_AMNT_TAX Tax Amount
comments FICNTAX_TRANSF_COMMENT Comment
mark_as_delete FICNTAX_TRANSFDELTNFLAG Transf. Item Deleted
item_status FICNTAX_TRANSF_STATUS Transfer Status
company_code FIS_BUKRS Company Code
tax_entity_id FICNTAX_ENTITY_ID Tax Entity
target_transf_ratio FICNTAX_TRANSF_TARGET_RATIO Transfer Ratio
target_period_by_month FICNTAX_TRANSF_TARGET_PERIOD Offset by Month
decln_year FICNTAXDECLN_YEAR Year
decln_month FICNTAXDECLN_MONTH Month
acc_doc_nmnr FICNTAX_JRNLENTR Journal Entry
fiscal_year GJAHR Fiscal Year
acc_doc_sts FICNTAX_JRNLENTRSTS Jrnl Entry Status
prev_item_num FICNTAX_TRANSF_ITM_NMBR Transfer Item No.
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
item_decln_time FICNTAXDECLN_TIME Declaration Time

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 Tax Transfer Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TXI_TRANSF_ITM (
    MANDT,                   -- Client [MANDT]
    TRANSFER_UUID,           -- Transf. Item UUID [FICNTAX_TRANSF_ITM_UUID]
    INVC_UUID,               -- Invoice UUID [FICNTAXINVC_UUID]
    DECLN_SMMRY_UUID,        -- Decln Summary UUID [FICNTAXDECLN_SMMRYUUID]
    ITEM_NUM,                -- Transfer Item No. [FICNTAX_TRANSF_ITM_NMBR]
    TRANSFER_TYPE,           -- Transfer Type [FICNTAX_TRANSF_TYPE]
    CURRENCY_CODE,           -- Currency [FICNTAXINVC_CRCY]
    NET_AMOUNT,              -- Tax Amount [FICNTAXINVC_AMNT_TAX]
    COMMENTS,                -- Comment [FICNTAX_TRANSF_COMMENT]
    MARK_AS_DELETE,          -- Transf. Item Deleted [FICNTAX_TRANSFDELTNFLAG]
    ITEM_STATUS,             -- Transfer Status [FICNTAX_TRANSF_STATUS]
    COMPANY_CODE,            -- Company Code [FIS_BUKRS]
    TAX_ENTITY_ID,           -- Tax Entity [FICNTAX_ENTITY_ID]
    TARGET_TRANSF_RATIO,     -- Transfer Ratio [FICNTAX_TRANSF_TARGET_RATIO]
    TARGET_PERIOD_BY_MONTH,  -- Offset by Month [FICNTAX_TRANSF_TARGET_PERIOD]
    DECLN_YEAR,              -- Year [FICNTAXDECLN_YEAR]
    DECLN_MONTH,             -- Month [FICNTAXDECLN_MONTH]
    ACC_DOC_NMNR,            -- Journal Entry [FICNTAX_JRNLENTR]
    FISCAL_YEAR,             -- Fiscal Year [GJAHR]
    ACC_DOC_STS,             -- Jrnl Entry Status [FICNTAX_JRNLENTRSTS]
    PREV_ITEM_NUM,           -- Transfer Item No. [FICNTAX_TRANSF_ITM_NMBR]
    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]
    ITEM_DECLN_TIME,         -- Declaration Time [FICNTAXDECLN_TIME]
    PRIMARY KEY (MANDT, TRANSFER_UUID)
);