C_MfgOpActyComponentVH

DDL: C_MFGOPACTYCOMPONENTVH SQL: CMFGOPACTYCOMPVH Type: view CONSUMPTION Package: MPE_EXEC_NON_CONFORMANCE
23 Fields 1 Data Sources 2 Associations

Components

C_MfgOpActyComponentVH is a Consumption CDS View that provides data about "Components" in SAP S/4HANA. It reads from 1 data source (P_MfgOpActyComponent) and exposes 23 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType. It has 2 associations to related views. Part of development package MPE_EXEC_NON_CONFORMANCE.

Data Sources (1)

SourceAliasJoin Type
P_MfgOpActyComponent MfgOpActyComponentVH from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[1..1] I_MatlCompAssembleControl _MatlCompAssembleControl $projection.MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMFGOPACTYCOMPVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Material view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Components view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_MfgOpActyComponent OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_MfgOpActyComponent OpActyNtwkElement Element Number
KEY Reservation P_MfgOpActyComponent Reservation Reservation
KEY ReservationItem P_MfgOpActyComponent ReservationItem Reservation Item
KEY RecordType P_MfgOpActyComponent RecordType Reservation Record Type
KEY AssemblyShopFloorItem P_MfgOpActyComponent AssemblyShopFloorItem
KEY Material P_MfgOpActyComponent Material Vehicle Model
KEY Plant P_MfgOpActyComponent Plant Valuation Area
SerialNumberProfile MatlPlntCompAssembleControl SerialNumberProfile SerialNoProfile
SerialNumberIsRqdForAssembly MatlPlntCompAssembleControl SerialNumberIsRqdForAssembly Serial Number Mgmt Rqt
IsBatchManagementRequired MatlPlntCompAssembleControl IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
MatlCompAssembleControl MatlPlntCompAssembleControl MatlCompAssembleControl
MatlCompInstceAssyIsRequired P_MfgOpActyComponent MatlCompInstceAssyIsRequired Instances Exist
BaseUnit P_MfgOpActyComponent BaseUnit Unit of Measure
EntryUnit P_MfgOpActyComponent EntryUnit Unit of Entry
MfgRefStructureItemDetailUUID P_MfgOpActyComponent MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_MfgOpActyComponent MfgRefStrucItmDetIsContextual
CompIsAssignedToOpActy
_MatlCompAssembleControl _MatlCompAssembleControl
_Material P_MfgOpActyComponent _Material
_OperationActivityInstance P_MfgOpActyComponent _OperationActivityInstance
_MaterialText _MaterialText
_OpActyNtwkInstance P_MfgOpActyComponent _OpActyNtwkInstance

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_MfgOpActyComponentVH.
-- 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.
-- SQL view name: CMFGOPACTYCOMPVH

CREATE VIEW C_MfgOpActyComponentVH AS
SELECT
  MfgOpActyComponentVH.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOpActyComponentVH.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOpActyComponentVH.Reservation AS Reservation,
  MfgOpActyComponentVH.ReservationItem AS ReservationItem,
  MfgOpActyComponentVH.RecordType AS RecordType,
  MfgOpActyComponentVH.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  MfgOpActyComponentVH.Material AS Material,
  MfgOpActyComponentVH.Plant AS Plant,
  MatlPlntCompAssembleControl.SerialNumberProfile AS SerialNumberProfile,
  MatlPlntCompAssembleControl.SerialNumberIsRqdForAssembly AS SerialNumberIsRqdForAssembly,
  MatlPlntCompAssembleControl.IsBatchManagementRequired AS IsBatchManagementRequired,
  MatlPlntCompAssembleControl.MatlCompAssembleControl AS MatlCompAssembleControl,
  MfgOpActyComponentVH.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  MfgOpActyComponentVH.BaseUnit AS BaseUnit,
  MfgOpActyComponentVH.EntryUnit AS EntryUnit,
  MfgOpActyComponentVH.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  MfgOpActyComponentVH.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  cast('X' as mpe_rtg_assigned_to_oa preserving type) AS CompIsAssignedToOpActy,
  MfgOpActyComponentVH._Material AS _Material,
  MfgOpActyComponentVH._OperationActivityInstance AS _OperationActivityInstance,
  MfgOpActyComponentVH._OpActyNtwkInstance AS _OpActyNtwkInstance
FROM P_MfgOpActyComponent AS MfgOpActyComponentVH
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MatlCompAssembleControl AS _MatlCompAssembleControl ON MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl  -- association [1..1]
;

Learn More