I_RECIPEFORMULAITEMFORKEYDATE

CDS View

Recipe Formula Item for Key Date

I_RECIPEFORMULAITEMFORKEYDATE is a CDS View in S/4HANA. Recipe Formula Item for Key Date. 12 CDS views read from this table.

Used by 12 CDS view(s)

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_RecipeFmlaWthExplosionRecipe view from CONSUMPTION Recipe Formula With Explosion Recipes
C_RecipeFmlaWthExplosionRecipe view inner CONSUMPTION Recipe Formula With Explosion Recipes
I_RcpFmlaItmWhereUsed view from COMPOSITE Recipe Formula Item for Where Used
I_RcpFmlaItmWhereUsed view inner COMPOSITE Recipe Formula Item for Where Used
I_RcpFmlaItmWhereUsedPrptySpec view from COMPOSITE Recipe Formula Item for Where Used (Property Specification)
I_RcpFmlaItmWhereUsedPrptySpec view inner COMPOSITE Recipe Formula Item for Where Used (Property Specification)
I_RecipeFmlaItemForKeyDateTP view from TRANSACTIONAL Recipe Formula Item for Key Date (Transactional Processing)
P_RecipeFmlaExplsnRcpWhereUsed view from CONSUMPTION Private view for Recipe Formula Explosion Where Used
P_RecipeFormulaItmForExplsnScp view from COMPOSITE Private view for Recipe Formula Item for Explosion Scope
P_RecipeFormulaItmForExplsnScp view inner COMPOSITE Private view for Recipe Formula Item for Explosion Scope
P_RecipeFormulaItmForExplsnScp view union COMPOSITE Private view for Recipe Formula Item for Explosion Scope
R_RecipeWithPrimaryOutput view inner COMPOSITE Recipe for Key Date with PO Data 
@AbapCatalog.sqlViewName: 'IRCPRFOKD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE

@EndUserText.label: 'Recipe Formula Item for Key Date'
define view I_RecipeFormulaItemForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_RecipeFormulaItem
  association [0..1] to I_SpecificationForKeyDate   as _SpecificationForKeyDate   on $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID
  association [1..1] to I_RecipeForKeyDate          as _RecipeForKeyDate          on $projection.RcpFmlaUUID = _RecipeForKeyDate.RcpFmlaUUID
  association [1..*] to I_RecipeStreamQtyForKeyDate as _RecipeStreamQtyForKeyDate on $projection.RcpFmlaItemUUID = _RecipeStreamQtyForKeyDate.RcpFmlaItemUUID
{
  key RcpFmlaItemUUID,
      RcpFmlaUUID,
      RcpFmlaItemSourceFmlaItemUUID,
      RcpFmlaItemPosition,
      RcpFmlaItemAlternativeItemPos,
      RcpFmlaItemType,
      SpecificationInternalID,
      Material,
      RcpFmlaStreamUUID,
      RcpFmlaItemComponentType,
      RcpFmlaItemLowerLimit,
      RcpFmlaItemUpperLimit,
      RcpFmlaItemQuantity,
      RcpFmlaItemUnit,
      RcpFmlaItemExceptionCode,
      RcpFmlaItemScrapInPercent,
      RcpFmlaItemOverrunInPercent,
      RcpFmlaItemAlternativeItemUUID,
      RcpFmlaItemQuantityInKilogram,
      RcpFmlaItemZeroSign,
      RcpFmlaItemIsSelectedForCalc,
      RcpFmlaItemExplosionRecipeUUID,
      RcpFmlaCalculationType,
      RcpFmlaItemIsBalancingItem,
      RecipeFmlaItemAltvIsUsed,
      RecipeUUID,

      /* Attributes from recipe header and its primary output for authorization */
      //_RecipeForKeyDate( P_KeyDate : $parameters.P_KeyDate ).RecipeType,

      //_RecipeForKeyDate( P_KeyDate : $parameters.P_KeyDate ).RecipePurpose,

      //_RecipeForKeyDate( P_KeyDate : $parameters.P_KeyDate ).RecipeStatus,

      //_RecipeForKeyDate( P_KeyDate : $parameters.P_KeyDate ).RecipeAuthorizationGroup,


      /* Associations */
      _ComponentType,

      _RecipeForKeyDate,
      _SpecificationForKeyDate,
      _RecipeProcessElementAssgmt,
      _Product,
      _RecipeStreamQtyForKeyDate
}

Learn More