R_PRODSUBSTNCTRLGRPTP

CDS View

Product Substitution Control Group TP

R_PRODSUBSTNCTRLGRPTP is a CDS View in S/4HANA. Product Substitution Control Group TP. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_ProdSubstnCtrlGrp view_entity projection CONSUMPTION Product Substitution Control Group
A_ProdSubstnCtrlGrp_2 view_entity projection CONSUMPTION Product Substitution Control Group
C_ProdSubstnCtrlGrpTP view_entity projection CONSUMPTION Product Substitution Control Group 
//@AbapCatalog: {

//  compiler.compareFilter: true,

//  preserveKey: true,

//  sqlViewName: 'RPRODSUBCTRLGRP'

//}

@AccessControl: {
  authorizationCheck: #MANDATORY
}
//@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Product Substitution Control Group TP'
@ObjectModel: {
  representativeKey: 'MDSubstnControl',
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #S
  },
  sapObjectNodeType.name: 'ProductSubstnControlGroup'
}
@VDM: {
  lifecycle: {
    contract.type: #SAP_INTERNAL_API
  },
  viewType: #TRANSACTIONAL
}
define view entity R_ProdSubstnCtrlGrpTP
  as select from R_MDSubstnCtrlGrpTP
  association        to parent R_ProdSubstnCtrlTP as _Control          on  $projection.MDSubstnObjectType = _Control.MDSubstnObjectType
                                                                       and $projection.MDSubstnControl    = _Control.MDSubstnControl
  association [1..1] to I_MDSubstnCtrlGrpCalc     as _ControlGroupCalc on  $projection.MDSubstnControl      = _ControlGroupCalc.MDSubstnControl
                                                                       and $projection.MDSubstnObjectType   = _ControlGroupCalc.MDSubstnObjectType
                                                                       and $projection.MDSubstnGroup        = _ControlGroupCalc.MDSubstnGroup
                                                                       and $projection.MDSubstnVersionValue = _ControlGroupCalc.MDSubstnVersionValue
{
  key MDSubstnObjectType,
  key MDSubstnControl,
  key MDSubstnGroup,
  key MDSubstnVersionValue,

      /* Associations */
      _MDObjectType,
      _Control,
      _Group,
      _ControlGroupCalc
}
where
  MDSubstnObjectType = 'Product'

Learn More