C_SlsOrdProdnModOpActivityTP

DDL: C_SLSORDPRODNMODOPACTIVITYTP Type: view_entity CONSUMPTION
42 Fields 1 Data Sources 1 Associations

Operation Activity

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

Data Sources (1)

SourceAliasJoin Type
R_ProdnModOperationActivityTP R_ProdnModOperationActivityTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ProdnModOAInstcAggrgd _ProdnModOAInstcAggrgd $projection.ProductionModelUUID = _ProdnModOAInstcAggrgd.ProductionModelUUID and $projection.BillOfOperationsVersion = _ProdnModOAInstcAggrgd.BillOfOperationsVersion and $projection.BOOOperationInternalID = _ProdnModOAInstcAggrgd.BOOOperationInternalID and $projection.OperationActivity = _ProdnModOAInstcAggrgd.OperationActivity and $projection.OperationActyVersionCounter = _ProdnModOAInstcAggrgd.OperationActyVersionCounter

Annotations (10)

NameValueLevelField
EndUserText.label Operation Activity view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
UI.deleteHidden true view
UI.headerInfo.typeNamePlural Operation Activity view
UI.headerInfo.title.value OperationActivityName view

Fields (42)

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
ProdnModOpDraftInternalID ProdnModOpDraftInternalID Node
OpActivityDraftInternalUUID OpActivityDraftInternalUUID
BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
BillOfMaterialCategory BillOfMaterialCategory BOM category
Material Material Vehicle Model
Plant Plant Valuation Area
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterial BillOfMaterial BOM
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
OpActyNtwkElementExternalID OpActyNtwkElementExternalID Op. Activity
OperationActivityName OperationActivityName
OpActyNtwkSegmentType OpActyNtwkSegmentType Segment Type
OpActyNtwkSegmentTypeText _OpActyNtwkSegmentTypeText OpActyNtwkSegmentTypeText
OperationActStsAndActnSchema OperationActStsAndActnSchema
StatusAndActionSchemaName _SASSchemaText StatusAndActionSchemaName
SFIStatusAndActionSchema SFIStatusAndActionSchema
SFIStatusAndActionSchemaName _SFISchemaText StatusAndActionSchemaName
OpActyInspectionRelevance OpActyInspectionRelevance
AssemblySqncCheckIsRequired AssemblySqncCheckIsRequired
OperationActivityNetworkGroup OperationActivityNetworkGroup
OpActyNtwkGroupVersionCounter OpActyNtwkGroupVersionCounter
OpActyNtwkGroupExternalID OpActyNtwkGroupExternalID OA Group
OpActyNtwkGroupType OpActyNtwkGroupType
OpActyNtwkGroupTypeText _BOOOpActyGrpTypeText OpActyNtwkGroupTypeText Group Type
OpActyNtwkGroupName _GroupText OpActyNtwkGroupName
OpActyNtwkElement OpActyNtwkElement Network Element
BillOfOperationsSequence BillOfOperationsSequence Sequence
OANElementDisplaySqncNumber OANElementDisplaySqncNumber Display Sequence
ShopFloorRoutingTemplateType ShopFloorRoutingTemplateType Template Type
ShopFloorRtgTemplateGroup ShopFloorRtgTemplateGroup Template Group
ShopFloorRtgTemplateGrpVariant ShopFloorRtgTemplateGrpVariant Group Counter
ShopFloorRtgTemplateVersion ShopFloorRtgTemplateVersion Template Versn
OpActyGroupDraftInternalUUID OpActyGroupDraftInternalUUID
_ProdnModOAInstcAggrgd _ProdnModOAInstcAggrgd

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 C_SlsOrdProdnModOpActivityTP.
-- 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 C_SlsOrdProdnModOpActivityTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  BOOOperationInternalID,
  OperationActivity,
  OperationActyVersionCounter,
  ProdnModOpDraftInternalID,
  OpActivityDraftInternalUUID,
  BOOOpInternalVersionCounter,
  BillOfMaterialCategory,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  OpActyNtwkElementExternalID,
  OperationActivityName,
  OpActyNtwkSegmentType,
  _OpActyNtwkSegmentTypeText.OpActyNtwkSegmentTypeText AS OpActyNtwkSegmentTypeText,
  OperationActStsAndActnSchema,
  _SASSchemaText.StatusAndActionSchemaName AS StatusAndActionSchemaName,
  SFIStatusAndActionSchema,
  _SFISchemaText.StatusAndActionSchemaName AS SFIStatusAndActionSchemaName,
  OpActyInspectionRelevance,
  AssemblySqncCheckIsRequired,
  OperationActivityNetworkGroup,
  OpActyNtwkGroupVersionCounter,
  OpActyNtwkGroupExternalID,
  OpActyNtwkGroupType,
  _BOOOpActyGrpTypeText.OpActyNtwkGroupTypeText AS OpActyNtwkGroupTypeText,
  _GroupText.OpActyNtwkGroupName AS OpActyNtwkGroupName,
  OpActyNtwkElement,
  BillOfOperationsSequence,
  OANElementDisplaySqncNumber,
  ShopFloorRoutingTemplateType,
  ShopFloorRtgTemplateGroup,
  ShopFloorRtgTemplateGrpVariant,
  ShopFloorRtgTemplateVersion,
  OpActyGroupDraftInternalUUID
FROM R_ProdnModOperationActivityTP
LEFT OUTER JOIN C_ProdnModOAInstcAggrgd AS _ProdnModOAInstcAggrgd ON ProductionModelUUID = _ProdnModOAInstcAggrgd.ProductionModelUUID AND BillOfOperationsVersion = _ProdnModOAInstcAggrgd.BillOfOperationsVersion AND BOOOperationInternalID = _ProdnModOAInstcAggrgd.BOOOperationInternalID AND OperationActivity = _ProdnModOAInstcAggrgd.OperationActivity AND OperationActyVersionCounter = _ProdnModOAInstcAggrgd.OperationActyVersionCounter  -- association [0..*]
;

Learn More