A_RecProcEquipRqmtCharcValue

DDL: A_RECPROCEQUIPRQMTCHARCVALUE SQL: ANGCRERCLFN4 Type: view CONSUMPTION

Recipe Equipment Requirement Characteristic Values

A_RecProcEquipRqmtCharcValue is a Consumption CDS View that provides data about "Recipe Equipment Requirement Characteristic Values" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValForKeyDate) and exposes 23 fields with key fields RecipeProcessEquipRqmtUUID, ClassType, CharcInternalID, CharcValuePositionNumber. It has 1 association to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ANGCRERCLFN4 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Consumption.filter.businessDate.at true view
EndUserText.label Recipe Equipment Requirement Characteristic Values view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessEquipRqmtUUID RecipeProcessEquipRqmt RecipeProcessEquipRqmtUUID
KEY ClassType Valuation ClassType
KEY CharcInternalID Valuation CharcInternalID
KEY CharcValuePositionNumber Valuation CharcValuePositionNumber
KeyDate
CharcValueDependency Valuation CharcValueDependency
CharcValue Valuation CharcValue
CharcFromNumericValue Valuation CharcFromNumericValue
CharcFromNumericValueUnit Valuation CharcFromNumericValueUnit
CharcToNumericValue Valuation CharcToNumericValue
CharcToNumericValueUnit Valuation CharcToNumericValueUnit
CharcFromDecimalValue Valuation CharcFromDecimalValue
CharcToDecimalValue Valuation CharcToDecimalValue
CharcFromAmount Valuation CharcFromAmount
CharcToAmount Valuation CharcToAmount
Currency Valuation Currency
CharcFromDate Valuation CharcFromDate
CharcToDate Valuation CharcToDate
CharcFromTime Valuation CharcFromTime
CharcToTime Valuation CharcToTime
CharacteristicAuthor Valuation CharacteristicAuthor
CharcMaintAuthGrp
_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ANGCRERCLFN4'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@Consumption.filter.businessDate.at: true

@EndUserText.label: 'Recipe Equipment Requirement Characteristic Values'
define view A_RecProcEquipRqmtCharcValue 
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate:sydate
  as select from I_ClfnObjectCharcValForKeyDate( P_KeyDate: $parameters.P_KeyDate ) as Valuation
     join A_RecipeProcessEquipRqmt( P_KeyDate: $parameters.P_KeyDate ) as RecipeProcessEquipRqmt on
          Valuation.ClfnObjectID = bintohex( RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID )
  
    association [1..1] to A_RecipeProcessEquipRqmt as _RecipeProcessEquipRqmt on
      $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID
  {
    key RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID,
    key Valuation.ClassType,
    key Valuation.CharcInternalID,
    key Valuation.CharcValuePositionNumber,
          
    $parameters.P_KeyDate as KeyDate,
    Valuation.CharcValueDependency,
    Valuation.CharcValue,
    Valuation.CharcFromNumericValue,  
    Valuation.CharcFromNumericValueUnit,
    Valuation.CharcToNumericValue,     
    Valuation.CharcToNumericValueUnit,
    Valuation.CharcFromDecimalValue,
    Valuation.CharcToDecimalValue,
    @Semantics.amount.currencyCode: 'Currency'
    Valuation.CharcFromAmount,
    @Semantics.amount.currencyCode: 'Currency'
    Valuation.CharcToAmount,
    @Semantics.currencyCode: true
    Valuation.Currency,
    Valuation.CharcFromDate,
    Valuation.CharcToDate,
    Valuation.CharcFromTime,
    Valuation.CharcToTime, 
    Valuation.CharacteristicAuthor,
    _Characteristic(P_KeyDate: $parameters.P_KeyDate).CharcMaintAuthGrp,
    
    _RecipeProcessEquipRqmt
  }
    where
      ClfnObjectTable = '/PLMB/RPR_EQR' and 
      ClfnObjectType = 'O'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_RECIPEPROCESSEQUIPRQMT",
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_CLFNOBJECTCHARCVALFORKEYDATE"
],
"ASSOCIATED":
[
"A_RECIPEPROCESSEQUIPRQMT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More