I_ARPostgRuleMatchItmClrgTP

DDL: I_ARPOSTGRULEMATCHITMCLRGTP Type: view_entity TRANSACTIONAL Package: ODATA_AR_POSTING_RULES
13 Fields 1 Data Sources 3 Associations

Match Open Items - TP

I_ARPostgRuleMatchItmClrgTP is a Transactional CDS View that provides data about "Match Open Items - TP" in SAP S/4HANA. It reads from 1 data source (far_pstrl_mtci) and exposes 13 fields with key field MatchItemClearingUUID. It has 3 associations to related views. Part of development package ODATA_AR_POSTING_RULES.

Data Sources (1)

SourceAliasJoin Type
far_pstrl_mtci far_pstrl_mtci from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ARPostingRuleTP _PostingRule $projection.PostingRuleUUID = _PostingRule.PostingRuleUUID
[1..*] I_MatchItemClrgSearchFieldText _SearchFieldText _SearchFieldText.MatchItemClearingSearchField = $projection.MatchItemClearingSearchField
[1..*] I_MatchItemClrgSourceFieldText _SourceFieldText _SourceFieldText.MatchItemClearingSourceField = $projection.MatchItemClearingSourceField

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Match Open Items - TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MatchItemClearingUUID matchitemclearinguuid MtchOpn Itm Node Key
PostingRuleActionUUID postingruleactionuuid Action Key
PostingRuleUUID postingruleuuid Rule Key
SequenceNumber sequencenumber Sort sequence
MatchItemClearingSourceField matchitemclearingsourcefield Source
MatchItemClearingSearchField matchitemclearingsearchfield Use as
JournalEntryDocDateIsMatched journalentrydocdateismatched Match Document Date
InterCompanyOpnItmIsIncluded intercompanyopnitmisincluded Intercompany Opn Itm
ReprocessingRuleApplType _Action ReprocessingRuleApplType Rule Appl Type
_PostingRule _PostingRule
_Action _Action
_SearchFieldText _SearchFieldText
_SourceFieldText _SourceFieldText

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_ARPostgRuleMatchItmClrgTP.
-- 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_ARPostgRuleMatchItmClrgTP AS
SELECT
  MatchItemClearingUUID,
  PostingRuleActionUUID,
  PostingRuleUUID,
  SequenceNumber,
  MatchItemClearingSourceField,
  MatchItemClearingSearchField,
  JournalEntryDocDateIsMatched,
  InterCompanyOpnItmIsIncluded,
  _Action.ReprocessingRuleApplType AS ReprocessingRuleApplType
FROM far_pstrl_mtci
LEFT OUTER JOIN I_ARPostingRuleTP AS _PostingRule ON PostingRuleUUID = _PostingRule.PostingRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MatchItemClrgSearchFieldText AS _SearchFieldText ON _SearchFieldText.MatchItemClearingSearchField = MatchItemClearingSearchField  -- association [1..*]
LEFT OUTER JOIN I_MatchItemClrgSourceFieldText AS _SourceFieldText ON _SourceFieldText.MatchItemClearingSourceField = MatchItemClearingSourceField  -- association [1..*]
;

Learn More