Deprecated
This CDS view is deprecated in S/4HANA. Use I_LoanContrPlndItmData instead. View all deprecated CDS views →

I_LoanContrPlndItm

DDL: I_LOANCONTRPLNDITM Type: view BASIC
25 Fields 1 Data Sources 3 Associations

Planned Items for Loan Contract

I_LoanContrPlndItm (Basic)

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

Cross Applications

I_LoanContrPlndItm is a Basic CDS View (Cube) that provides data about "Planned Items for Loan Contract" in SAP S/4HANA. It reads from 1 data source (vdbepp) and exposes 25 fields with key fields CompanyCode, LoanContractID, CashFlowItemGenerationDate, CashFlowItemGenerationTime, CashFlowItemSequenceNumber. It has 3 associations to related views.

SAP API Hub

StateDeprecated
Line of BusinessCross Applications
Application ComponentFS-CML
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
vdbepp vdbepp from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_LoanContrBP _LoanContrBP $projection.CompanyCode = _LoanContrBP.CompanyCode and $projection.LoanContractID = _LoanContrBP.LoanContractID
[0..1] I_Currency _SettlementCurrency $projection.CashFlowItemSettlementCurrency = _SettlementCurrency.Currency
[0..1] I_Currency _PositionCurrency $projection.CashFlowItemPositionCurrency = _PositionCurrency.Currency

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ILCPLNDITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality B view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_LoanContrPlndItmData view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label Planned Items for Loan Contract view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vdbepp bukrs Company Code
KEY LoanContractID vdbepp ranl Treasury ID No.
KEY CashFlowItemGenerationDate vdbepp dtrans Flow data key: System date
KEY CashFlowItemGenerationTime vdbepp ttrans Transaction data key: system time
KEY CashFlowItemSequenceNumber vdbepp ntrans Transaction data key: Consecutive number
CashFlowItemSource vdbepp swoher Source of flow record
CashFlowItemCategory vdbepp sbewziti Flow Category
CashFlowItemDueDate vdbepp dfaell Due date/calculation date
CashFlowItemPaymentDate vdbepp ddispo Payment date
CashFlowItemPercentageRate vdbepp pkond Percentage rate for condition items
CalculationPeriodStartDate vdbepp dbervon Start of Calculation Period
CalcPeriodStartDateIsExclusive vdbepp sexclvon Exclusive Indicator for the Start of a Calculation Period
CalculationPeriodEndDate vdbepp dberbis End of Calculation Period
CalcPeriodEndDateIsInclusive vdbepp sinclbis Inclusive Indicator for the End of a Calculation Period
LoanCshFlwItmIntrstFixingDte vdbepp dzfest Interest rate fixing date
CashFlowItemType vdbepp sbewart Flow Type
LoanCshFlwItmCalcDte vdbepp dvalut Calculation Date
CashFlowItemPostingDirection vdbepp ssolhab Debit/credit indicator
CashFlowItemSettlementCurrency vdbepp scwhr Settlement Currency
CshFlwItmAmtInSettlmtCrcy vdbepp bcwhr Settlement Amount
CashFlowItemPositionCurrency vdbepp sbwhr Position Currency (Currency of Position Amount)
CshFlwItmAmtInPosCrcy vdbepp bbwhr Amount in Position Currency
_LoanContrBP _LoanContrBP
_SettlementCurrency _SettlementCurrency
_PositionCurrency _PositionCurrency

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_LoanContrPlndItm.
-- 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_LoanContrPlndItm AS
SELECT
  vdbepp.bukrs AS CompanyCode,
  vdbepp.ranl AS LoanContractID,
  vdbepp.dtrans AS CashFlowItemGenerationDate,
  vdbepp.ttrans AS CashFlowItemGenerationTime,
  vdbepp.ntrans AS CashFlowItemSequenceNumber,
  vdbepp.swoher AS CashFlowItemSource,
  vdbepp.sbewziti AS CashFlowItemCategory,
  vdbepp.dfaell AS CashFlowItemDueDate,
  vdbepp.ddispo AS CashFlowItemPaymentDate,
  vdbepp.pkond AS CashFlowItemPercentageRate,
  vdbepp.dbervon AS CalculationPeriodStartDate,
  vdbepp.sexclvon AS CalcPeriodStartDateIsExclusive,
  vdbepp.dberbis AS CalculationPeriodEndDate,
  vdbepp.sinclbis AS CalcPeriodEndDateIsInclusive,
  vdbepp.dzfest AS LoanCshFlwItmIntrstFixingDte,
  vdbepp.sbewart AS CashFlowItemType,
  vdbepp.dvalut AS LoanCshFlwItmCalcDte,
  vdbepp.ssolhab AS CashFlowItemPostingDirection,
  vdbepp.scwhr AS CashFlowItemSettlementCurrency,
  vdbepp.bcwhr AS CshFlwItmAmtInSettlmtCrcy,
  vdbepp.sbwhr AS CashFlowItemPositionCurrency,
  vdbepp.bbwhr AS CshFlwItmAmtInPosCrcy
FROM vdbepp
LEFT OUTER JOIN I_LoanContrBP AS _LoanContrBP ON CompanyCode = _LoanContrBP.CompanyCode AND LoanContractID = _LoanContrBP.LoanContractID  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _SettlementCurrency ON CashFlowItemSettlementCurrency = _SettlementCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PositionCurrency ON CashFlowItemPositionCurrency = _PositionCurrency.Currency  -- association [0..1]
;

Learn More