C_GHONetworkMasterDetail

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_GHONetworkMasterDetail.
-- 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 C_GHONetworkMasterDetail AS
SELECT
  AllocationRunID,
  GHONetworkID,
  cast( _NetworkVarblData.MeasuringGroupID as gho_measurement_group preserving type ) AS MeasuringGroupID,
  cast(_DefermentAnalysis.DefermentSystemCapacity as gho_deferment_system_capacity preserving type ) AS DefermentSystemCapacity,
  cast(_DefermentAnalysis.DefermentAllocationQty as gho_deferment_event_allocation preserving type ) AS DefermentAllocationQty,
  cast(_DefermentAnalysis.DefermentQty as gho_deferment_qty preserving type ) AS DefermentQty,
  cast(_ProductionNetworkDetails.NetworkToBeAllocated as gho_network_to_be_allocated preserving type ) AS NetworkIsAllocated,
  _ProductionNetworkDetails.Operator AS Operator,
  cast(AllocationRuleUnitOfMsmt as gho_master_unit_of_measure preserving type ) AS AllocationRuleUnitOfMsmt,
  cast(AllocConversionGroup as gho_conversion_grp preserving type ) AS AllocConversionGroup,
  cast( AllocUnitOfMsmtGroup as gho_alloc_uom_group preserving type ) AS AllocUnitOfMsmtGroup,
  NetworkMedium,
  ProductionAllocationType,
  AllocationFrequencyCode,
  ProductionAllocationDate,
  cast(tstmp_to_dats(ProdnAllocDateTime, _ProductionNetworkDetails.NetworkTimeZone, $session.client, 'NULL') as gho_production_date preserving type ) AS ProductionDate,
  ProductionAllocationTime,
  cast(tstmp_to_tims(ProdnAllocDateTime, _ProductionNetworkDetails.NetworkTimeZone, $session.client, 'NULL') as gho_production_time preserving type ) AS UpstreamProductionTime,
  ProdnAllocDateTime,
  cast(_ProductionNetworkDetails._OperatorText[Language = $session.system_language ].TransporterName as gho_pe_operator_name ) AS OperatorName,
  cast( _LastChangedByUser.UserDescription as gho_last_changed_by preserving type ) AS UserDescription,
  LastChangedByUser,
  cast(_AllocationRunVersion.NumberOfAllocationResults as gho_result_version ) AS Version
FROM I_GHONetworkMasterDetail
;