I_LoanContrChgPointerData

DDL: I_LOANCONTRCHGPOINTERDATA Type: view BASIC
20 Fields 1 Data Sources 7 Associations

Change Pointer for Loan Contract

I_LoanContrChgPointerData (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_LoanContrChgPointerData is a Basic CDS View (Cube) that provides data about "Change Pointer for Loan Contract" in SAP S/4HANA. It reads from 1 data source (vdchgptr) and exposes 20 fields with key field LoanChangePointerUUID. It has 7 associations to related views.

SAP Help Documentation

CategoryChange Pointer for Loan Contract
Data CategoryCube
StatusReleased
Data Extraction TypeDelta enabled
Corresponding DataSourceIILCCHGPTRD
Purpose
This CDS view provides the prerequisites for answering the following business question: What is the change pointer for a loan.

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: LoanChangePointerUUID CompanyCode LoanArchivingCategory LoanContractID LoanChgPointerLastChgDteTme LoanChgPointerChangeCat LoanChgPointerChgSubCat LoanChgPointerEnteredDate LoanChgPointerEnteredTime LoanChgPointerEnteredBy LoanChgPointerEnteredSource LoanChgPointerProcgSts LoanChgPointerProcgGrp

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 change pointer for a loan.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
vdchgptr vdchgptr from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_LoanContrData _LoanContrData $projection.CompanyCode = _LoanContrData.CompanyCode and _LoanContrData.LoanArchivingCategory = ' ' and $projection.LoanContractID = _LoanContrData.LoanContractID
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_LoanArchivingCategory _LoanArchivingCategory $projection.LoanArchivingCategory = _LoanArchivingCategory.LoanArchivingCategory
[0..1] I_LoanChgPointerChangeCat _LoanChgPointerChangeCat $projection.LoanChgPointerChangeCat = _LoanChgPointerChangeCat.LoanChgPointerChangeCat
[0..1] I_LoanChgPointerChgSubCat _LoanChgPointerChgSubCat $projection.LoanChgPointerChangeCat = _LoanChgPointerChgSubCat.LoanChgPointerChangeCat and $projection.LoanChgPointerChgSubCat = _LoanChgPointerChgSubCat.LoanChgPointerChgSubCat
[0..1] I_LoanChgPointerProcgSts _LoanChgPointerProcgSts $projection.LoanChgPointerProcgSts = _LoanChgPointerProcgSts.LoanChgPointerProcgSts
[0..1] I_LoanChgPointerProcgGrp _LoanChgPointerProcgGrp $projection.LoanChgPointerProcgGrp = _LoanChgPointerProcgGrp.LoanChgPointerProcgGrp

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ILCCHGPTRD 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 Change Pointer for Loan Contract view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY LoanChangePointerUUID vdchgptr guid GUID in 'CHAR' Format in Uppercase
CompanyCode vdchgptr bukrs Company Code
LoanArchivingCategory vdchgptr sarchiv Archiving Category Indicator
LoanContractID vdchgptr ranl Treasury ID No.
LoanChgPointerLastChgDteTme vdchgptr timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
LoanChgPointerChangeCat vdchgptr chgcatg Change Category
LoanChgPointerChgSubCat vdchgptr chgcatgsub Change Sub-Category
LoanChgPointerEnteredDate vdchgptr derf First Entered On
LoanChgPointerEnteredTime vdchgptr terf Time of Creation
LoanChgPointerEnteredBy vdchgptr rerf Entered By
LoanChgPointerEnteredSource vdchgptr reher Source of Initial Entry
LoanChgPointerProcgSts vdchgptr ale_process Status of Change Pointer Regarding ALE Processing
LoanChgPointerProcgGrp vdchgptr ale_exp_group ALE Processing Group
_LoanContrData _LoanContrData
_CompanyCode _CompanyCode
_LoanArchivingCategory _LoanArchivingCategory
_LoanChgPointerChangeCat _LoanChgPointerChangeCat
_LoanChgPointerChgSubCat _LoanChgPointerChgSubCat
_LoanChgPointerProcgSts _LoanChgPointerProcgSts
_LoanChgPointerProcgGrp _LoanChgPointerProcgGrp

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_LoanContrChgPointerData.
-- 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_LoanContrChgPointerData AS
SELECT
  vdchgptr.guid AS LoanChangePointerUUID,
  vdchgptr.bukrs AS CompanyCode,
  vdchgptr.sarchiv AS LoanArchivingCategory,
  vdchgptr.ranl AS LoanContractID,
  vdchgptr.timestamp AS LoanChgPointerLastChgDteTme,
  vdchgptr.chgcatg AS LoanChgPointerChangeCat,
  vdchgptr.chgcatgsub AS LoanChgPointerChgSubCat,
  vdchgptr.derf AS LoanChgPointerEnteredDate,
  vdchgptr.terf AS LoanChgPointerEnteredTime,
  vdchgptr.rerf AS LoanChgPointerEnteredBy,
  vdchgptr.reher AS LoanChgPointerEnteredSource,
  vdchgptr.ale_process AS LoanChgPointerProcgSts,
  vdchgptr.ale_exp_group AS LoanChgPointerProcgGrp
FROM vdchgptr
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_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LoanArchivingCategory AS _LoanArchivingCategory ON LoanArchivingCategory = _LoanArchivingCategory.LoanArchivingCategory  -- association [0..1]
LEFT OUTER JOIN I_LoanChgPointerChangeCat AS _LoanChgPointerChangeCat ON LoanChgPointerChangeCat = _LoanChgPointerChangeCat.LoanChgPointerChangeCat  -- association [0..1]
LEFT OUTER JOIN I_LoanChgPointerChgSubCat AS _LoanChgPointerChgSubCat ON LoanChgPointerChangeCat = _LoanChgPointerChgSubCat.LoanChgPointerChangeCat AND LoanChgPointerChgSubCat = _LoanChgPointerChgSubCat.LoanChgPointerChgSubCat  -- association [0..1]
LEFT OUTER JOIN I_LoanChgPointerProcgSts AS _LoanChgPointerProcgSts ON LoanChgPointerProcgSts = _LoanChgPointerProcgSts.LoanChgPointerProcgSts  -- association [0..1]
LEFT OUTER JOIN I_LoanChgPointerProcgGrp AS _LoanChgPointerProcgGrp ON LoanChgPointerProcgGrp = _LoanChgPointerProcgGrp.LoanChgPointerProcgGrp  -- association [0..1]
;

Learn More