R_PaymentProgramControl

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 R_PaymentProgramControl.
-- 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 R_PaymentProgramControl AS
SELECT
  laufd AS PaymentRunDate,
  cast(laufi as farp_laufi preserving type ) AS PaymentRunID,
  cast(xvore as farp_xvore preserving type ) AS ProposalRunIsCarriedOut,
  cast(xvorb as farp_xvorb preserving type ) AS PaymentProposalIsRevised,
  cast(xecht as farp_xecht preserving type ) AS PaymentRunIsCarriedOut,
  cast(xbelg as farp_xbelg preserving type ) AS PaytRunDocCreationIsStarted,
  cast(xdele as farp_xdele preserving type ) AS PaymentRunIsDeleted,
  cast(anzer as farp_anzer preserving type ) AS NumberOfCreatedPayments,
  cast(anzgb as farp_anzgb preserving type ) AS NumberOfPostedPayments,
  fdebi AS ToNetDueDate,
  kurst AS ExchangeRateType,
  filzu AS BranchCompanyCodeAssignment,
  cast(bupla as farp_bupla preserving type ) AS BusinessPlace,
  x_dd_prenotif AS PaytRunIsForDrctDebitPreNotif,
  cast(laufd_dd_prenoti as farp_laufd_ref preserving type ) AS ReferencePaymentRunDate,
  cast(laufi_dd_prenoti as farp_laufi_ref preserving type ) AS ReferencePaymentRunID,
  x_wf_active AS WrkflwScenIsActv
FROM reguv
LEFT OUTER JOIN R_PaymentProposalPayment AS _PaymentProposalPayment ON PaymentRunID = _PaymentProposalPayment.PaymentRunID AND PaymentRunDate = _PaymentProposalPayment.PaymentRunDate  -- association [0..*]
;