A_ProdSubstn

DDL: A_PRODSUBSTN Type: view_entity CONSUMPTION

Product Substitution

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

1 data source(s) 42 fields

Data Sources (1)

SourceAliasJoin Type
R_ProdSubstnTP R_ProdSubstnTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Product Substitution 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

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnUUID MDSubstnUUID
MDSubstnObjectType MDSubstnObjectType
Product Product
SubstituteProduct SubstituteProduct
MDSubstnContextObjectType MDSubstnContextObjectType
Plant Plant
MDSubstnContextObjectType2 MDSubstnContextObjectType2
MDSubstnGroup MDSubstnGroup
MDSubstnVersionValue MDSubstnVersionValue
MDSubstnSet MDSubstnSet
MDSubstnIsExit MDSubstnIsExit
MDSubstnIsLeading MDSubstnIsLeading
MDSubstnSequenceValue MDSubstnSequenceValue
MDSubstnConversionNumerator MDSubstnConversionNumerator
MDSubstnConversionDenominator MDSubstnConversionDenominator
MDSubstnConversionPercent MDSubstnConversionPercent
MDSubstnValidityStartDate MDSubstnValidityStartDate
MDSubstnValidityStartTime MDSubstnValidityStartTime
MDSubstnValidityEndDate MDSubstnValidityEndDate
MDSubstnValidityEndTime MDSubstnValidityEndTime
TimeZoneID TimeZoneID
MDSubstnReason MDSubstnReason
MDSubstnStatus MDSubstnStatus
MDSubstnIsRlvtForATPProd MDSubstnIsRlvtForATPProd
MDSubstnIsRelevantForESPP MDSubstnIsRelevantForESPP
SrvcPartsSubstnRelshpCode SrvcPartsSubstnRelshpCode
SrvcPartsSubstnUseUpStrategy SrvcPartsSubstnUseUpStrategy
SrvcPartsSubstnUseUpDate SrvcPartsSubstnUseUpDate
SrvcPartsIntchgtyGroupType SrvcPartsIntchgtyGroupType
SrvcPartsSubstnReplacementCode SrvcPartsSubstnReplacementCode
SrvcPartsStockExhaustionDate SrvcPartsStockExhaustionDate
SrvcPartsSuccessorProdPlndDate SrvcPartsSuccessorProdPlndDate
SrvcPartsStkExhaustionWrngDate SrvcPartsStkExhaustionWrngDate
SrvcPartsSuccessorProdRcptDate SrvcPartsSuccessorProdRcptDate
SrvcPartsReorganizationEndDate SrvcPartsReorganizationEndDate
SrvcPartsProdSubstnFinalDate SrvcPartsProdSubstnFinalDate
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Product _Product
_SubstituteProduct _SubstituteProduct 
@AccessControl: {
  authorizationCheck: #MANDATORY
}
@EndUserText.label: 'Product Substitution'
@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]
}
define root view entity A_ProdSubstn 
  provider contract transactional_query
  as projection on R_ProdSubstnTP
{

  key MDSubstnUUID,

      @Consumption.hidden: true // exposed for DCL

      MDSubstnObjectType,

      Product,
      SubstituteProduct,

      @Consumption.hidden: true // exposed for DCL

      MDSubstnContextObjectType,

      Plant,

      @Consumption.hidden: true // exposed for DCL

      MDSubstnContextObjectType2,

      MDSubstnGroup,

      @Consumption.hidden: true // not supported functionality

      MDSubstnVersionValue,

      MDSubstnSet,
      MDSubstnIsExit,
      MDSubstnIsLeading,
      MDSubstnSequenceValue,
      MDSubstnConversionNumerator,
      MDSubstnConversionDenominator,
      MDSubstnConversionPercent,
      MDSubstnValidityStartDate,
      MDSubstnValidityStartTime,
      MDSubstnValidityEndDate,
      MDSubstnValidityEndTime,
      TimeZoneID,
      MDSubstnReason,
      @ObjectModel.sapObjectNodeTypeReference: 'MasterDataSubstitutionStatus'
      MDSubstnStatus,
      MDSubstnIsRlvtForATPProd,
      
      /* Start - Lightweight Business switch: Enable eSPP fields in Hybrid & OP systems only*/
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          MDSubstnIsRelevantForESPP,
          
      // [eSPP] Location Independent

          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsSubstnRelshpCode,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsSubstnUseUpStrategy,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsSubstnUseUpDate,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsIntchgtyGroupType,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsSubstnReplacementCode,

      // [eSPP] Location Dependent

          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsStockExhaustionDate,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsSuccessorProdPlndDate,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsStkExhaustionWrngDate,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsSuccessorProdRcptDate,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsReorganizationEndDate,
          @Feature: 'SW:PROD_SUBSTN_ENABLE_ESPP'
          SrvcPartsProdSubstnFinalDate,
      /* End - Lightweight Business switch: Enable eSPP fields in Hybrid & OP systems only*/
      
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,

      /* Associations */
      @Consumption.hidden: true // exposed for DCL

      _Product,

      @Consumption.hidden: true // exposed for DCL

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

Learn More