C_PaytFrmtTreePrpty

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_PaytFrmtTreePrpty.
-- 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_PaytFrmtTreePrpty 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,
  XMLEmptyElementProcessingType,
  HierTreeSpclCharHndlgOptions,
  HierTreeSpclCharRegularExprVal,
  XMLSchemaDefinitionIdentifier,
  HierarchyTreeDetailedText,
  cast(' ' as dme_iscustpartree preserving type) AS IsCustomerHierarchyParentTree,
  cast(' ' as dme_paymentformat) AS PaymentMediumFormat,
  cast(' ' as dme_paymentformatdesc) AS PaymentMediumFormatDescription
FROM I_DataMdmExchTreePrpty
LEFT OUTER JOIN C_PaytFrmtNode AS _TreeNode ON _TreeNode.HierarchyTreeType = HierarchyTreeType AND _TreeNode.HierarchyTree = HierarchyTree AND _TreeNode.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN C_PaytFrmtTreeLevel AS _TreeLevel ON _TreeLevel.HierarchyTreeType = HierarchyTreeType AND _TreeLevel.HierarchyTree = HierarchyTree AND _TreeLevel.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN C_PaytFrmtDataSorting AS _TreeDataSorting ON _TreeDataSorting.HierarchyTreeType = HierarchyTreeType AND _TreeDataSorting.HierarchyTree = HierarchyTree AND _TreeDataSorting.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN C_PaytFrmtTreeSheet AS _TreeSheet ON _TreeSheet.HierarchyTreeType = HierarchyTreeType AND _TreeSheet.HierarchyTree = HierarchyTree AND _TreeSheet.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN C_PaytFrmtTreeFunc AS _TreeFunction ON _TreeFunction.HierarchyTreeType = HierarchyTreeType AND _TreeFunction.HierarchyTree = HierarchyTree AND _TreeFunction.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN C_PaytFrmtTreeVarbl AS _TreeVariable ON _TreeVariable.HierarchyTreeType = HierarchyTreeType AND _TreeVariable.HierarchyTree = HierarchyTree AND _TreeVariable.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
;