R_EvtBsdPostingRuleReceiverVH

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 R_EvtBsdPostingRuleReceiverVH.
-- 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: REBPSTRLRCVRVH

CREATE VIEW R_EvtBsdPostingRuleReceiverVH AS
SELECT
  cast(Material as fco_ebpr_receiver) AS EvtBsdPostingRuleReceiver,
  cast('MA' as fco_ebpr_receiver_catg) AS PartnerControllingObjectType,
  cast('000000000000' as aufnr) AS OrderID,
  cast('' as kokrs) AS ControllingArea,
  cast(I_MaterialStdVH._Text[1: Language = $session.system_language ].MaterialName as fco_ebpr_receiver_txt) AS EvtBsdPostingRuleReceiverText,
  cast('' as bukrs) AS CompanyCode,
  AuthorizationGroup,
  MaterialGroup,
  MaterialType,
  cast('' as aufart) AS OrderType,
  cast('' as pph_autyp) AS OrderCategory,
  cast('' as pwwrk ) AS ProductionPlant,
  cast('' as co_dispo) AS MRPController,
  cast('' as kostl) AS CostCenter,
  cast('' as prctr) AS ProfitCenter,
  cast('' as ps_prart) AS ProjectType,
  cast('' as ps_s4_fkstl) AS ResponsibleCostCenter,
  cast('00000000' as ps_psphi1) AS ProjectInternalID,
  cast('' as fkber) AS FunctionalArea,
  cast('' as werks_d) AS Plant
FROM I_MaterialStdVH
LEFT OUTER JOIN I_ProjectBasicData AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialType AS _MaterialType ON MaterialType = _MaterialType.MaterialType  -- association [0..1]
-- UNION ALL with additional select branch(es): I_ProductCostCtrlgOrderItem, I_CostCenter, I_WBSElementBasicData, R_EvtBsdPostgRuleOrderVH
;