I_DunningEntryItem

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_DunningEntryItem.
-- 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: IDUNNINGENTRITM

CREATE VIEW I_DunningEntryItem AS
SELECT
  cast(mhnd.laufd as farp_laufd_mhn preserving type) AS DunningRunDate,
  cast(mhnd.laufi as farp_laufi_mhn preserving type) AS DunningRun,
  cast(mhnd.koart as farp_koart preserving type) AS FinancialAccountType,
  cast(mhnd.bukrs as fis_bukrs preserving type) AS CompanyCode,
  mhnd.kunnr AS Customer,
  cast(mhnd.lifnr as md_supplier preserving type) AS Supplier,
  cast(mhnd.cpdky as bankn) AS OneTimeAcctBankAccount,
  mhnd.sknrze AS CustomerHeadOffice,
  mhnd.smaber AS GroupingDunningArea,
  mhnd.smahsk AS GroupingDunningLevel,
  cast(mhnd.bbukrs as fis_bukrs preserving type) AS ReferenceDocumentCompanyCode,
  cast(mhnd.belnr as fis_belnr preserving type) AS JournalEntry,
  cast(mhnd.gjahr as fis_gjahr preserving type) AS FiscalYear,
  cast(mhnd.buzei as fis_buzei preserving type) AS JournalEntryItem,
  cast(mhnd.gsber as fis_rbusa preserving type ) AS BusinessArea,
  mhnd.xblnr AS DocumentReferenceID,
  cast(mhnd.budat as fis_budat preserving type) AS PostingDate,
  cast(mhnd.bldat as fis_bldat preserving type) AS DocumentDate,
  cast(mhnd.cpudt as farp_cpudt preserving type) AS AccountingDocumentCreationDate,
  cast(mhnd.zfbdt as dzfbdt preserving type) AS DueCalculationBaseDate,
  cast(mhnd.faedt as farp_netdt preserving type) AS NetDueDate,
  cast(mhnd.blart as farp_blart preserving type) AS AccountingDocumentType,
  cast(mhnd.bschl as fis_bschl preserving type) AS PostingKey,
  cast(mhnd.mschl as farp_mschl preserving type) AS DunningKey,
  cast(mhnd.mansp as farp_mansp preserving type) AS DunningBlockingReason,
  cast(mhnd.maber as farp_maber preserving type) AS DunningArea,
  cast(mhnd.madat as farp_madat preserving type) AS LastDunningDate,
  mhnd.mahns AS OldDunningLevel,
  cast(mhnd.mahnn as farp_mahns_d preserving type) AS DunningLevel,
  cast(mhnd.zlspr as farp_dzlspr preserving type) AS PaymentBlockingReason,
  cast(mhnd.xzalb as farp_xzalb_mhnd preserving type) AS DunningItemIsPayable,
  cast(mhnd.verzn as farp_verzn preserving type) AS NetDueArrearsDays,
  cast(mhnd.umsks as farp_umsks preserving type) AS SpecialGLTransactionType,
  cast(mhnd.umskz as fac_umskz preserving type) AS SpecialGLCode,
  cast(mhnd.shkzg as fis_shkzg preserving type) AS DebitCreditCode,
  cast(mhnd.waers as fis_rwcur preserving type) AS TransactionCurrency,
  cast(mhnd.dmshb as fis_hsl preserving type) AS AmountInCompanyCodeCurrency,
  cast(mhnd.wrshb as fis_wsl preserving type) AS AmountInTransactionCurrency,
  cast(mhnd.filkd as farp_filkd preserving type) AS BranchAccount,
  mhnd.vkorg AS SalesOrganization,
  mhnd.vtweg AS DistributionChannel,
  mhnd.spart AS Division,
  cast(mhnd.rebzg as fis_rebzg preserving type) AS InvoiceReference,
  cast(mhnd.rebzj as fis_rebzj preserving type) AS InvoiceReferenceFiscalYear,
  cast(mhnd.rebzz as fis_rebzz preserving type) AS InvoiceItemReference,
  mhnd.vertn AS TreasuryContract,
  mhnd.vertt AS TreasuryContractType,
  cast(mhnd.zlsch as farp_schzw_bseg preserving type) AS SupplierPaymentMethod,
  _CompanyCode.Currency AS CompanyCodeCurrency
FROM mhnd
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _DocumentCompanyCode ON ReferenceDocumentCompanyCode = _DocumentCompanyCode.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 [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..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 _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON ReferenceDocumentCompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND JournalEntry = _JournalEntry.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_DunningBlockingReasonCode AS _DunningBlockingReason ON DunningBlockingReason = _DunningBlockingReason.DunningBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
;