P_CollMgmtRblsItmForKeyDte

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 P_CollMgmtRblsItmForKeyDte.
-- 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: PCMRBLSKDATDUE
-- Parameters: P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_PeriodType : farp_period_type

CREATE VIEW P_CollMgmtRblsItmForKeyDte AS
SELECT
  _Item.CompanyCode AS CompanyCode,
  _Item.Customer AS Customer,
  _Item.AccountingClerk AS AccountingClerk,
  _Item.SpecialGLCode AS SpecialGLCode,
  _Item.ReconciliationAccount AS ReconciliationAccount,
  _Item.GLAccount AS GLAccount,
  _UdmProfile.CollectionProfile AS CollectionProfile,
  _UdmSegments.CollectionSegment AS CollectionSegment,
  case when _UdmSegments.CollectionSpecialist = '' or _UdmSegments.CollectionSpecialist = ' ' or _UdmSegments.CollectionSpecialist is null then case when _UdmBPSplAbs.CollectionSpecialist = '' or _UdmBPSplAbs.CollectionSpecialist = ' ' or _UdmBPSplAbs.CollectionSpecialist is null then _UdmSegments.CollectionGroup else _UdmBPSplAbs.CollectionGroup end else case when _UdmBPSplAbs.CollectionSpecialist = '' or _UdmBPSplAbs.CollectionSpecialist = ' ' or _UdmBPSplAbs.CollectionSpecialist is null then _UdmSegments.CollectionGroup else _UdmBPSplAbs.CollectionGroup end end as CollectionGroup AS CollectionGroupendendasCollectionGroup,
  _Item.CustomerCountry AS CustomerCountry,
  _Item.ChartOfAccounts AS ChartOfAccounts,
  _Item.DisplayCurrency AS DisplayCurrency,
  _Item.FinancialAccountType AS FinancialAccountType,
  _Item.AuthorizationGroup AS AuthorizationGroup,
  _Item.ReportingPeriodStartDate AS ReportingPeriodStartDate,
  _Item.ReportingPeriodEndDate AS ReportingPeriodEndDate,
  _Item.ReportingYear AS ReportingYear,
  _Item.ReportingPeriod AS ReportingPeriod,
  _Item.NetDueIntvl1AmtInDspCrcy AS NetDueIntvl1AmtInDspCrcy,
  _Item.NetDueIntvl2AmtInDspCrcy AS NetDueIntvl2AmtInDspCrcy,
  _Item.NetDueIntvl3AmtInDspCrcy AS NetDueIntvl3AmtInDspCrcy,
  _Item.PartialPaymentAmtInDspCrcy AS PartialPaymentAmtInDspCrcy,
  _Item._Company AS _Company,
  _Item._Customer AS _Customer,
  _Item._AccountingClerk AS _AccountingClerk,
  _Item._SpecialGLCode AS _SpecialGLCode,
  _Item._GLAccount AS _GLAccount,
  _Item._ReconciliationAccount AS _ReconciliationAccount,
  _Item._ChartOfAccounts AS _ChartOfAccounts,
  _Item._DisplayCurrency AS _DisplayCurrency,
  _Item._FinancialAccountType AS _FinancialAccountType
FROM I_RblsItmForKeyDteDuePerd
RIGHT OUTER JOIN I_BPCollectionsSegmentAssgmt AS _UdmSegments ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CollsSpecialistSubstitute AS _UdmSplAbs ON _UdmSplAbs.CollectionGroup = _UdmSegments.CollectionGroup AND _UdmSplAbs.CollectionSpecialist = _UdmSegments.CollectionSpecialist AND _UdmSplAbs.CollSpecialistAbsenceFrom <= $parameters.P_KeyDate AND _UdmSplAbs.CollSpecialistAbsenceTo >= $parameters.P_KeyDate  -- association [1..1]
LEFT OUTER JOIN I_BPCollectionsSgmtTmpAssgmt AS _UdmBPSplAbs ON _UdmBPSplAbs.BusinessPartner = _BPCust.BusinessPartner AND _UdmBPSplAbs.CollectionSegment = _UdmSegments.CollectionSegment AND _UdmBPSplAbs.TmpBPCollSgmtAssgmtValidFrom <= $parameters.P_KeyDate AND _UdmBPSplAbs.TmpBPCollSgmtAssgmtValidTo >= $parameters.P_KeyDate  -- association [1..1]
;