C_CN_TaxDeductionItemQuery

DDL: C_CN_TAXDEDUCTIONITEMQUERY SQL: CCNTXIDEDUCTIONQ Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_CN
25 Fields 1 Data Sources 1 Associations

China Input VAT Deduction

C_CN_TaxDeductionItemQuery is a Consumption CDS View that provides data about "China Input VAT Deduction" in SAP S/4HANA. It reads from 1 data source (C_CN_TaxDeductionItemCube) and exposes 25 fields with key fields CN_TaxInvcUUID, CategoryDescription, CN_TaxInvcCode, CN_TaxInvcNmbr. It has 1 association to related views. Part of development package GLO_FIN_IS_VAT_CN.

Data Sources (1)

SourceAliasJoin Type
C_CN_TaxDeductionItemCube deduct from

Parameters (1)

NameTypeDefault
P_CompanyCode bukrs

Associations (1)

CardinalityTargetAliasCondition
[1] C_CN_TaxInvcInptProcgSts _InvoiceStatus $projection.CN_TaxInvcInptProcgSts = _InvoiceStatus.CN_TaxInvcInptProcgSts

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CCNTXIDEDUCTIONQ 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 Deduction view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CN_TaxInvcUUID CN_TaxInvcUUID Invoice UUID
KEY CategoryDescription CategoryDescription Category Description
KEY CN_TaxInvcCode CN_TaxInvcCode
KEY CN_TaxInvcNmbr CN_TaxInvcNmbr
CompanyCode CompanyCode Receiver Company Code
CN_TaxEntityID CN_TaxEntityID Tax Entity
TaxCategory TaxCategory Tax Code
CN_TaxInvcDate CN_TaxInvcDate
DisplayTaxRate DisplayTaxRate
CN_TaxInvcNetAmtInInvcCrcy CN_TaxInvcNetAmtInInvcCrcy
CN_TaxInvcTaxAmtInInvcCrcy CN_TaxInvcTaxAmtInInvcCrcy
CN_TaxInvcDeductAmtInInvcCrcy CN_TaxInvcDeductAmtInInvcCrcy
TaxAmount TaxAmount Tax Amt in Rptg Crcy
CN_TaxInvcType CN_TaxInvcType
CN_TaxInvcTypeTxt CN_TaxInvcTypeTxt
DocumentStatusDesc DocumentStatusDesc
CN_TaxInvcInptProcgSts CN_TaxInvcInptProcgSts
RatioUnit RatioUnit Unit of Measure
CN_TaxInvcCrcy CN_TaxInvcCrcy Currency
CN_TaxInvcTotAmtInInvcCrcy 1
CN_TaxDeclnYear CN_TaxDeclnYear Year
CN_TaxDeclnMonth CN_TaxDeclnMonth Month
CN_TaxInvoiceUsage CN_TaxInvoiceUsage
CN_TaxInvoiceDataSource CN_TaxInvoiceDataSource
CN_TaxInvoiceExpenseReportNmbr CN_TaxInvoiceExpenseReportNmbr

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_TaxDeductionItemQuery.
-- 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: CCNTXIDEDUCTIONQ
-- Parameters: P_CompanyCode : bukrs

CREATE VIEW C_CN_TaxDeductionItemQuery AS
SELECT
  CN_TaxInvcUUID,
  CategoryDescription,
  CN_TaxInvcCode,
  CN_TaxInvcNmbr,
  CompanyCode,
  CN_TaxEntityID,
  TaxCategory,
  CN_TaxInvcDate,
  DisplayTaxRate,
  CN_TaxInvcNetAmtInInvcCrcy,
  CN_TaxInvcTaxAmtInInvcCrcy,
  CN_TaxInvcDeductAmtInInvcCrcy,
  TaxAmount,
  CN_TaxInvcType,
  CN_TaxInvcTypeTxt,
  DocumentStatusDesc,
  CN_TaxInvcInptProcgSts,
  RatioUnit,
  CN_TaxInvcCrcy,
  1 AS CN_TaxInvcTotAmtInInvcCrcy,
  CN_TaxDeclnYear,
  CN_TaxDeclnMonth,
  CN_TaxInvoiceUsage,
  CN_TaxInvoiceDataSource,
  CN_TaxInvoiceExpenseReportNmbr
FROM C_CN_TaxDeductionItemCube AS deduct
LEFT OUTER JOIN C_CN_TaxInvcInptProcgSts AS _InvoiceStatus ON CN_TaxInvcInptProcgSts = _InvoiceStatus.CN_TaxInvcInptProcgSts  -- association [1]
;

Learn More