C_CN_TaxTransferItemQuery

DDL: C_CN_TAXTRANSFERITEMQUERY SQL: CCNTXITRANSFIQ Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_CN
19 Fields 1 Data Sources

China Input VAT Transfer

C_CN_TaxTransferItemQuery is a Consumption CDS View that provides data about "China Input VAT Transfer" in SAP S/4HANA. It reads from 1 data source (C_CN_TaxTransferItemCube) and exposes 19 fields with key field CN_TaxTransfItmUUID. Part of development package GLO_FIN_IS_VAT_CN.

Data Sources (1)

SourceAliasJoin Type
C_CN_TaxTransferItemCube transfer from

Parameters (1)

NameTypeDefault
P_CompanyCode bukrs

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CCNTXITRANSFIQ view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label China Input VAT Transfer view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CN_TaxTransfItmUUID CN_TaxTransfItmUUID Transf. Item UUID
CompanyCode CompanyCode Receiver Company Code
CN_TaxTransfTypeTxt CN_TaxTransfTypeTxt
CN_TaxTransfType CN_TaxTransfType Transfer Type
CN_TaxEntityID CN_TaxEntityID Tax Entity
CN_TaxInvcCode CN_TaxInvcCode
CN_TaxInvcNmbr CN_TaxInvcNmbr
CN_TaxTransfDrctn CN_TaxTransfDrctn
CN_TaxInvcDate CN_TaxInvcDate
DomainText DomainText Short Description
CN_TaxInvcUUID CN_TaxInvcUUID Invoice UUID
CN_TaxTransfNetAmtInInvcCrcy CN_TaxTransfNetAmtInInvcCrcy Tax Amount
CN_TaxInvcCrcy CN_TaxInvcCrcy Currency
CN_TaxDeclnYear CN_TaxDeclnYear Year
CN_TaxDeclnMonth CN_TaxDeclnMonth Month
CN_TaxTransfItmSts CN_TaxTransfItmSts Transfer Status
CN_TaxTransfJrnlEntr CN_TaxTransfJrnlEntr Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
CN_TaxTransfCmnt CN_TaxTransfCmnt Comment

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CN_TaxTransferItemQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCNTXITRANSFIQ
-- Parameters: P_CompanyCode : bukrs

CREATE VIEW C_CN_TaxTransferItemQuery AS
SELECT
  CN_TaxTransfItmUUID,
  CompanyCode,
  CN_TaxTransfTypeTxt,
  CN_TaxTransfType,
  CN_TaxEntityID,
  CN_TaxInvcCode,
  CN_TaxInvcNmbr,
  CN_TaxTransfDrctn,
  CN_TaxInvcDate,
  DomainText,
  CN_TaxInvcUUID,
  CN_TaxTransfNetAmtInInvcCrcy,
  CN_TaxInvcCrcy,
  CN_TaxDeclnYear,
  CN_TaxDeclnMonth,
  CN_TaxTransfItmSts,
  CN_TaxTransfJrnlEntr,
  FiscalYear,
  CN_TaxTransfCmnt
FROM C_CN_TaxTransferItemCube AS transfer
;

Learn More