I_GHOProdnAllocRsltsExpanded

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 I_GHOProdnAllocRsltsExpanded.
-- 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 I_GHOProdnAllocRsltsExpanded AS
SELECT
  AllocationRunID,
  _AllocatedTheo.GHOQuantityCategory AS GHOQuantityCategory,
  _AllocatedTheo.GHOQuantityType AS GHOQuantityType,
  _AllocatedTheo.EffectiveFromDateTime AS EffectiveFromDateTime,
  _AllocatedTheo.AllocationRuleUnitOfMsmt AS AllocationRuleUnitOfMsmt,
  GHONetworkID,
  NetworkMedium,
  ProductionAllocationType,
  AllocationFrequencyCode,
  ProductionAllocationDate,
  ProductionAllocationTime,
  cast(ProdnAllocUTCDteTme as gho_prodalloc_datetime preserving type ) AS ProdnAllocDateTime,
  _AllocatedTheo.GHOFromNtwkObjID AS GHOFromNtwkObjID,
  _AllocatedTheo.GHOToNtwkObjID AS GHOToNtwkObjID,
  cast(sum(_AllocatedTheo.AllocationRuleMsmtValue) as gho_quantity_in_dec) AS AllocationRuleMsmtValue,
  _AllocatedTheo.GHOComponent AS GHOComponent,
  _AllocatedTheo.WellCompltnVolDoc AS WellCompltnVolDoc,
  _AllocatedTheo.AllocationMaterial AS AllocationMaterial,
  _AllocatedTheo.ReclassifiedMaterial AS ReclassifiedMaterial,
  _AllocatedTheo.Transporter AS Transporter,
  _AllocatedTheo.TransporterReference AS TransporterReference,
  _AllocatedTheo.EffectiveToDateTime AS EffectiveToDateTime,
  _AllocatedTheo.ProductionHours AS ProductionHours,
  _AllocatedTheo.TicketNumber AS TicketNumber,
  _AllocatedTheo.TicketDateTime AS TicketDateTime,
  _AllocatedTheo.InventoryDate AS InventoryDate,
  _AllocatedTheo.LoadOilTransferWithoutRecovery AS LoadOilTransferWithoutRecovery,
  _AllocatedTheo.GHOOriginatingMsmtPoint AS GHOOriginatingMsmtPoint,
  _AllocatedTheo.AllocRsltsThrtclOrActual AS AllocRsltsThrtclOrActual,
  _AllocatedTheo._NetworkObjectDetails AS _NetworkObjectDetails,
  _AllocatedTheo._NtwkAllocRuleQtyType AS _NtwkAllocRuleQtyType,
  _AllocatedTheo._QuantityCategory AS _QuantityCategory
FROM I_GHOProdnAllocationResults
;