R_EvtBsdTmpPostingRuleSetting

DDL: R_EVTBSDTMPPOSTINGRULESETTING SQL: REBTMPPSTRLSET Type: view BASIC
21 Fields 1 Data Sources

Event-Based Temporary Posting Rule Setting

R_EvtBsdTmpPostingRuleSetting is a Basic CDS View that provides data about "Event-Based Temporary Posting Rule Setting" in SAP S/4HANA. It reads from 1 data source (fcot_ebpr_tmpstg) and exposes 21 fields with key field EvtBsdPostingRuleIdentifier.

Data Sources (1)

SourceAliasJoin Type
fcot_ebpr_tmpstg fcot_ebpr_tmpstg from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName REBTMPPSTRLSET view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Event-Based Temporary Posting Rule Setting view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY EvtBsdPostingRuleIdentifier identifier Snd. Alias
ControllingObject object_number Object number
ControllingArea kokrs Org. Value
CompanyCode bukrs Value
OrderCategory autyp Order category
OrderType auart Sales Doc. Type
Plant werks Receiving Plant
OrderID order_number Order Number
OrderItem order_item SO Item
SalesOrder sales_order_number Sales Order
SalesOrderItem sales_order_item_number Sales Ord. Item
WBSElementInternalID WBS Internal ID
Product matnr Vehicle Model
MfgOrderHasMultipleItems flg_mltps Multiple Items
ResultAnalysisInternalID abgsl Results analysis key
EventBasedDistributionType posting_type Posting Type
EvtBsdDistrSourceStructure source_structure Source Struct.
EvtBsdPostgRuleDistrMethod distribution_method Distribution Method
EnteredByUser ernam User Name
LastChangedByUser aenam User Name
LocalLastChangeDateTime timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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_EvtBsdTmpPostingRuleSetting.
-- 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: REBTMPPSTRLSET

CREATE VIEW R_EvtBsdTmpPostingRuleSetting AS
SELECT
  identifier AS EvtBsdPostingRuleIdentifier,
  object_number AS ControllingObject,
  kokrs AS ControllingArea,
  bukrs AS CompanyCode,
  autyp AS OrderCategory,
  auart AS OrderType,
  werks AS Plant,
  order_number AS OrderID,
  order_item AS OrderItem,
  sales_order_number AS SalesOrder,
  sales_order_item_number AS SalesOrderItem,
  cast(wbs_element_internal_id as fco_ebpr_wbs_element_int_id) AS WBSElementInternalID,
  matnr AS Product,
  flg_mltps AS MfgOrderHasMultipleItems,
  abgsl AS ResultAnalysisInternalID,
  posting_type AS EventBasedDistributionType,
  source_structure AS EvtBsdDistrSourceStructure,
  distribution_method AS EvtBsdPostgRuleDistrMethod,
  ernam AS EnteredByUser,
  aenam AS LastChangedByUser,
  timestamp AS LocalLastChangeDateTime
FROM fcot_ebpr_tmpstg
;

Learn More