I_ARPostingRuleKPI

DDL: I_ARPOSTINGRULEKPI Type: view_entity COMPOSITE
10 Fields 1 Data Sources 1 Associations

Posting Rule - KPI

I_ARPostingRuleKPI is a Composite CDS View that provides data about "Posting Rule - KPI" in SAP S/4HANA. It reads from 1 data source (I_ARPostingRuleKPIBasic) and exposes 10 fields with key field PostgRuleKeyPerfIndUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ARPostingRuleKPIBasic RuleKPI from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_ARPostingRuleKPINewest _RuleKPINewest $projection.PostingRuleUUID = _RuleKPINewest.PostingRuleUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Posting Rule - KPI view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PostgRuleKeyPerfIndUUID I_ARPostingRuleKPIBasic PostgRuleKeyPerfIndUUID KPI Key
PostingRuleUUID I_ARPostingRuleKPIBasic PostingRuleUUID Rule Key
CreationDateTime I_ARPostingRuleKPIBasic CreationDateTime Timestamp
MaLrnProposalConfidencePercent I_ARPostingRuleKPIBasic MaLrnProposalConfidencePercent Confidence of Rule
NmbrOfMtchgOpenBkStatementItms I_ARPostingRuleKPIBasic NmbrOfMtchgOpenBkStatementItms Appl. Open Items
NmbrOfMtchgHistlBkStmntItms I_ARPostingRuleKPIBasic NmbrOfMtchgHistlBkStmntItms Past Appl. Items
NmbrOfOpenBkStatementItms I_ARPostingRuleKPIBasic NmbrOfOpenBkStatementItms All Open Items
NumberOfBankStatementItems I_ARPostingRuleKPIBasic NumberOfBankStatementItems All Items
NumberOfWrongPostings I_ARPostingRuleKPIBasic NumberOfWrongPostings Past Diff. Post. Itm
_PostingRule _PostingRule

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_ARPostingRuleKPI.
-- 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_ARPostingRuleKPI AS
SELECT
  RuleKPI.PostgRuleKeyPerfIndUUID AS PostgRuleKeyPerfIndUUID,
  RuleKPI.PostingRuleUUID AS PostingRuleUUID,
  RuleKPI.CreationDateTime AS CreationDateTime,
  RuleKPI.MaLrnProposalConfidencePercent AS MaLrnProposalConfidencePercent,
  RuleKPI.NmbrOfMtchgOpenBkStatementItms AS NmbrOfMtchgOpenBkStatementItms,
  RuleKPI.NmbrOfMtchgHistlBkStmntItms AS NmbrOfMtchgHistlBkStmntItms,
  RuleKPI.NmbrOfOpenBkStatementItms AS NmbrOfOpenBkStatementItms,
  RuleKPI.NumberOfBankStatementItems AS NumberOfBankStatementItems,
  RuleKPI.NumberOfWrongPostings AS NumberOfWrongPostings
FROM I_ARPostingRuleKPIBasic AS RuleKPI
LEFT OUTER JOIN P_ARPostingRuleKPINewest AS _RuleKPINewest ON PostingRuleUUID = _RuleKPINewest.PostingRuleUUID  -- association [1..1]
;

Learn More