I_PaytFrmtCustTreePrptyTP

DDL: I_PAYTFRMTCUSTTREEPRPTYTP Type: view_entity TRANSACTIONAL
44 Fields 1 Data Sources 10 Associations

Payment Format Customer Tree Property

I_PaytFrmtCustTreePrptyTP is a Transactional CDS View that provides data about "Payment Format Customer Tree Property" in SAP S/4HANA. It reads from 1 data source (I_DataMdmExchCustTreePrpty) and exposes 44 fields with key fields HierarchyTreeType, HierarchyTree, HierarchyTreeVersion. It has 10 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DataMdmExchCustTreePrpty I_DataMdmExchCustTreePrpty from

Associations (10)

CardinalityTargetAliasCondition
[0..*] I_PaytFrmtCustNodeCndnTP _TreeCondition _TreeCondition.HierarchyTreeType = $projection.HierarchyTreeType and _TreeCondition.HierarchyTree = $projection.HierarchyTree and _TreeCondition.HierarchyTreeVersion = $projection.HierarchyTreeVersion
[0..*] I_PaytFrmtCustNodeCalcTP _TreeCalculation _TreeCalculation.HierarchyTreeType = $projection.HierarchyTreeType and _TreeCalculation.HierarchyTree = $projection.HierarchyTree and _TreeCalculation.HierarchyTreeVersion = $projection.HierarchyTreeVersion
[0..*] I_PaytFrmtCustNodeAggrgnTP _TreeAggregation _TreeAggregation.HierarchyTreeType = $projection.HierarchyTreeType and _TreeAggregation.HierarchyTree = $projection.HierarchyTree and _TreeAggregation.HierarchyTreeVersion = $projection.HierarchyTreeVersion
[0..1] I_UserContactCard _ChangedByUserContactCard $projection.LastChangedByUser = _ChangedByUserContactCard.ContactCardID
[0..*] I_PaytFrmtCustNodeTP _TreeNode
[0..*] I_PaytFrmtCustTreeLevelTP _TreeLevel
[0..*] I_PaytFrmtCustDataSortingTP _TreeDataSorting
[0..*] I_PaytFrmtCustTreeSheetTP _TreeSheet
[0..*] I_PaytFrmtCustTreeVarblTP _TreeVariable
[0..*] I_PaytFrmtCustTreeFuncTP _TreeFunction

Annotations (8)

NameValueLevelField
EndUserText.label Payment Format Customer Tree Property view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTreeType HierarchyTreeType Mapping Type ID
KEY HierarchyTree HierarchyTree Format Mapping Name
KEY HierarchyTreeVersion HierarchyTreeVersion Format Mapping Version
HierarchyTreeParametersStruc HierarchyTreeParametersStruc Tree Parameters Structure
OutputStructureDelimiterType OutputStructureDelimiterType Output Structure Delimiter Type
SegmentGroupDelimiterCharValue SegmentGroupDelimiterCharValue Segment Group Delimiter Sign
SegmentDelimiterCharacterValue SegmentDelimiterCharacterValue Segment Delimiter Sign
CompositeDelimiterCharValue CompositeDelimiterCharValue Composite Delimiter Sign
DelimiterIsCompressed DelimiterIsCompressed Compress Delimiters
DelimiterEscapeCharacterValue DelimiterEscapeCharacterValue Delimiter Escape Sign
HierarchyRootNode HierarchyRootNode Root Node
SgmtGrpIsCarriageRetSeparated SgmtGrpIsCarriageRetSeparated Segment Group CR Separated
SegmentGrpIsLineFeedSeparated SegmentGrpIsLineFeedSeparated Segment Group LF Separated
SegmentIsCarriageRetSeparated SegmentIsCarriageRetSeparated Segment CR Separated
SegmentIsLineFeedSeparated SegmentIsLineFeedSeparated Segment LF Separated
AccompanyingSheetType AccompanyingSheetType Accompanying Sheet Type
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
SpecialHandlingCharacter SpecialHandlingCharacter Special Handling Character
SpecialHandlingCharacterIsExcl SpecialHandlingCharacterIsExcl Exclude Special Handling Character
PostProcessingProgramName PostProcessingProgramName Program for Post Processing
LengthIsBytes LengthIsBytes Length in Bytes
DataReleaseRequestID DataReleaseRequestID Request ID
HierarchyTreeVersionType HierarchyTreeVersionType Version Type
Status
IsCustomerHierarchyParentTree
PaymentMediumFormat
PaymentMediumFormatDescription
XMLEmptyElementProcessingType XMLEmptyElementProcessingType Empty Element Processing
HierTreeSpclCharHndlgOptions HierTreeSpclCharHndlgOptions Charset Options
HierTreeSpclCharRegularExprVal HierTreeSpclCharRegularExprVal Regex Pattern
XMLSchemaDefinitionIdentifier XMLSchemaDefinitionIdentifier Message Identifier
HierarchyTreeDetailedText HierarchyTreeDetailedText
_TreeNode _TreeNode
_TreeLevel _TreeLevel
_TreeDataSorting _TreeDataSorting
_TreeSheet _TreeSheet
_TreeFunction _TreeFunction
_TreeVariable _TreeVariable
_TreeCondition _TreeCondition
_TreeCalculation _TreeCalculation
_TreeAggregation _TreeAggregation
_ChangedByUserContactCard _ChangedByUserContactCard

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_PaytFrmtCustTreePrptyTP.
-- 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_PaytFrmtCustTreePrptyTP AS
SELECT
  HierarchyTreeType,
  HierarchyTree,
  HierarchyTreeVersion,
  HierarchyTreeParametersStruc,
  OutputStructureDelimiterType,
  SegmentGroupDelimiterCharValue,
  SegmentDelimiterCharacterValue,
  CompositeDelimiterCharValue,
  DelimiterIsCompressed,
  DelimiterEscapeCharacterValue,
  HierarchyRootNode,
  SgmtGrpIsCarriageRetSeparated,
  SegmentGrpIsLineFeedSeparated,
  SegmentIsCarriageRetSeparated,
  SegmentIsLineFeedSeparated,
  AccompanyingSheetType,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  SpecialHandlingCharacter,
  SpecialHandlingCharacterIsExcl,
  PostProcessingProgramName,
  LengthIsBytes,
  DataReleaseRequestID,
  HierarchyTreeVersionType,
  cast(' ' as dme_status) AS Status,
  cast(' ' as dme_iscustpartree) AS IsCustomerHierarchyParentTree,
  cast(' ' as dme_paymentformat) AS PaymentMediumFormat,
  cast(' ' as dme_paymentformatdesc) AS PaymentMediumFormatDescription,
  XMLEmptyElementProcessingType,
  HierTreeSpclCharHndlgOptions,
  HierTreeSpclCharRegularExprVal,
  XMLSchemaDefinitionIdentifier,
  HierarchyTreeDetailedText
FROM I_DataMdmExchCustTreePrpty
LEFT OUTER JOIN I_PaytFrmtCustNodeCndnTP AS _TreeCondition ON _TreeCondition.HierarchyTreeType = HierarchyTreeType AND _TreeCondition.HierarchyTree = HierarchyTree AND _TreeCondition.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN I_PaytFrmtCustNodeCalcTP AS _TreeCalculation ON _TreeCalculation.HierarchyTreeType = HierarchyTreeType AND _TreeCalculation.HierarchyTree = HierarchyTree AND _TreeCalculation.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN I_PaytFrmtCustNodeAggrgnTP AS _TreeAggregation ON _TreeAggregation.HierarchyTreeType = HierarchyTreeType AND _TreeAggregation.HierarchyTree = HierarchyTree AND _TreeAggregation.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByUserContactCard ON LastChangedByUser = _ChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_PaytFrmtCustNodeTP AS _TreeNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_PaytFrmtCustTreeLevelTP AS _TreeLevel ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_PaytFrmtCustDataSortingTP AS _TreeDataSorting ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_PaytFrmtCustTreeSheetTP AS _TreeSheet ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_PaytFrmtCustTreeVarblTP AS _TreeVariable ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_PaytFrmtCustTreeFuncTP AS _TreeFunction ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More