C_SubstVolRetrckMatMasterTP

DDL: C_SUBSTVOLRETRCKMATMASTERTP Type: view_entity CONSUMPTION

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.

1 data source(s) 41 fields

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

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY SubstVolRetrackingUUID SubstVolRetrackingUUID
SubstVolRetrackingStatus SubstVolRetrackingStatus
SubstVolRetrckgIsOpnTrckgPerds SubstVolRetrckgIsOpnTrckgPerds
SubstVolRetrckgIsCurTrckgPerd SubstVolRetrckgIsCurTrckgPerd
SubstVolRetrackingReasonText SubstVolRetrackingReasonText
ComplianceRequirement ComplianceRequirement
CmplRqUUID CmplRqUUID
ProdCmplncEventUUID ProdCmplncEventUUID
SubstVolRetrackingType SubstVolRetrackingType
SubstVolRetrackingSourceUUID SubstVolRetrackingSourceUUID
SubstVolRetrackingSource SubstVolRetrackingSource
SubstVolRetrackingSourceType SubstVolRetrackingSourceType
SubstVolRetrackingCategory SubstVolRetrackingCategory
SubstVolRetrckgCompletedDteTme SubstVolRetrckgCompletedDteTme
SubstVolRetrackingCompletedBy SubstVolRetrackingCompletedBy
SubstVolRetrckgDecidedDteTme SubstVolRetrckgDecidedDteTme
SubstVolRetrackingDecidedBy SubstVolRetrackingDecidedBy
SubstVolRetrackingSrceChgdBy SubstVolRetrackingSrceChgdBy
SuVolRtrckgSrceChgdByFullName SuVolRtrckgSrceChgdByFullName
SuVolRtrckgCmpltdByFullName SuVolRtrckgCmpltdByFullName
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
SubstVolRetrckgSrceChgdDteTme SubstVolRetrckgSrceChgdDteTme
SuVolRtrckgDecidedBySystemText SuVolRtrckgDecidedBySystemText
SuVolRtrckgDecidedByFullName SuVolRtrckgDecidedByFullName
SubstVolRetrackingStartDate
ProductDescription _Product ProductDescription
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 
@EndUserText.label: 'Retrack Product Master'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: ['_ReleasedByUser', '_CompletedByUser', '_DecidedByUser']
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.allowExtensions: true

@VDM: {
  viewType: #CONSUMPTION,
  usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ] }

--Header information
@UI:
{
  headerInfo:
  {
    typeImageUrl: 'sap-icon://product',

    title:
    {
      label: 'ProductDescription',
      value: 'ProductDescription'
    },
    description: {
        label: 'Product',
        value: 'SubstVolRetrackingSource'
    }
  }
}

@ObjectModel.usageType:{ serviceQuality: #D,
                         sizeCategory:   #L,
                         dataClass:      #MASTER }

@UI.presentationVariant: [{ requestAtLeast: ['SubstVolRetrckgIsAccepted', 'SubstVolRetrckgIsRejected'] }]
@Search.searchable: true
define root view entity C_SubstVolRetrckMatMasterTP
  provider contract transactional_query
  as projection on R_SubstVolRetrackingTP as SubstVolRetrackingTP
  association [0..*] to C_MaterialSubstanceVolume     as _MaterialSubstVolCurPeriod  on  _MaterialSubstVolCurPeriod.TrackingPeriodType = 'CURR_PER'
                                                                                     and _MaterialSubstVolCurPeriod.Material = $projection.SubstVolRetrackingSource
                                                                                     

  association [0..*] to C_MaterialSubstanceVolume     as _MaterialSubstVolPrevPeriod on _MaterialSubstVolPrevPeriod.TrackingPeriodType = 'PREV_PER'
                                                                                     and _MaterialSubstVolPrevPeriod.Material = $projection.SubstVolRetrackingSource


  association [0..*] to C_MaterialDailySubstanceVolume  as _MaterialDailySubstVol    on  _MaterialDailySubstVol.Material = $projection.SubstVolRetrackingSource

{
  key            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,
                  
                 _SubstVolRetrackingTypeTxt.SubstVolRetrackingTypeText,

                 @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_HIDE_RTRCKG_EXIT'
  virtual        SubstVolRetrckgDetsAreHidden   : abap_boolean,

                 @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_HIDE_RTRCKG_EXIT'
  virtual        SubstVolRetrckgIsRejected      : abap_boolean,

                 @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_HIDE_RTRCKG_EXIT'
  virtual        SubstVolRetrckgIsAccepted      : abap_boolean,
  
                 @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_DECIDED_BY_EXIT'
  virtual        SuVolRtrckgIsDecidedBySystem   : abap_boolean,
  
                 @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_DECIDED_BY_EXIT'
  virtual        SuVolRtrckgIsDecidedByUser     : abap_boolean,

                 @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_CCMPS_LINK_EXIT'
  virtual        ObjectLinkURL                  : string_unicode,
  
  
                 /* Associations */
                 _CompletedByUser,
                 _DecidedByUser,
                 _ReleasedByUser,
                 _SubstVolRetrackingStatusTxt,
                 _SubstVolRetrackingTypeTxt,
                 _SubstVolRetrckgChmlCmpstn,
                 _ChmlCmplncMatlAssgmt,
                 
                 _MaterialDailySubstVol,
                 _MaterialSubstVolCurPeriod,
                 _MaterialSubstVolPrevPeriod
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTWD",
"I_SUBSTVOLRETRACKINGTYPETXT",
"R_SUBSTVOLRETRACKINGTP"
],
"ASSOCIATED":
[
"C_MATERIALDAILYSUBSTANCEVOLUME",
"C_MATERIALSUBSTANCEVOLUME",
"I_CHMLCMPLNCMATLASSGMT",
"I_SUBSTVOLRETRACKINGSTATUSTXT",
"I_SUBSTVOLRETRACKINGTYPETXT",
"I_SUVOLRTRCKGCHMLCMPSTNSRCE",
"I_USERCONTACTCARD"
],
"BASE":
[
"R_SUBSTVOLRETRACKINGTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More