I_RecipeStreamQtyForKeyDate

DDL: I_RECIPESTREAMQTYFORKEYDATE SQL: IRFOSTRQTYFKD Type: view COMPOSITE

Recipe Formula Stream Quantity On a Key Date

I_RecipeStreamQtyForKeyDate is a Composite CDS View that provides data about "Recipe Formula Stream Quantity On a Key Date" in SAP S/4HANA. It reads from 1 data source (I_RecipeStreamQuantity) and exposes 7 fields with key fields ExplosionScope, RecipeUUID, RcpFmlaUUID, RcpFmlaItemUUID. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_RecipeStreamQuantity I_RecipeStreamQuantity from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_RecipeForKeyDate _RecipeForKeyDate $projection.RecipeUUID = _RecipeForKeyDate.RecipeUUID
[1..*] I_RecipeFormulaItemForKeyDate _FormulaForKeyDate $projection.RcpFmlaUUID = _FormulaForKeyDate.RcpFmlaUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRFOSTRQTYFKD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Recipe Formula Stream Quantity On a Key Date view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ExplosionScope ExplosionScope
KEY RecipeUUID RecipeUUID
KEY RcpFmlaUUID RcpFmlaUUID
KEY RcpFmlaItemUUID RcpFmlaItemUUID
RcpFmlaItemStreamQuantityInKg RcpFmlaItemStreamQuantityInKg
_RecipeForKeyDate _RecipeForKeyDate
_FormulaForKeyDate _FormulaForKeyDate 
@AbapCatalog.sqlViewName: 'IRFOSTRQTYFKD'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

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

@EndUserText.label: 'Recipe Formula Stream Quantity On a Key Date'
define view I_RecipeStreamQtyForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_RecipeStreamQuantity
  association [1..1] to I_RecipeForKeyDate            as _RecipeForKeyDate  on $projection.RecipeUUID = _RecipeForKeyDate.RecipeUUID
  association [1..*] to I_RecipeFormulaItemForKeyDate as _FormulaForKeyDate on $projection.RcpFmlaUUID = _FormulaForKeyDate.RcpFmlaUUID
{
  key ExplosionScope,
  key RecipeUUID,
  key RcpFmlaUUID,
  key RcpFmlaItemUUID,
      RcpFmlaItemStreamQuantityInKg,

      /* Associations */
      _RecipeForKeyDate,
      _FormulaForKeyDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECIPESTREAMQUANTITY"
],
"ASSOCIATED":
[
"I_RECIPEFORKEYDATE",
"I_RECIPEFORMULAITEMFORKEYDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More