I_LoanContrCndnHdrData

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_LoanContrCndnHdrData.
-- 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_LoanContrCndnHdrData AS
SELECT
  vzzkoko.bukrs AS CompanyCode,
  vzzkoko.sanlf AS LoanProductCategory,
  vzzkoko.rkey1 AS LoanContractID,
  vzzkoko.dguel_kk AS LoanCndnHdrValdtyStrtDte,
  vzzkoko.nlfd_ang AS LoanConditionHeaderOfferNumber,
  vzzkoko.sstati AS LoanLifeCycleStatus,
  vzzkoko.skokoart AS LoanConditionHeaderType,
  vzzkoko.stilgart AS LoanRepaymentType,
  vzzkoko.kzahlung AS LoanDisbursementRate,
  vzzkoko.bzusage AS LoanCommittedCapitalAmount,
  vzzkoko.swhrzusa AS LoanCommittedCapitalCrcy,
  vzzkoko.peffzins AS LoanEffectiveInterestRate,
  vzzkoko.seffmeth AS LoanEffectiveInterestMethod,
  vzzkoko.szbmeth AS InterestCalculationMethod,
  vzzkoko.dkuend AS LoanNoticeDate,
  vzzkoko.skuend AS LoanNoticeReason,
  vzzkoko.dkuenddg AS LoanLndrErlstNtcDate,
  vzzkoko.dblfz AS LoanTermStartDate,
  vzzkoko.delfz AS LoanTermEndDate,
  vzzkoko.pmaneffz AS LoanIntEffctvIntrstRate,
  vzzkoko.seffm2 AS LoanIntEffctvIntrstMeth,
  vzzkoko.skuegl AS LoanLenderNoticeArrgmt,
  vzzkoko.defsz AS LoanCndnHdrValdtyEndDte,
  vzzkoko.dabeffz AS LoanCndnEffctvIntrstStrtDte,
  vzzkoko.skuedn AS LoanContrBrwrNtcArrgmt,
  vzzkoko.skueart AS LoanContrNtcType,
  vzzkoko.skalidwt AS InterestDaysCalendar,
  vzzkoko.edeffzins AS LoanClslyDfndEffctvIntrstRate,
  vzzkoko.edeffmeth AS LoanClslyDfndEffctvIntrstMeth,
  vzzkoko.jahreffzins AS LoanYrlyEffctvInterestRate,
  vzzkoko.jahreffmeth AS LoanYrlyEffctvInterestMethod,
  vzzkoko.peffzins_origin AS LoanOriglEffectiveInterestRate,
  vzzkoko.peffzins_add AS LoanAddlEffectiveInterestRate,
  vzzkoko.stilgrhy AS LoanRepaymentFrequency,
  vzzkoko.sdisein AS LoanDiscountDeterminationType,
  vzzkoko.bzahlung AS LoanDisbursementAmount,
  vzzkoko.swhrzhlg AS LoanDisbursementCurrency,
  vzzkoko.dblfz_origin AS LoanTermOriginalStartDate,
  vzzkoko.dresam AS LoanOffrResvnValidFromDate,
  vzzkoko.dresbis AS LoanOffrResvnValidToDate,
  vzzkoko.dangam AS LoanOfferCreationDate,
  vzzkoko.dangbis AS LoanOfferValidToDate,
  vzzkoko.sangvor AS LoanContrAccptcReservationType,
  vzzkoko.jannahme AS LoanOfferAcceptanceIndCode,
  vzzkoko.sannahme AS LoanOfferAcceptanceType,
  vzzkoko.dannahme AS LoanOfferAcceptedOnDate,
  vzzkoko.jvertrag AS LoanContractCreationIndCode,
  vzzkoko.dvertram AS LoanContractCreationDate,
  vzzkoko.dvertbis AS LoanContractReturnByDate,
  vzzkoko.rpnr AS LoanRolloverNumber,
  vzzkoko.dges AS LoanLglRghtOfNtcErlstNtcDate,
  vzzkoko.sgesaus AS LoanLglRightOfNoticeIsExcluded,
  vzzkoko.szkz AS LoanSpclIntrstCalculationType,
  vzzkoko.nangebot AS LoanCndnHdrOffrConsecutiveNmbr,
  vzzkoko.sincl AS LnCnHdrValdtyEndDateInclvCode,
  vzzkoko.zvrhyeff AS LoanIntrstSetlFrqcyNrOfMnths,
  vzzkoko.pvgleffz AS LoanComparEffctvInterestRate,
  vzzkoko.sultefsz AS LnCnHdrValdtyEndDateIsMonthEnd,
  vzzkoko.dkuenddn AS LoanBorrowerEarliestNoticeDate,
  vzzkoko.dmarktzins AS LoanMarketInterestRateDate,
  _LoanContrData.BusinessPartner AS BusinessPartner
FROM vzzkoko
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_FinancialInstrProdCat AS _FinancialInstrProdCat ON LoanProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory  -- association [0..1]
LEFT OUTER JOIN I_LoanConditionHeaderType AS _LoanConditionHeaderType ON LoanConditionHeaderType = _LoanConditionHeaderType.LoanConditionHeaderType  -- association [0..1]
LEFT OUTER JOIN I_LoanNoticeReason AS _LoanNoticeReason ON LoanNoticeReason = _LoanNoticeReason.LoanNoticeReason  -- association [0..1]
LEFT OUTER JOIN I_LoanLenderNoticeArrgmt AS _LoanLenderNoticeArrgmt ON LoanLenderNoticeArrgmt = _LoanLenderNoticeArrgmt.LoanLenderNoticeArrgmt  -- association [0..1]
LEFT OUTER JOIN I_LoanContrBrwrNtcArrgmt AS _LoanContrBrwrNtcArrgmt ON LoanContrBrwrNtcArrgmt = _LoanContrBrwrNtcArrgmt.LoanContrBrwrNtcArrgmt  -- association [0..1]
LEFT OUTER JOIN I_LoanContractNoticeType AS _LoanContractNoticeType ON LoanContrNtcType = _LoanContractNoticeType.LoanContrNtcType  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON InterestDaysCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON LoanCommittedCapitalCrcy = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_LoanOfferAcceptanceType AS _LoanOfferAcceptanceType ON LoanOfferAcceptanceType = _LoanOfferAcceptanceType.LoanOfferAcceptanceType  -- association [0..1]
LEFT OUTER JOIN I_LoanSpecialInterestType AS _LoanSpecialInterestType ON LoanSpclIntrstCalculationType = _LoanSpecialInterestType.LoanSpclIntrstCalculationType  -- association [0..1]
LEFT OUTER JOIN I_LoanContrAccptcResvnType AS _LoanContrAccptcResvnType ON LoanContrAccptcReservationType = _LoanContrAccptcResvnType.LoanContrAccptcReservationType  -- association [0..1]
LEFT OUTER JOIN I_LoanConditionItem AS _LoanConditionItem ON CompanyCode = _LoanConditionItem.CompanyCode AND LoanProductCategory = _LoanConditionItem.LoanProductCategory AND LoanContractID = _LoanConditionItem.LoanContractID AND LoanCndnHdrValdtyStrtDte = _LoanConditionItem.LoanCndnHdrValdtyStrtDte AND LoanConditionHeaderOfferNumber = _LoanConditionItem.LoanConditionHeaderOfferNumber  -- association [0..*]
LEFT OUTER JOIN I_LoanRepaymentFrequency AS _LoanRepaymentFrequency ON LoanRepaymentFrequency = _LoanRepaymentFrequency.LoanRepaymentFrequency  -- association [0..1]
;