I_MASTERRECIPE

CDS View

Master Recipe Main Header Details

I_MASTERRECIPE is a CDS View in S/4HANA. Master Recipe Main Header Details. It contains 4 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 4 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_LinkedProdnVersBOO view_entity inner CONSUMPTION BOO to Material Assignment for ProdnVers
I_MasterRecipeHeaderTP view_entity inner TRANSACTIONAL Master Recipe - Header
I_MasterRecipeNonHistoricHdrTP view_entity from TRANSACTIONAL Master Recipe Non Historical Header
P_ProcOrdMgmtOpRelshpExists view inner COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup BillOfOperationsGroup 1
KEY BillOfOperationsType BillOfOperationsType 1
KEY BillOfOperationsVariant BillOfOperationsVariant 1
IsMarkedForDeletion IsMarkedForDeletion 1 
@AbapCatalog.sqlViewName: 'IMSTRRCP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'BillOfOperationsVariant'
@EndUserText.label: 'Master Recipe Main Header Details'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@Metadata.allowExtensions: true
define view I_MasterRecipe
  as select from plkz
  association [1..1] to I_BillOfOperationsType        as _BillOfOperationsType        on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
  association [0..1] to I_BillOfOperationsVersionType as _BillOfOperationsVersionType on  $projection.BillOfOperationsVersionType = _BillOfOperationsVersionType.BillOfOperationsVersionType
  association [1..1] to I_BillOfOperationsGroup       as _BillOfOperationsGroup       on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                                      and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plkz.plnty                                                   as   BillOfOperationsType,

      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key plkz.plnnr                                                   as   BillOfOperationsGroup,
  key plkz.plnal                                                   as   BillOfOperationsVariant,

      @ObjectModel.foreignKey.association: '_BillOfOperationsVersionType'
      plkz.subtype                                                 as   BillOfOperationsVersionType,

      plkz.subtype                                                 as   BillOfOperationsSubtype, //kept for compatibility reasons


      plkz.abdat                                                   as   LastUsageDate,
      plkz.abanz                                                   as   NumberOfUsages,

      plkz.flg_ecm                                                 as   HasChangeNumber,
      plkz.flg_ecm_par                                             as   HasParameterEffectivity,

      -- Administrative Data
      plkz.aedat                                                   as   LastChangeDate,
      plkz.aeuzeit                                                 as   LastChangeTime,
      cast(plkz.aenam as vdm_lastchangedbyuserid preserving type)  as   LastChangedByUser,

      plkz.delkz                                                   as   IsMarkedForDeletion,

      plkz.rework                                                  as   RoutingIsReworkRouting,
      plkz.relaxed                                                 as   ProdnProcgIsFlexible,

      // **************************** Associations *****************************

      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperationsVersionType
}
where
  plnty = '2'

Learn More