FAR_PSTRL_MTCI

Transparent Table Application Table

Match Open item Parameters

FAR_PSTRL_MTCI is an SAP database table in S/4HANA. Match Open item Parameters. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ARPostgRuleMatchItmClrgTP view_entity from TRANSACTIONAL Match Open Items - TP

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY matchitemclearinguuid far_matchopenitem_node_key MtchOpn Itm Node Key
postingruleuuid far_pstrl_node_key Rule Key
postingruleactionuuid far_pstrla_node_key Action Key
sequencenumber far_pstrl_paytrancat_sequence Sequence Number
matchitemclearingsourcefield far_src_attrib Source
matchitemclearingsearchfield far_search_attrib Use as
journalentrydocdateismatched far_je_docdate_mtchd Match Document Date
intercompanyopnitmisincluded far_inter_company_is_included Intercompany Opn Itm

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.

-- Match Open item Parameters
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAR_PSTRL_MTCI (
    CLIENT,                        -- Client [mandt]
    MATCHITEMCLEARINGUUID,         -- MtchOpn Itm Node Key [far_matchopenitem_node_key]
    POSTINGRULEUUID,               -- Rule Key [far_pstrl_node_key]
    POSTINGRULEACTIONUUID,         -- Action Key [far_pstrla_node_key]
    SEQUENCENUMBER,                -- Sequence Number [far_pstrl_paytrancat_sequence]
    MATCHITEMCLEARINGSOURCEFIELD,  -- Source [far_src_attrib]
    MATCHITEMCLEARINGSEARCHFIELD,  -- Use as [far_search_attrib]
    JOURNALENTRYDOCDATEISMATCHED,  -- Match Document Date [far_je_docdate_mtchd]
    INTERCOMPANYOPNITMISINCLUDED,  -- Intercompany Opn Itm [far_inter_company_is_included]
    PRIMARY KEY (CLIENT, MATCHITEMCLEARINGUUID)
);