C_SubstVolRetrckPolymerTP

DDL: C_SUBSTVOLRETRCKPOLYMERTP Type: view_entity CONSUMPTION
46 Fields 1 Data Sources 3 Associations

Retrack Substance

C_SubstVolRetrckPolymerTP is a Consumption CDS View that provides data about "Retrack Substance" in SAP S/4HANA. It reads from 1 data source (R_SubstVolRetrackingTP) and exposes 46 fields with key field SubstVolRetrackingUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SubstVolRetrackingTP R_SubstVolRetrackingTP projection

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_SubstanceVolume _SubstVolCurPeriod $projection.ComplianceRequirement = _SubstVolCurPeriod.ComplianceRequirement and _SubstVolCurPeriod.TrackingPeriodType = 'CURR_PER' and $projection.substanceuuid = _SubstVolCurPeriod.SourceSubstanceUUID
[0..*] C_SubstanceVolume _SubstVolPrevPeriod $projection.ComplianceRequirement = _SubstVolPrevPeriod.ComplianceRequirement and _SubstVolPrevPeriod.TrackingPeriodType = 'PREV_PER' and $projection.substanceuuid = _SubstVolPrevPeriod.SourceSubstanceUUID
[0..*] C_SubstanceDailySubstVol _SubstDailySubstVol $projection.ComplianceRequirement = _SubstDailySubstVol.ComplianceRequirement and $projection.substanceuuid = _SubstDailySubstVol.SourceSubstanceUUID

Annotations (14)

NameValueLevelField
EndUserText.label Retrack Substance view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeImageUrl sap-icon: title: { label: view
UI.headerInfo.value SubstanceName view
UI.headerInfo.description.label ComplianceRequirement view
UI.headerInfo.description.value ComplianceRequirement view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
Search.searchable false view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY SubstVolRetrackingUUID SubstVolRetrackingUUID Retracking UUID
SubstVolRetrackingStatus SubstVolRetrackingStatus RtrkDecisionStatus
SubstVolRetrckgIsOpnTrckgPerds SubstVolRetrckgIsOpnTrckgPerds RtrkOpenTrkPer
SubstVolRetrckgIsCurTrckgPerd SubstVolRetrckgIsCurTrckgPerd RtrkCurTrkPer
SubstVolRetrackingReasonText SubstVolRetrackingReasonText CmntRtrkDecision
ComplianceRequirement ComplianceRequirement Compliance Requirement
CmplRqUUID CmplRqUUID Compl Req.
ProdCmplncEventUUID ProdCmplncEventUUID Product Compliance Event
SubstVolRetrackingType SubstVolRetrackingType Retrack Event Typ
SubstVolRetrackingSourceUUID SubstVolRetrackingSourceUUID RetrackSourceUUID
SubstVolRetrackingSource SubstVolRetrackingSource RetrackSourceUUID
SubstVolRetrackingSourceType SubstVolRetrackingSourceType RetrackSourceType
SubstVolRetrackingCategory SubstVolRetrackingCategory RtrkCategory
SubstVolRetrckgCompletedDteTme SubstVolRetrckgCompletedDteTme Retracking Completed On
SubstVolRetrackingCompletedBy SubstVolRetrackingCompletedBy RtrkCompletedBy
SubstVolRetrckgDecidedDteTme SubstVolRetrckgDecidedDteTme Decided On
SubstVolRetrackingDecidedBy SubstVolRetrackingDecidedBy Decided By
SubstVolRetrackingSrceChgdBy SubstVolRetrackingSrceChgdBy Released By
SuVolRtrckgSrceChgdByFullName SuVolRtrckgSrceChgdByFullName
SuVolRtrckgCmpltdByFullName SuVolRtrckgCmpltdByFullName
SuVolRtrckgDecidedByFullName SuVolRtrckgDecidedByFullName Name
SuVolRtrckgDecidedBySystemText SuVolRtrckgDecidedBySystemText User Group
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
SubstVolRetrackingSrceCrtedBy _SubstVolRetrckgChmlCmpstn SubstVolRetrackingSrceCrtedBy
SubstVolRetrckgSrceChgdDteTme SubstVolRetrckgSrceChgdDteTme Last Changed
SubstVolRetrckgSrceDetsName _SubstVolRetrckgChmlCmpstn SubstVolRetrckgSrceDetsName
PolymerCompositionName _SubstVolRetrckgChmlCmpstn PolymerCompositionName Name
SubstanceUUID _SubstVolRetrckgChmlCmpstn SubstanceUUID Substance
virtualECNumberehfnd_chm_lisu_ec_number
virtualCASNumberehfnd_chm_cas_no
SubstVolRetrackingStartDate Retrack From
SubstVolRetrackingTypeText _SubstVolRetrackingTypeTxt SubstVolRetrackingTypeText
virtualObjectLinkURLstring_unicode
_CompletedByUser _CompletedByUser
_DecidedByUser _DecidedByUser
_ReleasedByUser _ReleasedByUser
_SubstVolRetrackingStatusTxt _SubstVolRetrackingStatusTxt
_SubstVolRetrackingTypeTxt _SubstVolRetrackingTypeTxt
_SubstVolRetrckgChmlCmpstn _SubstVolRetrckgChmlCmpstn
_ChmlCmplncMatlAssgmt _ChmlCmplncMatlAssgmt
_SubstVolCurPeriod _SubstVolCurPeriod
_SubstVolPrevPeriod _SubstVolPrevPeriod
_SubstDailySubstVol _SubstDailySubstVol

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_SubstVolRetrckPolymerTP.
-- 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_SubstVolRetrckPolymerTP AS
SELECT
  SubstVolRetrackingUUID,
  SubstVolRetrackingStatus,
  SubstVolRetrckgIsOpnTrckgPerds,
  SubstVolRetrckgIsCurTrckgPerd,
  SubstVolRetrackingReasonText,
  ComplianceRequirement,
  CmplRqUUID,
  ProdCmplncEventUUID,
  SubstVolRetrackingType,
  SubstVolRetrackingSourceUUID,
  SubstVolRetrackingSource,
  SubstVolRetrackingSourceType,
  SubstVolRetrackingCategory,
  SubstVolRetrckgCompletedDteTme,
  SubstVolRetrackingCompletedBy,
  SubstVolRetrckgDecidedDteTme,
  SubstVolRetrackingDecidedBy,
  SubstVolRetrackingSrceChgdBy,
  SuVolRtrckgSrceChgdByFullName,
  SuVolRtrckgCmpltdByFullName,
  SuVolRtrckgDecidedByFullName,
  SuVolRtrckgDecidedBySystemText,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  _SubstVolRetrckgChmlCmpstn.SubstVolRetrackingSrceCrtedBy AS SubstVolRetrackingSrceCrtedBy,
  SubstVolRetrckgSrceChgdDteTme,
  _SubstVolRetrckgChmlCmpstn.SubstVolRetrckgSrceDetsName AS SubstVolRetrckgSrceDetsName,
  _SubstVolRetrckgChmlCmpstn.PolymerCompositionName AS PolymerCompositionName,
  _SubstVolRetrckgChmlCmpstn.SubstanceUUID AS SubstanceUUID,
  virtual ECNumber : ehfnd_chm_lisu_ec_number AS virtualECNumberehfnd_chm_lisu_ec_number,
  virtual CASNumber : ehfnd_chm_cas_no AS virtualCASNumberehfnd_chm_cas_no,
  cast ( SubstVolRetrackingStartDate as ehpma_svt_retrckg_date_from preserving type ) AS SubstVolRetrackingStartDate,
  _SubstVolRetrackingTypeTxt.SubstVolRetrackingTypeText AS SubstVolRetrackingTypeText,
  virtual ObjectLinkURL : string_unicode AS virtualObjectLinkURLstring_unicode
FROM R_SubstVolRetrackingTP
LEFT OUTER JOIN C_SubstanceVolume AS _SubstVolCurPeriod ON ComplianceRequirement = _SubstVolCurPeriod.ComplianceRequirement AND _SubstVolCurPeriod.TrackingPeriodType = 'CURR_PER' AND substanceuuid = _SubstVolCurPeriod.SourceSubstanceUUID  -- association [0..*]
LEFT OUTER JOIN C_SubstanceVolume AS _SubstVolPrevPeriod ON ComplianceRequirement = _SubstVolPrevPeriod.ComplianceRequirement AND _SubstVolPrevPeriod.TrackingPeriodType = 'PREV_PER' AND substanceuuid = _SubstVolPrevPeriod.SourceSubstanceUUID  -- association [0..*]
LEFT OUTER JOIN C_SubstanceDailySubstVol AS _SubstDailySubstVol ON ComplianceRequirement = _SubstDailySubstVol.ComplianceRequirement AND substanceuuid = _SubstDailySubstVol.SourceSubstanceUUID  -- association [0..*]
;

Learn More