A_Recipe
Recipe Header Data
A_Recipe is a Consumption CDS View that provides data about "Recipe Header Data" in SAP S/4HANA. It reads from 1 data source (I_RecipeForKeyDateTP) and exposes 38 fields with key field RecipeUUID. It has 11 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_RecipeForKeyDateTP | I_RecipeForKeyDateTP | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_KeyDate | sydate |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | A_RecipeClass | _Classification | $projection.RecipeUUID = _Classification.RecipeUUID |
| [0..*] | A_RecipeCharc | _Characteristics | $projection.RecipeUUID = _Characteristics.RecipeUUID |
| [0..1] | A_LogAccMObjectTypeActive | _LogAccMObjectTypeActive | _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_RCP' |
| [0..*] | A_LogAccMObjSecureIDAssgmt | _LogAccMObjSecureIDAssgmt | $projection.RecipeUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID and _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_RCP' |
| [0..*] | A_LogAccMObjectUserAuthzn | _LogAccMObjectUserAuthzn | $projection.RecipeUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID and _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_RCP' and _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_RCP' and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' and ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user or _LogAccMObjectUserAuthzn.UserID = $session.user ) |
| [1..1] | E_Recipe | _Extension | $projection.RecipeUUID = _Extension.RecipeUUID |
| [0..*] | A_RecipeText | _RecipeText | |
| [1..*] | A_RecipeFormulaItem | _FormulaItem | |
| [0..*] | A_RecipeProcessElement | _RecipeProcessElement | |
| [0..*] | A_RecipeProcessEquipRqmt | _RecipeProcessEquipRqmt | |
| [0..*] | A_RecipeProcessParamValue | _RecipeProcessParamValue | |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ARECIPE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| VDM.viewType | #CONSUMPTION | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Consumption.filter.businessDate.at | true | view | |
| EndUserText.label | Recipe Header Data | view |
Fields (38)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | RecipeUUID | RecipeUUID | ||
| RecipeUniqueID | RecipeUniqueID | |||
| Recipe | Recipe | |||
| RecipePrimaryOutputInternalID | RecipePrimaryOutputInternalID | |||
| RecipePrimaryOutput | RecipePrimaryOutput | |||
| RecipeAlternativeNumber | RecipeAlternativeNumber | |||
| RecipeVersionNumber | RecipeVersionNumber | |||
| RecipeType | RecipeType | |||
| RecipePurpose | RecipePurpose | |||
| RecipeStatus | RecipeStatus | |||
| RecipeStatusSchema | RecipeStatusSchema | |||
| RecipeAuthorizationGroup | RecipeAuthorizationGroup | |||
| RcpFmlaUUID | RcpFmlaUUID | |||
| RecipeProcessUUID | RecipeProcessUUID | |||
| RecipeValidityStartDate | RecipeValidityStartDate | |||
| RecipeValidityEndDate | RecipeValidityEndDate | |||
| RecipeValidityMinQuantity | RecipeValidityMinQuantity | |||
| RecipeValidityMaxQuantity | RecipeValidityMaxQuantity | |||
| RecipeValidityUnit | RecipeValidityUnit | |||
| Plant | _Plant | Plant | ||
| RecipeCreatedByUser | RecipeCreatedByUser | |||
| RecipeLastChangedByUser | RecipeLastChangedByUser | |||
| RecipeCreationDateTime | RecipeCreationDateTime | |||
| RecipeLastChangeDateTime | RecipeLastChangeDateTime | |||
| RecipeIsDeleted | RecipeIsDeleted | |||
| RecipeIsArchived | RecipeIsArchived | |||
| RecipePrimOutpAuthznGrp | RecipePrimOutpAuthznGrp | |||
| RecipePrimOutpSpecType | RecipePrimOutpSpecType | |||
| _RecipeText | _RecipeText | |||
| _FormulaItem | _FormulaItem | |||
| _Classification | _Classification | |||
| _Characteristics | _Characteristics | |||
| _LogAccMObjectTypeActive | _LogAccMObjectTypeActive | |||
| _LogAccMObjectUserAuthzn | _LogAccMObjectUserAuthzn | |||
| _LogAccMObjSecureIDAssgmt | _LogAccMObjSecureIDAssgmt | |||
| _RecipeProcessElement | _RecipeProcessElement | |||
| _RecipeProcessEquipRqmt | _RecipeProcessEquipRqmt | |||
| _RecipeProcessParamValue | _RecipeProcessParamValue |
@AbapCatalog.sqlViewName: 'ARECIPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true
@Consumption.filter.businessDate.at: true
@EndUserText.label: 'Recipe Header Data'
define root view A_Recipe
with parameters
@Consumption.hidden: true
@Semantics.businessDate.at: true
P_KeyDate : sydate
as select from I_RecipeForKeyDateTP( P_KeyDate: $parameters.P_KeyDate )
composition [0..*] of A_RecipeText as _RecipeText
composition [1..*] of A_RecipeFormulaItem as _FormulaItem
// Classification integration
association [0..*] to A_RecipeClass as _Classification on $projection.RecipeUUID = _Classification.RecipeUUID
association [0..*] to A_RecipeCharc as _Characteristics on $projection.RecipeUUID = _Characteristics.RecipeUUID
// Access Control Management integration
association [0..1] to A_LogAccMObjectTypeActive as _LogAccMObjectTypeActive on _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_RCP'
association [0..*] to A_LogAccMObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on $projection.RecipeUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
and _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_RCP'
association [0..*] to A_LogAccMObjectUserAuthzn as _LogAccMObjectUserAuthzn on $projection.RecipeUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID
and _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_RCP'
and _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_RCP'
and (
_LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03'
or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*'
)
and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT'
and (
_LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user
or _LogAccMObjectUserAuthzn.UserID = $session.user
)
association [1..1] to E_Recipe as _Extension on $projection.RecipeUUID = _Extension.RecipeUUID
composition [0..*] of A_RecipeProcessElement as _RecipeProcessElement
composition [0..*] of A_RecipeProcessEquipRqmt as _RecipeProcessEquipRqmt
composition [0..*] of A_RecipeProcessParamValue as _RecipeProcessParamValue
{
@ObjectModel.text.association: '_RecipeText'
key RecipeUUID,
RecipeUniqueID,
Recipe,
RecipePrimaryOutputInternalID,
RecipePrimaryOutput,
RecipeAlternativeNumber,
RecipeVersionNumber,
RecipeType,
RecipePurpose,
RecipeStatus,
RecipeStatusSchema,
RecipeAuthorizationGroup,
RcpFmlaUUID,
RecipeProcessUUID,
RecipeValidityStartDate,
RecipeValidityEndDate,
@Semantics.quantity.unitOfMeasure: 'RecipeValidityUnit'
RecipeValidityMinQuantity,
@Semantics.quantity.unitOfMeasure: 'RecipeValidityUnit'
RecipeValidityMaxQuantity,
@Semantics.unitOfMeasure: true
RecipeValidityUnit,
_Plant.Plant,
RecipeCreatedByUser,
RecipeLastChangedByUser,
RecipeCreationDateTime,
RecipeLastChangeDateTime,
RecipeIsDeleted,
RecipeIsArchived,
RecipePrimOutpAuthznGrp,
RecipePrimOutpSpecType,
_RecipeText,
_FormulaItem,
_Classification,
_Characteristics,
_LogAccMObjectTypeActive,
_LogAccMObjectUserAuthzn,
_LogAccMObjSecureIDAssgmt,
_RecipeProcessElement,
_RecipeProcessEquipRqmt,
_RecipeProcessParamValue
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECIPEASSGDPLANT",
"I_RECIPEFORKEYDATETP"
],
"ASSOCIATED":
[
"A_LOGACCMOBJECTTYPEACTIVE",
"A_LOGACCMOBJECTUSERAUTHZN",
"A_LOGACCMOBJSECUREIDASSGMT",
"A_RECIPECHARC",
"A_RECIPECLASS",
"A_RECIPEFORMULAITEM",
"A_RECIPEPROCESSELEMENT",
"A_RECIPEPROCESSEQUIPRQMT",
"A_RECIPEPROCESSPARAMVALUE",
"A_RECIPETEXT",
"E_RECIPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA