I_SVTCalculationResult

DDL: I_SVTCALCULATIONRESULT Type: view_entity BASIC Package: EHPMA_SVT_CALCULATION
13 Fields 1 Data Sources 2 Associations

SVT Calculation Result

I_SVTCalculationResult is a Basic CDS View that provides data about "SVT Calculation Result" in SAP S/4HANA. It reads from 1 data source (ehpmad_svt_hdrpr) and exposes 13 fields with key field SVTCalculationResultUUID. It has 2 associations to related views. Part of development package EHPMA_SVT_CALCULATION.

Data Sources (1)

SourceAliasJoin Type
ehpmad_svt_hdrpr ehpmad_svt_hdrpr from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SVTProdCmplncEvent _SVTProdCmplncEvent $projection.ProdCmplncEventUUID = _SVTProdCmplncEvent.ProdCmplncEventUUID
[0..1] I_SVTCalculation _SVTCalculation $projection.SVTCalculationUUID = _SVTCalculation.SVTCalculationUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SVT Calculation Result view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SVTCalculationResultUUID svtcalcheaderprofileresultuuid Calculation Header Profile Result UUID
SVTCalculationUUID svtcalculationheaderuuid Calculation uuid
CreationDateTime creationutcdatetime Time Stamp
ProdCmplncLegalEntity legalentity Legal Entity ID
ProdCmplncLglEntyMappgUUID legalentitymapuuid LE Mapping UUID
SVTCalculationDecisionReason svtactionreason SVT Action Reason
SVTCalculationDecision processingaction Calculation Profile Result Action
SVTCalculationStatus calculationstatus SVT Calculation Status
SVTCalcChmCmInRglnUUID svtcciregulatoryprofileuuid CCI Regulatory Profile UUID
SVTCalcChmCmInUUID svtcciuserprofileuuid SVT CCI User Profile UUID
ProdCmplncEventUUID prodcmplnceventuuid Product Compliance Event
ProdCmplncEventType _SVTProdCmplncEvent ProdCmplncEventType Event Type
_SVTCalculation _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 I_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 I_SVTCalculationResult AS
SELECT
  svtcalcheaderprofileresultuuid AS SVTCalculationResultUUID,
  svtcalculationheaderuuid AS SVTCalculationUUID,
  creationutcdatetime AS CreationDateTime,
  legalentity AS ProdCmplncLegalEntity,
  legalentitymapuuid AS ProdCmplncLglEntyMappgUUID,
  svtactionreason AS SVTCalculationDecisionReason,
  processingaction AS SVTCalculationDecision,
  calculationstatus AS SVTCalculationStatus,
  svtcciregulatoryprofileuuid AS SVTCalcChmCmInRglnUUID,
  svtcciuserprofileuuid AS SVTCalcChmCmInUUID,
  ProdCmplncEventUUID,
  _SVTProdCmplncEvent.ProdCmplncEventType AS ProdCmplncEventType
FROM ehpmad_svt_hdrpr
LEFT OUTER JOIN I_SVTProdCmplncEvent AS _SVTProdCmplncEvent ON ProdCmplncEventUUID = _SVTProdCmplncEvent.ProdCmplncEventUUID  -- association [0..1]
LEFT OUTER JOIN I_SVTCalculation AS _SVTCalculation ON SVTCalculationUUID = _SVTCalculation.SVTCalculationUUID  -- association [0..1]
;

Learn More