A_ProdSubstnExclsn_2

DDL: A_PRODSUBSTNEXCLSN_2 Type: view_entity CONSUMPTION

Product Substitution Exclusion

A_ProdSubstnExclsn_2 is a Consumption CDS View that provides data about "Product Substitution Exclusion" in SAP S/4HANA. It reads from 1 data source (R_ProdSubstnExclsnTP) and exposes 22 fields with key field MDSubstnUUID.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
R_ProdSubstnExclsnTP R_ProdSubstnExclsnTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Substitution Exclusion view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey MDSubstnUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
OData.entityType.name ProductExclusion_Type view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnUUID MDSubstnUUID
MDSubstnObjectType MDSubstnObjectType
Product Product
Plant Plant
MDSubstnContextObjectType MDSubstnContextObjectType
MDSubstnContextObjectType2 MDSubstnContextObjectType2
MDSubstnGroup MDSubstnGroup
MDSubstnVersionValue MDSubstnVersionValue
MDSubstnValidityStartDate MDSubstnValidityStartDate
MDSubstnValidityStartTime MDSubstnValidityStartTime
MDSubstnValidityEndDate MDSubstnValidityEndDate
MDSubstnValidityEndTime MDSubstnValidityEndTime
TimeZoneID TimeZoneID
MDSubstnReason MDSubstnReason
MDSubstnStatus MDSubstnStatus
MDSubstnIsRlvtForATPProd MDSubstnIsRlvtForATPProd
MDSubstnIsRelevantForESPP MDSubstnIsRelevantForESPP
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Product _Product 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Substitution Exclusion'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  representativeKey: 'MDSubstnUUID' ,
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #A,
    sizeCategory: #M
  }
}
@VDM: {
  lifecycle: {
    contract.type: #PUBLIC_REMOTE_API
  },
  viewType: #CONSUMPTION,
  usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}
@OData.entityType.name: 'ProductExclusion_Type'
define root view entity A_ProdSubstnExclsn_2
  provider contract transactional_query
  as projection on R_ProdSubstnExclsnTP
{
  key MDSubstnUUID,

      @Consumption.hidden: true // exposed for DCL

      MDSubstnObjectType,

      Product,
      Plant,

      @Consumption.hidden: true // exposed for DCL

      MDSubstnContextObjectType,

      @Consumption.hidden: true // exposed for DCL

      MDSubstnContextObjectType2,

      MDSubstnGroup,

      @Consumption.hidden: true // not supported functionality

      MDSubstnVersionValue,

      MDSubstnValidityStartDate,
      MDSubstnValidityStartTime,
      MDSubstnValidityEndDate,
      MDSubstnValidityEndTime,
      TimeZoneID,
      MDSubstnReason,
      @ObjectModel.sapObjectNodeTypeReference: 'MasterDataSubstitutionStatus'
      MDSubstnStatus,
      MDSubstnIsRlvtForATPProd,

      /* Start - Lightweight Business switch: Enable eSPP flag in Hybrid & OP systems only*/
      @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
      MDSubstnIsRelevantForESPP,
      /* End - Lightweight Business switch: Enable eSPP flag in Hybrid & OP systems only*/

      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,

      @Consumption.hidden: true // exposed for DCL

      _Product
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PRODSUBSTNEXCLSNTP"
],
"ASSOCIATED":
[
"I_PRODUCT"
],
"BASE":
[
"R_PRODSUBSTNEXCLSNTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More