C_SubstVolRetrckPolymerTP

DDL: C_SUBSTVOLRETRCKPOLYMERTP Type: view_entity CONSUMPTION

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 48 fields with key field SubstVolRetrackingUUID. It has 3 associations to related views.

1 data source(s) 48 fields

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 #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
Search.searchable false view

Fields (48)

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
SuVolRtrckgDecidedByFullName SuVolRtrckgDecidedByFullName
SuVolRtrckgDecidedBySystemText SuVolRtrckgDecidedBySystemText
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
SubstVolRetrackingSrceCrtedBy _SubstVolRetrckgChmlCmpstn SubstVolRetrackingSrceCrtedBy
SubstVolRetrckgSrceChgdDteTme SubstVolRetrckgSrceChgdDteTme
SubstVolRetrckgSrceDetsName _SubstVolRetrckgChmlCmpstn SubstVolRetrckgSrceDetsName
PolymerCompositionName _SubstVolRetrckgChmlCmpstn PolymerCompositionName
SubstanceUUID _SubstVolRetrckgChmlCmpstn SubstanceUUID
SubstanceName
CASNumber
ECNumber
MolecularFormula
SubstVolRetrackingStartDate
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 
@EndUserText.label: 'Retrack Substance'
@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: 'Substance Name',
      value: 'SubstanceName'
    },
    description: {
        label: 'ComplianceRequirement',
        value: 'ComplianceRequirement'
    }
  }
}

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

@UI.presentationVariant: [{ requestAtLeast: ['SubstVolRetrckgIsAccepted', 'SubstVolRetrckgIsRejected'] }]
@ObjectModel.semanticKey: ['PolymerCompositionName' ]
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: false
define root view entity C_SubstVolRetrckPolymerTP
  provider contract transactional_query
  as projection on R_SubstVolRetrackingTP as SubstVolRetrackingTP
  association [0..*] to C_SubstanceVolume        as _SubstVolCurPeriod  on  $projection.ComplianceRequirement     = _SubstVolCurPeriod.ComplianceRequirement
                                                                        and _SubstVolCurPeriod.TrackingPeriodType = 'CURR_PER'
                                                                        and $projection.substanceuuid = _SubstVolCurPeriod.SourceSubstanceUUID
                                                                        

  association [0..*] to C_SubstanceVolume        as _SubstVolPrevPeriod on  $projection.ComplianceRequirement      = _SubstVolPrevPeriod.ComplianceRequirement
                                                                        and _SubstVolPrevPeriod.TrackingPeriodType = 'PREV_PER'
                                                                        and $projection.substanceuuid = _SubstVolPrevPeriod.SourceSubstanceUUID

  association [0..*] to C_SubstanceDailySubstVol as _SubstDailySubstVol on  $projection.ComplianceRequirement = _SubstDailySubstVol.ComplianceRequirement
                                                                        and $projection.substanceuuid = _SubstDailySubstVol.SourceSubstanceUUID
      

{
  key            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,
                 SubstVolRetrckgSrceChgdDteTme,
                 _SubstVolRetrckgChmlCmpstn.SubstVolRetrckgSrceDetsName,
                 _SubstVolRetrckgChmlCmpstn.PolymerCompositionName,
                 _SubstVolRetrckgChmlCmpstn.SubstanceUUID,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP.SubstanceName,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CASNumber,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.ECNumber,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.MolecularFormula,
                 cast ( SubstVolRetrackingStartDate as ehpma_svt_retrckg_date_from preserving type ) as SubstVolRetrackingStartDate,

                 _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,

                 _SubstVolCurPeriod,
                 _SubstVolPrevPeriod,
                 _SubstDailySubstVol
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUBSTACTIVEDRAFTLSTDSUBST",
"I_SUBSTANCETP",
"I_SUBSTVOLRETRACKINGTYPETXT",
"I_SUVOLRTRCKGCHMLCMPSTNSRCE",
"R_SUBSTVOLRETRACKINGTP"
],
"ASSOCIATED":
[
"C_SUBSTANCEDAILYSUBSTVOL",
"C_SUBSTANCEVOLUME",
"I_CHMLCMPLNCMATLASSGMT",
"I_SUBSTVOLRETRACKINGSTATUSTXT",
"I_SUBSTVOLRETRACKINGTYPETXT",
"I_SUVOLRTRCKGCHMLCMPSTNSRCE",
"I_USERCONTACTCARD"
],
"BASE":
[
"R_SUBSTVOLRETRACKINGTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More