C_SubstVolRetrckMatMasterTP

DDL: C_SUBSTVOLRETRCKMATMASTERTP Type: view_entity CONSUMPTION
41 Fields 1 Data Sources 3 Associations 1 OData Services

Retrack Product Master

C_SubstVolRetrckMatMasterTP is a Consumption CDS View that provides data about "Retrack Product Master" in SAP S/4HANA. It reads from 1 data source (R_SubstVolRetrackingTP) and exposes 41 fields with key field SubstVolRetrackingUUID. It has 3 associations to related views. It is exposed through 1 OData service (UI_SUBSTVOLRETRCKG_MANAGE).

Data Sources (1)

SourceAliasJoin Type
R_SubstVolRetrackingTP R_SubstVolRetrackingTP projection

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_MaterialSubstanceVolume _MaterialSubstVolCurPeriod _MaterialSubstVolCurPeriod.TrackingPeriodType = 'CURR_PER' and _MaterialSubstVolCurPeriod.Material = $projection.SubstVolRetrackingSource
[0..*] C_MaterialSubstanceVolume _MaterialSubstVolPrevPeriod _MaterialSubstVolPrevPeriod.TrackingPeriodType = 'PREV_PER' and _MaterialSubstVolPrevPeriod.Material = $projection.SubstVolRetrackingSource
[0..*] C_MaterialDailySubstanceVolume _MaterialDailySubstVol _MaterialDailySubstVol.Material = $projection.SubstVolRetrackingSource

Annotations (13)

NameValueLevelField
EndUserText.label Retrack Product Master 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 ProductDescription view
UI.headerInfo.description.label Product view
UI.headerInfo.description.value SubstVolRetrackingSource view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SUBSTVOLRETRCKG_MANAGE UI_SUBSTVOLRETRCKG_MANAGE V4 C1 NOT_RELEASED

Fields (41)

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
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
SubstVolRetrckgSrceChgdDteTme SubstVolRetrckgSrceChgdDteTme Last Changed
SuVolRtrckgDecidedBySystemText SuVolRtrckgDecidedBySystemText User Group
SuVolRtrckgDecidedByFullName SuVolRtrckgDecidedByFullName Name
SubstVolRetrackingStartDate Retrack From
ProductDescription _Product ProductDescription Description
SubstVolRetrackingTypeText _SubstVolRetrackingTypeTxt SubstVolRetrackingTypeText
virtualObjectLinkURLstring_unicode
_CompletedByUser _CompletedByUser
_DecidedByUser _DecidedByUser
_ReleasedByUser _ReleasedByUser
_SubstVolRetrackingStatusTxt _SubstVolRetrackingStatusTxt
_SubstVolRetrackingTypeTxt _SubstVolRetrackingTypeTxt
_SubstVolRetrckgChmlCmpstn _SubstVolRetrckgChmlCmpstn
_ChmlCmplncMatlAssgmt _ChmlCmplncMatlAssgmt
_MaterialDailySubstVol _MaterialDailySubstVol
_MaterialSubstVolCurPeriod _MaterialSubstVolCurPeriod
_MaterialSubstVolPrevPeriod _MaterialSubstVolPrevPeriod

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_SubstVolRetrckMatMasterTP.
-- 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_SubstVolRetrckMatMasterTP AS
SELECT
  SubstVolRetrackingUUID,
  SubstVolRetrackingStatus,
  SubstVolRetrckgIsOpnTrckgPerds,
  SubstVolRetrckgIsCurTrckgPerd,
  SubstVolRetrackingReasonText,
  ComplianceRequirement,
  CmplRqUUID,
  ProdCmplncEventUUID,
  SubstVolRetrackingType,
  SubstVolRetrackingSourceUUID,
  SubstVolRetrackingSource,
  SubstVolRetrackingSourceType,
  SubstVolRetrackingCategory,
  SubstVolRetrckgCompletedDteTme,
  SubstVolRetrackingCompletedBy,
  SubstVolRetrckgDecidedDteTme,
  SubstVolRetrackingDecidedBy,
  SubstVolRetrackingSrceChgdBy,
  SuVolRtrckgSrceChgdByFullName,
  SuVolRtrckgCmpltdByFullName,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  SubstVolRetrckgSrceChgdDteTme,
  SuVolRtrckgDecidedBySystemText,
  SuVolRtrckgDecidedByFullName,
  cast ( SubstVolRetrackingStartDate as ehpma_svt_retrckg_date_from preserving type ) AS SubstVolRetrackingStartDate,
  _Product.ProductDescription AS ProductDescription,
  _SubstVolRetrackingTypeTxt.SubstVolRetrackingTypeText AS SubstVolRetrackingTypeText,
  virtual ObjectLinkURL : string_unicode AS virtualObjectLinkURLstring_unicode
FROM R_SubstVolRetrackingTP
LEFT OUTER JOIN C_MaterialSubstanceVolume AS _MaterialSubstVolCurPeriod ON _MaterialSubstVolCurPeriod.TrackingPeriodType = 'CURR_PER' AND _MaterialSubstVolCurPeriod.Material = SubstVolRetrackingSource  -- association [0..*]
LEFT OUTER JOIN C_MaterialSubstanceVolume AS _MaterialSubstVolPrevPeriod ON _MaterialSubstVolPrevPeriod.TrackingPeriodType = 'PREV_PER' AND _MaterialSubstVolPrevPeriod.Material = SubstVolRetrackingSource  -- association [0..*]
LEFT OUTER JOIN C_MaterialDailySubstanceVolume AS _MaterialDailySubstVol ON _MaterialDailySubstVol.Material = SubstVolRetrackingSource  -- association [0..*]
;

Learn More