C_SVTCalculationItem

DDL: C_SVTCALCULATIONITEM SQL: CSVTCLITM Type: view CONSUMPTION
48 Fields 1 Data Sources 3 Associations

SVT Calculation Item

C_SVTCalculationItem is a Consumption CDS View that provides data about "SVT Calculation Item" in SAP S/4HANA. It reads from 1 data source (I_SVTCalculationItem) and exposes 48 fields with key field SVTCalculationItemUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SVTCalculationItem I_SVTCalculationItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_SVTCalculationItemResult _SVTLatestCalcItemResult $projection.SVTCalcItemLastResultUUID = _SVTLatestCalcItemResult.SVTCalculationItemResultUUID
[0..*] C_SVTCalculationItemResult _SVTCalcItemResult $projection.SVTCalculationItemUUID = _SVTCalcItemResult.SVTCalculationItemUUID and $projection.SVTCalculationUUID = _SVTCalcItemResult.SVTCalculationUUID
[0..1] I_SubstanceTP _SubstanceTP $projection.SubstanceUUID = _SubstanceTP.SubstanceUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CSVTCLITM view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.compiler.compareFilter true view
EndUserText.label SVT Calculation Item view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
UI.headerInfo.title.value SubstanceName view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.description.value ChmlCompType view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.label Substance view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY SVTCalculationItemUUID SVTCalculationItemUUID Calc itm uuid
SVTCalculationUUID SVTCalculationUUID Calculation uuid
CalculatedSubstanceVolume Substance Volume
SubstanceVolumeUnit SubstanceVolumeUnit Subst vol unit
SVTAggrgnItmByBusProcUUID SVTAggrgnItmByBusProcUUID Aggr item uuid
SubstanceUUID I_SVTCalculationItem SubstanceUUID Substance
SVTCalcItemLastResultUUID SVTCalcItemLastResultUUID Calculation Item Profile Result UUID
SVTCalculationItemResultUUID _SVTLatestCalcItemResult SVTCalculationItemResultUUID
ProdCmplncEventUUID _SVTLatestCalcItemResult ProdCmplncEventUUID Product Compliance Event
ProdCmplncEventType _SVTLatestCalcItemResult ProdCmplncEventType Event Type
ProdCmplncEventTypeText _SVTLatestCalcItemResult ProdCmplncEventTypeText
SVTCalculationSubstanceUUID _SVTLatestCalcItemResult SVTCalculationSubstanceUUID
SVTParentCalculationItemUUID _SVTLatestCalcItemResult SVTParentCalculationItemUUID Calc itm uuid
SVTCalculationResultUUID _SVTLatestCalcItemResult SVTCalculationResultUUID
SVTParentCalcItemResultUUID _SVTLatestCalcItemResult SVTParentCalcItemResultUUID Calculation Item Profile Result UUID
CreationDateTime _SVTLatestCalcItemResult CreationDateTime Timestamp
SVTCalculationDecision _SVTLatestCalcItemResult SVTCalculationDecision
SVTCalculationDecisionText _SVTLatestCalcItemResult SVTCalculationDecisionText
SVTCalculationDecisionReason _SVTLatestCalcItemResult SVTCalculationDecisionReason
SVTCalcDecisionReasonText _SVTLatestCalcItemResult SVTCalcDecisionReasonText
SVTCalculationValidityStatus _SVTLatestCalcItemResult SVTCalculationValidityStatus
SVTCalcValidityStatusText _SVTLatestCalcItemResult SVTCalcValidityStatusText
SVTSubstanceConcentrationQty _SVTLatestCalcItemResult SVTSubstanceConcentrationQty
SVTSubstConcentrationQtyUnit _SVTLatestCalcItemResult SVTSubstConcentrationQtyUnit
ChmlCompType _SVTLatestCalcItemResult ChmlCompType Role in Composition
ComplianceRequirement _SVTLatestCalcItemResult ComplianceRequirement Compliance Requirement
CmplRqUUID _SVTLatestCalcItemResult CmplRqUUID Compl Req.
CmplRqVersUUID _SVTLatestCalcItemResult CmplRqVersUUID NodeID
SVTSubstanceList _SVTLatestCalcItemResult SVTSubstanceList
SVTSubstanceListUUID _SVTLatestCalcItemResult SVTSubstanceListUUID
SubstanceListName _SVTLatestCalcItemResult SubstanceListName List Name
SubstanceListType _SVTLatestCalcItemResult SubstanceListType Regulatory List Type
SubstanceListTypeText _SVTLatestCalcItemResult SubstanceListTypeText
SubstIsNotListed _SVTLatestCalcItemResult SubstIsNotListed
PolymerCompositionIntID _SVTLatestCalcItemResult PolymerCompositionIntID Internal Number
CmplRqRsltUUID _SVTLatestCalcItemResult CmplRqRsltUUID SDS Assessment
CmplRqRsltLastChgdDateTime _SVTLatestCalcItemResult CmplRqRsltLastChgdDateTime
SVTCalculationStatus _SVTLatestCalcItemResult SVTCalculationStatus
SVTCalculationStatusText _SVTLatestCalcItemResult SVTCalculationStatusText
PolymerIsBsdOnOECDDef _SVTLatestCalcItemResult PolymerIsBsdOnOECDDef OECD Polymer
PolymerCompositionName _SVTLatestCalcItemResult PolymerCompositionName Name
_SVTExclsnRsn _SVTLatestCalcItemResult _SVTExclsnRsn
_SVTSubstanceList _SVTLatestCalcItemResult _SVTSubstanceList
_UnitOfMeasureVolume _UnitOfMeasureVolume
_SVTCalcItemResult _SVTCalcItemResult
_SVTLatestCalcItemResult _SVTLatestCalcItemResult
_SVTCalculation _SVTCalculation
_SubstanceTP _SubstanceTP

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_SVTCalculationItem.
-- 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: CSVTCLITM

CREATE VIEW C_SVTCalculationItem AS
SELECT
  SVTCalculationItemUUID,
  SVTCalculationUUID,
  cast( CalculatedSubstanceVolume as ehpma_svt_subst_vol_ui ) AS CalculatedSubstanceVolume,
  SubstanceVolumeUnit,
  SVTAggrgnItmByBusProcUUID,
  I_SVTCalculationItem.SubstanceUUID AS SubstanceUUID,
  SVTCalcItemLastResultUUID,
  _SVTLatestCalcItemResult.SVTCalculationItemResultUUID AS SVTCalculationItemResultUUID,
  _SVTLatestCalcItemResult.ProdCmplncEventUUID AS ProdCmplncEventUUID,
  _SVTLatestCalcItemResult.ProdCmplncEventType AS ProdCmplncEventType,
  _SVTLatestCalcItemResult.ProdCmplncEventTypeText AS ProdCmplncEventTypeText,
  _SVTLatestCalcItemResult.SVTCalculationSubstanceUUID AS SVTCalculationSubstanceUUID,
  _SVTLatestCalcItemResult.SVTParentCalculationItemUUID AS SVTParentCalculationItemUUID,
  _SVTLatestCalcItemResult.SVTCalculationResultUUID AS SVTCalculationResultUUID,
  _SVTLatestCalcItemResult.SVTParentCalcItemResultUUID AS SVTParentCalcItemResultUUID,
  _SVTLatestCalcItemResult.CreationDateTime AS CreationDateTime,
  _SVTLatestCalcItemResult.SVTCalculationDecision AS SVTCalculationDecision,
  _SVTLatestCalcItemResult.SVTCalculationDecisionText AS SVTCalculationDecisionText,
  _SVTLatestCalcItemResult.SVTCalculationDecisionReason AS SVTCalculationDecisionReason,
  _SVTLatestCalcItemResult.SVTCalcDecisionReasonText AS SVTCalcDecisionReasonText,
  _SVTLatestCalcItemResult.SVTCalculationValidityStatus AS SVTCalculationValidityStatus,
  _SVTLatestCalcItemResult.SVTCalcValidityStatusText AS SVTCalcValidityStatusText,
  _SVTLatestCalcItemResult.SVTSubstanceConcentrationQty AS SVTSubstanceConcentrationQty,
  _SVTLatestCalcItemResult.SVTSubstConcentrationQtyUnit AS SVTSubstConcentrationQtyUnit,
  _SVTLatestCalcItemResult.ChmlCompType AS ChmlCompType,
  _SVTLatestCalcItemResult.ComplianceRequirement AS ComplianceRequirement,
  _SVTLatestCalcItemResult.CmplRqUUID AS CmplRqUUID,
  _SVTLatestCalcItemResult.CmplRqVersUUID AS CmplRqVersUUID,
  _SVTLatestCalcItemResult.SVTSubstanceList AS SVTSubstanceList,
  _SVTLatestCalcItemResult.SVTSubstanceListUUID AS SVTSubstanceListUUID,
  _SVTLatestCalcItemResult.SubstanceListName AS SubstanceListName,
  _SVTLatestCalcItemResult.SubstanceListType AS SubstanceListType,
  _SVTLatestCalcItemResult.SubstanceListTypeText AS SubstanceListTypeText,
  _SVTLatestCalcItemResult.SubstIsNotListed AS SubstIsNotListed,
  _SVTLatestCalcItemResult.PolymerCompositionIntID AS PolymerCompositionIntID,
  _SVTLatestCalcItemResult.CmplRqRsltUUID AS CmplRqRsltUUID,
  _SVTLatestCalcItemResult.CmplRqRsltLastChgdDateTime AS CmplRqRsltLastChgdDateTime,
  _SVTLatestCalcItemResult.SVTCalculationStatus AS SVTCalculationStatus,
  _SVTLatestCalcItemResult.SVTCalculationStatusText AS SVTCalculationStatusText,
  _SVTLatestCalcItemResult.PolymerIsBsdOnOECDDef AS PolymerIsBsdOnOECDDef,
  _SVTLatestCalcItemResult.PolymerCompositionName AS PolymerCompositionName,
  _SVTLatestCalcItemResult._SVTExclsnRsn AS _SVTExclsnRsn,
  _SVTLatestCalcItemResult._SVTSubstanceList AS _SVTSubstanceList
FROM I_SVTCalculationItem
LEFT OUTER JOIN C_SVTCalculationItemResult AS _SVTLatestCalcItemResult ON SVTCalcItemLastResultUUID = _SVTLatestCalcItemResult.SVTCalculationItemResultUUID  -- association [0..1]
LEFT OUTER JOIN C_SVTCalculationItemResult AS _SVTCalcItemResult ON SVTCalculationItemUUID = _SVTCalcItemResult.SVTCalculationItemUUID AND SVTCalculationUUID = _SVTCalcItemResult.SVTCalculationUUID  -- association [0..*]
LEFT OUTER JOIN I_SubstanceTP AS _SubstanceTP ON SubstanceUUID = _SubstanceTP.SubstanceUUID  -- association [0..1]
;

Learn More