What is I_LoanContrActlDocItmData in SAP S/4HANA?

I_LoanContrActlDocItmData is a basic CDS view in SAP S/4HANA. Actual Document Item for Loan Contract It contains 56 fields.

Which tables does I_LoanContrActlDocItmData read from?

I_LoanContrActlDocItmData reads data from: vdbepi.

What VDM layer is I_LoanContrActlDocItmData?

I_LoanContrActlDocItmData is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_LoanContrActlDocItmData

DDL: I_LOANCONTRACTLDOCITMDATA Type: view BASIC Package: FVVD_VDM

56 Fields 1 Data Sources 9 Associations

Actual Document Item for Loan Contract

I_LoanContrActlDocItmData (Basic)

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

Cross Applications

I_LoanContrActlDocItmData is a Basic CDS View (Cube) that provides data about "Actual Document Item for Loan Contract" in SAP S/4HANA. It reads from 1 data source (vdbepi) and exposes 56 fields with key fields CompanyCode, PostedDocumentID, PostedDocumentActivityNumber. It has 9 associations to related views. Part of development package FVVD_VDM.

SAP Help Documentation

Category	Number Ranges in Loans Management
Data Category	Cube
Status	Released
Data Extraction Type	Delta enabled
Corresponding DataSource	ILCACTDOCITMD

Purpose
This CDS view provides the prerequisites for answering the following business question: What is the actual document item data in a loan contract?

Structure
Measures and attributes Some important measures and attributes are: CompanyCode PostedDocumentID PostedDocumentActivityNumber CashFlowItemType CashFlowItemReferenceType CashFlowItemCategory CashFlowItmNominalAmt CashFlowItmNominalAmtCrcy CshFlwItmAmtInPosCrcy CashFlowItemPositionCurrency CshFlwItmAmtInSettlmtCrcy CashFlowItemSettlementCurrency CashFlowItemCalcDate CashFlowItemDueDate CashFlowItemPaymentDate CalculationPeriodStartDate CashFlowItemPostingDirection CashFlowItemPercentageRate CalculationPeriodEndDate CashFlowItemGenerationDate CashFlowItemGenerationTime CashFlowItemSequenceNumber FinConditionConditionType LoanMainBrwrCustNmbr AccountingDocument

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

Category	Basic
State	C1
Line of Business	Cross Applications
Application Component	FS-CML
Capabilities	Data Source for Data Extraction,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Cross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
vdbepi	vdbepi	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	I_LoanContrActlDocHdrData	_LoanContrActlDocHdrData	`$projection.CompanyCode = _LoanContrActlDocHdrData.CompanyCode and $projection.PostedDocumentID = _LoanContrActlDocHdrData.PostedDocumentID`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_Currency	_SettlementCurrency	`$projection.CashFlowItemSettlementCurrency = _SettlementCurrency.Currency`
[0..1]	I_Currency	_PositionCurrency	`$projection.CashFlowItemPositionCurrency = _PositionCurrency.Currency`
[0..1]	I_Currency	_NominalCurrency	`$projection.CashFlowItmNominalAmtCrcy = _NominalCurrency.Currency`
[0..1]	I_BusinessArea	_BusinessArea	`$projection.LoanBusinessArea = _BusinessArea.BusinessArea`
[0..1]	I_FinCndnConditionType	_FinCndnConditionType	`$projection.FinConditionConditionType = _FinCndnConditionType.FinConditionConditionType and _FinCndnConditionType.TreasuryContractType = '1'`
[0..1]	I_Customer	_Customer	`$projection.LoanMainBrwrCustNmbr = _Customer.Customer`
[0..1]	I_LoanCshFlwItmActivityCat	_LoanCshFlwItmActivityCat	`$projection.LoanCshFlwItmActivityCat = _LoanCshFlwItmActivityCat.LoanCshFlwItmActivityCat`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	ILCACTDOCITMD	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ObjectModel.usageType.serviceQuality	A	view
ObjectModel.usageType.sizeCategory	XL	view
ObjectModel.usageType.dataClass	TRANSACTIONAL	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
Analytics.internalName	#LOCAL	view
Analytics.dataCategory	#CUBE	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.changeDataCapture.automatic	true	view
VDM.viewType	#BASIC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Actual Document Item for Loan Contract	view

Fields (56)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	vdbepi	bukrs	Company Code
KEY	PostedDocumentID	vdbepi	rbelkpfd	Document Number of Document Header (Loan)
KEY	PostedDocumentActivityNumber	vdbepi	rposnr	Activity number
	CashFlowItemType	vdbepi	sbewart	Flow Type
	CashFlowItemReferenceType	vdbepi	srefbew	Reference flow type
	CashFlowItemCategory	vdbepi	sbewziti	Flow Category
	CashFlowItmNominalAmt	vdbepi	bnwhr	Nominal amount
	CashFlowItmNominalAmtCrcy	vdbepi	snwhr	Currency of nominal amount
	CshFlwItmAmtInPosCrcy	vdbepi	bbwhr	Amount in Position Currency
	CashFlowItemPositionCurrency	vdbepi	sbwhr	Position Currency (Currency of Position Amount)
	CshFlwItmAmtInSettlmtCrcy	vdbepi	bcwhr	Settlement Amount
	CashFlowItemSettlementCurrency	vdbepi	scwhr	Settlement Currency
	CashFlowItemCalcDate	vdbepi	dvalut	Calculation Date
	CashFlowItemDueDate	vdbepi	dfaell	Due Date
	CashFlowItemPaymentDate	vdbepi	ddispo	Payment date
	CalculationPeriodStartDate	vdbepi	dbervon	Start of Calculation Period
	CashFlowItemPostingDirection	vdbepi	ssolhab	Debit/credit indicator
	CshFlwItmDebitPostgAcct	vdbepi	rsoll	Account for debit posting
	CshFlwItmCreditPostgAcct	vdbepi	rhaben	Account for credit posting
	CashFlowItemPercentageRate	vdbepi	pkond	Percentage rate for condition items
	CashFlowItemSource	vdbepi	swoher	Source of flow record
	CalculationPeriodEndDate	vdbepi	dberbis	End of Calculation Period
	CashFlowItemGenerationDate	vdbepi	dtrans	Flow data key: System date
	CashFlowItemGenerationTime	vdbepi	ttrans	Transaction data key: system time
	CashFlowItemSequenceNumber	vdbepi	ntrans	Transaction data key: Consecutive number
	LoanBusinessArea	vdbepi	gsber	Business Area
	FinConditionConditionType	vdbepi	skoart	Condition Type (Smallest Subdivision of Condition Records)
	CalcPeriodStartDateIsExclusive	vdbepi	sexclvon	Exclusive Indicator for the Start of a Calculation Period
	CalcPeriodEndDateIsInclusive	vdbepi	sinclbis	Inclusive Indicator for the End of a Calculation Period
	CalcEndDteIsInclusive	vdbepi	sincl	Inclusive Indicator for Beginning and End of a Period
	CshFlwItmSettlementDate	vdbepi	dverrech	Settlement date
	CshFlwItmClrgDteIsInclusive	vdbepi	sinclverr	Inclusive Indicator for Clearing Date
	AccrDefrlRefFlwCat	vdbepi	srefziti	Refer.flow category in accrual/deferral flow records
	DebitCrdtCtrlActyType	vdbepi	svorgkz	Activity indicator for debit/credit control
	CashFlowItemEnteredBy	vdbepi	rerf	Entered By
	CashFlowItemEnteredDate	vdbepi	derf	First Entered On
	CashFlowItemEnteredTime	vdbepi	terf	Time of Creation
	CashFlowItemEnteredSource	vdbepi	reher	Source of Initial Entry
	CashFlowItemEditedBy	vdbepi	rbear	Last Changed By
	CashFlowItemEditedDate	vdbepi	dbear	Last Processing
	CashFlowItemEditedTime	vdbepi	tbear	Last Edited At
	CashFlowItemEditedSource	vdbepi	rbher	Editing Source
	LoanMainBrwrCustNmbr	vdbepi	hdn_kunnr	Main Borrower Customer Number
	AccountingDocument	vdbepi	ruzbel	Document Number of an Accounting Document
	LoanCshFlwItmActivityCat	vdbepi	vorgtyp	Activity Category (Posting Area)
	CshFlwItmDirectionOfFlow	vdbepi	ssign	Direction of Flow
	CashFlowItemBillDueDate	vdbepi	bill_due_date	Due Date for Bill
	_LoanContrActlDocHdrData		_LoanContrActlDocHdrData
	_CompanyCode		_CompanyCode
	_SettlementCurrency		_SettlementCurrency
	_PositionCurrency		_PositionCurrency
	_NominalCurrency		_NominalCurrency
	_BusinessArea		_BusinessArea
	_FinCndnConditionType		_FinCndnConditionType
	_Customer		_Customer
	_LoanCshFlwItmActivityCat		_LoanCshFlwItmActivityCat

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_LoanContrActlDocItmData.
-- 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_LoanContrActlDocItmData AS
SELECT
  vdbepi.bukrs AS CompanyCode,
  vdbepi.rbelkpfd AS PostedDocumentID,
  vdbepi.rposnr AS PostedDocumentActivityNumber,
  vdbepi.sbewart AS CashFlowItemType,
  vdbepi.srefbew AS CashFlowItemReferenceType,
  vdbepi.sbewziti AS CashFlowItemCategory,
  vdbepi.bnwhr AS CashFlowItmNominalAmt,
  vdbepi.snwhr AS CashFlowItmNominalAmtCrcy,
  vdbepi.bbwhr AS CshFlwItmAmtInPosCrcy,
  vdbepi.sbwhr AS CashFlowItemPositionCurrency,
  vdbepi.bcwhr AS CshFlwItmAmtInSettlmtCrcy,
  vdbepi.scwhr AS CashFlowItemSettlementCurrency,
  vdbepi.dvalut AS CashFlowItemCalcDate,
  vdbepi.dfaell AS CashFlowItemDueDate,
  vdbepi.ddispo AS CashFlowItemPaymentDate,
  vdbepi.dbervon AS CalculationPeriodStartDate,
  vdbepi.ssolhab AS CashFlowItemPostingDirection,
  vdbepi.rsoll AS CshFlwItmDebitPostgAcct,
  vdbepi.rhaben AS CshFlwItmCreditPostgAcct,
  vdbepi.pkond AS CashFlowItemPercentageRate,
  vdbepi.swoher AS CashFlowItemSource,
  vdbepi.dberbis AS CalculationPeriodEndDate,
  vdbepi.dtrans AS CashFlowItemGenerationDate,
  vdbepi.ttrans AS CashFlowItemGenerationTime,
  vdbepi.ntrans AS CashFlowItemSequenceNumber,
  vdbepi.gsber AS LoanBusinessArea,
  vdbepi.skoart AS FinConditionConditionType,
  vdbepi.sexclvon AS CalcPeriodStartDateIsExclusive,
  vdbepi.sinclbis AS CalcPeriodEndDateIsInclusive,
  vdbepi.sincl AS CalcEndDteIsInclusive,
  vdbepi.dverrech AS CshFlwItmSettlementDate,
  vdbepi.sinclverr AS CshFlwItmClrgDteIsInclusive,
  vdbepi.srefziti AS AccrDefrlRefFlwCat,
  vdbepi.svorgkz AS DebitCrdtCtrlActyType,
  vdbepi.rerf AS CashFlowItemEnteredBy,
  vdbepi.derf AS CashFlowItemEnteredDate,
  vdbepi.terf AS CashFlowItemEnteredTime,
  vdbepi.reher AS CashFlowItemEnteredSource,
  vdbepi.rbear AS CashFlowItemEditedBy,
  vdbepi.dbear AS CashFlowItemEditedDate,
  vdbepi.tbear AS CashFlowItemEditedTime,
  vdbepi.rbher AS CashFlowItemEditedSource,
  vdbepi.hdn_kunnr AS LoanMainBrwrCustNmbr,
  vdbepi.ruzbel AS AccountingDocument,
  vdbepi.vorgtyp AS LoanCshFlwItmActivityCat,
  vdbepi.ssign AS CshFlwItmDirectionOfFlow,
  vdbepi.bill_due_date AS CashFlowItemBillDueDate
FROM vdbepi
LEFT OUTER JOIN I_LoanContrActlDocHdrData AS _LoanContrActlDocHdrData ON CompanyCode = _LoanContrActlDocHdrData.CompanyCode AND PostedDocumentID = _LoanContrActlDocHdrData.PostedDocumentID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..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]
LEFT OUTER JOIN I_Currency AS _NominalCurrency ON CashFlowItmNominalAmtCrcy = _NominalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON LoanBusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FinCndnConditionType AS _FinCndnConditionType ON FinConditionConditionType = _FinCndnConditionType.FinConditionConditionType AND _FinCndnConditionType.TreasuryContractType = '1'  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON LoanMainBrwrCustNmbr = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_LoanCshFlwItmActivityCat AS _LoanCshFlwItmActivityCat ON LoanCshFlwItmActivityCat = _LoanCshFlwItmActivityCat.LoanCshFlwItmActivityCat  -- association [0..1]
;

Depth:

I_LoanContrActlDocItmData view

vdbepi