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,
  personalData.blocking: #REQUIRED,
  privilegedAssociations: ['_CompletedByUser', '_ReleasedByUser', '_DecidedByUser' ]
}
@EndUserText.label: 'Substance Volume Retracking - TP'

@ObjectModel: {
  usageType: {
    sizeCategory: #XL,
    serviceQuality: #C,
    dataClass: #MIXED },
    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

}

Learn More