I_CmtmtItemHierVariantText

DDL: I_CMTMTITEMHIERVARIANTTEXT SQL: ICIHIVT Type: view BASIC
9 Fields 1 Data Sources 4 Associations

Commitment Item Hierarchy Variant Text

I_CmtmtItemHierVariantText is a Basic CDS View that provides data about "Commitment Item Hierarchy Variant Text" in SAP S/4HANA. It reads from 1 data source (fmcivarntt) and exposes 9 fields with key fields Language, FinancialManagementArea, FinMgmtAreaFiscalYear, CommitmentItemHierarchyVariant. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
fmcivarntt fmcivarntt from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_FinancialManagementArea _FinMgmtArea $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea
[1..1] I_FiscalYearForFinMgmtArea _FinMgmtAreaFiscalYear $projection.FinancialManagementArea = _FinMgmtAreaFiscalYear.FinancialManagementArea and $projection.FinMgmtAreaFiscalYear = _FinMgmtAreaFiscalYear.FinMgmtAreaFiscalYear
[1..1] I_CmtmtItemHierVariant _CmtmtItemHierVariant $projection.FinancialManagementArea = _CmtmtItemHierVariant.FinancialManagementArea and $projection.FinMgmtAreaFiscalYear = _CmtmtItemHierVariant.FinMgmtAreaFiscalYear and $projection.CommitmentItemHierarchyVariant = _CmtmtItemHierVariant.CommitmentItemHierarchyVariant

Annotations (11)

NameValueLevelField
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.sqlViewName ICIHIVT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Commitment Item Hierarchy Variant Text view
ObjectModel.representativeKey CommitmentItemHierarchyVariant view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Language fmcivarntt spras Off. Language
KEY FinancialManagementArea fmcivarntt fikrs FM Area
KEY FinMgmtAreaFiscalYear fmcivarntt gjahr Settlement Year
KEY CommitmentItemHierarchyVariant fmcivarntt varnt Variant
CommitmentItemHierVariantName fmcivarntt varnt_txt Name
_Language _Language
_FinMgmtArea _FinMgmtArea
_FinMgmtAreaFiscalYear _FinMgmtAreaFiscalYear
_CmtmtItemHierVariant _CmtmtItemHierVariant

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_CmtmtItemHierVariantText.
-- 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.
-- SQL view name: ICIHIVT

CREATE VIEW I_CmtmtItemHierVariantText AS
SELECT
  fmcivarntt.spras AS Language,
  fmcivarntt.fikrs AS FinancialManagementArea,
  fmcivarntt.gjahr AS FinMgmtAreaFiscalYear,
  fmcivarntt.varnt AS CommitmentItemHierarchyVariant,
  fmcivarntt.varnt_txt AS CommitmentItemHierVariantName
FROM fmcivarntt
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FinMgmtAreaFiscalYear ON FinancialManagementArea = _FinMgmtAreaFiscalYear.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FinMgmtAreaFiscalYear.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_CmtmtItemHierVariant AS _CmtmtItemHierVariant ON FinancialManagementArea = _CmtmtItemHierVariant.FinancialManagementArea AND FinMgmtAreaFiscalYear = _CmtmtItemHierVariant.FinMgmtAreaFiscalYear AND CommitmentItemHierarchyVariant = _CmtmtItemHierVariant.CommitmentItemHierarchyVariant  -- association [1..1]
;

Learn More