I_FixedVariableInterestCat

DDL: I_FIXEDVARIABLEINTERESTCAT Type: view BASIC
2 Fields 1 Data Sources 1 Associations

Fixed Variable Interest Category

I_FixedVariableInterestCat (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_FixedVariableInterestCat is a Basic CDS View (Dimension) that provides data about "Fixed Variable Interest Category" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field FixedVariableInterestRateCat. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for System Data
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the interest category of financial transactions? Whether the interest category of financial transactions is fixed, or variable?

Structure
Object types This view is built on the interest category object type. Measures and attributes The most important measure is interest category.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the interest category of financial transactions?</p></li> <li><p>Whether the interest category of financial transactions is fixed, or variable?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
dd07l DomainValue from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_FixedVariableInterestCatT _Text $projection.FixedVariableInterestRateCat = _Text.FixedVariableInterestRateCat

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IFIXVARINTCAT view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey FixedVariableInterestRateCat view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
EndUserText.label Fixed Variable Interest Category view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY FixedVariableInterestRateCat Interest Rate Category (for Interest Rate Management)
_Text _Text

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_FixedVariableInterestCat.
-- 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_FixedVariableInterestCat AS
SELECT
  cast(left(DomainValue.domvalue_l, 1) as ftr_interest_category preserving type) AS FixedVariableInterestRateCat
FROM dd07l AS DomainValue
LEFT OUTER JOIN I_FixedVariableInterestCatT AS _Text ON FixedVariableInterestRateCat = _Text.FixedVariableInterestRateCat  -- association [0..*]
;

Learn More