R_SUBSTVOLRETRACKINGTP

CDS View

Substance Volume Retracking - TP

R_SUBSTVOLRETRACKINGTP is a CDS View in S/4HANA. Substance Volume Retracking - TP. 9 CDS views read from this table.

Used by 9 CDS view(s)

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_SubstVolRetrackingMaterialTP view_entity projection CONSUMPTION Subst Vol Retracking for Material
C_SubstVolRetrackingProductTP view_entity projection CONSUMPTION Subst Vol Retracking for Products
C_SubstVolRetrackingRawMatlTP view_entity projection CONSUMPTION Subst Vol Retracking for Raw Materials
C_SubstVolRetrackingSubstTP view_entity projection CONSUMPTION Subst Vol Retracking for Substance
C_SubstVolRetrackingTP view_entity projection CONSUMPTION Substance Volume Retracking
C_SubstVolRetrckMatMasterTP view_entity projection CONSUMPTION Retrack Product Master
C_SubstVolRetrckPolymerTP view_entity projection CONSUMPTION Retrack Substance
C_SuVolRtrckgMatlChmlCmpstnTP view_entity projection CONSUMPTION Retrack Material Based Composition
C_SuVolRtrckgSubstChmlCmpstnTP view_entity projection CONSUMPTION Retrack Substance Based Composition 
@AccessControl: {
  authorizationCheck: #MANDATORY,
  privilegedAssociations: ['_CompletedByUser', '_ReleasedByUser']
}
@EndUserText.label: 'Substance Volume Retracking - TP'

@ObjectModel: {
  usageType: {
    sizeCategory: #M,
    serviceQuality: #C,
    dataClass: #MASTER },
    representativeKey: 'SubstVolRetrackingUUID' }

@ObjectModel.modelingPattern: #TRANSACTIONAL_ENTITY

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL }

@ObjectModel.sapObjectNodeType.name: 'SubstanceVolumeRetracking'

/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define root view entity R_SubstVolRetrackingTP
  as select from I_SubstVolRetracking
  association [1..1] to I_SubstVolRetrackingTypeTxt   as _SubstVolRetrackingTypeTxt   on  $projection.SubstVolRetrackingType  = _SubstVolRetrackingTypeTxt.SubstVolRetrackingType
                                                                                      and _SubstVolRetrackingTypeTxt.Language = $session.system_language

  association [1..1] to I_SubstVolRetrackingStatusTxt as _SubstVolRetrackingStatusTxt on  $projection.SubstVolRetrackingStatus  = _SubstVolRetrackingStatusTxt.SubstVolRetrackingStatus
                                                                                      and _SubstVolRetrackingStatusTxt.Language = $session.system_language

  association [0..1] to I_SuVolRtrckgChmlCmpstnSrce   as _SubstVolRetrckgChmlCmpstn   on  $projection.SubstVolRetrackingSourceUUID = _SubstVolRetrckgChmlCmpstn.SubstVolRetrackingSourceUUID
  
  --Link to user data
  association [1..1] to I_UserContactCard             as _CompletedByUser             on  $projection.SubstVolRetrackingCompletedBy = _CompletedByUser.ContactCardID
  association [1..1] to I_UserContactCard             as _ReleasedByUser              on  $projection.SubstVolRetrackingSrceChgdBy = _ReleasedByUser.ContactCardID
  association [1..1] to I_UserContactCard             as _DecidedByUser               on  $projection.SubstVolRetrackingDecidedBy = _DecidedByUser.ContactCardID
  association [0..1] to I_ChmlCmplncMatlAssgmt        as _ChmlCmplncMatlAssgmt        on  $projection.SubstVolRetrackingSource    = _ChmlCmplncMatlAssgmt.Material 
  association [0..1] to I_ProductWD                   as _Product                     on  _Product.Product = $projection.SubstVolRetrackingSource
  association [0..1] to I_OTRText                     as _NotAssignText            on  _NotAssignText.OnlnTxtRpstryConceptID = '0894EF4576511EEA95948AEACCDAAAC7' and _NotAssignText.Language = $session.system_language
{
  key SubstVolRetrackingUUID,
      I_SubstVolRetracking.SubstVolRetrackingStatus,
      SubstVolRetrackingStartDate,
      SubstVolRetrckgIsOpnTrckgPerds,
      SubstVolRetrckgIsCurTrckgPerd,
      SubstVolRetrackingReasonText,
      ComplianceRequirement,
      CmplRqUUID,
      ProdCmplncEventUUID,
      SubstVolRetrackingType,
      I_SubstVolRetracking.SubstVolRetrackingSourceUUID,
      I_SubstVolRetracking.SubstVolRetrackingSource,
      I_SubstVolRetracking.SubstVolRetrackingSourceType,
      SubstVolRetrackingCategory,
      SubstVolRetrckgCompletedDteTme,
      SubstVolRetrackingCompletedBy,
      SubstVolRetrckgDecidedDteTme,
      SubstVolRetrackingDecidedBy,
      SubstVolRetrackingSrceChgdBy,
      cast( _ReleasedByUser.FullName as  ehfnd_released_by_user_name preserving type )                                      as SuVolRtrckgSrceChgdByFullName,
      cast( _CompletedByUser.FullName   as ehpma_svt_retrckg_accptd_by preserving type )                                    as SuVolRtrckgCmpltdByFullName,
      _NotAssignText.Text as SuVolRtrckgDecidedBySystemText,
      _DecidedByUser.FullName as SuVolRtrckgDecidedByFullName,
      cast( 
        case
          when _DecidedByUser.FullName is not initial
            then _DecidedByUser.FullName
          else _NotAssignText.Text
        end 
      as ehpma_svt_retrckg_dcd_by_fn preserving type ) as SuVolRtrckgDecidedByCmbndName,
      
      CreationDateTime,
      SubstVolRetrckgSrceChgdDteTme,
      CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      LastChangedByUser,


      _ChmlCmplncMatlAssgmt,
      _Product,
      _SubstVolRetrackingTypeTxt,
      _SubstVolRetrackingStatusTxt,


      _SubstVolRetrckgChmlCmpstn,
      _ReleasedByUser,
      _CompletedByUser,
      _DecidedByUser,
      _NotAssignText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OTRTEXT",
"I_SUBSTVOLRETRACKING",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCMATLASSGMT",
"I_OTRTEXT",
"I_PRODUCTWD",
"I_SUBSTVOLRETRACKINGSTATUSTXT",
"I_SUBSTVOLRETRACKINGTYPETXT",
"I_SUVOLRTRCKGCHMLCMPSTNSRCE",
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More