FAR_PSTRL_KPI

Transparent Table Application Table

I_ARPOSTINGRULEKPI

FAR_PSTRL_KPI is an SAP database table in S/4HANA. I_ARPOSTINGRULEKPI. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ARPostingRuleKPIBasic view from BASIC Posting Rule KPI Basic

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY postgrulekeyperfinduuid FAR_PSTRLKPI_NODE_KEY KPI Key
postingruleuuid FAR_PSTRL_NODE_KEY Rule Key
creationdatetime FAR_RP_KPI_CALC_DATETIME KPI calc. datetime
malrnproposalconfidencepercent FAR_PSTRL_PERCENT_CONFIDENCE Confidence of Rule
nmbrofmtchgopenbkstatementitms FAR_RP_NO_OPEN_BS_ITM_MATCH_RU Appl. Open Items
nmbrofmtchghistlbkstmntitms FAR_RP_NO_MTCHNG_HISTL_BS_ITM Past Appl. Items
numberofwrongpostings FAR_RP_NO_WRONG_POSTINGS Past Diff. Post. Itm
numberofbankstatementitems FAR_PSTRL_NO_BS_ITEMS All Items
nmbrofopenbkstatementitms FAR_PSTRL_NO_OPEN_BS_ITEMS All Open Items

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- I_ARPOSTINGRULEKPI
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAR_PSTRL_KPI (
    MANDT,                           -- Client [MANDT]
    POSTGRULEKEYPERFINDUUID,         -- KPI Key [FAR_PSTRLKPI_NODE_KEY]
    POSTINGRULEUUID,                 -- Rule Key [FAR_PSTRL_NODE_KEY]
    CREATIONDATETIME,                -- KPI calc. datetime [FAR_RP_KPI_CALC_DATETIME]
    MALRNPROPOSALCONFIDENCEPERCENT,  -- Confidence of Rule [FAR_PSTRL_PERCENT_CONFIDENCE]
    NMBROFMTCHGOPENBKSTATEMENTITMS,  -- Appl. Open Items [FAR_RP_NO_OPEN_BS_ITM_MATCH_RU]
    NMBROFMTCHGHISTLBKSTMNTITMS,     -- Past Appl. Items [FAR_RP_NO_MTCHNG_HISTL_BS_ITM]
    NUMBEROFWRONGPOSTINGS,           -- Past Diff. Post. Itm [FAR_RP_NO_WRONG_POSTINGS]
    NUMBEROFBANKSTATEMENTITEMS,      -- All Items [FAR_PSTRL_NO_BS_ITEMS]
    NMBROFOPENBKSTATEMENTITMS,       -- All Open Items [FAR_PSTRL_NO_OPEN_BS_ITEMS]
    PRIMARY KEY (MANDT, POSTGRULEKEYPERFINDUUID)
);