R_PRODSUBSTNCTRLGRPTP

CDS View

Product Substitution Control Group TP

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

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_ProdSubstnCtrlGrp 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: #CHECK
}
//@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Product Substitution Control Group TP'
@ObjectModel: {
  representativeKey: 'MDSubstnControl',
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #S
  }
}
@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_MDSUBSTNCTRLGRPTP"
],
"ASSOCIATED":
[
"I_MDSUBSTNCTRLGRPCALC",
"I_MDSUBSTNGRP",
"I_SAPOBJECTTYPE",
"R_PRODSUBSTNCTRLTP"
],
"BASE":
[
"R_MDSUBSTNCTRLGRPTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More