C_PaymentFormatCompareLogDet

DDL: C_PAYMENTFORMATCOMPARELOGDET Type: view_entity CONSUMPTION
13 Fields 1 Data Sources 1 Associations

Payment Format Compare Log Detail

C_PaymentFormatCompareLogDet is a Consumption CDS View that provides data about "Payment Format Compare Log Detail" in SAP S/4HANA. It reads from 1 data source (I_DataMdmExchCompareLogDet) and exposes 13 fields with key fields HierarchyTreeType, HierarchyTree, HierarchyNode, HierarchyNodeChangeType, HierarchyNodeDetailChangeType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DataMdmExchCompareLogDet I_DataMdmExchCompareLogDet from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_PaymentFormatCompareLog _Log _Log.HierarchyTreeType = $projection.HierarchyTreeType and _Log.HierarchyTree = $projection.HierarchyTree and _Log.HierarchyNode = $projection.HierarchyNode and _Log.HierarchyNodeChangeType = $projection.HierarchyNodeChangeType

Annotations (6)

NameValueLevelField
EndUserText.label Payment Format Compare Log Detail view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTreeType HierarchyTreeType Mapping Type ID
KEY HierarchyTree HierarchyTree Format Mapping Name
KEY HierarchyNode HierarchyNode Node
KEY HierarchyNodeChangeType HierarchyNodeChangeType Change type
KEY HierarchyNodeDetailChangeType HierarchyNodeDetailChangeType
KEY HierarchyNodeAttributeName HierarchyNodeAttributeName Type
CDSViewName CDSViewName CDS View Name
HierarchyNodeSourceValue HierarchyNodeSourceValue Explanation
HierarchyNodeTargetValue HierarchyNodeTargetValue Target Value
HierarchyNodeUsedValueType HierarchyNodeUsedValueType
_HierarchyNodeChangeTypeText _HierarchyNodeChangeTypeText
_HierarchyNodeDetChgTypeText _HierarchyNodeDetChgTypeText
_Log _Log

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 C_PaymentFormatCompareLogDet.
-- 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 C_PaymentFormatCompareLogDet AS
SELECT
  HierarchyTreeType,
  HierarchyTree,
  HierarchyNode,
  HierarchyNodeChangeType,
  HierarchyNodeDetailChangeType,
  HierarchyNodeAttributeName,
  CDSViewName,
  HierarchyNodeSourceValue,
  HierarchyNodeTargetValue,
  HierarchyNodeUsedValueType
FROM I_DataMdmExchCompareLogDet
LEFT OUTER JOIN C_PaymentFormatCompareLog AS _Log ON _Log.HierarchyTreeType = HierarchyTreeType AND _Log.HierarchyTree = HierarchyTree AND _Log.HierarchyNode = HierarchyNode AND _Log.HierarchyNodeChangeType = HierarchyNodeChangeType  -- association [0..1]
;

Learn More