A_ProdSubstnPredecessor_2

DDL: A_PRODSUBSTNPREDECESSOR_2 Type: view_entity CONSUMPTION

Product Substitution Predecessor

A_ProdSubstnPredecessor_2 is a Consumption CDS View that provides data about "Product Substitution Predecessor" in SAP S/4HANA. It reads from 1 data source (R_ProdSubstnPrdcssrTP) and exposes 30 fields with key fields MDSubstnUUID, MDSubstnMasterUUID.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
R_ProdSubstnPrdcssrTP R_ProdSubstnPrdcssrTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.query.implementedBy ABAP:CL_PRODSUBSTN_QUERY view
ObjectModel.representativeKey MDSubstnUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Product Substitution Predecessor view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name ProdSubstnPredecessor_Type view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnUUID MDSubstnUUID
KEY MDSubstnMasterUUID MDSubstnMasterUUID
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
MDSubstnValidityStartDateTime MDSubstnValidityStartDateTime
MDSubstnValidityEndDateTime MDSubstnValidityEndDateTime
TimeZoneID TimeZoneID
MDSubstnReason MDSubstnReason
MDSubstnStatus MDSubstnStatus
MDSubstnIsRlvtForATPProd MDSubstnIsRlvtForATPProd
MDSubstnIsRelevantForESPP MDSubstnIsRelevantForESPP
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Product _Product
_SubstituteProduct _SubstituteProduct 
@AccessControl: {
  authorizationCheck: #MANDATORY
}

@ObjectModel: {
  query.implementedBy: 'ABAP:CL_PRODSUBSTN_QUERY',
  representativeKey: 'MDSubstnUUID',
  semanticKey: [ 'Product', 'SubstituteProduct', 'Plant', 'MDSubstnGroup', 'MDSubstnReason' ],
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory: #M
  }
}
@EndUserText.label: 'Product Substitution Predecessor'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #CONSUMPTION,
  lifecycle: {
    contract.type: #PUBLIC_REMOTE_API
  },
  usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}
@OData.entityType.name: 'ProdSubstnPredecessor_Type'
define view entity A_ProdSubstnPredecessor_2 
as projection on R_ProdSubstnPrdcssrTP
{
  key MDSubstnUUID,
      @ObjectModel.foreignKey.association : '_Substitution'
  key MDSubstnMasterUUID,
      MDSubstnObjectType,
      Product,
      SubstituteProduct,
      MDSubstnContextObjectType,
      Plant,
      MDSubstnContextObjectType2,
      MDSubstnGroup,
      MDSubstnVersionValue,
      MDSubstnSet,
      MDSubstnIsExit,
      MDSubstnIsLeading,
      MDSubstnSequenceValue,
      MDSubstnConversionNumerator,
      MDSubstnConversionDenominator,
      MDSubstnConversionPercent,
      MDSubstnValidityStartDateTime,    
      MDSubstnValidityEndDateTime,      
      TimeZoneID,
      MDSubstnReason,
      MDSubstnStatus,
      MDSubstnIsRlvtForATPProd,
      MDSubstnIsRelevantForESPP,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,
      /* Associations */
      /*_ContextObjectTypeCode,
      _ContextObjectTypeCode2,
      _CreatedByUser,
      _ExitIndicator,
      _Group,
      _LastChangedByUser,
      _LeadIndicator,
      _MDObjectType,
      _MDSubstnIsRelevantForESPP,
      _MDSubstnIsRlvtForATPProd,
      _Plant,
      _Product,
      _Reason,
      _Status,
      _SubstituteProduct, */
      @Consumption.hidden: true // exposed for DCL

      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      _Product,
      @Consumption.hidden: true // exposed for DCL

      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      _SubstituteProduct,
      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      _Substitution : redirected to parent A_ProdSubstn_3
      //_TimeZone

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

Learn More