C_SVTCalculationItem

DDL: C_SVTCALCULATIONITEM SQL: CSVTCLITM Type: view CONSUMPTION Package: EHPMA_CNS_SVT
48 Fields 1 Data Sources 3 Associations 1 OData Services

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. It is exposed through 1 OData service (UI_SVTPROCDMATDOCUMENTTP_SRV). Part of development package EHPMA_CNS_SVT.

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_SVTPROCDMATDOCUMENTTP_SRV UI_SVTPROCDMATDOCUMENTTP_SRV V4 C1 NOT_RELEASED

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