I_LoanContrActlDocHdrData

DDL: I_LOANCONTRACTLDOCHDRDATA Type: view BASIC
23 Fields 1 Data Sources 4 Associations

Actual Document Header for Loan Contract

I_LoanContrActlDocHdrData (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_LoanContrActlDocHdrData is a Basic CDS View (Cube) that provides data about "Actual Document Header for Loan Contract" in SAP S/4HANA. It reads from 1 data source (vdbeki) and exposes 23 fields with key fields CompanyCode, PostedDocumentID. It has 4 associations to related views.

SAP Help Documentation

CategoryNumber Ranges in Loans Management
Data CategoryCube
StatusReleased
Data Extraction TypeDelta enabled
Corresponding DataSourceILCACTDOCHDRD
Purpose
This CDS view provides the prerequisites for answering the following business question: What is the actual document header data in a loan contract?

Prerequisites
You have the following authorizations: To define which business partners can be edited on the basis of the authorization group ( B_BUPA_GRP ) To view, block or unblock a business partner ( B_BUP_PCPT ) To define which BP roles can be edited ( B_BUPA_RLT ) To enter master data for loans for specific company codes ( FD_DAR_BUK ) To process loan master data for specific product types ( FD_DAR_GSA ) To maintain loan master data and order data for specific statuses ( FD_DAR_STA ) To process loan contracts for specific company codes and authorization groups ( FD_DAR_BEG ) To process loans data with specific transactions and specific product categories ( FD_DAR_ACT ) For more information about the authorizations, see the documentation for the related authorization objects.

Structure
Measures and attributes Some important measures and attributes are: CompanyCode PostedDocumentID LoanContractID LoanClassfctnNmbr LoanLifeCycleStatus LoanAcctAssgmtRef CshFlwItmGLAccount LoanBusinessArea CashFlowItemPostingDate CashFlowItemReversalStatus ReverseDocumentReverseDocument WvrWriteoffDocument CshFlwItmTransfToFinAcctgDte CashFlowItemEnteredBy CashFlowItemEnteredDate CashFlowItemEnteredTime CashFlowItemEnteredSource CshFlwItmBusTransNmbr 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

StateC1
Line of BusinessCross Applications
Application ComponentFS-CML
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business question: What is the actual document header data in a loan contract?</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
vdbeki vdbeki from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_LoanContrData _LoanContrData $projection.CompanyCode = _LoanContrData.CompanyCode and _LoanContrData.LoanArchivingCategory = ' ' and $projection.LoanContractID = _LoanContrData.LoanContractID
[0..*] I_LoanContrActlDocItmData _LoanContrActlDocItmData $projection.CompanyCode = _LoanContrActlDocItmData.CompanyCode and $projection.PostedDocumentID = _LoanContrActlDocItmData.PostedDocumentID
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_BusinessArea _BusinessArea $projection.LoanBusinessArea = _BusinessArea.BusinessArea

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ILCACTDOCHDRD view
AbapCatalog.compiler.compareFilter 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 Header for Loan Contract view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vdbeki bukrs Company Code
KEY PostedDocumentID vdbeki rbelkpfd Document Number of Document Header (Loan)
LoanContractID vdbeki ranl Treasury ID No.
LoanClassfctnNmbr vdbeki rklammer Classification Number for Finance Projects
LoanLifeCycleStatus vdbeki sstati Status of data record
LoanAcctAssgmtRef vdbeki rrefkont Account Assignment Reference in Financial Assets Management
CshFlwItmGLAccount vdbeki hkont General Ledger Account
LoanBusinessArea vdbeki gsber Business Area
CashFlowItemPostingDate vdbeki dbudat Posting Date in the Document
CashFlowItemReversalStatus vdbeki sstorno Reversal indicator
ReverseDocument vdbeki rstblg Reverse Document Number
WvrWriteoffDocument vdbeki rzebel Doc.no. of debit pos. doc.header (only for inc.pmnt records)
CshFlwItmTransfToFinAcctgDte vdbeki danfibu Date of transferal to FiAc
CashFlowItemEnteredBy vdbeki rerf Entered By
CashFlowItemEnteredDate vdbeki derf First Entered On
CashFlowItemEnteredTime vdbeki terf Time of Creation
CashFlowItemEnteredSource vdbeki reher Source of Initial Entry
CshFlwItmBusTransNmbr vdbeki rpnnr Daybook no.
AccountingDocument vdbeki ruzbel Document Number of an Accounting Document
_LoanContrData _LoanContrData
_LoanContrActlDocItmData _LoanContrActlDocItmData
_CompanyCode _CompanyCode
_BusinessArea _BusinessArea

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_LoanContrActlDocHdrData.
-- 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_LoanContrActlDocHdrData AS
SELECT
  vdbeki.bukrs AS CompanyCode,
  vdbeki.rbelkpfd AS PostedDocumentID,
  vdbeki.ranl AS LoanContractID,
  vdbeki.rklammer AS LoanClassfctnNmbr,
  vdbeki.sstati AS LoanLifeCycleStatus,
  vdbeki.rrefkont AS LoanAcctAssgmtRef,
  vdbeki.hkont AS CshFlwItmGLAccount,
  vdbeki.gsber AS LoanBusinessArea,
  vdbeki.dbudat AS CashFlowItemPostingDate,
  vdbeki.sstorno AS CashFlowItemReversalStatus,
  vdbeki.rstblg AS ReverseDocument,
  vdbeki.rzebel AS WvrWriteoffDocument,
  vdbeki.danfibu AS CshFlwItmTransfToFinAcctgDte,
  vdbeki.rerf AS CashFlowItemEnteredBy,
  vdbeki.derf AS CashFlowItemEnteredDate,
  vdbeki.terf AS CashFlowItemEnteredTime,
  vdbeki.reher AS CashFlowItemEnteredSource,
  vdbeki.rpnnr AS CshFlwItmBusTransNmbr,
  vdbeki.ruzbel AS AccountingDocument
FROM vdbeki
LEFT OUTER JOIN I_LoanContrData AS _LoanContrData ON CompanyCode = _LoanContrData.CompanyCode AND _LoanContrData.LoanArchivingCategory = ' ' AND LoanContractID = _LoanContrData.LoanContractID  -- association [0..1]
LEFT OUTER JOIN I_LoanContrActlDocItmData AS _LoanContrActlDocItmData ON CompanyCode = _LoanContrActlDocItmData.CompanyCode AND PostedDocumentID = _LoanContrActlDocItmData.PostedDocumentID  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON LoanBusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
;

Learn More