C_ZA_SuplrCharcsAndTaxItemCube

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_ZA_SuplrCharcsAndTaxItemCube.
-- 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: CZASUPCHARTXITMC
-- Parameters: P_KeyDate : sydate, P_SupplierRecognitionLevel : fiza_bee_level, P_ZA_OrgIsEligibleToBBBEE050 : fiza_bee_charc_blackowned, P_ZA_OrgIsEligibleToBBBEE030 : fiza_bee_charc_blackwomenowned, P_SupplierTurnoverLevel : fiza_bee_turnover_level, P_SupplierIsEmpowering : fiza_bee_charc_empowering_sup, P_HasSupplierRole : fiza_bee_charc_entdev_sup, P_ConversionFactor : fiza_bee_mulfactor, P_ContractExpiryPredictedDate : fiza_bee_sup_expirydate

CREATE VIEW C_ZA_SuplrCharcsAndTaxItemCube AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.Supplier AS Supplier,
  CharValue.ClfnObjectID AS ClfnObjectID,
  TaxItem._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  TaxItem._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  TaxItem._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  division (CharValue.ConversionFactor,100,2) AS ConversionFactor,
  TaxItem.ReportingDate AS ReportingDate,
  TaxItem._Supplier.BPSupplierName AS BPSupplierName,
  CharValue.SupplierRecognitionLevel AS SupplierRecognitionLevel,
  CharValue.ZA_OrgIsEligibleToBBBEE050 AS ZA_OrgIsEligibleToBBBEE050,
  CharValue.ZA_OrgIsEligibleToBBBEE030 AS ZA_OrgIsEligibleToBBBEE030,
  CharValue.SupplierTurnoverLevel AS SupplierTurnoverLevel,
  CharValue.SupplierIsEmpowering AS SupplierIsEmpowering,
  CharValue.SupplierIsEnterpriseDeveloped AS SupplierIsEnterpriseDeveloped,
  cast (CharValue.ContractExpiryPredictedDate as fiza_expirydate) AS ContractExpiryPredictedDate,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  TaxItem.TaxBaseAmountInCoCodeCrcy * division (CharValue.ConversionFactor,100,2) AS RevenueAdjustmentAmount,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_StRpTaxItem AS TaxItem
LEFT OUTER JOIN P_ZA_CharacteristicsValue ON /* join condition not captured in parsed metadata */
;