I_CN_GoldenTaxDocumentItem

DDL: I_CN_GOLDENTAXDOCUMENTITEM Type: view COMPOSITE Package: GLO_FIN_TAX_GTI_CN
26 Fields 1 Data Sources 1 Associations

China Golden Tax Document Item

I_CN_GoldenTaxDocumentItem is a Composite CDS View that provides data about "China Golden Tax Document Item" in SAP S/4HANA. It reads from 1 data source (I_CN_GoldenTaxDocumentItmBasic) and exposes 26 fields with key field CN_GoldenTaxItemUUID. It has 1 association to related views. Part of development package GLO_FIN_TAX_GTI_CN.

Data Sources (1)

SourceAliasJoin Type
I_CN_GoldenTaxDocumentItmBasic I_CN_GoldenTaxDocumentItmBasic from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _LocalCurrency $projection.LocalCurrency = _LocalCurrency.Currency

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICNGTDITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label China Golden Tax Document Item view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CN_GoldenTaxItemUUID CN_GoldenTaxItemUUID GT Doc. Item UUID
CN_GoldenTaxUUID CN_GoldenTaxUUID GT Doc. Header UUID
CN_GoldenTaxDocument CN_GoldenTaxDocument GT Doc No
CN_GoldenTaxDocumentItem CN_GoldenTaxDocumentItem Item Number
Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
ProductName ProductName Description
SizeOrDimensionText SizeOrDimensionText Size/dimensions
BilledQuantityUnit BilledQuantityUnit Base Unit
BilledQuantity BilledQuantity Quantity Billed
BilledQuantityUnitName BilledQuantityUnitName Uni.Measure
NetAmount NetAmount Stated Amount
TaxAmount TaxAmount Tax Amt in Rptg Crcy
CN_TaxInvcDiscNetAmtInLoclCrcy CN_TaxInvcDiscNetAmtInLoclCrcy Discount
CN_TaxInvcDiscTaxAmtInLoclCrcy CN_TaxInvcDiscTaxAmtInLoclCrcy Tax Amount
CN_GoldenTaxDdctdAmtInLoclCrcy CN_GoldenTaxDdctdAmtInLoclCrcy Deduction Amount
CN_GoldenTaxUnitPrice CN_GoldenTaxUnitPrice Unit Price Bfr Disc
CN_GoldenTaxClassfctnNumber CN_GoldenTaxClassfctnNumber Tax Classificat. No.
CN_GoldenTaxPrfntlTreatment CN_GoldenTaxPrfntlTreatment Preferent. Treatment
CN_GoldenTaxIdentification CN_GoldenTaxIdentification Zero Tax Rate Idn
CN_GoldenTxPrfntlTrtmtNote CN_GoldenTxPrfntlTrtmtNote Pref. Treatment Desc
CN_GoldenTaxCommodityCode CN_GoldenTaxCommodityCode Internal Matl No.
CN_GoldenTaxClassificationDesc CN_GoldenTaxClassificationDesc Desc. of Tax Cls. No
LocalCurrency LocalCurrency Local Currency
_GTDHeader _GTDHeader
_LocalCurrency _LocalCurrency

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 I_CN_GoldenTaxDocumentItem.
-- 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.

CREATE VIEW I_CN_GoldenTaxDocumentItem AS
SELECT
  CN_GoldenTaxItemUUID,
  CN_GoldenTaxUUID,
  CN_GoldenTaxDocument,
  CN_GoldenTaxDocumentItem,
  Product,
  ProductGroup,
  ProductName,
  SizeOrDimensionText,
  BilledQuantityUnit,
  BilledQuantity,
  BilledQuantityUnitName,
  NetAmount,
  TaxAmount,
  CN_TaxInvcDiscNetAmtInLoclCrcy,
  CN_TaxInvcDiscTaxAmtInLoclCrcy,
  CN_GoldenTaxDdctdAmtInLoclCrcy,
  CN_GoldenTaxUnitPrice,
  CN_GoldenTaxClassfctnNumber,
  CN_GoldenTaxPrfntlTreatment,
  CN_GoldenTaxIdentification,
  CN_GoldenTxPrfntlTrtmtNote,
  CN_GoldenTaxCommodityCode,
  CN_GoldenTaxClassificationDesc,
  LocalCurrency
FROM I_CN_GoldenTaxDocumentItmBasic
LEFT OUTER JOIN I_Currency AS _LocalCurrency ON LocalCurrency = _LocalCurrency.Currency  -- association [0..1]
;

Learn More