R_ConsolidationPostingRuleTP

DDL: R_CONSOLIDATIONPOSTINGRULETP Type: view_entity TRANSACTIONAL
34 Fields 1 Data Sources 12 Associations

Posting Rule - TP

R_ConsolidationPostingRuleTP is a Transactional CDS View that provides data about "Posting Rule - TP" in SAP S/4HANA. It reads from 1 data source (I_ConsolidationPostingRule) and exposes 34 fields with key field ConsolidationPostingRule. It has 12 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ConsolidationPostingRule I_ConsolidationPostingRule from

Associations (12)

CardinalityTargetAliasCondition
[0..1] I_ConsolidationPostingRuleText _Description $projection.ConsolidationPostingRule = _Description.ConsolidationPostingRule and _Description.Language = $session.system_language
[0..1] I_CnsldtnChartOfAccountsT _ChartOfAccountsText $projection.ConsolidationChartOfAccounts = _ChartOfAccountsText.ConsolidationChartOfAccounts and _ChartOfAccountsText.Language = $session.system_language
[0..*] I_CnsldtnPostingRuleTypeVH _CnsldtnPostingRuleTypeVH _CnsldtnPostingRuleTypeVH.ConsolidationPostingRuleType = $projection.ConsolidationPostingRuleType
[0..*] I_CnsldtnPostingRuleStatusVH _CnsldtnPostingRuleStatusVH _CnsldtnPostingRuleStatusVH.ConsolidationPostingRuleStatus = $projection.ConsolidationPostingRuleStatus
[0..*] I_CnsldtnPstRlSelFieldModeVH _CnsldtnPstRlSelFieldModeVH _CnsldtnPstRlSelFieldModeVH.CnsldtnPstRlSelectionFieldMode = $projection.CnsldtnPstRlSelectionFieldMode
[0..*] I_CnsldtnPstRlPerdSelSourceVH _CnsldtnPstRlPerdSelSourceVH _CnsldtnPstRlPerdSelSourceVH.CnsldtnPstRlPerdSelSource = $projection.CnsldtnPstRlPerdSelSource
[0..1] I_CnsldtnPstRlSelectionVH _CnsldtnPstRlSelectionVH _CnsldtnPstRlSelectionVH.ConsolidationSelection = $projection.ConsolidationSelection
[0..1] I_CnsldtnPstRlTypeDocType _CnsldtnPstRlTypeDocTypeVH _CnsldtnPstRlTypeDocTypeVH.ConsolidationDocumentType = $projection.ConsolidationDocumentType and _CnsldtnPstRlTypeDocTypeVH.ConsolidationPostingRuleType = $projection.ConsolidationPostingRuleType
[0..1] I_CnsldtnChartOfAccounts _ChartOfAccounts $projection.ConsolidationChartOfAccounts = _ChartOfAccounts.ConsolidationChartOfAccounts
[0..*] R_CnsldtnPstRlPostingLineTP _PostingLine
[0..*] R_CnsldtnPstRlSelectionFieldTP _SelectionField
[0..*] R_CnsldtnPostingRuleTextTP _Text

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Posting Rule - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name ConsolidationPostingRule view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationPostingRule ConsolidationPostingRule Rule ID
ConsolidationPostingRuleText _Description ConsolidationPostingRuleText
CnsldtnPostingRuleLongText _Description CnsldtnPostingRuleLongText
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
ConsolidationChartOfAcctsText _ChartOfAccountsText ConsolidationChartOfAcctsText Description
ConsolidationPostingRuleType ConsolidationPostingRuleType Rule Type
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
ChangedBy ChangedBy User Name
ChangedDateTime ChangedDateTime Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
ConsolidationPostingRuleStatus ConsolidationPostingRuleStatus Workflow Status
ConsolidationDocumentType ConsolidationDocumentType Document Type
CnsldtnPstRlDocTypeMappingMode CnsldtnPstRlDocTypeMappingMode
CnsldtnPostingIsInLocalCrcy CnsldtnPostingIsInLocalCrcy
CnsldtnPostingIsInTransCrcy CnsldtnPostingIsInTransCrcy
CnsldtnPostingIsInGroupCrcy CnsldtnPostingIsInGroupCrcy
CnsldtnPostingIsWithQuantities CnsldtnPostingIsWithQuantities
ConsolidationSelection ConsolidationSelection
CnsldtnPstRlSelectionFieldMode CnsldtnPstRlSelectionFieldMode
CnsldtnPstRlPerdSelSource CnsldtnPstRlPerdSelSource
CnsldtnPostgRulePrtnInclsnMode CnsldtnPostgRulePrtnInclsnMode
_Description _Description
_PostingLine _PostingLine
_Text _Text
_SelectionField _SelectionField
_ChartOfAccountsText _ChartOfAccountsText
_CnsldtnPostingRuleTypeVH _CnsldtnPostingRuleTypeVH
_CnsldtnPostingRuleStatusVH _CnsldtnPostingRuleStatusVH
_CnsldtnPstRlSelFieldModeVH _CnsldtnPstRlSelFieldModeVH
_CnsldtnPstRlPerdSelSourceVH _CnsldtnPstRlPerdSelSourceVH
_CnsldtnPstRlSelectionVH _CnsldtnPstRlSelectionVH
_CnsldtnPstRlTypeDocTypeVH _CnsldtnPstRlTypeDocTypeVH
_ChartOfAccounts _ChartOfAccounts

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 R_ConsolidationPostingRuleTP.
-- 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 R_ConsolidationPostingRuleTP AS
SELECT
  ConsolidationPostingRule,
  _Description.ConsolidationPostingRuleText AS ConsolidationPostingRuleText,
  _Description.CnsldtnPostingRuleLongText AS CnsldtnPostingRuleLongText,
  ConsolidationChartOfAccounts,
  _ChartOfAccountsText.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  ConsolidationPostingRuleType,
  CreatedByUser,
  CreationDateTime,
  ChangedBy,
  ChangedDateTime,
  LastChangeDateTime,
  ConsolidationPostingRuleStatus,
  ConsolidationDocumentType,
  CnsldtnPstRlDocTypeMappingMode,
  CnsldtnPostingIsInLocalCrcy,
  CnsldtnPostingIsInTransCrcy,
  CnsldtnPostingIsInGroupCrcy,
  CnsldtnPostingIsWithQuantities,
  ConsolidationSelection,
  CnsldtnPstRlSelectionFieldMode,
  CnsldtnPstRlPerdSelSource,
  CnsldtnPostgRulePrtnInclsnMode
FROM I_ConsolidationPostingRule
LEFT OUTER JOIN I_ConsolidationPostingRuleText AS _Description ON ConsolidationPostingRule = _Description.ConsolidationPostingRule AND _Description.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccountsT AS _ChartOfAccountsText ON ConsolidationChartOfAccounts = _ChartOfAccountsText.ConsolidationChartOfAccounts AND _ChartOfAccountsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnPostingRuleTypeVH AS _CnsldtnPostingRuleTypeVH ON _CnsldtnPostingRuleTypeVH.ConsolidationPostingRuleType = ConsolidationPostingRuleType  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnPostingRuleStatusVH AS _CnsldtnPostingRuleStatusVH ON _CnsldtnPostingRuleStatusVH.ConsolidationPostingRuleStatus = ConsolidationPostingRuleStatus  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnPstRlSelFieldModeVH AS _CnsldtnPstRlSelFieldModeVH ON _CnsldtnPstRlSelFieldModeVH.CnsldtnPstRlSelectionFieldMode = CnsldtnPstRlSelectionFieldMode  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnPstRlPerdSelSourceVH AS _CnsldtnPstRlPerdSelSourceVH ON _CnsldtnPstRlPerdSelSourceVH.CnsldtnPstRlPerdSelSource = CnsldtnPstRlPerdSelSource  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnPstRlSelectionVH AS _CnsldtnPstRlSelectionVH ON _CnsldtnPstRlSelectionVH.ConsolidationSelection = ConsolidationSelection  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnPstRlTypeDocType AS _CnsldtnPstRlTypeDocTypeVH ON _CnsldtnPstRlTypeDocTypeVH.ConsolidationDocumentType = ConsolidationDocumentType AND _CnsldtnPstRlTypeDocTypeVH.ConsolidationPostingRuleType = ConsolidationPostingRuleType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ChartOfAccounts ON ConsolidationChartOfAccounts = _ChartOfAccounts.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN R_CnsldtnPstRlPostingLineTP AS _PostingLine ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CnsldtnPstRlSelectionFieldTP AS _SelectionField ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CnsldtnPostingRuleTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More