I_DunningEntry

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_DunningEntry.
-- 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.
-- SQL view name: IDUNNINGENTRY

CREATE VIEW I_DunningEntry AS
SELECT
  cast(mhnk.laufd as farp_laufd_mhn preserving type) AS DunningRunDate,
  cast(mhnk.laufi as farp_laufi_mhn preserving type) AS DunningRun,
  cast(mhnk.koart as farp_koart preserving type) AS FinancialAccountType,
  cast(mhnk.bukrs as fis_bukrs preserving type) AS CompanyCode,
  mhnk.kunnr AS Customer,
  cast(mhnk.lifnr as md_supplier preserving type) AS Supplier,
  cast(mhnk.cpdky as bankn) AS OneTimeAcctBankAccount,
  mhnk.sknrze AS CustomerHeadOffice,
  mhnk.smaber AS GroupingDunningArea,
  cast( mhnk.smahsk as farp_group_dunn_level preserving type ) AS GroupingDunningLevel,
  mhnk.busab AS DunningClerk,
  mhnk.ausdt AS DunningDate,
  mhnk.grdat AS DocIncldUpToPostgDate,
  mhnk.knrma AS DunningRecipient,
  mhnk.gmvdt AS LegDunningProcedureOn,
  mhnk.mahna AS DunningProcedure,
  cast(mhnk.mahns as farp_mahns_d preserving type) AS DunningLevel,
  cast(mhnk.vzskz as farp_vzskz preserving type) AS InterestCalculationCode,
  cast(mhnk.waers as farp_waers_mhn preserving type) AS DunningCurrency,
  cast(mhnk.saldo as farp_salfw_mhnk preserving type) AS DunAreaAcctBalanceDunCrcy,
  cast(mhnk.salhw as farp_salhw_mhnk preserving type) AS DunAreaAcctBalanceCCCrcy,
  cast(mhnk.gsfbt as farp_gsfbt_mhnk preserving type) AS DueItemsBlockedInDunCrcy,
  cast(mhnk.gsnbt as farp_gsnbt_mhnk preserving type) AS NotDueItemsBlockedInDunCrcy,
  cast(mhnk.faebt as farp_faebt_mhnk preserving type) AS DueLineItemsTotalInDunCrcy,
  cast(mhnk.faehw as farp_faehw_mhnk preserving type) AS DueLineItemsTotalInCCCrcy,
  mhnk.xmflg AS DunningNoticeIsToBeSent,
  cast(mhnk.mansp as farp_mansp preserving type) AS DunningBlockingReason,
  cast(mhnk.mahsk as maxst preserving type) AS MaximumDunningLevel,
  cast(mhnk.zinbt as farp_dzinbt_mhn preserving type) AS InterestAmountInDunCrcy,
  cast(mhnk.zinhw as farp_dzinhw_mhn preserving type) AS InterestAmountInCCCrcy,
  mhnk.xzins AS InterestIsNotDisplayed,
  mhnk.mgrup AS DunningNoticeGroup,
  mhnk.vertn AS TreasuryContract,
  mhnk.vertt AS TreasuryContractType,
  cast(mhnk.imkey as farp_imkey preserving type) AS RealEstateObject,
  cast(mhnk.famsm as farp_famsm_mhnk preserving type) AS DueItemDunLevelTotalInDunCrcy,
  mhnk.famsh AS DueItemDunLevelTotalInCCCrcy,
  cast(mhnk.pstlz as ad_pstcd1 preserving type) AS PostalCode,
  cast(mhnk.ort01 as ad_city1) AS CityName,
  mhnk.stras AS StreetName,
  cast(mhnk.pfach as ad_pobx preserving type) AS POBox,
  cast(mhnk.land1 as land1_gp preserving type) AS Country,
  mhnk.avsid AS PaymentAdvice,
  mhnk.applk AS BusTransEventApplication,
  cast(mhnk.mhngh as farp_mhngh_f150 preserving type) AS DunningChargeInCCCrcy,
  cast(mhnk.mhngf as farp_mhngf_f150 preserving type) AS DunningChargeInDunCrcy,
  cast(mhnk.prndt as farp_prndt preserving type) AS DunningPrintDate,
  mhnk.prndt_before AS LastDunningPrntDate,
  _CompanyCode.Currency AS CompanyCodeCurrency
FROM mhnk
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_DunningArea AS _DunningArea ON CompanyCode = _DunningArea.CompanyCode AND GroupingDunningArea = _DunningArea.DunningArea  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DunningCurrency ON DunningCurrency = _DunningCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_DunningBlockingReasonCode AS _DunningBlockingReason ON DunningBlockingReason = _DunningBlockingReason.DunningBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_AccountingClerk AS _AccountingClerk ON CompanyCode = _AccountingClerk.CompanyCode AND DunningClerk = _AccountingClerk.AccountingClerk  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_DunningEntryItem AS _DunningEntryItem ON DunningRunDate = _DunningEntryItem.DunningRunDate AND DunningRun = _DunningEntryItem.DunningRun AND FinancialAccountType = _DunningEntryItem.FinancialAccountType AND CompanyCode = _DunningEntryItem.CompanyCode AND Customer = _DunningEntryItem.Customer AND Supplier = _DunningEntryItem.Supplier AND OneTimeAcctBankAccount = _DunningEntryItem.OneTimeAcctBankAccount AND CustomerHeadOffice = _DunningEntryItem.CustomerHeadOffice AND GroupingDunningArea = _DunningEntryItem.GroupingDunningArea AND DunningLevel = _DunningEntryItem.DunningLevel  -- association [0..*]
LEFT OUTER JOIN I_DunningProcedure AS _DunningProcedure ON DunningProcedure = _DunningProcedure.DunningProcedure  -- association [0..1]
;