I_LoanContrBusPartRelshpData

DDL: I_LOANCONTRBUSPARTRELSHPDATA Type: view BASIC
25 Fields 1 Data Sources 6 Associations

Business Partner relationship data for Loan Contract

I_LoanContrBusPartRelshpData (Basic)

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

LoansMgmtContrBPRelationship · Cross Applications

I_LoanContrBusPartRelshpData is a Basic CDS View (Cube) that provides data about "Business Partner relationship data for Loan Contract" in SAP S/4HANA. It reads from 1 data source (vdgpo) and exposes 25 fields with key fields LoanBPObjectCode, LoanBPObjectInternalKey, BusinessPartner, BusinessPartnerRole, LoanBPObjectGenerationDate. It has 6 associations to related views.

SAP Help Documentation

CategoryCorrespondence
Data CategoryCube
StatusReleased
Data Extraction TypeDelta enabled
Corresponding DataSourceILCBPRELD
Purpose
This CDS view provides the prerequisites for answering the following business question: How is a business partner related to 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: LoanBPObjectCode LoanBPObjectInternalKey BusinessPartner BusinessPartnerRole LoanBPObjectGenerationDate LoanBusPartRelshpStrtDte LoanBusPartRelshpEndDte LoanCorrespncRoleType Customer BPBankAccountInternalID BPPaymentMethod LoanBPDunLetterType LoanBPIsPostDunCharge

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
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction, Data Source for Defining CDS Entities, Data Provider for Analytical Queries
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business question: How is a business partner related to a loan contract?</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
vdgpo vdgpo from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_LoanContrData _LoanContrData $projection.LoanBPObjectInternalKey = _LoanContrData.LoanObjectInternalKey
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_BusinessPartnerRole _BusinessPartnerRole $projection.BusinessPartnerRole = _BusinessPartnerRole.BusinessPartnerRole
[0..1] I_LoanCorrespncRoleType _LoanCorrespncRoleType $projection.LoanCorrespncRoleType = _LoanCorrespncRoleType.LoanCorrespncRoleType
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_LoanBPObjectCode _LoanBPObjectCode $projection.LoanBPObjectCode = _LoanBPObjectCode.LoanBPObjectCode

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ILCBPRELD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ObjectModel.sapObjectNodeType.name LoansMgmtContrBPRelationship 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 Business Partner relationship data for Loan Contract view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY LoanBPObjectCode vdgpo snumobj Key for number range object
KEY LoanBPObjectInternalKey vdgpo sobjekt Internal key for object for business partner table
KEY BusinessPartner vdgpo partnr Business Partner Number
KEY BusinessPartnerRole vdgpo roletyp Role Category
KEY LoanBPObjectGenerationDate vdgpo dtrans Flow data key: System date
LoanBusPartRelshpStrtDte vdgpo dbebez Date of start of relationship
LoanBusPartRelshpEndDte vdgpo denbez Date of end of relationship
LoanCorrespncRoleType vdgpo role CML Correspondence Role Type of Recipient
Customer vdgpo kunnr Customer Number
BPBankAccountInternalID vdgpo bvtyp Partner bank type
BPPaymentMethod vdgpo zlsch Payment Method
LoanBPDunLetterType vdgpo sdunndoc Type of Dunning Letter
LoanBPIsPostDunCharge vdgpo sdunnbuc Post Dunning Charges and Interest to This Partner
LoanBPApplicationCategory vdgpo appl Application Category
LoanBusinessPartnerAddressID vdgpo adr_ref Address ID
LoanBPRelationshipPercent vdgpo pbez Percentage rate of relationship
LoanBPRelationshipAmount vdgpo bbez Relationship amount
LoanBPRelationshipCurrency vdgpo sbbez Currency Key
SEPAMandate vdgpo mndid Unique Reference to Mandate for each Payee
_LoanContrData _LoanContrData
_BusinessPartner _BusinessPartner
_BusinessPartnerRole _BusinessPartnerRole
_LoanCorrespncRoleType _LoanCorrespncRoleType
_Customer _Customer
_LoanBPObjectCode _LoanBPObjectCode

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_LoanContrBusPartRelshpData.
-- 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_LoanContrBusPartRelshpData AS
SELECT
  vdgpo.snumobj AS LoanBPObjectCode,
  vdgpo.sobjekt AS LoanBPObjectInternalKey,
  vdgpo.partnr AS BusinessPartner,
  vdgpo.roletyp AS BusinessPartnerRole,
  vdgpo.dtrans AS LoanBPObjectGenerationDate,
  vdgpo.dbebez AS LoanBusPartRelshpStrtDte,
  vdgpo.denbez AS LoanBusPartRelshpEndDte,
  vdgpo.role AS LoanCorrespncRoleType,
  vdgpo.kunnr AS Customer,
  vdgpo.bvtyp AS BPBankAccountInternalID,
  vdgpo.zlsch AS BPPaymentMethod,
  vdgpo.sdunndoc AS LoanBPDunLetterType,
  vdgpo.sdunnbuc AS LoanBPIsPostDunCharge,
  vdgpo.appl AS LoanBPApplicationCategory,
  vdgpo.adr_ref AS LoanBusinessPartnerAddressID,
  vdgpo.pbez AS LoanBPRelationshipPercent,
  vdgpo.bbez AS LoanBPRelationshipAmount,
  vdgpo.sbbez AS LoanBPRelationshipCurrency,
  vdgpo.mndid AS SEPAMandate
FROM vdgpo
LEFT OUTER JOIN I_LoanContrData AS _LoanContrData ON LoanBPObjectInternalKey = _LoanContrData.LoanObjectInternalKey  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerRole AS _BusinessPartnerRole ON BusinessPartnerRole = _BusinessPartnerRole.BusinessPartnerRole  -- association [0..1]
LEFT OUTER JOIN I_LoanCorrespncRoleType AS _LoanCorrespncRoleType ON LoanCorrespncRoleType = _LoanCorrespncRoleType.LoanCorrespncRoleType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_LoanBPObjectCode AS _LoanBPObjectCode ON LoanBPObjectCode = _LoanBPObjectCode.LoanBPObjectCode  -- association [0..1]
;

Learn More