I_ARPostingRuleTP

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_ARPostingRuleTP.
-- 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_ARPostingRuleTP AS
SELECT
  Rule.postingruleuuid AS PostingRuleUUID,
  cast (Rule.debitcreditcode as far_pstrl_debitcreditcode) AS DebitCreditCode,
  Rule.reprocgrulepostgproceduretype AS ReprocgRulePostgProcedureType,
  Rule.postingruledescription AS PostingRuleDescription,
  Rule.bankstatementshortid AS BankStatementShortID,
  Rule.bankstatementitem AS BankStatementItem,
  Rule.originalpostingruleuuid AS OriginalPostingRuleUUID,
  Rule.postingrule AS PostingRule,
  Rule.postingruleversion AS PostingRuleVersion,
  Rule.sourcereprocessingruleuuid AS SourceReprocessingRuleUUID,
  cast( Rule.lastchangedbyuser as far_pstrl_cuser ) AS LastChangedByUser,
  cast( _lastChangeUser.UserDescription as far_pstrl_cuser_name ) AS LastChangedByUserFullName,
  cast( Rule.lastchangedatetime as timestamp ) AS LastChangeDateTime,
  cast (Rule.createdbyuser as far_pstrl_euser ) AS CreatedByUser,
  cast (_createUser.UserDescription as far_pstrl_euser_name ) AS CreatedByUserFullName,
  cast( Rule.creationdatetime as timestamp ) AS CreationDateTime,
  Rule.reprocessingrulecreationmode AS ReprocessingRuleCreationMode,
  Rule.postingruledatamodelversion AS PostingRuleDataModelVersion,
  Rule.bankstatementitemsemantickey AS BankStatementItemSemanticKey,
  Rule.postingruleactiontype AS PostingRuleActionType,
  Rule.isobsolete AS IsObsolete,
  Rule.postingruleisautomatic AS PostingRuleIsAutomatic,
  Rule.postingruleisactive AS PostingRuleIsActive,
  Rule.isauthorizeduser AS IsAuthorizedUser,
  Rule.reprocessingruleisshared AS ReprocessingRuleIsShared,
  Rule.postingruleismalrnproposal AS PostingRuleIsMaLrnProposal,
  Rule.applicationlog AS ApplicationLog,
  cast( Rule.applicationloghandle as abap.char(22) ) AS ApplicationLogHandle,
  Rule.assignedprocessorisignored AS AssignedProcessorIsIgnored,
  Rule.proposedpostgruleisdisregarded AS ProposedPostgRuleIsDisregarded,
  Rule.reprocessingrulecluster AS ReprocessingRuleCluster,
  Rule.postingruletemplate AS PostingRuleTemplate,
  Rule.fallbackonacctpostingisenabled AS FallbackOnAcctPostingIsEnabled,
  Rule.accountingdocumenttype AS AccountingDocumentType,
  Rule.reprocessingrulecreationvers AS ReprocessingRuleCreationVers,
  _InterimPostingAssoc.JournalEntryType AS JournalEntryType,
  _InterimPostingAssoc.GLAccount AS GLAccount,
  Rule.reprocessingruleuploadstatus AS ReprocessingRuleUploadStatus
FROM far_pstrl_d_root AS Rule
LEFT OUTER JOIN P_ARPostgRuleSourceTmpldist AS _PostingRuleTmplSource ON Rule.postingruleuuid = _PostingRuleTmplSource.sourcereprocessingruleuuid  -- association [1..1]
LEFT OUTER JOIN I_User AS _lastChangeUser ON _lastChangeUser.UserID = Rule.lastchangedbyuser  -- association [1..1]
LEFT OUTER JOIN I_User AS _createUser ON _createUser.UserID = Rule.createdbyuser  -- association [1..1]
LEFT OUTER JOIN I_ARPostingRuleKPI AS _RuleKPILatest ON Rule.postingruleuuid = _RuleKPILatest.PostingRuleUUID AND _RuleKPILatest.PostingRuleKPIIsLatest = 'X'  -- association [0..*]
LEFT OUTER JOIN I_ARPostgRuleInterimPosting AS _InterimPostingAssoc ON PostingRuleUUID = _InterimPostingAssoc.PostingRuleUUID  -- association [1..*]
LEFT OUTER JOIN I_OutgoingIncomingPaytCodeText AS _OutgoingIncomingPaymentText ON DebitCreditCode = _OutgoingIncomingPaymentText.DebitCreditCode  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _DocumentTypeText ON AccountingDocumentType = _DocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_ReprocgRulePostgProcedTypeT AS _ProcedureTypeText ON ReprocgRulePostgProcedureType = _ProcedureTypeText.ReprocgRulePostgProcedureType  -- association [0..*]
LEFT OUTER JOIN I_ReprocgRuleApplTypeText AS _RuleApplicationTypeText ON ReprocessingRuleApplType = _RuleApplicationTypeText.ReprocessingRuleApplType  -- association [0..*]
LEFT OUTER JOIN I_PostgRuleLifecycleStatusTxt AS _LifecycleStatusText ON PostingRuleLifecycleStatus = _LifecycleStatusText.PostingRuleLifecycleStatus  -- association [0..*]
LEFT OUTER JOIN I_ARPostingRuleUserTP AS _UserFavoriteCalculation ON Rule.postingruleuuid = _UserFavoriteCalculation.PostingRuleUUID AND _UserFavoriteCalculation.UserID = $session.user  -- association [1..*]
LEFT OUTER JOIN I_ARPostingRuleUploadStatusTxt AS _PostingRuleUploadStatusTxt ON ReprocessingRuleUploadStatus = _PostingRuleUploadStatusTxt.ReprocessingRuleUploadStatus  -- association [0..*]
LEFT OUTER JOIN I_ARPostingRuleUserTP AS _User ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ARPostingRuleConditionTP AS _Condition ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ARPostgRuleActnGLTP AS _ActionGL ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ARPostgRuleActnAPARTP AS _ActionAPAR ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ARPostgRuleActnPaytCatTP AS _ActionPaytCat ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ARPostingRuleKPI AS _RuleKPI ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ARPostgRuleOriginatingTmpl AS _RuleTemplate ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ARPostgRuleInterimPosting AS _InterimPosting ON /* condition not available in parsed metadata */  -- association [1..1]
;