P_EvtBsdPostingRule

DDL: P_EVTBSDPOSTINGRULE SQL: PEBPSTRULE Type: view COMPOSITE Package: ODATA_CO_EB_POSTING_RULES

Event-Based Posting Rule

P_EvtBsdPostingRule is a Composite CDS View that provides data about "Event-Based Posting Rule" in SAP S/4HANA. It reads from 7 data sources and exposes 200 fields with key field EventBasedDistrPostingRuleUUID. Part of development package ODATA_CO_EB_POSTING_RULES.

Data Sources (7)

SourceAliasJoin Type
P_EventBasedPCCOrderAndItem OrderMasterContext inner
R_EventBasedDistrPostingRule Rule from
R_EventBasedDistrPostingRule Rule union_all
R_EventBasedDistrPostingRule Rule union_all
R_EventBasedDistrPostingRule Rule union_all
R_EventBasedDistrPostingRule Rule union_all
R_EventBasedDistrPostingRule Rule union_all

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PEBPSTRULE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (200)

KeyFieldSource TableSource FieldDescription
KEY EventBasedDistrPostingRuleUUID EventBasedDistrPostingRuleUUID Rule UUID
SAPObjectNodeType SAPObjectNodeType SONT Name
ControllingObject ControllingObject Object number
ControllingObjectType ControllingObjectType Object Type
EventBasedDistributionRuleSqnc EventBasedDistributionRuleSqnc Sequence Number
EventBasedDistributionType EventBasedDistributionType Posting Type
EvtBsdDistrSourceStructure EvtBsdDistrSourceStructure Source Struct.
EvtBsdDistrSourceAssignment EvtBsdDistrSourceAssignment Source Assgnmnt
EventBasedDistrRateInPercent EventBasedDistrRateInPercent Percent
EvtBsdDistrEquivalenceFactor EvtBsdDistrEquivalenceFactor Equivalence No.
EventBasedDistributionDfltRule EventBasedDistributionDfltRule Default Rule
OrderID OrderID Order ID
OrderItem OrderItem SO Item
OrderCategory OrderCategory Order Category
IsSettled IsSettled Is Settled
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID WBSElementInternalID WBS Internal ID
ReceiverOrder ReceiverOrder Order
PartnerOrderItem PartnerOrderItem Item Number
ProducedProduct ProducedProduct Material
PartnerProfitabilitySegment PartnerProfitabilitySegment Profit. segment
ReceiverCostCenter ReceiverCostCenter Cost Center
PartnerControllingObjectType PartnerControllingObjectType Receiver Type
ReceiverWBSElementInternalID ReceiverWBSElementInternalID
EvtBsdPostingRuleReceiver
EvtBsdPostingRuleReceiverText
EvtBsdDistrTracingFctrDetnMeth EvtBsdDistrTracingFctrDetnMeth Methods
MfgOrdNonMatlRcvrAcctDetnMeth MfgOrdNonMatlRcvrAcctDetnMeth
EnteredByUser EnteredByUser Version Created By
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
SAPObjectNodeType SAPObjectNodeType SONT Name
ControllingObject ControllingObject Object number
ControllingObjectType ControllingObjectType Object Type
EventBasedDistributionRuleSqnc EventBasedDistributionRuleSqnc Sequence Number
EventBasedDistributionType EventBasedDistributionType Posting Type
EvtBsdDistrSourceStructure EvtBsdDistrSourceStructure Source Struct.
EvtBsdDistrSourceAssignment EvtBsdDistrSourceAssignment Source Assgnmnt
EventBasedDistrRateInPercent EventBasedDistrRateInPercent Percent
EvtBsdDistrEquivalenceFactor EvtBsdDistrEquivalenceFactor Equivalence No.
EventBasedDistributionDfltRule EventBasedDistributionDfltRule Default Rule
OrderID R_EventBasedDistrPostingRule OrderID Order ID
OrderItem OrderItem SO Item
OrderCategory R_EventBasedDistrPostingRule OrderCategory Order Category
IsSettled IsSettled Is Settled
SalesOrder R_EventBasedDistrPostingRule SalesOrder SD Document
SalesOrderItem R_EventBasedDistrPostingRule SalesOrderItem Sales Order Item
WBSElementInternalID R_EventBasedDistrPostingRule WBSElementInternalID WBS Internal ID
ReceiverOrder ReceiverOrder Order
PartnerOrderItem PartnerOrderItem Item Number
ProducedProduct ProducedProduct Material
PartnerProfitabilitySegment PartnerProfitabilitySegment Profit. segment
ReceiverCostCenter ReceiverCostCenter Cost Center
PartnerControllingObjectType PartnerControllingObjectType Receiver Type
ReceiverWBSElementInternalID ReceiverWBSElementInternalID
EvtBsdPostingRuleReceiver
EvtBsdPostingRuleReceiverText
EvtBsdDistrTracingFctrDetnMeth EvtBsdDistrTracingFctrDetnMeth Methods
MfgOrdNonMatlRcvrAcctDetnMeth MfgOrdNonMatlRcvrAcctDetnMeth
EnteredByUser EnteredByUser Version Created By
CreationDate R_EventBasedDistrPostingRule CreationDate Time Stamp
CreationTime R_EventBasedDistrPostingRule CreationTime Time of Change
LastChangedByUser R_EventBasedDistrPostingRule LastChangedByUser User Name
LastChangeDate R_EventBasedDistrPostingRule LastChangeDate Time Stamp
SAPObjectNodeType SAPObjectNodeType SONT Name
ControllingObject ControllingObject Object number
ControllingObjectType ControllingObjectType Object Type
EventBasedDistributionRuleSqnc EventBasedDistributionRuleSqnc Sequence Number
EventBasedDistributionType EventBasedDistributionType Posting Type
EvtBsdDistrSourceStructure EvtBsdDistrSourceStructure Source Struct.
EvtBsdDistrSourceAssignment EvtBsdDistrSourceAssignment Source Assgnmnt
EventBasedDistrRateInPercent EventBasedDistrRateInPercent Percent
EvtBsdDistrEquivalenceFactor EvtBsdDistrEquivalenceFactor Equivalence No.
EventBasedDistributionDfltRule EventBasedDistributionDfltRule Default Rule
OrderID R_EventBasedDistrPostingRule OrderID Order ID
OrderItem R_EventBasedDistrPostingRule OrderItem SO Item
OrderCategory R_EventBasedDistrPostingRule OrderCategory Order Category
IsSettled IsSettled Is Settled
SalesOrder R_EventBasedDistrPostingRule SalesOrder SD Document
SalesOrderItem R_EventBasedDistrPostingRule SalesOrderItem Sales Order Item
WBSElementInternalID R_EventBasedDistrPostingRule WBSElementInternalID WBS Internal ID
ReceiverOrder ReceiverOrder Order
PartnerOrderItem PartnerOrderItem Item Number
ProducedProduct R_EventBasedDistrPostingRule ProducedProduct Material
PartnerProfitabilitySegment PartnerProfitabilitySegment Profit. segment
ReceiverCostCenter ReceiverCostCenter Cost Center
PartnerControllingObjectType PartnerControllingObjectType Receiver Type
ReceiverWBSElementInternalID ReceiverWBSElementInternalID
EvtBsdPostingRuleReceiver
EvtBsdPostingRuleReceiverText
EvtBsdDistrTracingFctrDetnMeth EvtBsdDistrTracingFctrDetnMeth Methods
MfgOrdNonMatlRcvrAcctDetnMeth MfgOrdNonMatlRcvrAcctDetnMeth
EnteredByUser EnteredByUser Version Created By
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
SAPObjectNodeType SAPObjectNodeType SONT Name
ControllingObject ControllingObject Object number
ControllingObjectType ControllingObjectType Object Type
EventBasedDistributionRuleSqnc EventBasedDistributionRuleSqnc Sequence Number
EventBasedDistributionType EventBasedDistributionType Posting Type
EvtBsdDistrSourceStructure EvtBsdDistrSourceStructure Source Struct.
EvtBsdDistrSourceAssignment EvtBsdDistrSourceAssignment Source Assgnmnt
EventBasedDistrRateInPercent EventBasedDistrRateInPercent Percent
EvtBsdDistrEquivalenceFactor EvtBsdDistrEquivalenceFactor Equivalence No.
EventBasedDistributionDfltRule EventBasedDistributionDfltRule Default Rule
OrderID R_EventBasedDistrPostingRule OrderID Order ID
OrderItem R_EventBasedDistrPostingRule OrderItem SO Item
OrderCategory R_EventBasedDistrPostingRule OrderCategory Order Category
IsSettled IsSettled Is Settled
SalesOrder R_EventBasedDistrPostingRule SalesOrder SD Document
SalesOrderItem R_EventBasedDistrPostingRule SalesOrderItem Sales Order Item
WBSElementInternalID R_EventBasedDistrPostingRule WBSElementInternalID WBS Internal ID
ReceiverOrder ReceiverOrder Order
PartnerOrderItem PartnerOrderItem Item Number
ProducedProduct ProducedProduct Material
PartnerProfitabilitySegment PartnerProfitabilitySegment Profit. segment
ReceiverCostCenter ReceiverCostCenter Cost Center
PartnerControllingObjectType PartnerControllingObjectType Receiver Type
ReceiverWBSElementInternalID ReceiverWBSElementInternalID
EvtBsdPostingRuleReceiver
EvtBsdPostingRuleReceiverText
EvtBsdDistrTracingFctrDetnMeth EvtBsdDistrTracingFctrDetnMeth Methods
MfgOrdNonMatlRcvrAcctDetnMeth MfgOrdNonMatlRcvrAcctDetnMeth
EnteredByUser EnteredByUser Version Created By
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
SAPObjectNodeType SAPObjectNodeType SONT Name
ControllingObject ControllingObject Object number
ControllingObjectType ControllingObjectType Object Type
EventBasedDistributionRuleSqnc EventBasedDistributionRuleSqnc Sequence Number
EventBasedDistributionType EventBasedDistributionType Posting Type
EvtBsdDistrSourceStructure EvtBsdDistrSourceStructure Source Struct.
EvtBsdDistrSourceAssignment EvtBsdDistrSourceAssignment Source Assgnmnt
EventBasedDistrRateInPercent EventBasedDistrRateInPercent Percent
EvtBsdDistrEquivalenceFactor EvtBsdDistrEquivalenceFactor Equivalence No.
EventBasedDistributionDfltRule EventBasedDistributionDfltRule Default Rule
OrderID OrderID Order ID
OrderItem OrderItem SO Item
OrderCategory OrderCategory Order Category
IsSettled IsSettled Is Settled
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID R_EventBasedDistrPostingRule WBSElementInternalID WBS Internal ID
ReceiverOrder ReceiverOrder Order
PartnerOrderItem PartnerOrderItem Item Number
ProducedProduct ProducedProduct Material
PartnerProfitabilitySegment PartnerProfitabilitySegment Profit. segment
ReceiverCostCenter ReceiverCostCenter Cost Center
PartnerControllingObjectType PartnerControllingObjectType Receiver Type
ReceiverWBSElementInternalID ReceiverWBSElementInternalID
EvtBsdPostingRuleReceiver
EvtBsdPostingRuleReceiverText
EvtBsdDistrTracingFctrDetnMeth EvtBsdDistrTracingFctrDetnMeth Methods
MfgOrdNonMatlRcvrAcctDetnMeth MfgOrdNonMatlRcvrAcctDetnMeth
EnteredByUser EnteredByUser Version Created By
CreationDate R_EventBasedDistrPostingRule CreationDate Time Stamp
CreationTime R_EventBasedDistrPostingRule CreationTime Time of Change
LastChangedByUser R_EventBasedDistrPostingRule LastChangedByUser User Name
LastChangeDate R_EventBasedDistrPostingRule LastChangeDate Time Stamp
SAPObjectNodeType SAPObjectNodeType SONT Name
ControllingObject ControllingObject Object number
ControllingObjectType ControllingObjectType Object Type
EventBasedDistributionRuleSqnc EventBasedDistributionRuleSqnc Sequence Number
EventBasedDistributionType EventBasedDistributionType Posting Type
EvtBsdDistrSourceStructure EvtBsdDistrSourceStructure Source Struct.
EvtBsdDistrSourceAssignment EvtBsdDistrSourceAssignment Source Assgnmnt
EventBasedDistrRateInPercent EventBasedDistrRateInPercent Percent
EvtBsdDistrEquivalenceFactor EvtBsdDistrEquivalenceFactor Equivalence No.
EventBasedDistributionDfltRule EventBasedDistributionDfltRule Default Rule
OrderID OrderID Order ID
OrderItem OrderItem SO Item
OrderCategory OrderCategory Order Category
IsSettled IsSettled Is Settled
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID R_EventBasedDistrPostingRule WBSElementInternalID WBS Internal ID
ReceiverOrder ReceiverOrder Order
PartnerOrderItem PartnerOrderItem Item Number
ProducedProduct ProducedProduct Material
PartnerProfitabilitySegment PartnerProfitabilitySegment Profit. segment
ReceiverCostCenter ReceiverCostCenter Cost Center
PartnerControllingObjectType PartnerControllingObjectType Receiver Type
ReceiverWBSElementInternalID ReceiverWBSElementInternalID
EvtBsdPostingRuleReceiver
EvtBsdPostingRuleReceiverText
EvtBsdDistrTracingFctrDetnMeth EvtBsdDistrTracingFctrDetnMeth Methods
MfgOrdNonMatlRcvrAcctDetnMeth MfgOrdNonMatlRcvrAcctDetnMeth
EnteredByUser EnteredByUser Version Created By
CreationDate R_EventBasedDistrPostingRule CreationDate Time Stamp
CreationTime R_EventBasedDistrPostingRule CreationTime Time of Change
LastChangedByUser R_EventBasedDistrPostingRule LastChangedByUser User Name
LastChangeDate R_EventBasedDistrPostingRule LastChangeDate Time Stamp
RecentlyChangedDateTime RecentlyChangedDateTime Timestamp (Changed)

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_EvtBsdPostingRule.
-- 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: PEBPSTRULE

CREATE VIEW P_EvtBsdPostingRule AS
SELECT
  EventBasedDistrPostingRuleUUID,
  SAPObjectNodeType,
  ControllingObject,
  ControllingObjectType,
  EventBasedDistributionRuleSqnc,
  EventBasedDistributionType,
  EvtBsdDistrSourceStructure,
  EvtBsdDistrSourceAssignment,
  EventBasedDistrRateInPercent,
  EvtBsdDistrEquivalenceFactor,
  EventBasedDistributionDfltRule,
  OrderID,
  OrderItem,
  OrderCategory,
  IsSettled,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  ReceiverOrder,
  PartnerOrderItem,
  ProducedProduct,
  PartnerProfitabilitySegment,
  ReceiverCostCenter,
  PartnerControllingObjectType,
  ReceiverWBSElementInternalID,
  cast(ProducedProduct as fco_ebpr_receiver) AS EvtBsdPostingRuleReceiver,
  cast(ProductText.ProductName as fco_ebpr_receiver_txt) AS EvtBsdPostingRuleReceiverText,
  EvtBsdDistrTracingFctrDetnMeth,
  MfgOrdNonMatlRcvrAcctDetnMeth,
  EnteredByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  RecentlyChangedDateTime
FROM R_EventBasedDistrPostingRule AS Rule
INNER JOIN P_EventBasedPCCOrderAndItem AS OrderMasterContext ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): R_EventBasedDistrPostingRule
;