I_IncgFrmtCustVersionTP

DDL: I_INCGFRMTCUSTVERSIONTP Type: view_entity TRANSACTIONAL
19 Fields 1 Data Sources 7 Associations

Incoming Format Customer Version - TP

I_IncgFrmtCustVersionTP is a Transactional CDS View that provides data about "Incoming Format Customer Version - TP" in SAP S/4HANA. It reads from 1 data source (I_IncgFrmtCustVersion) and exposes 19 fields with key fields HierarchyTreeType, HierarchyTree, HierarchyTreeVersion. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_IncgFrmtCustVersion Version from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_IncgFrmtCust _FormatMapping _FormatMapping.HierarchyTreeType = $projection.HierarchyTreeType and _FormatMapping.HierarchyTree = $projection.HierarchyTree
[1..1] I_IncgFrmtType _FormatType _FormatType.HierarchyTreeType = $projection.HierarchyTreeType
[0..*] I_IncgFrmtCustNodeTP _Node
[0..*] I_IncgFrmtCustEnumtnTP _Enumeration
[0..*] I_IncgFrmtCustConstantTP _Constant
[0..*] I_IncgFrmtCustVariableTP _Variable
[0..*] I_IncgFrmtCustFlatFileAttribTP _FlatFileAttribute

Annotations (8)

NameValueLevelField
EndUserText.label Incoming Format Customer Version - TP 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 (19)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTreeType HierarchyTreeType Mapping Type ID
KEY HierarchyTree HierarchyTree Format Mapping Name
KEY HierarchyTreeVersion HierarchyTreeVersion Format Mapping Version
HierarchyTreeVersionShortText HierarchyTreeVersionShortText Description
LastChangeDateTime LastChangeDateTime Timestamp
LastChangeByUser LastChangeByUser User Name
DataReleaseRequestID DataReleaseRequestID Request ID
ParentVersionDateTime ParentVersionDateTime Parent Version Timestamp
HierarchyTreeVersionType HierarchyTreeVersionType Version Type
CreationDateTime _FormatMapping CreationDateTime Timestamp
CreatedByUser _FormatMapping CreatedByUser User Name
InputFileFormat _FormatMapping InputFileFormat Data Format
HierarchyTreeRedefinitionLevel _FormatMapping HierarchyTreeRedefinitionLevel Tree Redefinition Level
HierarchyParentTree _FormatMapping HierarchyParentTree Parent Tree
_Node _Node
_Enumeration _Enumeration
_Constant _Constant
_Variable _Variable
_FlatFileAttribute _FlatFileAttribute

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_IncgFrmtCustVersionTP.
-- 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_IncgFrmtCustVersionTP AS
SELECT
  HierarchyTreeType,
  HierarchyTree,
  HierarchyTreeVersion,
  HierarchyTreeVersionShortText,
  LastChangeDateTime,
  LastChangeByUser,
  DataReleaseRequestID,
  ParentVersionDateTime,
  HierarchyTreeVersionType,
  _FormatMapping.CreationDateTime AS CreationDateTime,
  _FormatMapping.CreatedByUser AS CreatedByUser,
  _FormatMapping.InputFileFormat AS InputFileFormat,
  _FormatMapping.HierarchyTreeRedefinitionLevel AS HierarchyTreeRedefinitionLevel,
  _FormatMapping.HierarchyParentTree AS HierarchyParentTree
FROM I_IncgFrmtCustVersion AS Version
LEFT OUTER JOIN I_IncgFrmtCust AS _FormatMapping ON _FormatMapping.HierarchyTreeType = HierarchyTreeType AND _FormatMapping.HierarchyTree = HierarchyTree  -- association [1..1]
LEFT OUTER JOIN I_IncgFrmtType AS _FormatType ON _FormatType.HierarchyTreeType = HierarchyTreeType  -- association [1..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeTP AS _Node ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_IncgFrmtCustEnumtnTP AS _Enumeration ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_IncgFrmtCustConstantTP AS _Constant ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_IncgFrmtCustVariableTP AS _Variable ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_IncgFrmtCustFlatFileAttribTP AS _FlatFileAttribute ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More