C_ProdSubstnExclsn

DDL: C_PRODSUBSTNEXCLSN Type: view_entity CONSUMPTION

Product Exclusion

C_ProdSubstnExclsn is a Consumption CDS View that provides data about "Product Exclusion" in SAP S/4HANA. It reads from 1 data source (I_MDSubstnExclsn) and exposes 26 fields with key field MDSubstnUUID. It has 4 associations to related views.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_MDSubstnExclsn I_MDSubstnExclsn from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_Indicator _MDSubstnIsRlvtForATPProd $projection.MDSubstnIsRlvtForATPProd = _MDSubstnIsRlvtForATPProd.IndicatorValue
[1..1] I_Indicator _MDSubstnIsRelevantForESPP $projection.MDSubstnIsRelevantForESPP = _MDSubstnIsRelevantForESPP.IndicatorValue

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Exclusion view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #CONSUMPTION view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnUUID MDSubstnUUID
MDSubstnObjectType MDSubstnObjectType
Product
MDSubstnContextObjectType MDSubstnContextObjectType
Plant
MDSubstnContextObjectType2 MDSubstnContextObjectType2
MDSubstnGroup MDSubstnGroup
MDSubstnVersionValue MDSubstnVersionValue
MDSubstnValidityStartDateTime MDSubstnValidityStartDateTime
MDSubstnValidityEndDateTime MDSubstnValidityEndDateTime
TimeZoneID TimeZoneID
MDSubstnReason MDSubstnReason
MDSubstnStatus MDSubstnStatus
MDSubstnIsRlvtForATPProd MDSubstnIsRlvtForATPProd
MDSubstnIsRelevantForESPP MDSubstnIsRelevantForESPP
_MDObjectType _MDObjectType
_ContextObjectTypeCode _ContextObjectTypeCode
_ContextObjectTypeCode2 _ContextObjectTypeCode2
_Product _Product
_Plant _Plant
_Group _Group
_TimeZone _TimeZone
_Reason _Reason
_Status _Status
_MDSubstnIsRlvtForATPProd _MDSubstnIsRlvtForATPProd
_MDSubstnIsRelevantForESPP _MDSubstnIsRelevantForESPP 
@AccessControl:{
  authorizationCheck: #CHECK
}
@EndUserText.label: 'Product Exclusion'
@ObjectModel:{
    usageType:{
      dataClass: #MASTER,
      sizeCategory: #M,
      serviceQuality: #A
  }
}
@VDM: {
  viewType: #CONSUMPTION
}

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity C_ProdSubstnExclsn
  as select from I_MDSubstnExclsn
  association [1..1] to I_Product   as _Product                   on $projection.Product = _Product.Product
  association [0..1] to I_Plant     as _Plant                     on $projection.Plant = _Plant.Plant
  association [1..1] to I_Indicator as _MDSubstnIsRlvtForATPProd  on $projection.MDSubstnIsRlvtForATPProd = _MDSubstnIsRlvtForATPProd.IndicatorValue
  association [1..1] to I_Indicator as _MDSubstnIsRelevantForESPP on $projection.MDSubstnIsRelevantForESPP = _MDSubstnIsRelevantForESPP.IndicatorValue
{
  key MDSubstnUUID,

      @Consumption.hidden: true
      MDSubstnObjectType,

      @ObjectModel.foreignKey.association: '_Product'
      cast( MDObject as productnumber )        as Product,

      @Consumption.hidden: true
      MDSubstnContextObjectType,

      @ObjectModel.foreignKey.association: '_Plant'
      cast( MDSubstnContextObject as werks_d ) as Plant,

      @Consumption.hidden: true
      MDSubstnContextObjectType2,

      MDSubstnGroup,
      MDSubstnVersionValue,
      MDSubstnValidityStartDateTime,
      MDSubstnValidityEndDateTime,
      TimeZoneID,
      MDSubstnReason,
      MDSubstnStatus,
      MDSubstnIsRlvtForATPProd,
      MDSubstnIsRelevantForESPP,

      /* Associations */
      _MDObjectType,
      _ContextObjectTypeCode,
      _ContextObjectTypeCode2,
      _Product,
      _Plant,
      _Group,
      _TimeZone,
      _Reason,
      _Status,
      _MDSubstnIsRlvtForATPProd,
      _MDSubstnIsRelevantForESPP
}
where
       MDSubstnObjectType         = 'Product'
  and  MDSubstnContextObjectType  = 'Plant'
  and(
       MDSubstnContextObjectType2 is initial
    or MDSubstnContextObjectType2 is null
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDSUBSTNEXCLSN"
],
"ASSOCIATED":
[
"I_INDICATOR",
"I_MDSUBSTNGRP",
"I_MDSUBSTNRSN",
"I_MDSUBSTNSTS",
"I_PLANT",
"I_PRODUCT",
"I_SAPOBJECTTYPE",
"I_TIMEZONE"
],
"BASE":
[
"I_MDSUBSTNEXCLSN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More