R_ProdnModOperationActivityTP

DDL: R_PRODNMODOPERATIONACTIVITYTP Type: view_entity TRANSACTIONAL
50 Fields 1 Data Sources 1 Associations

Production Model Operation Activity

R_ProdnModOperationActivityTP is a Transactional CDS View that provides data about "Production Model Operation Activity" in SAP S/4HANA. It reads from 1 data source (I_ProdnModOperationActivity) and exposes 50 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BOOOperationInternalID, OperationActivity, OperationActyVersionCounter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdnModOperationActivity I_ProdnModOperationActivity from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_ProdnModOpActyComponentTP _OperationActivityComponent

Annotations (7)

NameValueLevelField
EndUserText.label Production Model Operation Activity view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion BillOfOperationsVersion Routing Version
KEY BOOOperationInternalID BOOOperationInternalID Task list node
KEY OperationActivity OperationActivity Operation Activity
KEY OperationActyVersionCounter OperationActyVersionCounter OA Version
BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
Plant Plant Valuation Area
BillOfOperationsType BillOfOperationsType Task List Type
OpActyNtwkElementExternalID OpActyNtwkElementExternalID Op. Activity
OperationActivityName OperationActivityName
OperationExternalID OperationExternalID Ext. Oper. ID
Operation Operation Transaction
OperationText OperationText Description
OpActyNtwkSegmentType OpActyNtwkSegmentType
LongTextLanguageCode LongTextLanguageCode Language
OperationControlProfile OperationControlProfile Control Key
OperationActStsAndActnSchema OperationActStsAndActnSchema
SFIStatusAndActionSchema SFIStatusAndActionSchema
AssemblySqncCheckIsRequired AssemblySqncCheckIsRequired
OperationActivityNetworkGroup OperationActivityNetworkGroup
OpActyNtwkGroupVersionCounter OpActyNtwkGroupVersionCounter
OpActyNtwkGroupExternalID OpActyNtwkGroupExternalID
OpActyNtwkGroupType OpActyNtwkGroupType
OpActyNtwkGroupParentElement OpActyNtwkGroupParentElement
IsReleased IsReleased
OpActyInspectionRelevance OpActyInspectionRelevance
OriginalChgAlertCount OriginalChgAlertCount
OpActyNtwkElement OpActyNtwkElement Element Number
OANElementDisplaySqncNumber OANElementDisplaySqncNumber
PrdcssrOpActyNtwkElmnt
PrdcssrOpActyDrftUUID
ProdnModOpActySqncIsAffcd
ShopFloorRoutingTemplateType ShopFloorRoutingTemplateType Template Type
ShopFloorRtgTemplateGroup ShopFloorRtgTemplateGroup Template Group
ShopFloorRtgTemplateGrpVariant ShopFloorRtgTemplateGrpVariant Group Counter
ShopFloorRtgTemplateVersion ShopFloorRtgTemplateVersion Template Versn
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
ChangedBy ChangedBy User Name
LastChangeDateTime LastChangeDateTime Timestamp
_Operation _Operation
_OpActyNtwkSegmentTypeText _OpActyNtwkSegmentTypeText
_ProductionModel _ProductionModel
_SASSchemaText _SASSchemaText
_SFISchemaText _SFISchemaText
_BOOOpActyGrpTypeText _BOOOpActyGrpTypeText
_GroupText _GroupText
_OperationActivityComponent _OperationActivityComponent

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 R_ProdnModOperationActivityTP.
-- 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 R_ProdnModOperationActivityTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  BOOOperationInternalID,
  OperationActivity,
  OperationActyVersionCounter,
  BOOOpInternalVersionCounter,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  Plant,
  BillOfOperationsType,
  OpActyNtwkElementExternalID,
  OperationActivityName,
  OperationExternalID,
  Operation,
  OperationText,
  OpActyNtwkSegmentType,
  LongTextLanguageCode,
  OperationControlProfile,
  OperationActStsAndActnSchema,
  SFIStatusAndActionSchema,
  AssemblySqncCheckIsRequired,
  OperationActivityNetworkGroup,
  OpActyNtwkGroupVersionCounter,
  OpActyNtwkGroupExternalID,
  OpActyNtwkGroupType,
  OpActyNtwkGroupParentElement,
  IsReleased,
  OpActyInspectionRelevance,
  OriginalChgAlertCount,
  OpActyNtwkElement,
  OANElementDisplaySqncNumber,
  cast ( '0' as mpe_oan_element_number ) AS PrdcssrOpActyNtwkElmnt,
  hextobin('00000000000000000000000000000000') AS PrdcssrOpActyDrftUUID,
  ' ' AS ProdnModOpActySqncIsAffcd,
  ShopFloorRoutingTemplateType,
  ShopFloorRtgTemplateGroup,
  ShopFloorRtgTemplateGrpVariant,
  ShopFloorRtgTemplateVersion,
  CreatedByUser,
  CreationDateTime,
  ChangedBy,
  LastChangeDateTime
FROM I_ProdnModOperationActivity
LEFT OUTER JOIN R_ProdnModOpActyComponentTP AS _OperationActivityComponent ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More