TXI_TRANSF_ITM
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 22 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_CN_TaxTransfItem | view | from | BASIC | Input VAT Transfer Item |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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. | ||||
| 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]
ITEM_DECLN_TIME, -- Declaration Time [ficntaxdecln_time]
PRIMARY KEY (MANDT, TRANSFER_UUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA