P_SVTSubstanceConcentration

DDL: P_SVTSUBSTANCECONCENTRATION SQL: PSVTSUBCONC Type: view COMPOSITE Package: EHPMA_SVT_CALCULATION
10 Fields 3 Data Sources

SVT Substance Concentration

P_SVTSubstanceConcentration is a Composite CDS View that provides data about "SVT Substance Concentration" in SAP S/4HANA. It reads from 3 data sources (I_SVTCalcChmlCmplncInfo, I_SVTCalcSubstanceRegulation, I_SVTCalcChmlCmplncInfoComp) and exposes 10 fields with key fields SubstanceUUID, ComplianceRequirement, ChmlCmplncInfoUUID, SVTBusinessProcess, ValidityStartDateTime. Part of development package EHPMA_SVT_CALCULATION.

Data Sources (3)

SourceAliasJoin Type
I_SVTCalcChmlCmplncInfo _SVTChmlCmplncInfo inner
I_SVTCalcSubstanceRegulation _SVTSubstanceRegulation inner
I_SVTCalcChmlCmplncInfoComp I_SVTCalcChmlCmplncInfoComp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSVTSUBCONC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SubstanceUUID I_SVTCalcSubstanceRegulation SubstanceUUID Substance
KEY ComplianceRequirement I_SVTCalcSubstanceRegulation ComplianceRequirement Compliance Requirement
KEY ChmlCmplncInfoUUID
KEY SVTBusinessProcess
KEY ValidityStartDateTime I_SVTCalcChmlCmplncInfo SVTCalcChmCmInValdtyStrtDteTme Valid From Timestamp
KEY ValidityEndDateTime I_SVTCalcChmlCmplncInfo SVTCalcChmCmInValdtyEndDteTme Valid To Timestamp
SVTSubstanceConcentrationQty I_SVTCalcChmlCmplncInfoComp SVTSubstanceConcentrationQty Subst Concentration
SVTSubstConcentrationQtyUnit I_SVTCalcChmlCmplncInfoComp SVTSubstConcentrationQtyUnit Subst Concentra Unit
clientNULLasValidityStartDate
clientNULLendasValidityEndDate

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 P_SVTSubstanceConcentration.
-- 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: PSVTSUBCONC

CREATE VIEW P_SVTSubstanceConcentration AS
SELECT
  _SVTSubstanceRegulation.SubstanceUUID AS SubstanceUUID,
  _SVTSubstanceRegulation.ComplianceRequirement AS ComplianceRequirement,
  _SVTChmlCmplncInfo._SVTChmlCmplncInfoRgln.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _SVTChmlCmplncInfo._SVTChmlCmplncInfoRgln.SVTBusinessProcess AS SVTBusinessProcess,
  _SVTChmlCmplncInfo.SVTCalcChmCmInValdtyStrtDteTme AS ValidityStartDateTime,
  _SVTChmlCmplncInfo.SVTCalcChmCmInValdtyEndDteTme AS ValidityEndDateTime,
  I_SVTCalcChmlCmplncInfoComp.SVTSubstanceConcentrationQty AS SVTSubstanceConcentrationQty,
  I_SVTCalcChmlCmplncInfoComp.SVTSubstConcentrationQtyUnit AS SVTSubstConcentrationQtyUnit,
  tstmp_to_dats( _SVTChmlCmplncInfo.SVTCalcChmCmInValdtyStrtDteTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ValidityStartDate AS clientNULLasValidityStartDate,
  case when _SVTChmlCmplncInfo.SVTCalcChmCmInValdtyEndDteTme = 99991231235959 then cast( '20500510' as dats ) else tstmp_to_dats( _SVTChmlCmplncInfo.SVTCalcChmCmInValdtyEndDteTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) end as ValidityEndDate AS clientNULLendasValidityEndDate
FROM I_SVTCalcChmlCmplncInfoComp
INNER JOIN I_SVTCalcChmlCmplncInfo AS _SVTChmlCmplncInfo ON /* join condition not captured in parsed metadata */
INNER JOIN I_SVTCalcSubstanceRegulation AS _SVTSubstanceRegulation ON /* join condition not captured in parsed metadata */
;

Learn More