C_SuVolRtrckgMatlChmlCmpstnTP

DDL: C_SUVOLRTRCKGMATLCHMLCMPSTNTP Type: view_entity CONSUMPTION

Retrack Material Based Composition

C_SuVolRtrckgMatlChmlCmpstnTP is a Consumption CDS View that provides data about "Retrack Material Based Composition" in SAP S/4HANA. It reads from 1 data source (R_SubstVolRetrackingTP) and exposes 38 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_MatlChmlCmpstnSubstVol _SubstVolByCRCurrPeriod $projection.chmlcmplncinfouuid = _SubstVolByCRCurrPeriod.ChmlCmplncInfoUUID and $projection.ComplianceRequirement = _SubstVolByCRCurrPeriod.ComplianceRequirement and _SubstVolByCRCurrPeriod.TrackingPeriodType = 'CURR_PER'
[0..*] C_MatlChmlCmpstnSubstVol _SubstVolByCRPrevPeriod $projection.chmlcmplncinfouuid = _SubstVolByCRPrevPeriod.ChmlCmplncInfoUUID and $projection.ComplianceRequirement = _SubstVolByCRPrevPeriod.ComplianceRequirement and _SubstVolByCRPrevPeriod.TrackingPeriodType = 'PREV_PER'
[0..*] C_MatlChmlCmpstnDailySubstVol _MatlChmlCmpstnDailySubstVol $projection.chmlcmplncinfouuid = _MatlChmlCmpstnDailySubstVol.ChmlCmplncInfoUUID and $projection.ComplianceRequirement = _MatlChmlCmpstnDailySubstVol.ComplianceRequirement

Annotations (13)

NameValueLevelField
EndUserText.label Retrack Material Based Composition 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 ChmlCmplncInfoCombinedName view
UI.headerInfo.description.label ComplianceRequirement view
UI.headerInfo.description.value ComplianceRequirement 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 (38)

KeyFieldSource TableSource FieldDescription
KEY SubstVolRetrackingUUID SubstVolRetrackingUUID
SubstVolRetrackingStatus SubstVolRetrackingStatus
ProdCmplncEventUUID ProdCmplncEventUUID
SubstVolRetrackingType SubstVolRetrackingType
SubstVolRetrackingSourceUUID SubstVolRetrackingSourceUUID
SubstVolRetrackingSource SubstVolRetrackingSource
SubstVolRetrckgIsCurTrckgPerd SubstVolRetrckgIsCurTrckgPerd
SubstVolRetrckgIsOpnTrckgPerds SubstVolRetrckgIsOpnTrckgPerds
SubstVolRetrackingReasonText SubstVolRetrackingReasonText
SubstVolRetrackingCategory SubstVolRetrackingCategory
ComplianceRequirement ComplianceRequirement
ChmlCompositionUUID _SubstVolRetrckgChmlCmpstn ChmlCompositionUUID
SubstVolRetrackingSrceChgdBy SubstVolRetrackingSrceChgdBy
SuVolRtrckgSrceChgdByFullName SuVolRtrckgSrceChgdByFullName
SubstVolRetrckgSrceChgdDteTme _SubstVolRetrckgChmlCmpstn SubstVolRetrckgSrceChgdDteTme
ChmlCompositionTypeName
ChmlCmplncInfoCombinedName
SubstVolRetrackingCompletedBy SubstVolRetrackingCompletedBy
SuVolRtrckgCmpltdByFullName SuVolRtrckgCmpltdByFullName
SubstVolRetrckgCompletedDteTme SubstVolRetrckgCompletedDteTme
SubstVolRetrackingDecidedBy SubstVolRetrackingDecidedBy
SuVolRtrckgDecidedByFullName SuVolRtrckgDecidedByFullName
SuVolRtrckgDecidedBySystemText SuVolRtrckgDecidedBySystemText
SubstVolRetrckgDecidedDteTme SubstVolRetrckgDecidedDteTme
SubstVolRetrackingStartDate
ChmlCompositionType _SubstVolRetrckgChmlCmpstn ChmlCompositionType
Material _SubstVolRetrckgChmlCmpstn Material
ChmlCmplncInfoUUID _SubstVolRetrckgChmlCmpstn ChmlCmplncInfoUUID
SubstVolRetrackingTypeText _SubstVolRetrackingTypeTxt SubstVolRetrackingTypeText
virtualObjectLinkURLstring_unicode
_SubstVolByCRCurrPeriod _SubstVolByCRCurrPeriod
_SubstVolByCRPrevPeriod _SubstVolByCRPrevPeriod
_MatlChmlCmpstnDailySubstVol _MatlChmlCmpstnDailySubstVol
_SubstVolRetrckgChmlCmpstn _SubstVolRetrckgChmlCmpstn
_ChmlCmplncMatlAssgmt _ChmlCmplncMatlAssgmt
_ReleasedByUser _ReleasedByUser
_CompletedByUser _CompletedByUser
_DecidedByUser _DecidedByUser
@EndUserText.label: 'Retrack Material Based Composition'
@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://tree',

    title:
    {
      label: 'Chemical Compliance View',
      value: 'ChmlCmplncInfoCombinedName'
    },
    description: {
        label: 'ComplianceRequirement',
        value: 'ComplianceRequirement'
    }
  }
}

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

@Search.searchable: true
define root view entity C_SuVolRtrckgMatlChmlCmpstnTP
  provider contract transactional_query
  as projection on R_SubstVolRetrackingTP as SubstVolRetrackingTP
  association [0..*] to C_MatlChmlCmpstnSubstVol      as _SubstVolByCRCurrPeriod      on  $projection.chmlcmplncinfouuid             = _SubstVolByCRCurrPeriod.ChmlCmplncInfoUUID
                                                                                      and $projection.ComplianceRequirement          = _SubstVolByCRCurrPeriod.ComplianceRequirement
                                                                                      and _SubstVolByCRCurrPeriod.TrackingPeriodType = 'CURR_PER'

  association [0..*] to C_MatlChmlCmpstnSubstVol      as _SubstVolByCRPrevPeriod      on  $projection.chmlcmplncinfouuid             = _SubstVolByCRPrevPeriod.ChmlCmplncInfoUUID
                                                                                      and $projection.ComplianceRequirement          = _SubstVolByCRPrevPeriod.ComplianceRequirement
                                                                                      and _SubstVolByCRPrevPeriod.TrackingPeriodType = 'PREV_PER'


  association [0..*] to C_MatlChmlCmpstnDailySubstVol as _MatlChmlCmpstnDailySubstVol on  $projection.chmlcmplncinfouuid    = _MatlChmlCmpstnDailySubstVol.ChmlCmplncInfoUUID
                                                                                      and $projection.ComplianceRequirement = _MatlChmlCmpstnDailySubstVol.ComplianceRequirement
{
  key            SubstVolRetrackingUUID,
                 SubstVolRetrackingStatus,
                 ProdCmplncEventUUID,
                 SubstVolRetrackingType,
                 SubstVolRetrackingSourceUUID,
                 SubstVolRetrackingSource,
                 SubstVolRetrckgIsCurTrckgPerd,
                 SubstVolRetrckgIsOpnTrckgPerds,
                 SubstVolRetrackingReasonText,
                 SubstVolRetrackingCategory,
                 ComplianceRequirement,
                 _SubstVolRetrckgChmlCmpstn.ChmlCompositionUUID,
                 SubstVolRetrackingSrceChgdBy,
                 SuVolRtrckgSrceChgdByFullName,
                 _SubstVolRetrckgChmlCmpstn.SubstVolRetrckgSrceChgdDteTme                                                        as SubstVolRetrckgSrceChgdDteTme,
                 cast ( _SubstVolRetrckgChmlCmpstn.ChmlCompositionTypeName as ehpma_svt_retrckg_cmpstn_type preserving type )    as ChmlCompositionTypeName,
                 cast ( _SubstVolRetrckgChmlCmpstn.ChmlCmplncInfoCombinedName as ehpma_svt_retrckg_cmpstn_link preserving type ) as ChmlCmplncInfoCombinedName,
                 SubstVolRetrackingCompletedBy,
                 SuVolRtrckgCmpltdByFullName,
                 SubstVolRetrckgCompletedDteTme,
                 SubstVolRetrackingDecidedBy,
                 SuVolRtrckgDecidedByFullName,
                 SuVolRtrckgDecidedBySystemText,
                 SubstVolRetrckgDecidedDteTme,
                 cast ( SubstVolRetrackingStartDate as ehpma_svt_retrckg_date_from preserving type )                             as SubstVolRetrackingStartDate,
                 _SubstVolRetrckgChmlCmpstn.ChmlCompositionType,
                 _SubstVolRetrckgChmlCmpstn.Material,
                 _SubstVolRetrckgChmlCmpstn.ChmlCmplncInfoUUID,
                 _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,

                 --Combined name of composition category and combined name of CCI
                 @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_CMPS_HEADER_EXIT'
  virtual        ChmlCompositionCombinedName  : ehpma_svt_retrckg_cmpstn_link,

                 _SubstVolByCRCurrPeriod,
                 _SubstVolByCRPrevPeriod,
                 _MatlChmlCmpstnDailySubstVol,
                 _SubstVolRetrckgChmlCmpstn,
                 _ChmlCmplncMatlAssgmt,
                 _ReleasedByUser,
                 _CompletedByUser,
                 _DecidedByUser
}