P_MfgOrderCompAssyWthoutInstce

DDL: P_MFGORDERCOMPASSYWTHOUTINSTCE SQL: PMPECOMPASMAGGNI Type: view COMPOSITE
24 Fields 1 Data Sources 1 Associations

P_MfgOrderCompAssyWthoutInstce is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MfgOrderComponentAssembly) and exposes 24 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderComponentAssembly MfgOrderComponentAssembly from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _MaterialBaseUnit $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPECOMPASMAGGNI view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_MfgOrderComponentAssembly Reservation Reservation
KEY ReservationItem I_MfgOrderComponentAssembly ReservationItem Reservation Item
KEY RecordType I_MfgOrderComponentAssembly RecordType Reservation Record Type
KEY OpActyNtwkInstance I_MfgOrderComponentAssembly OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_MfgOrderComponentAssembly OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem I_MfgOrderComponentAssembly AssemblyShopFloorItem Parent SFI ID
KEY ShopFloorItem I_MfgOrderComponentAssembly ShopFloorItem Serial.Mat. ID
KEY Batch I_MfgOrderComponentAssembly Batch Lot No.
KEY Material I_MfgOrderComponentAssembly Material Vehicle Model
KEY Plant I_MfgOrderComponentAssembly Plant Valuation Area
DebitCreditCode I_MfgOrderComponentAssembly DebitCreditCode Single-Character Flag
MaterialComponentQuantity
MaterialBaseUnit
QuantityInEntryUnit
EntryUnit
_OpActyNtwkInstance I_MfgOrderComponentAssembly _OpActyNtwkInstance
_OperationActivityInstance I_MfgOrderComponentAssembly _OperationActivityInstance
_ShopFloorItem I_MfgOrderComponentAssembly _ShopFloorItem
_ParentShopFloorItem I_MfgOrderComponentAssembly _ParentShopFloorItem
_BatchDistinct I_MfgOrderComponentAssembly _BatchDistinct
_Material I_MfgOrderComponentAssembly _Material
_Plant I_MfgOrderComponentAssembly _Plant
_Reservation I_MfgOrderComponentAssembly _Reservation
_MaterialBaseUnit _MaterialBaseUnit

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 P_MfgOrderCompAssyWthoutInstce.
-- 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: PMPECOMPASMAGGNI

CREATE VIEW P_MfgOrderCompAssyWthoutInstce AS
SELECT
  MfgOrderComponentAssembly.Reservation AS Reservation,
  MfgOrderComponentAssembly.ReservationItem AS ReservationItem,
  MfgOrderComponentAssembly.RecordType AS RecordType,
  MfgOrderComponentAssembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderComponentAssembly.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOrderComponentAssembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  MfgOrderComponentAssembly.ShopFloorItem AS ShopFloorItem,
  MfgOrderComponentAssembly.Batch AS Batch,
  MfgOrderComponentAssembly.Material AS Material,
  MfgOrderComponentAssembly.Plant AS Plant,
  MfgOrderComponentAssembly.DebitCreditCode AS DebitCreditCode,
  cast(sum(MfgOrderComponentAssembly.MaterialComponentQuantity) as kmpmg preserving type) AS MaterialComponentQuantity,
  cast(max(MfgOrderComponentAssembly.MaterialBaseUnit) as meins preserving type) AS MaterialBaseUnit,
  cast(sum(MfgOrderComponentAssembly.QuantityInEntryUnit) as erfmgv preserving type) AS QuantityInEntryUnit,
  cast(max(MfgOrderComponentAssembly.EntryUnit) as erfme preserving type) AS EntryUnit,
  MfgOrderComponentAssembly._OpActyNtwkInstance AS _OpActyNtwkInstance,
  MfgOrderComponentAssembly._OperationActivityInstance AS _OperationActivityInstance,
  MfgOrderComponentAssembly._ShopFloorItem AS _ShopFloorItem,
  MfgOrderComponentAssembly._ParentShopFloorItem AS _ParentShopFloorItem,
  MfgOrderComponentAssembly._BatchDistinct AS _BatchDistinct,
  MfgOrderComponentAssembly._Material AS _Material,
  MfgOrderComponentAssembly._Plant AS _Plant,
  MfgOrderComponentAssembly._Reservation AS _Reservation
FROM I_MfgOrderComponentAssembly AS MfgOrderComponentAssembly
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialBaseUnit ON MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure  -- association [0..1]
;

Learn More