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 26 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 |
Fields (26)
| 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. | ||||
| 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)
);
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