P_EvtBsdPostingRuleAndTmp

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 P_EvtBsdPostingRuleAndTmp.
-- 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: PEBPSTRLATMP

CREATE VIEW P_EvtBsdPostingRuleAndTmp AS
SELECT
  cast(ControllingObject as fco_ebpr_identifier) AS EvtBsdPostingRuleIdentifier,
  cast('' as fco_ebpr_is_temporary ) AS EvtBsdPostingRuleIsTemporary,
  EventBasedDistrPostingRuleUUID,
  ControllingObject,
  ControllingObjectType,
  EventBasedDistributionRuleSqnc,
  cast( EventBasedDistributionType as fco_ebpr_distribution_type ) AS EventBasedDistributionType,
  PartnerControllingObjectType,
  EvtBsdPostingRuleReceiver,
  EvtBsdPostingRuleReceiverText,
  cast(EventBasedDistrRateInPercent as fco_ebpr_pstg_rule_perc_rate) AS EventBasedDistrRateInPercent,
  EvtBsdDistrEquivalenceFactor,
  ReceiverWBSElementInternalID,
  PartnerControllingObjectType AS EvtBsdPostingRuleRcvrCat,
  EvtBsdDistrSourceStructure,
  EvtBsdDistrSourceAssignment,
  EventBasedDistributionDfltRule,
  Rule.OrderID AS OrderID,
  Rule.OrderItem AS OrderItem,
  EvtBsdDistrTracingFctrDetnMeth,
  MfgOrdNonMatlRcvrAcctDetnMeth,
  OrderMasterContext.ControllingArea AS ControllingArea,
  OrderMasterContext.CompanyCode AS CompanyCode,
  OrderMasterContext.OrderCategory AS OrderCategory,
  OrderMasterContext.OrderType AS OrderType,
  OrderMasterContext.Plant AS Plant,
  cast('' as abgr_schl) AS ResultAnalysisInternalID,
  EnteredByUser,
  CreationDate,
  LastChangedByUser,
  Rule.LastChangeDate AS LastChangeDate
FROM P_EvtBsdPostingRule AS Rule
INNER JOIN P_EventBasedPCCOrderAndItem AS OrderMasterContext ON /* join condition not captured in parsed metadata */
INNER JOIN R_EvtBsdTmpPostingRuleSetting AS PostingRuleSetting ON /* join condition not captured in parsed metadata */
INNER JOIN R_EvtBsdTmpPostingRule AS NonMatlRcvrAcctDetnMeth ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_EvtBsdTmpPostingRule
;