I_ARPostingRuleKPIBasic

DDL: I_ARPOSTINGRULEKPIBASIC SQL: IARPOSTRLKPIBSC Type: view BASIC
9 Fields 1 Data Sources

Posting Rule KPI Basic

I_ARPostingRuleKPIBasic is a Basic CDS View that provides data about "Posting Rule KPI Basic" in SAP S/4HANA. It reads from 1 data source (far_pstrl_kpi) and exposes 9 fields with key field PostgRuleKeyPerfIndUUID.

Data Sources (1)

SourceAliasJoin Type
far_pstrl_kpi RuleKPI from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IARPOSTRLKPIBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Posting Rule KPI Basic view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PostgRuleKeyPerfIndUUID far_pstrl_kpi postgrulekeyperfinduuid KPI Key
PostingRuleUUID far_pstrl_kpi postingruleuuid Rule Key
CreationDateTime far_pstrl_kpi creationdatetime Timestamp
MaLrnProposalConfidencePercent far_pstrl_kpi malrnproposalconfidencepercent Confidence of Rule
NmbrOfMtchgOpenBkStatementItms far_pstrl_kpi nmbrofmtchgopenbkstatementitms Appl. Open Items
NmbrOfMtchgHistlBkStmntItms far_pstrl_kpi nmbrofmtchghistlbkstmntitms Past Appl. Items
NmbrOfOpenBkStatementItms far_pstrl_kpi nmbrofopenbkstatementitms All Open Items
NumberOfBankStatementItems far_pstrl_kpi numberofbankstatementitems All Items
NumberOfWrongPostings far_pstrl_kpi numberofwrongpostings Past Diff. Post. Itm

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_ARPostingRuleKPIBasic.
-- 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: IARPOSTRLKPIBSC

CREATE VIEW I_ARPostingRuleKPIBasic 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 far_pstrl_kpi AS RuleKPI
;

Learn More