C_SVTCalculation

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_SVTCalculation.
-- 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 C_SVTCalculation AS
SELECT
  SVTCalculationUUID,
  SVTCalculationLastResultUUID,
  SVTPreprocessedDocumentUUID,
  ComplianceRequirement,
  SVTPreprocessedDocumentDate,
  Material,
  Plant,
  CompanyCode,
  ApplicationLogHandle,
  ProdCmplncLglEntyMappgUUID,
  Supplier,
  _Supplier.BPSupplierName AS BPSupplierName,
  SVTBusinessProcess,
  _BusinessProcess._Text[1: Language = $session.system_language].SVTBusinessProcessText AS SVTBusinessProcessText,
  SVTBusinessProcessScenario,
  _BusinessProcessScenario._Text[1: Language = $session.system_language].CmplRqSVTScenarioText AS CmplRqSVTScenarioText,
  _LatestCalculationResult.SVTCalculationResultUUID AS SVTCalculationResultUUID,
  _LatestCalculationResult.ProdCmplncEventUUID AS ProdCmplncEventUUID,
  _LatestCalculationResult.ProdCmplncEventType AS ProdCmplncEventType,
  _LatestCalculationResult.ProdCmplncEventTypeText AS ProdCmplncEventTypeText,
  _LatestCalculationResult.SVTCalcChmCmInRglnUUID AS SVTCalcChmCmInRglnUUID,
  _LatestCalculationResult.SVTCalcChmCmInUUID AS SVTCalcChmCmInUUID,
  _LatestCalculationResult.CreationDateTime AS CreationDateTime,
  _LatestCalculationResult.ProdCmplncLegalEntity AS ProdCmplncLegalEntity,
  _LatestCalculationResult.CmplRqVersName AS CmplRqVersName,
  _LatestCalculationResult.CmplRqPattern AS CmplRqPattern,
  _LatestCalculationResult.CmplRqPatternName AS CmplRqPatternName,
  _LatestCalculationResult.EffectiveDate AS EffectiveDate,
  _LatestCalculationResult.CmplRqApplicationComponent AS CmplRqApplicationComponent,
  _LatestCalculationResult.CmplRqApplicationComponentName AS CmplRqApplicationComponentName,
  _LatestCalculationResult.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _LatestCalculationResult.ProdCmplncLegalArea AS ProdCmplncLegalArea,
  _LatestCalculationResult.ProdCmplncLegalAreaName AS ProdCmplncLegalAreaName,
  _LatestCalculationResult.CmplRqRsltUUID AS CmplRqRsltUUID,
  _LatestCalculationResult.ChmlCmplncInfoLastChgdDateTime AS ChmlCmplncInfoLastChgdDateTime,
  _LatestCalculationResult.SVTCalculationValidityStatus AS SVTCalculationValidityStatus,
  _LatestCalculationResult.SVTCalcValidityStatusText AS SVTCalcValidityStatusText,
  _LatestCalculationResult.ChmlCompositionType AS ChmlCompositionType,
  _LatestCalculationResult.ChmlCompositionTypeName AS ChmlCompositionTypeName,
  _LatestCalculationResult.ChmlCompositionStatus AS ChmlCompositionStatus,
  _LatestCalculationResult.ChmlCompositionStatusName AS ChmlCompositionStatusName,
  _LatestCalculationResult.ReleaseDateTime AS ReleaseDateTime,
  _LatestCalculationResult.ReleasedByUserName AS ReleasedByUserName,
  _LatestCalculationResult.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _LatestCalculationResult.SVTCalculationStatus AS SVTCalculationStatus,
  _LatestCalculationResult.SVTCalculationStatusText AS SVTCalculationStatusText,
  _LatestCalculationResult._SVTCalcChmlCmplncInfoRgln AS _SVTCalcChmlCmplncInfoRgln,
  _LatestCalculationResult._SVTObjectExclusionReason AS _SVTObjectExclusionReason,
  ChmlSuplrMatlImprtRespyUUID,
  _ChmlSuplrMatlImprtRespy.ImprtRespyBuyingCompanyCode AS ImprtRespyBuyingCompanyCode,
  _ChmlSuplrMatlImprtRespy.ImprtRespyRcvgPlant AS ImprtRespyRcvgPlant,
  _ChmlSuplrMatlImprtRespy.ImprtRespyRespImporter AS ImprtRespyRespImporter,
  _ChmlSuplrMatlImprtRespy.ValidityStartDate AS ValidityStartDate,
  _ChmlSuplrMatlImprtRespy.ValidityEndDate AS ValidityEndDate,
  _ChmlSuplrMatlImprtRespy.ImprtRespyRemarkText AS ImprtRespyRemarkText,
  SVTBizProcCatRespImporter,
  _ResponsibleImporter._Text[ 1:Language = $session.system_language ].ImprtRespyRespImporterText AS ImprtRespyRespImporterText,
  SubstVolSourceCountry,
  _CountryFrom._Text[1: Language = $session.system_language].CountryName AS SVTSourceCountryName,
  SubstVolTargetCountry,
  _CountryTo._Text[1: Language = $session.system_language].CountryName AS SVTTargetCountryName,
  BusinessPartnerSupplier,
  BusinessPartnerCustomer,
  PolymerBreakdownIsRequired,
  PolymerExclusionIsRequired,
  cast( '' as abap.char( 60 )) AS SubstVolRetrackingTypeText
FROM I_SVTCalculation
LEFT OUTER JOIN I_CmplRqSVTScenario AS _BusinessProcessScenario ON SVTBusinessProcessScenario = _BusinessProcessScenario.CmplRqSVTScenario  -- association [0..1]
LEFT OUTER JOIN I_SVTBusinessProcess AS _BusinessProcess ON SVTBusinessProcess = _BusinessProcess.SVTBusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_ChmlSuplrMatlImprtRespy AS _ChmlSuplrMatlImprtRespy ON ChmlSuplrMatlImprtRespyUUID = _ChmlSuplrMatlImprtRespy.ChmlSuplrMatlImprtRespyUUID  -- association [0..1]
LEFT OUTER JOIN C_SVTCalculationResult AS _LatestCalculationResult ON SVTCalculationLastResultUUID = _LatestCalculationResult.SVTCalculationResultUUID AND SVTCalculationUUID = _LatestCalculationResult.SVTCalculationUUID  -- association [0..1]
LEFT OUTER JOIN C_SVTCalculationItem AS _SVTCalculationItem ON SVTCalculationUUID = _SVTCalculationItem.SVTCalculationUUID  -- association [0..*]
LEFT OUTER JOIN C_SVTCalculationResult AS _SVTCalculationResult ON SVTCalculationUUID = _SVTCalculationResult.SVTCalculationUUID  -- association [0..*]
;