A_PlannedOrder

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_PlannedOrder.
-- 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: APLNDORD

CREATE VIEW A_PlannedOrder AS
SELECT
  PlannedOrder,
  I_PlannedOrder.PlannedOrderType AS PlannedOrderType,
  P_PlannedOrderProfileGet.PlannedOrderProfile AS PlannedOrderProfile,
  Material,
  _Material._Text[1: Language = 'E'].MaterialName AS MaterialName,
  ProductionPlant,
  MRPPlant,
  MRPArea,
  ProductionVersion,
  I_PlannedOrder.MaterialProcurementCategory AS MaterialProcurementCategory,
  I_PlannedOrder.MaterialProcurementType AS MaterialProcurementType,
  StorageLocation,
  BaseUnit,
  PlannedTotalQtyInBaseUnit AS TotalQuantity,
  PlannedScrapQtyInBaseUnit AS PlndOrderPlannedScrapQty,
  GoodsReceiptQtyInBaseUnit AS GoodsReceiptQty,
  QuantityWithdrawnInBaseUnit AS IssuedQuantity,
  PlndOrderPlannedStartDate,
  PlndOrderPlannedStartTime,
  PlndOrderPlannedEndDate,
  PlndOrderPlannedEndTime,
  PlannedOrderOpeningDate,
  LastChangeDateTime,
  ProductionStartDate,
  ProductionEndDate,
  SalesOrder,
  SalesOrderItem,
  Customer,
  WBSElementInternalID,
  cast( _WBSElement.WBSElement as rcpe_ps_posnr preserving type ) AS WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  I_PlannedOrder.AccountAssignmentCategory AS AccountAssignmentCategory,
  Reservation,
  MRPController,
  ProductionSupervisor,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  PurchasingOrganization,
  FixedSupplier,
  PurchasingDocument,
  PurchasingDocumentItem,
  QuotaArrangement,
  QuotaArrangementItem,
  _Supplier.SupplierName AS SupplierName,
  PlannedOrderIsFirm,
  PlannedOrderIsConvertible,
  PlannedOrderBOMIsFixed,
  PlannedOrderCapacityIsDsptchd,
  CapacityRequirement,
  _CapacityRequirement.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  _CapacityRequirement.BillOfOperationsType AS BillOfOperationsType,
  _CapacityRequirement.BillOfOperationsGroup AS BillOfOperationsGroup,
  _CapacityRequirement.BillOfOperations AS BillOfOperations,
  _CapacityRequirement.LastScheduledDate AS LastScheduledDate,
  _CapacityRequirement.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _CapacityRequirement.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  _CapacityRequirement.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _CapacityRequirement.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  _CapacityRequirement.SchedulingType AS SchedulingType
FROM I_PlannedOrder
LEFT OUTER JOIN A_PlannedOrderComponent AS _PlannedOrderComponent ON PlannedOrder = _PlannedOrderComponent.PlannedOrder  -- association [0..*]
LEFT OUTER JOIN A_PlannedOrderCapacity AS _PlannedOrderCapacity ON PlannedOrder = _PlannedOrderCapacity.PlannedOrder  -- association [0..*]
LEFT OUTER JOIN E_PlannedOrder AS _Extension ON PlannedOrder = _Extension.PlannedOrder  -- association [1..1]
;