I_GHOPriorPeriodNotification

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_GHOPriorPeriodNotification.
-- 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_GHOPriorPeriodNotification AS
SELECT
  ppa_req_id AS PriorPeriodNotifReqUUID,
  data_guid AS PriorPeriodNotifUUID,
  process_type AS PriorPeriodNotifTypeOfData,
  cast (netid as tplnr_unconverted preserving type ) AS GHONetworkID,
  requester AS PriorPeriodNotifRequestedBy,
  approver AS PriorPeriodNotifApprovedBy,
  ppa_req_status AS PriorPeriodNotifRequestStatus,
  ppa_req_reason AS PriorPeriodNotifRequestReason,
  audit_reaon_code AS PriorPeriodNotifAudRsnCode,
  cast( planchngnr as gho_de_plan_document preserving type ) AS PlanChangeDocumentNumber,
  cdoc_num AS ChangeDocument,
  created_on AS PriorPeriodNotifCreatedDate,
  created_tst AS PriorPeriodNotifCreatedTime,
  medium AS NetworkMedium,
  frequency AS AllocationFrequencyCode,
  cast( case action when 'I' then 'C' else action end as gho_dm_action_type preserving type ) AS PriorPeriodNotifActionType,
  processed_on AS PriorPeriodNotifChangedDate,
  processed_at AS PriorPeriodNotifChangedTime,
  processor_comment AS PriorPeriodNotifChgReasonText,
  cast (net_obj_id as tplnr_unconverted preserving type ) AS GHONetworkObjectID,
  cast(case _FavoriteNetwork.UserID when $session.user then 'Y' else 'N' end as gho_network_is_favorite preserving type ) AS ProductionNetworkIsFavorite
FROM gho_ppa_request
LEFT OUTER JOIN I_GhoMediumText AS _MediumText ON NetworkMedium = _MediumText.NetworkMedium AND _MediumText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GhoFreqText AS _FrequencyText ON AllocationFrequencyCode = _FrequencyText.AllocationFrequencyCode AND _FrequencyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHOAuditReasonCodeText AS _PPNReasonCodeDesc ON PriorPeriodNotifAudRsnCode = _PPNReasonCodeDesc.AuditObjectValue AND _PPNReasonCodeDesc.AuditType = '95' AND _PPNReasonCodeDesc.LanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ReadDomainFixedValues AS _ProcessTypeDesc ON _ProcessTypeDesc.SAPDataDictionaryDomain = 'GHO_D_TYPE' AND PriorPeriodNotifTypeOfData = _ProcessTypeDesc.DomainValue AND _ProcessTypeDesc.LanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ReadDomainFixedValues AS _RequestStatusDesc ON _RequestStatusDesc.SAPDataDictionaryDomain = 'GHO_D_PPA_REQ_STAT' AND PriorPeriodNotifRequestStatus = _RequestStatusDesc.DomainValue AND _RequestStatusDesc.LanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ReadDomainFixedValues AS _ActionDesc ON _ActionDesc.SAPDataDictionaryDomain = 'GHO_DM_ACTION_TYPE' AND PriorPeriodNotifActionType = _ActionDesc.DomainValue AND _ActionDesc.LanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHOUserName AS _RequestorFullName ON PriorPeriodNotifRequestedBy = _RequestorFullName.UserID  -- association [0..1]
LEFT OUTER JOIN I_GHOUserName AS _ApproverFullName ON PriorPeriodNotifApprovedBy = _ApproverFullName.UserID  -- association [0..1]
LEFT OUTER JOIN I_SrvProInfUserSpecificData AS _FavoriteNetwork ON GHONetworkID = _FavoriteNetwork.SrvProInfObject AND _FavoriteNetwork.SrvProInfObjectType = 'GHO_NET' AND _FavoriteNetwork.PersonalAreaType = '03' AND _FavoriteNetwork.UserID = $session.user  -- association [0..1]
LEFT OUTER JOIN I_GHOProdnNtwkDetails AS _ProdnNtwkDetails ON GHONetworkID = _ProdnNtwkDetails.GHONetworkID  -- association [1..1]
LEFT OUTER JOIN I_GHONtwkObjects AS _NtwkObjDetails ON GHONetworkObjectID = _NtwkObjDetails.GHONetworkObjectID  -- association [0..1]
LEFT OUTER JOIN I_ReadDomainFixedValues AS _FavoriteText ON _FavoriteText.SAPDataDictionaryDomain = 'GHO_NETWORK_IS_FAVORITE' AND ProductionNetworkIsFavorite = _FavoriteText.DomainValue AND _FavoriteText.LanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHONetworkObjectLabel AS _NetworkObjectLabel ON _NetworkObjectLabel.GHONetworkObjectID = GHONetworkID AND _NetworkObjectLabel.NetworkObjectType = 'GHO_PN'  -- association [0..1]
;