I_ARPostgRuleActnAPARTP

DDL: I_ARPOSTGRULEACTNAPARTP Type: view_entity COMPOSITE Package: ODATA_AR_POSTING_RULES
15 Fields 1 Data Sources 2 Associations

Posting Rule - APAR Action

I_ARPostgRuleActnAPARTP is a Composite CDS View that provides data about "Posting Rule - APAR Action" in SAP S/4HANA. It reads from 1 data source (far_pstrl_aapar) and exposes 15 fields with key field PostingRuleActionUUID. It has 2 associations to related views. Part of development package ODATA_AR_POSTING_RULES.

Data Sources (1)

SourceAliasJoin Type
far_pstrl_aapar APARAction from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_DisputeCaseCreationModeText _DisputeCaseCreationMode $projection.DisputeCaseCreationMode = _DisputeCaseCreationMode.DisputeCaseCreationMode
[0..*] I_SpecialGLCodeText _SpecialGLCode $projection.FinancialAccountType= _SpecialGLCode.FinancialAccountType and $projection.SpecialGLCode = _SpecialGLCode.SpecialGLCode

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Posting Rule - APAR Action view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PostingRuleActionUUID far_pstrl_aapar postingruleactionuuid Action Key
PostingRuleUUID far_pstrl_aapar postingruleuuid Rule Key
AssignmentReference far_pstrl_aapar assignmentreference Assignment Reference
Customer far_pstrl_aapar customer Sold-to Party
DocumentItemText far_pstrl_aapar documentitemtext Text
Supplier far_pstrl_aapar supplier Supplier
DisputeCaseCreationMode far_pstrl_aapar disputecasecreationmode Dispute Case Crtn ID
SpecialGLCode far_pstrl_aapar specialglcode Special G/L Ind
ProcessingRuleItemDebitAmount far_pstrl_aapar processingruleitemdebitamount
ProcessingRuleItemCreditAmount far_pstrl_aapar processingruleitemcreditamount
ProcgRuleItemAmountPercent far_pstrl_aapar procgruleitemamountpercent
GLAccount far_pstrl_aapar glaccount General Ledger
_DisputeCaseCreationMode _DisputeCaseCreationMode
_SpecialGLCode _SpecialGLCode
_Rule _Rule

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_ARPostgRuleActnAPARTP.
-- 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_ARPostgRuleActnAPARTP AS
SELECT
  APARAction.postingruleactionuuid AS PostingRuleActionUUID,
  APARAction.postingruleuuid AS PostingRuleUUID,
  APARAction.assignmentreference AS AssignmentReference,
  APARAction.customer AS Customer,
  APARAction.documentitemtext AS DocumentItemText,
  APARAction.supplier AS Supplier,
  APARAction.disputecasecreationmode AS DisputeCaseCreationMode,
  APARAction.specialglcode AS SpecialGLCode,
  APARAction.processingruleitemdebitamount AS ProcessingRuleItemDebitAmount,
  APARAction.processingruleitemcreditamount AS ProcessingRuleItemCreditAmount,
  APARAction.procgruleitemamountpercent AS ProcgRuleItemAmountPercent,
  APARAction.glaccount AS GLAccount
FROM far_pstrl_aapar AS APARAction
LEFT OUTER JOIN I_DisputeCaseCreationModeText AS _DisputeCaseCreationMode ON DisputeCaseCreationMode = _DisputeCaseCreationMode.DisputeCaseCreationMode  -- association [0..*]
LEFT OUTER JOIN I_SpecialGLCodeText AS _SpecialGLCode ON FinancialAccountType= _SpecialGLCode.FinancialAccountType AND SpecialGLCode = _SpecialGLCode.SpecialGLCode  -- association [0..*]
;

Learn More