I_LoanContrData

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_LoanContrData.
-- 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_LoanContrData AS
SELECT
  vdarl.bukrs AS CompanyCode,
  vdarl.sarchiv AS LoanArchivingCategory,
  vdarl.ranl AS LoanContractID,
  vdarl.rerf AS LoanContractEnteredBy,
  vdarl.derf AS LoanContractEnteredDate,
  vdarl.terf AS LoanContractEnteredTime,
  vdarl.reher AS LoanContractEnteredSource,
  vdarl.rbear AS LoanContractEditedBy,
  vdarl.dbear AS LoanContractEditedDate,
  vdarl.tbear AS LoanContractEditedTime,
  vdarl.rbher AS LoanContractEditedSource,
  vdarl.sobjekt AS LoanObjectInternalKey,
  vdarl.sstati AS LoanLifeCycleStatus,
  vdarl.sanlf AS LoanProductCategory,
  vdarl.gsart AS LoanProductType,
  vdarl.rrefkont AS LoanAcctAssgmtRef,
  vdarl.hbkid AS HouseBank,
  vdarl.hktid AS HouseBankAccount,
  vdarl.stitel AS LoanType,
  vdarl.sglzb AS StateCntrlBkAstGrp,
  vdarl.sfibg AS FinAcctgAstGrp,
  vdarl.sbilk AS BalanceSheetCode,
  vdarl.xakt AS LoanFileNumber,
  vdarl.ranlalt1 AS LoanAlternativeID1,
  vdarl.ranlalt2 AS LoanAlternativeID2,
  vdarl.sgr1 AS LoanGroupKey1,
  vdarl.sgr2 AS LoanGroupKey2,
  vdarl.rklammer AS LoanClassfctnNmbr,
  vdarl.ranlket AS PrncpLoanInvmtNmbr,
  vdarl.rantrag AS LoanApplicationNumber,
  vdarl.ssolist AS LoanIntrstCalcCptlMeth,
  vdarl.sfrist AS LoanTerm,
  vdarl.bantrag AS LoanCapitalAppliedAmount,
  vdarl.santwhr AS LoanContractCurrency,
  vdarl.dantrag AS LoanApplicationEntryDate,
  vdarl.bzusage AS LoanCommittedCapitalAmount,
  vdarl.dzusage AS LoanCommitmentDate,
  vdarl.dblfz AS LoanTermStartDate,
  vdarl.delfz AS LoanTermEndDate,
  vdarl.svzweck AS LoanPurpose,
  vdarl.ssonder AS LoanSpecialTreatment,
  vdarl.slaender AS LoanCountryID,
  vdarl.snichtab AS LoanNonAccptcRsn,
  vdarl.darchiv AS LoanWithdrawalDate,
  vdarl.sdtyp AS LoanClass,
  vdarl.dbewi AS LoanApprovalDate,
  vdarl.sabt AS LoanAssignmentCreditor,
  vdarl.maber AS DunningArea,
  vdarl.mahns AS DunningLevel,
  vdarl.madat AS LastDunningDate,
  vdarl.sondst AS LoanSpecialPostingType,
  vdarl.sgrp3 AS LoanGroupKey3,
  vdarl.sgrp4 AS LoanGroupKey4,
  vdarl.szkey AS LoanIncgPaytDistrCtrl,
  vdarl.begru AS LoanAuthorizationGroup,
  vdarl.sverfu AS LoanDrwgRestraintType,
  vdarl.stitart AS LoanSecurityType,
  vdarl.rportb AS LoanPortfolioType,
  vdarl.sregion AS LoanSalesRegion,
  vdarl.sgesst AS LoanBranchOffice,
  vdarl.sbea AS LoanProcessingControl,
  vdarl.sobez AS LoanOrganizationalDistrict,
  vdarl.sbezirk AS LoanAgentDistrict,
  vdarl.smahnm AS LoanManualDunLevel,
  vdarl.drueck AS LoanRedeemDate,
  vdarl.sabgrenz AS LoanDiscountMethod,
  vdarl.sfest AS LoanFixedContractControl,
  vdarl.rdarnehm AS BusinessPartner,
  vdarl.objnr AS FinTransObjNmbr,
  vdarl.hdn_kunnr AS LoanMainBrwrCustNmbr,
  vdarl.ranlstamnr AS LoanMasterNumber,
  vdarl.sdunncmp AS LoanDunSmmrzn,
  vdarl.xnodunn AS LoanDunRunIsExclude,
  vdarl.refer AS LoanInternalReference,
  vdarl.merkm AS LoanCharacteristic,
  vdarl.sduncharg AS LoanIsPostDunCharge,
  vdarl.saktpas AS LoanIsLiabilityTransaction,
  vdarl.gsber AS LoanBusinessArea,
  vdarl.jnorepay AS LoanIsPayoffLock,
  vdarl.jnodoip AS LoanIsPOffBlkOpnItmClrg,
  vdarl.com_val_class AS LoanGeneralValuationClass,
  vdarl.paym_status AS LoanPaymentStatus,
  vdarl.sstate_of_exec AS LoanConcludedRegion,
  vdarl.backoffice_id AS LoanBackOffice,
  vdarl.contract_iban AS LoanContractIBAN,
  vdarl.bpca_type_code AS LoanBusProcChnAssgmtType,
  vdarl.bpca_id AS LoanBusProcChnAssgmtID,
  vdarl.xalkz AS LoanReferenceShortText,
  vdarl.xallb AS LoanReferenceLongText,
  vdarl.dzusage_origin AS LoanOriginalApprovalDate,
  vdarl.sdismeth AS LoanDiscountDistributionMethod,
  vdarl.sfiwo AS LoanResidentialFinancingType,
  vdarl.aabtret AS LoanNmbrOfPossibleAssignments,
  vdarl.babtret AS LoanAssignmentsMinimumAmount,
  vdarl.bgesdar AS LoanSyndicatedTotalAmount,
  vdarl.dkons AS LoanSyndicationDate,
  vdarl.jorig AS LoanBorrowersNotePostingType,
  vdarl.vvsloekz AS LoanDeletionIndicatorCode,
  vdarl.sabtrans AS LoanFrgnAssignmentIsPossible,
  vdarl.akons AS LoanNumberOfSyndicateMembers,
  vdarl.sfgkz AS LoanContractReleaseType,
  vdarl.rpnr AS LoanRolloverNumber,
  vdarl.rsbear AS LoanRollOverClerkUserID,
  vdarl.nabtrv AS LoanAssignmentContractNumber,
  vdarl.naval AS LoanGuaranteeNumber,
  vdarl.dabtr AS LoanAssignmentDate,
  vdarl.dverfu AS LoanDrwgRestraintDsplValdToDte,
  vdarl.sfgbew AS LoanTransactionDataReleaseType,
  vdarl.delsoz AS LoanSpclIntrstPaytValidToDate,
  vdarl.split AS LoanPaymentSplittingIsActive,
  vdarl.bnbuerg AS LoanNonGuaranteedCapitalAmount,
  vdarl.srefzins AS LoanHasReferenceInterestRate,
  vdarl.skwg14_neu AS LoanPositionGrouping,
  vdarl.migdate AS LoanMigrationDate,
  vdarl.swhrorg AS LoanCrcyBeforeEuroConversion,
  vdarl.dconvert AS LoanCurrencyEuroConversionDate,
  vdarl.dcorrect AS LoanCrcyEuroCnvrsnAdjmtDate,
  vdarl.sarc_excl AS LoanDocumentArchivingIsLocked,
  vdarl.sarc_docs AS LoanDocumentIsArchived,
  vdarl.no_plan_done AS LoanToCompletedStatusIsBlocked,
  vdarl.dplan_set AS LoanPlannedCompletedStatusDate,
  vdarl.dopen AS LoanContractOpeningDate,
  vdarl.dclose AS LoanContractClosingDate,
  vdarl.dunn_block_till AS LoanDunningLockValidToDate,
  vdarl.xnoioa AS LoanIntrstOnArrsLockedIndCode,
  vdarl.noioa_till AS LoanIntrstOnArrsLockValdToDte,
  vdarl.origin AS LoanOriginType,
  vdarl.sver_excl AS LoanDocSummarizationIsLocked,
  vdarl.lc_disbursement AS LoanDisbursementStatus,
  vdarl.lc_capitals AS LoanCapitalAmountStatus,
  vdarl.lc_planned_flow AS LoanPlannedRecordStatus,
  vdarl.lc_debit AS LoanOpenReceivablesStatus,
  vdarl.lc_credit AS LoanOpenPayablesStatus,
  vdarl.lc_status AS LoanProcgCharacteristicsStatus,
  vdarl.stop_indicator AS LoanStopIndicatorCode,
  vdarl.scheme_id AS LoanIntrstOnArrsCalcProfile,
  vdarl.flg_non_accrual AS LoanNonAccrStatusIsPermitted,
  vdarl.sfima_method AS LoanFinMathConnectionType,
  vdarl.noioa_till_block AS LoanNonIntrstOnArrsValidToDate,
  vdarl.flg_syndicate AS LoanIsSyndicated,
  vdarl.flg_facility AS LoanIsPartOfFacility,
  vdarl.skwg14_open AS LoanPosGrpgOpenLoanCommitment,
  vdarl.flg_addflow AS LoanCrteCustomerFlowsIsActive,
  vdarl.coicode AS ScrtyClCmplmntyIdnCode,
  vdarl.coiland AS ScrtyClCmplmntyIdnCtryReg,
  vdarl.dcac_class AS LoanCrdtAgrmtClassification,
  vdarl.dcac_curr AS LoanCrdtAgrmtPartnerCurrency,
  vdarl.pycur AS LoanAutomaticPaymentCurrency,
  vdarl.contract_bic AS LoanContractSWIFTCode,
  vdarl.iban_det AS LoanContrIBANDeterminationType,
  vdarl.esg_etax_eligible AS LoanTaxReductionIsEligible,
  vdarl.esg_etax_elgblty_perc AS LoanTxnmEligibilityPctgRate,
  vdarl.esg_clim_chng_algnmnt AS LoanClimateNeutralityIsAligned,
  vdarl.esg_env_impct_algnmnt AS LoanEnvrnmtlObjtvsAreAligned,
  vdarl.esg_sust_invst_supprt AS LoanSustblInvmtIsSupported,
  vdarl.esg_lgl_req_comp AS LoanLglRequirementIsCompliant,
  vdarl.esg_ovrll_dnsh_comp AS LoanDoNotSgnftHarmIsCmpant,
  vdarl.esg_green_loan AS LoanIsGreenProject,
  vdarl.esg_econ_actvty AS LoanEconomicActivityType,
  vdarl.saktpas AS LoanAssetLiabilityTransCode
FROM vdarl
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON LoanMainBrwrCustNmbr = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_LoanContrCndnHdrData AS _LoanContrCndnHdrData ON CompanyCode = _LoanContrCndnHdrData.CompanyCode AND LoanContractID = _LoanContrCndnHdrData.LoanContractID  -- association [0..*]
LEFT OUTER JOIN I_LoanContrBusPartRelshpData AS _LoanContrBusPartRelshpData ON LoanObjectInternalKey = _LoanContrBusPartRelshpData.LoanBPObjectInternalKey  -- association [0..*]
LEFT OUTER JOIN I_LoanContrChgPointerData AS _LoanContrChgPointerData ON CompanyCode = _LoanContrChgPointerData.CompanyCode AND LoanArchivingCategory = _LoanContrChgPointerData.LoanArchivingCategory AND LoanContractID = _LoanContrChgPointerData.LoanContractID  -- association [0..*]
LEFT OUTER JOIN I_LoanContrActlDocHdrData AS _LoanContrActlDocHdrData ON CompanyCode = _LoanContrActlDocHdrData.CompanyCode AND LoanContractID = _LoanContrActlDocHdrData.LoanContractID  -- association [0..*]
LEFT OUTER JOIN I_LoanContrPostedItemData AS _LoanContrPostedItemData ON CompanyCode = _LoanContrPostedItemData.CompanyCode AND LoanContractID = _LoanContrPostedItemData.LoanContractID  -- association [0..*]
LEFT OUTER JOIN I_LoanContrPlndItmData AS _LoanContrPlndItmData ON CompanyCode = _LoanContrPlndItmData.CompanyCode AND LoanContractID = _LoanContrPlndItmData.LoanContractID  -- association [0..*]
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_Currency AS _Currency ON LoanContractCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrProdCat AS _FinancialInstrProdCat ON LoanProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _FinancialInstrProductType ON LoanProductType = _FinancialInstrProductType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_LoanTypeProdTypeRelshp AS _LoanTypeProdTypeRelshp ON LoanProductType = _LoanTypeProdTypeRelshp.LoanProductType AND LoanType = _LoanTypeProdTypeRelshp.LoanType  -- association [0..1]
LEFT OUTER JOIN I_LoanType AS _LoanType ON LoanType = _LoanType.LoanType  -- association [0..1]
LEFT OUTER JOIN I_LoanGroupKey1 AS _LoanGroupKey1 ON LoanGroupKey1 = _LoanGroupKey1.LoanGroupKey1  -- association [0..1]
LEFT OUTER JOIN I_LoanGroupKey2 AS _LoanGroupKey2 ON LoanGroupKey2 = _LoanGroupKey2.LoanGroupKey2  -- association [0..1]
LEFT OUTER JOIN I_LoanTerm AS _LoanTerm ON LoanTerm = _LoanTerm.LoanTerm  -- association [0..1]
LEFT OUTER JOIN I_LoanNonAccptcRsn AS _LoanNonAccptcRsn ON CompanyCode = _LoanNonAccptcRsn.CompanyCode AND LoanProductType = _LoanNonAccptcRsn.LoanProductType AND LoanNonAccptcRsn = _LoanNonAccptcRsn.LoanNonAccptcRsn  -- association [0..1]
LEFT OUTER JOIN I_LoanAssignmentCreditor AS _LoanAssignmentCreditor ON LoanAssignmentCreditor = _LoanAssignmentCreditor.LoanAssignmentCreditor  -- association [0..1]
LEFT OUTER JOIN I_LoanClass AS _LoanClass ON LoanClass = _LoanClass.LoanClass  -- association [0..1]
LEFT OUTER JOIN I_DunningArea AS _DunningArea ON CompanyCode = _DunningArea.CompanyCode AND DunningArea = _DunningArea.DunningArea  -- association [0..1]
LEFT OUTER JOIN I_LoanSpecialPostingType AS _LoanSpecialPostingType ON CompanyCode = _LoanSpecialPostingType.CompanyCode AND LoanSpecialPostingType = _LoanSpecialPostingType.LoanSpecialPostingType  -- association [0..1]
LEFT OUTER JOIN I_LoanGroupKey3 AS _LoanGroupKey3 ON LoanGroupKey3 = _LoanGroupKey3.LoanGroupKey3  -- association [0..1]
LEFT OUTER JOIN I_LoanGroupKey4 AS _LoanGroupKey4 ON LoanGroupKey4 = _LoanGroupKey4.LoanGroupKey4  -- association [0..1]
LEFT OUTER JOIN I_LoanIncgPaytDistrCtrl AS _LoanIncgPaytDistrCtrl ON LoanIncgPaytDistrCtrl = _LoanIncgPaytDistrCtrl.LoanIncgPaytDistrCtrl  -- association [0..1]
LEFT OUTER JOIN I_LoanDrwgRestraintType AS _LoanDrwgRestraintType ON LoanDrwgRestraintType = _LoanDrwgRestraintType.LoanDrwgRestraintType  -- association [0..1]
LEFT OUTER JOIN I_LoanSecurityType AS _LoanSecurityType ON LoanSecurityType = _LoanSecurityType.LoanSecurityType  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _TreasuryPortfolio ON CompanyCode = _TreasuryPortfolio.CompanyCode AND LoanPortfolioType = _TreasuryPortfolio.Portfolio  -- association [0..1]
LEFT OUTER JOIN I_LoanSalesRegion AS _LoanSalesRegion ON LoanSalesRegion = _LoanSalesRegion.LoanSalesRegion  -- association [0..1]
LEFT OUTER JOIN I_LoanBranchOffice AS _LoanBranchOffice ON LoanBranchOffice = _LoanBranchOffice.LoanBranchOffice  -- association [0..1]
LEFT OUTER JOIN I_LoanManualDunLevel AS _LoanManualDunLevel ON LoanManualDunLevel = _LoanManualDunLevel.LoanManualDunLevel  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON LoanBusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_LoanPaymentStatus AS _LoanPaymentStatus ON LoanPaymentStatus = _LoanPaymentStatus.LoanPaymentStatus  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON LoanCountryID = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON LoanCountryID = _Region.Country AND LoanConcludedRegion = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_LoanActivityAgentRelshp AS _LoanActivityAgentRelshp ON LoanObjectInternalKey = _LoanActivityAgentRelshp.LoanObjectInternalKey  -- association [0..*]
LEFT OUTER JOIN I_LoanConditionItem AS _LoanConditionItem ON CompanyCode = _LoanConditionItem.CompanyCode AND LoanProductCategory = _LoanConditionItem.LoanProductCategory AND LoanContractID = _LoanConditionItem.LoanContractID  -- association [0..*]
LEFT OUTER JOIN I_LoanPurpose AS _LoanPurpose ON LoanProductType = _LoanPurpose.LoanProductType AND LoanPurpose = _LoanPurpose.LoanPurpose  -- association [0..1]
LEFT OUTER JOIN I_LoanSpecialTreatment AS _LoanSpecialTreatment ON LoanSpecialTreatment = _LoanSpecialTreatment.LoanSpecialTreatment  -- association [0..1]
LEFT OUTER JOIN I_LoanResidentialFinancingType AS _LoanResidentialFinancingType ON LoanResidentialFinancingType = _LoanResidentialFinancingType.LoanResidentialFinancingType  -- association [0..1]
LEFT OUTER JOIN I_LoanOriginType AS _LoanOriginType ON LoanOriginType = _LoanOriginType.LoanOriginType  -- association [0..1]
LEFT OUTER JOIN I_LoanIntrstOnArrsCalcProfile AS _LoanIntrstOnArrsCalcProfile ON LoanIntrstOnArrsCalcProfile = _LoanIntrstOnArrsCalcProfile.LoanIntrstOnArrsCalcProfile  -- association [0..1]
LEFT OUTER JOIN I_LoanCrdtAgrmtClassification AS _LoanCrdtAgrmtClassification ON LoanCrdtAgrmtClassification = _LoanCrdtAgrmtClassification.LoanCrdtAgrmtClassification  -- association [0..1]
LEFT OUTER JOIN I_LoanEconomicActivityType AS _LoanEconomicActivityType ON LoanEconomicActivityType = _LoanEconomicActivityType.LoanEconomicActivityType  -- association [0..1]
;