A_ProcessOrderComponent_2

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_ProcessOrderComponent_2.
-- 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_ProcessOrderComponent_2 AS
SELECT
  Reservation,
  ReservationItem,
  RecordType AS ReservationRecordType,
  MaterialGroup,
  Material,
  Plant,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  cast(ManufacturingOrder as co_bid preserving type) AS ManufacturingOrder,
  ManufacturingOrderSequence,
  ManufacturingOrderOperation,
  ProductionPlant,
  OrderInternalBillOfOperations,
  MatlCompRequirementDate,
  MatlCompRequirementTime,
  MaterialIsDirectlyProduced,
  ReservationIsFinallyIssued,
  cast( MatlCompIsMarkedForDeletion as /plmb/lkenz preserving type ) AS MatlCompIsMarkedForDeletion,
  IsBulkMaterialComponent,
  MatlCompIsMarkedForBackflush,
  MaterialCompIsCostRelevant,
  RequirementType,
  WBSElementInternalID_2 AS WBSElementInternalID,
  _LongText.OrderComponentLongText AS OrderComponentLongText,
  SalesOrder,
  SalesOrderItem,
  SortField,
  MaterialComponentSortText,
  BillOfMaterialCategory,
  BOMItem,
  BOMItemCategory,
  BillOfMaterialItemNumber,
  BOMItemDescription,
  InheritedBOMItemNode,
  BillOfMaterialInternalID_2 AS BillOfMaterialInternalID,
  BOMItemInternalChangeCount,
  _BillOfMaterialItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  StorageLocation,
  Batch,
  GoodsMovementType,
  SupplyArea,
  GoodsRecipientName,
  UnloadingPointName,
  InventorySpecialStockType,
  MaterialStaging,
  MaterialCompIsAlternativeItem,
  AlternativeItemGroup,
  AlternativeItemStrategy,
  AlternativeItemPriority,
  UsageProbabilityPercent,
  MaterialComponentIsPhantomItem,
  OrderLevelValue,
  OrderPathValue,
  AssemblyOrderLevelValue,
  AssemblyOrderPathValue,
  MaterialProvisionType,
  LeadTimeOffset,
  QuantityIsFixed,
  IsNetScrap,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  BaseUnit,
  _BaseUnit.UnitOfMeasureISOCode AS BaseUnitISOCode,
  _BaseUnit.UnitOfMeasureSAPCode AS BaseUnitSAPCode,
  RequiredQuantity,
  WithdrawnQuantity,
  ConfirmedAvailableQuantity,
  MaterialCompOriginalQuantity,
  EntryUnit,
  _EntryUnit.UnitOfMeasureISOCode AS EntryUnitISOCode,
  _EntryUnit.UnitOfMeasureSAPCode AS EntryUnitSAPCode,
  GoodsMovementEntryQty,
  Currency,
  WithdrawnQuantityAmount,
  case I_MfgOrderOperationComponent._MfgOrder.LastChangeDate when '00000000' then concat(I_MfgOrderOperationComponent._MfgOrder.MfgOrderCreationDate, I_MfgOrderOperationComponent._MfgOrder.MfgOrderCreationTime) else concat(I_MfgOrderOperationComponent._MfgOrder.LastChangeDate, I_MfgOrderOperationComponent._MfgOrder.LastChangeTime) end as LastChangeDateTime AS LastChangeTimeendasLastChangeDateTime
FROM I_MfgOrderOperationComponent
LEFT OUTER JOIN E_ReservationDocumentItem AS _Extension ON Reservation = _Extension.Reservation AND ReservationItem = _Extension.ReservationItem AND ReservationRecordType = _Extension.RecordType  -- association [1..1]
;