C_SVTCalculationResult

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_SVTCalculationResult.
-- 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_SVTCalculationResult AS
SELECT
  SVTCalculationResultUUID,
  SVTCalculationUUID,
  ProdCmplncEventUUID,
  ProdCmplncEventType,
  _ProdCmplncEventType._Text[1: Language = $session.system_language].ProdCmplncEventTypeText AS ProdCmplncEventTypeText,
  SVTCalcChmCmInRglnUUID,
  SVTCalcChmCmInUUID,
  CreationDateTime,
  SVTCalculationDecision,
  _SVTCalculationDecision._Text[ 1: Language = $session.system_language ].SVTCalculationDecisionText AS SVTCalculationDecisionText,
  SVTCalculationDecisionReason,
  _SVTCalcDecisionReason._Text[ 1: Language = $session.system_language ].SVTCalcDecisionReasonText AS SVTCalcDecisionReasonText,
  ProdCmplncLegalEntity,
  SVTCalculationStatus,
  _SVTCalculationStatus._Text[ 1: Language = $session.system_language ].SVTCalculationStatusText AS SVTCalculationStatusText,
  _SVTCalcChmlCmplncInfoRgln._CmplRqVers.CmplRqVersName AS CmplRqVersName,
  _SVTCalcChmlCmplncInfoRgln._CmplRqVers.ComplianceRequirement AS ComplianceRequirement,
  _SVTCalcChmlCmplncInfoRgln._CmplRqVers.CmplRqPattern AS CmplRqPattern,
  _SVTCalcChmlCmplncInfoRgln._CmplRqVers._CompReqPattern.CmplRqPatternName AS CmplRqPatternName,
  _SVTCalcChmlCmplncInfoRgln._CmplRqVers.EffectiveDate AS EffectiveDate,
  _SVTCalcChmlCmplncInfoRgln._CmplRqVers.CmplRqApplicationComponent AS CmplRqApplicationComponent,
  _SVTCalcChmlCmplncInfoRgln._CmplRqVers._CmplRqApplCompText.CmplRqApplicationComponentName AS CmplRqApplicationComponentName,
  _SVTCalcChmlCmplncInfoRgln._ChmlCmplncPrimMatl.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _SVTCalcChmlCmplncInfoRgln.ChmlCompositionType AS ProdCmplncLegalArea,
  _SVTCalcChmlCmplncInfoRgln._LegalAreaText.ProdCmplncLegalAreaName AS ProdCmplncLegalAreaName,
  _SVTCalcChmlCmplncInfo.CmplRqRsltUUID AS CmplRqRsltUUID,
  _SVTCalcChmlCmplncInfo.ChmlCmplncInfoLastChgdDateTime AS ChmlCmplncInfoLastChgdDateTime,
  _SVTCalcChmlCmplncInfo.SVTCalculationValidityStatus AS SVTCalculationValidityStatus,
  _SVTCalcChmlCmplncInfo._SVTCalculationStatus._Text[1: Language = $session.system_language].SVTCalculationStatusText AS SVTCalcValidityStatusText,
  _SVTCalcChmlCmplncInfo._ChmlComposition.ChmlCompositionType AS ChmlCompositionType,
  _SVTCalcChmlCmplncInfo._ChmlComposition._CompositionType._Text[1: Language = $session.system_language ].ChmlCompositionTypeName AS ChmlCompositionTypeName,
  _SVTCalcChmlCmplncInfo._ChmlComposition.ChmlCompositionStatus AS ChmlCompositionStatus,
  _SVTCalcChmlCmplncInfo._ChmlComposition._CompositionStatus._Text[1: Language = $session.system_language ].ChmlCompositionStatusName AS ChmlCompositionStatusName,
  _SVTCalcChmlCmplncInfo._ChmlComposition.ReleaseDateTime AS ReleaseDateTime,
  cast( '' as abap.char( 60 )) AS SubstVolRetrackingTypeText,
  _SVTCalcChmlCmplncInfoRgln.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _SVTCalcChmlCmplncInfoRgln._ChmlCmplncPrimMatl AS _ChmlCmplncPrimMatl
FROM I_SVTCalculationResult
LEFT OUTER JOIN I_SVTCalcDecisionReason AS _SVTCalcDecisionReason ON SVTCalculationDecisionReason = _SVTCalcDecisionReason.SVTCalculationDecisionReason  -- association [0..1]
LEFT OUTER JOIN I_SVTCalculationDecision AS _SVTCalculationDecision ON SVTCalculationDecision = _SVTCalculationDecision.SVTCalculationDecision  -- association [0..1]
LEFT OUTER JOIN C_SVTCalcChmlCmplncInfoRgln AS _SVTCalcChmlCmplncInfoRgln ON SVTCalcChmCmInRglnUUID = _SVTCalcChmlCmplncInfoRgln.SVTCalcChmCmInRglnUUID  -- association [0..1]
LEFT OUTER JOIN I_SVTCalcChmlCmplncInfo AS _SVTCalcChmlCmplncInfo ON SVTCalcChmCmInUUID = _SVTCalcChmlCmplncInfo.SVTCalcChmCmInUUID  -- association [0..1]
LEFT OUTER JOIN I_SVTCalculationStatus AS _SVTCalculationStatus ON SVTCalculationStatus = _SVTCalculationStatus.SVTCalculationStatus  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncEventType AS _ProdCmplncEventType ON ProdCmplncEventType = _ProdCmplncEventType.ProdCmplncEventType  -- association [0..1]
LEFT OUTER JOIN C_SVTCalculationItemResult AS _SVTCalculationItemResult ON SVTCalculationResultUUID = _SVTCalculationItemResult.SVTCalculationResultUUID  -- association [0..*]
LEFT OUTER JOIN C_SVTObjectExclusionReason AS _SVTObjectExclusionReason ON SVTCalcChmCmInUUID = _SVTObjectExclusionReason.SVTObjectUUID AND _SVTObjectExclusionReason.SVTObjExclusionReasonIsDeleted = ''  -- association [0..*]
;