I_GHOProdnPeriodStartEndDate

DDL: I_GHOPRODNPERIODSTARTENDDATE Type: view_entity COMPOSITE
8 Fields 1 Data Sources 3 Associations

Production Period Start and End Date

I_GHOProdnPeriodStartEndDate is a Composite CDS View that provides data about "Production Period Start and End Date" in SAP S/4HANA. It reads from 1 data source (I_GhoAllocResH_Db) and exposes 8 fields with key field AllocationRunID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_GhoAllocResH_Db I_GhoAllocResH_Db from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_GHOFunctionalLocation _FunctionalLocation _FunctionalLocation.FunctionalLocation = $projection.GHONetworkID
[1..1] I_GHOFrequency _FrequencyDetails $projection.AllocationFrequencyCode = _FrequencyDetails.AllocationFrequencyCode
[0..1] I_GHOIsBusinessFunctionActive _ActiveSwitch _ActiveSwitch.BusinessFunction = 'OIL_UPO_INTEGRATION_1'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Production Period Start and End Date view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AllocationRunID AllocationRunID Allocation Run ID
GHONetworkID GHONetworkID Netw Object ID
AllocationFrequencyCode AllocationFrequencyCode Frequency ID
NetworkMedium NetworkMedium Medium ID
ProdnAllocUTCDteTme ProdnAllocUTCDteTme Production UTC Date Time
ProductionAllocationDate ProductionAllocationDate Prod. Start Dt
ProductionAllocationTime ProductionAllocationTime Prod St Tme
NetworkTimeZone _FunctionalLocation NetworkTimeZone

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_GHOProdnPeriodStartEndDate.
-- 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_GHOProdnPeriodStartEndDate AS
SELECT
  AllocationRunID,
  GHONetworkID,
  AllocationFrequencyCode,
  NetworkMedium,
  ProdnAllocUTCDteTme,
  ProductionAllocationDate,
  ProductionAllocationTime,
  _FunctionalLocation.NetworkTimeZone AS NetworkTimeZone
FROM I_GhoAllocResH_Db
LEFT OUTER JOIN I_GHOFunctionalLocation AS _FunctionalLocation ON _FunctionalLocation.FunctionalLocation = GHONetworkID  -- association [1..1]
LEFT OUTER JOIN I_GHOFrequency AS _FrequencyDetails ON AllocationFrequencyCode = _FrequencyDetails.AllocationFrequencyCode  -- association [1..1]
LEFT OUTER JOIN I_GHOIsBusinessFunctionActive AS _ActiveSwitch ON _ActiveSwitch.BusinessFunction = 'OIL_UPO_INTEGRATION_1'  -- association [0..1]
;

Learn More