I_REPaymentCashFlow

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_REPaymentCashFlow.
-- 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: IRECDCFPAY

CREATE VIEW I_REPaymentCashFlow AS
SELECT
  cfpayguid AS PayRelatedCashFlowRecordUUID,
  condguid AS REConditionUUID,
  condvalidfrom AS ValidityStartDate,
  refguid AS REDocumentReferenceUUID,
  intreno AS InternalRealEstateNumber,
  rerf AS CreatedByUser,
  derf AS CreationDate,
  terf AS CreationTime,
  reher AS RESourceOfCreation,
  rbear AS LastChangedByUser,
  dbear AS LastChangeDate,
  tbear AS LastChangeTime,
  rbher AS RESourceOfChange,
  bbwhr AS RECashFlowPositionAmount,
  cast ( bnwhr as recfvdmnetamt ) AS FinTransFlowNomAmt,
  dbervon AS CalculationPeriodStartDate,
  sexclvon AS CalcPeriodStartDateIsExclusive,
  sultvon AS CalcPeriodStartDateIsMonthEnd,
  dberbis AS CalculationPeriodEndDate,
  sinclbis AS CalcPeriodEndDateIsInclusive,
  sultbis AS CalcPeriodEndDateIsMonthEnd,
  dvalut AS CalculationDate,
  sincl AS CalcDateIsAsEndDateInclusive,
  svult AS CalculationDateIsMonthEnd,
  dfaell AS PaymentDueDate,
  sfult AS DueDateIsMonthEnd,
  ddispo AS NextWorkingDateForPayDueDate,
  atage AS NumberOfDays,
  apertage AS NumberOfCalculationDays,
  stgbasis AS InterestBaseDaysMethod,
  szbmeth AS InterestCalculationMethod,
  dbperiod AS REBeginOfPeriodDate,
  spaexcl AS PeriodStartDateIsExclusive,
  spault AS PeriodStartDateIsMonthEnd,
  deperiod AS REEndOfPeriodDate,
  speincl AS PeriodEndDateIsInclusive,
  speult AS PeriodEndDateIsMonthEnd,
  swhrkond AS REConditionCurrency,
  bkond AS REUnitPrice,
  cast ( szeitant as recdvdmprorate ) AS REProRataMethod,
  ssalbas AS REPaymentStatus,
  skondgrp AS CashFlowConditionGroup,
  lcnetamount AS RECashFlowLoclNetAmount,
  lcgrossamount AS RECashFlowLoclGrossAmount,
  lctaxamount AS RECashFlowLoclTaxAmount,
  localcurr AS RECashFlowLoclCurrency,
  ccnetamount AS RECashFlowConditionNetAmount,
  ccgrossamount AS RECashFlowConditionGrossAmount,
  cctaxamount AS RECashFlowConditionTaxAmount,
  condcurr AS RECashFlowConditionCurrency,
  taxtype AS RETaxType,
  TaxGroup,
  txjcd AS TaxJurisdiction,
  isgross AS REIsConditionGrossAmount,
  TaxCountry,
  wherefrom AS CashFlowItemOrigin,
  flowtype AS REFlowType,
  cast ( origflowtype as recdoflowtype) AS REOriginalFlowType,
  cast ( refflowrel as recdorefflowrel ) AS RERelshpOriglToFlowType,
  cast( cfstatus as recfvdmcfstatus) AS CashFlowPostingStatus,
  fdlev AS PlanningLevel,
  fdelete AS IsToBeArchived,
  origduedate AS REOriglDueDate,
  partner AS BusinessPartner,
  partnerobjnr AS REPartnerStatusObject,
  condtype AS REConditionType,
  termnopy AS REPostingTerm,
  termnorh AS RERhythmTerm,
  termnoaj AS REAdjustmentNumber,
  termnooa AS REOrgAssignmentTerm,
  termnosr AS RESalesTerm,
  termnomr AS REPeakSalesTerm,
  termnowt AS REWithholdingTaxTerm,
  origexduedate AS REOriglExDueDate,
  seapstatus AS REAdvancePaymentRelevantStatus,
  PostingDate,
  DocumentDate,
  valuationdate AS ExchangeRateDate,
  reversal_for AS REReversalForUUID,
  reversal_by AS REReversalByUUID,
  followup_for AS REFollowUpPostingUUID,
  cast( book_flowtype as recdbflowtype ) AS REBookedFlowType,
  cast( book_refflowrel as recdbrefflowrel ) AS RERelshpBookedToFlowType,
  taxdate AS RETaxCalcDate,
  modduedate AS REModifiedDueDate,
  calcduedate AS RECalcDueDate,
  cfsplitforguid AS SplitCashFlowRecordUUID,
  cfsplitbasis AS RecordIsBasisForSplit,
  cdsplitno AS REConditionSplitNumber,
  CompanyCode,
  cmcfgroup AS CashPlanningGroup,
  ctrule AS RECurrencyTranslationRule,
  ctlcnetamount AS RETrnsltnRuleLoclNetAmount,
  ctlcgrossamount AS RETrnsltnRuleLoclGrossAmount,
  ctlctaxamount AS RETrnsltnRuleLoclTaxAmount,
  ctrate AS ExchangeRate,
  ctrateorig AS REOriginExchangeRate,
  ctpostcdcurr AS REIsPostInConditionCurrency,
  ctdatereq AS REPlndTranslationDate,
  ctdateact AS REActlTranslationDate,
  ctdateactorig AS REOriglActlTranslationDate,
  ctdatefromcfpos AS REIsTranslationDateFrmCashFlow,
  objnrcond AS REStatusObject
FROM vicdcfpay
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_RECondition AS _RECondition ON REConditionUUID = _RECondition.REConditionUUID  -- association [1..1]
LEFT OUTER JOIN I_REConditionType AS _REConditionType ON REConditionType = _REConditionType.REConditionType  -- association [0..1]
LEFT OUTER JOIN I_REDocumentHeader AS _REDocumentHeader ON REDocumentReferenceUUID = _REDocumentHeader.RealEstateDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_REPostingTerm AS _REPostingTerm ON InternalRealEstateNumber = _REPostingTerm.InternalRealEstateNumber AND REPostingTerm = _REPostingTerm.RETermNumber  -- association [1..*]
LEFT OUTER JOIN I_RERhythmTerm AS _RERhythmTerm ON InternalRealEstateNumber = _RERhythmTerm.InternalRealEstateNumber AND RERhythmTerm = _RERhythmTerm.RETermNumber  -- association [1..*]
LEFT OUTER JOIN I_RETaxType AS _RETaxType ON TaxCountry = _RETaxType.Country AND RETaxType = _RETaxType.RETaxType  -- association [0..1]
LEFT OUTER JOIN I_RETaxGroup AS _RETaxGroup ON TaxGroup = _RETaxGroup.TaxGroup  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_REFlowType AS _REFlowType ON REFlowType = _REFlowType.REFlowType  -- association [0..1]
LEFT OUTER JOIN I_REFlowType AS _REOriglFlowType ON REOriginalFlowType = _REOriglFlowType.REFlowType  -- association [0..1]
LEFT OUTER JOIN I_RERelshpOriglToFlowType AS _RERelshpOriglToFlowType ON RERelshpOriglToFlowType = _RERelshpOriglToFlowType.RERelshpOriglToFlowType  -- association [0..1]
LEFT OUTER JOIN I_REFlowType AS _REBookedFlowType ON REBookedFlowType = _REBookedFlowType.REFlowType  -- association [0..1]
LEFT OUTER JOIN I_RERelshpOriglToFlowType AS _RERelshpBookedToFlowType ON RERelshpBookedToFlowType = _RERelshpBookedToFlowType.RERelshpOriglToFlowType  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _PlanningLevel ON PlanningLevel = _PlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_REProRataMethod AS _REProRateMethod ON REProRataMethod = _REProRateMethod.REProRataMethod  -- association [0..1]
LEFT OUTER JOIN I_RECashFlowItemOrigin AS _RECashFlowItemOrigin ON CashFlowItemOrigin = _RECashFlowItemOrigin.CashFlowItemOrigin  -- association [0..1]
LEFT OUTER JOIN I_RECashFlowPostingStatus AS _RECashFlowPostingStatus ON CashFlowPostingStatus = _RECashFlowPostingStatus.CashFlowPostingStatus  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_REAdvancePaytRlvtStatus AS _REAdvancePaytRlvtStatus ON REAdvancePaymentRelevantStatus = _REAdvancePaytRlvtStatus.REAdvancePaymentRelevantStatus  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;