A_MasterRecipePhseSecdryRsce

DDL: A_MASTERRECIPEPHSESECDRYRSCE Type: view_entity CONSUMPTION
70 Fields 1 Data Sources

Phase Secondary Resource

A_MasterRecipePhseSecdryRsce is a Consumption CDS View that provides data about "Phase Secondary Resource" in SAP S/4HANA. It reads from 1 data source (I_MasterRecipePhseSecdryRsceTP) and exposes 70 fields with key fields MasterRecipeGroup, MasterRecipe, MasterRecipeOperationIntID, MstrRcpOperationIntVersion.

Data Sources (1)

SourceAliasJoin Type
I_MasterRecipePhseSecdryRsceTP I_MasterRecipePhseSecdryRsceTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Phase Secondary Resource view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY MasterRecipeGroup MasterRecipeGroup Group
KEY MasterRecipe MasterRecipe Group Counter
KEY MasterRecipeOperationIntID MasterRecipeSecdryRsceIntID Task list node
KEY MstrRcpOperationIntVersion MstrRcpPhseSecdryRsceIntVers Counter
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
Operation SecondaryResource Transaction
OperationText SecondaryResourceText Description
LongTextLanguageCode LongTextLanguageCode Language
PlainLongText PlainLongText Long Text
Plant Plant Valuation Area
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
OperationControlProfile OperationControlProfile Control Key
OperationStandardTextCode OperationStandardTextCode Std Text Key
OperationReferenceQuantity OperationReferenceQuantity Base Quantity
OperationUnit OperationUnit Act/op UoM
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr
StandardWorkQuantity1 StandardWorkQuantity1 Standard Value
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 Std value unit
CostCtrActivityType1 CostCtrActivityType1 Activity Type
StandardWorkQuantity2 StandardWorkQuantity2 Standard Value
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 Std value unit
CostCtrActivityType2 CostCtrActivityType2 Activity Type
StandardWorkQuantity3 StandardWorkQuantity3 Standard Value
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 Std value unit
CostCtrActivityType3 CostCtrActivityType3 Activity Type
StandardWorkQuantity4 StandardWorkQuantity4 Standard Value
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 Std value unit
CostCtrActivityType4 CostCtrActivityType4 Activity Type
StandardWorkQuantity5 StandardWorkQuantity5 Standard Value
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 Std value unit
CostCtrActivityType5 CostCtrActivityType5 Activity Type
StandardWorkQuantity6 StandardWorkQuantity6 Standard Value
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 Std value unit
CostCtrActivityType6 CostCtrActivityType6 Activity Type
OperationCostingRelevancyType OperationCostingRelevancyType Operation Costing Relevancy Type
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
NumberOfConfirmationSlips NumberOfConfirmationSlips No. of Conf. Slips
EmployeeWageGroup EmployeeWageGroup Wage Group
EmployeeWageType EmployeeWageType Wage type
EmployeeSuitability EmployeeSuitability
NumberOfEmployees NumberOfEmployees No. employees
BusinessProcess BusinessProcess Business Process
OpIsExtlyProcdWithSubcontrg OpIsExtlyProcdWithSubcontrg
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
PurchasingInfoRecdAddlGrpgName PurchasingInfoRecdAddlGrpgName Sort Term
MaterialGroup MaterialGroup Product Group
PurchasingGroup PurchasingGroup Purchasing Group
Supplier Supplier Supplier
PlannedDeliveryDuration PlannedDeliveryDuration Pl. Deliv. Time
NumberOfOperationPriceUnits NumberOfOperationPriceUnits Price Unit
OpExternalProcessingPrice OpExternalProcessingPrice Price
OpExternalProcessingCurrency OpExternalProcessingCurrency Currency
InspectionLotType InspectionLotType Inspection Type
CostElement CostElement G/L Account
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ChangeNumber ChangeNumber Change Number
ChangedDateTime ChangedDateTime Time Stamp
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_Header _Header

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_MasterRecipePhseSecdryRsce.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_MasterRecipePhseSecdryRsce AS
SELECT
  MasterRecipeGroup,
  MasterRecipe,
  MasterRecipeSecdryRsceIntID AS MasterRecipeOperationIntID,
  MstrRcpPhseSecdryRsceIntVers AS MstrRcpOperationIntVersion,
  SuperiorOperationInternalID,
  SecondaryResource AS Operation,
  SecondaryResourceText AS OperationText,
  LongTextLanguageCode,
  PlainLongText,
  Plant,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  OperationControlProfile,
  OperationStandardTextCode,
  OperationReferenceQuantity,
  OperationUnit,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  CostCtrActivityType1,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  CostCtrActivityType2,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  CostCtrActivityType3,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  CostCtrActivityType4,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  CostCtrActivityType5,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  CostCtrActivityType6,
  OperationCostingRelevancyType,
  NumberOfTimeTickets,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  EmployeeSuitability,
  NumberOfEmployees,
  BusinessProcess,
  OpIsExtlyProcdWithSubcontrg,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingPrice,
  OpExternalProcessingCurrency,
  InspectionLotType,
  CostElement,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  ChangedDateTime
FROM I_MasterRecipePhseSecdryRsceTP
;

Learn More