C_CN_TaxTransferItemCube

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_TaxTransferItemCube.
-- 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: CCNTXITRANSFIC

CREATE VIEW C_CN_TaxTransferItemCube AS
SELECT
  item.CN_TaxTransfItmUUID AS CN_TaxTransfItmUUID,
  item.CompanyCode AS CompanyCode,
  item.CN_TaxEntityID AS CN_TaxEntityID,
  item.CN_TaxTransfType AS CN_TaxTransfType,
  item._TransferType._Text[ 1: Language = $session.system_language ].CN_TaxTransfTypeTxt AS CN_TaxTransfTypeTxt,
  item._TransferType.CN_TaxTransfDrctn AS CN_TaxTransfDrctn,
  item._TransferType._TransfDrctn.DomainText AS DomainText,
  invoice.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  invoice.CN_TaxInvcCode AS CN_TaxInvcCode,
  invoice.CN_TaxInvcNmbr AS CN_TaxInvcNmbr,
  invoice.CN_TaxInvcDate AS CN_TaxInvcDate,
  item.CN_TaxTransfNetAmtInInvcCrcy AS CN_TaxTransfNetAmtInInvcCrcy,
  item.CN_TaxInvcCrcy AS CN_TaxInvcCrcy,
  item.CN_TaxDeclnYear AS CN_TaxDeclnYear,
  item.CN_TaxDeclnMonth AS CN_TaxDeclnMonth,
  item.CN_TaxTransfItmSts AS CN_TaxTransfItmSts,
  _ItemStatus.DocumentStatusDesc AS DocumentStatusDesc,
  item.CN_TaxTransfJrnlEntr AS CN_TaxTransfJrnlEntr,
  item.FiscalYear AS FiscalYear,
  item.CN_TaxTransfCmnt AS CN_TaxTransfCmnt
FROM I_CN_TaxTransfItem AS item
LEFT OUTER JOIN I_CN_TaxInputInvc AS invoice ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_CN_TaxTransfType AS _TransferType ON CN_TaxTransfType = _TransferType.CN_TaxTransfType  -- association [1]
LEFT OUTER JOIN C_CN_TaxCurrency AS _Currency ON CN_TaxInvcCrcy = _Currency.Currency  -- association [1]
LEFT OUTER JOIN C_CN_TaxCompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN C_CN_TaxEntity AS _TaxEntity ON CN_TaxEntityID = _TaxEntity.CN_TaxEntityID AND CompanyCode = _TaxEntity.CompanyCode  -- association [1]
LEFT OUTER JOIN C_CN_TaxTransfItmSts AS _ItemStatus ON CN_TaxTransfItmSts = _ItemStatus.CN_TaxTransfItmSts  -- association [1]
LEFT OUTER JOIN C_CN_TaxTransfDrctn AS _TransferDirection ON cn_taxtransfdrctn = _TransferDirection.CN_TaxTransfDrctn  -- association [1]
LEFT OUTER JOIN C_CN_TaxDeclarationMonth AS _DeclarationMonth ON CN_TaxDeclnMonth = _DeclarationMonth.CN_TaxDeclnMonth  -- association [1]
;