P_RecipeFmlaExplsnRcpWhereUsed

DDL: P_RECIPEFMLAEXPLSNRCPWHEREUSED SQL: PRCPEXPLWHEREU Type: view CONSUMPTION Package: VDM_PLMB_RCA

Private view for Recipe Formula Explosion Where Used

P_RecipeFmlaExplsnRcpWhereUsed is a Consumption CDS View that provides data about "Private view for Recipe Formula Explosion Where Used" in SAP S/4HANA. It reads from 1 data source (I_RecipeFormulaItemForKeyDate) and exposes 35 fields with key field RcpFmlaItemUUID. Part of development package VDM_PLMB_RCA.

1 data source(s) 35 fields

Data Sources (1)

SourceAliasJoin Type
I_RecipeFormulaItemForKeyDate I_RecipeFormulaItemForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRCPEXPLWHEREU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #CONSUMPTION view
EndUserText.label Private view for Recipe Formula Explosion Where Used view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY RcpFmlaItemUUID RcpFmlaItemUUID
RecipePurpose
RecipeStatus
RecipeType
RcpFmlaUUID RcpFmlaUUID
RcpFmlaItemSourceFmlaItemUUID RcpFmlaItemSourceFmlaItemUUID
RcpFmlaItemPosition RcpFmlaItemPosition
RcpFmlaItemAlternativeItemPos RcpFmlaItemAlternativeItemPos
RcpFmlaItemType RcpFmlaItemType
SpecificationInternalID SpecificationInternalID
Material Material
RcpFmlaStreamUUID RcpFmlaStreamUUID
RcpFmlaItemComponentType RcpFmlaItemComponentType
RcpFmlaItemLowerLimit RcpFmlaItemLowerLimit
RcpFmlaItemUpperLimit RcpFmlaItemUpperLimit
RcpFmlaItemQuantity RcpFmlaItemQuantity
RcpFmlaItemUnit RcpFmlaItemUnit
RcpFmlaItemExceptionCode RcpFmlaItemExceptionCode
RcpFmlaItemScrapInPercent RcpFmlaItemScrapInPercent
RcpFmlaItemOverrunInPercent RcpFmlaItemOverrunInPercent
RcpFmlaItemAlternativeItemUUID RcpFmlaItemAlternativeItemUUID
RcpFmlaItemQuantityInKilogram RcpFmlaItemQuantityInKilogram
RcpFmlaItemZeroSign RcpFmlaItemZeroSign
RcpFmlaItemIsSelectedForCalc RcpFmlaItemIsSelectedForCalc
RcpFmlaItemExplosionRecipeUUID RcpFmlaItemExplosionRecipeUUID
RcpFmlaCalculationType RcpFmlaCalculationType
RcpFmlaItemIsBalancingItem RcpFmlaItemIsBalancingItem
RecipeFmlaItemAltvIsUsed RecipeFmlaItemAltvIsUsed
RecipeUUID RecipeUUID
_ComponentType _ComponentType
_RecipeForKeyDate _RecipeForKeyDate
_SpecificationForKeyDate _SpecificationForKeyDate
_RecipeProcessElementAssgmt _RecipeProcessElementAssgmt
_Product _Product
_ToRecipeForKeyDate _RecipeStreamQtyForKeyDate 
@AbapCatalog.sqlViewName: 'PRCPEXPLWHEREU'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.lifecycle.contract.type: #NONE
@VDM.viewType: #CONSUMPTION

@EndUserText.label: 'Private view for Recipe Formula Explosion Where Used'
define view P_RecipeFmlaExplsnRcpWhereUsed
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate        : sydate
  as select from I_RecipeFormulaItemForKeyDate( P_KeyDate : $parameters.P_KeyDate )

{
      key RcpFmlaItemUUID,
        
      _RecipeForKeyDate( P_KeyDate: $parameters.P_KeyDate ).RecipePurpose as RecipePurpose,
      _RecipeForKeyDate( P_KeyDate: $parameters.P_KeyDate ).RecipeStatus as RecipeStatus,
      _RecipeForKeyDate( P_KeyDate: $parameters.P_KeyDate ).RecipeType as RecipeType,      
     
      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,

      /* Associations */
      _ComponentType,

      _RecipeForKeyDate,
      _SpecificationForKeyDate,
      _RecipeProcessElementAssgmt,
      _Product,
      _RecipeStreamQtyForKeyDate
                                                                                                                                                                                as  _ToRecipeForKeyDate
}

Learn More