I_MasterRecipeMaterialAssgmtTP

DDL: I_MASTERRECIPEMATERIALASSGMTTP SQL: IMRCMATLASSGMTTP Type: view_entity TRANSACTIONAL

Master Recipe - Material Assignment

I_MasterRecipeMaterialAssgmtTP is a Transactional CDS View that provides data about "Master Recipe - Material Assignment" in SAP S/4HANA. It reads from 1 data source (I_MasterRecipeMaterialAssgmt) and exposes 18 fields with key fields Product, Plant, MasterRecipeGroup, MasterRecipe, MasterRecipeMaterialAssignment. It has 2 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_MasterRecipeMaterialAssgmt I_MasterRecipeMaterialAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_MasterRecipeHeaderTP _Header $projection.MasterRecipeGroup = _Header.MasterRecipeGroup and $projection.MasterRecipe = _Header.MasterRecipe and $projection.ValidityEndDate >= _Header.ValidityStartDate and $projection.ValidityStartDate <= _Header.ValidityEndDate -- to root node
[1..1] I_MaterialText _MaterialText $projection.Product = _MaterialText.Material and _MaterialText.Language = $session.system_language

Annotations (9)

NameValueLevelField
ObjectModel.representativeKey MasterRecipeMaterialAssignment view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Recipe - Material Assignment view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Product Material Product
KEY Plant Plant
KEY MasterRecipeGroup BillOfOperationsGroup
KEY MasterRecipe BillOfOperationsVariant
KEY MasterRecipeMaterialAssignment BOOToMaterialInternalID
KEY MstrRcpMatlAssgmtIntVersion BOOMatlInternalVersionCounter
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
ChangeNumber ChangeNumber
ChangedDateTime _RcpTP ChangedDateTime
ProductName _MaterialText MaterialName
_Header _Header
_RcpTP _RcpTP
_MaterialText _MaterialText 
//@AbapCatalog.sqlViewName: 'IMRCMATLASSGMTTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'MasterRecipeMaterialAssignment'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Recipe - Material Assignment'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #M, dataClass: #MASTER}
define view entity I_MasterRecipeMaterialAssgmtTP
  as select from I_MasterRecipeMaterialAssgmt
  -- for DCLS
  association [1..*] to I_MasterRecipeHeaderTP                as _Header       on  $projection.MasterRecipeGroup =  _Header.MasterRecipeGroup
                                                                               and $projection.MasterRecipe      =  _Header.MasterRecipe
                                                                               and $projection.ValidityEndDate   >= _Header.ValidityStartDate
                                                                               and $projection.ValidityStartDate <= _Header.ValidityEndDate
  -- to root node
  association        to parent I_MasterRecipeNonHistoricHdrTP as _RcpTP        on  $projection.MasterRecipeGroup = _RcpTP.MasterRecipeGroup
                                                                               and $projection.MasterRecipe      = _RcpTP.MasterRecipe

  association [1..1] to I_MaterialText                        as _MaterialText on  $projection.Product    = _MaterialText.Material
                                                                               and _MaterialText.Language = $session.system_language

{
      //I_MasterRecipeMaterialAssgmt

      @Consumption.valueHelpDefinition: [{entity:{ name: 'C_MassMaintCapProductVH', element: 'Product'} }]
      @EndUserText.label: 'Product'
  key Material                      as Product,
  key Plant,
  key BillOfOperationsGroup         as MasterRecipeGroup,
  key BillOfOperationsVariant       as MasterRecipe,
  key BOOToMaterialInternalID       as MasterRecipeMaterialAssignment,
  key BOOMatlInternalVersionCounter as MstrRcpMatlAssgmtIntVersion,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      @Semantics.businessDate.to: true
      ValidityEndDate,
      ChangeNumber,
      _RcpTP.ChangedDateTime,
      _MaterialText.MaterialName    as ProductName,

      /* Associations */
      //I_MasterRecipeMaterialAssgmt

      @Consumption.hidden: true
      _Header,
      _RcpTP,
      _MaterialText
}
where
      IsDeleted           <> 'X'
  and IsImplicitlyDeleted <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERRECIPEMATERIALASSGMT",
"I_MASTERRECIPENONHISTORICHDRTP",
"I_MATERIALTEXT"
],
"ASSOCIATED":
[
"I_MASTERRECIPEHEADERTP",
"I_MASTERRECIPENONHISTORICHDRTP",
"I_MATERIALTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More