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
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]
;