FAR_PSTRL_MTCI

Transparent Table Application Table
9 Fields 1 CDS Views

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)
);

Learn More