I_CASampleDocBPRepetitionItem

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_CASampleDocBPRepetitionItem.
-- 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: ICASDOCBPREPITM

CREATE VIEW I_CASampleDocBPRepetitionItem AS
SELECT
  opbel AS CADocumentNumber,
  whgrp AS CARepetitionGroup,
  opupw AS CARepetitionItemNumber,
  whanz AS CANmbrOfItemsInRepetitionGrp,
  cast(gpart as bu_partner) AS BusinessPartner,
  cast(cast(vkont as abap.char(12)) as corr_vkont_kk) AS ContractAccount,
  abwbl AS CASubstituteDocumentNumber,
  abwtp AS CASubstituteDocumentCategory,
  budat AS CAPostingDate,
  faedn AS CANetDueDate,
  faeds AS CACashDiscountDueDate,
  persl AS CAPeriodCode,
  xaesp AS CAChangeIsForbidden,
  augdt AS CAClearingDate,
  augbl AS CAClearingDocumentNumber,
  augbd AS CAPostingDateOfClearingDoc,
  augrd AS CAClearingReason,
  augvd AS CAValueDateForClearing,
  augob AS CAItemIsWithdrawn,
  xaufl AS CARepetitionItemIsResolved,
  xragl AS CAClearingPostingIsReset,
  xpyor AS CAPaymentPreNotificationCode,
  pnnum AS CASEPAPreNotificationNumber,
  pnhkf AS CASEPAPreNotifOriginCode,
  pnexd AS CASEPAPreNotifExecutionDate
FROM dfkkmopw
LEFT OUTER JOIN I_CASampleDocHeader AS _DocHeader ON CADocumentNumber = _DocHeader.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_CASampleDocHeader AS _SubstitDocHeader ON CASubstituteDocumentNumber = _SubstitDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CASampleDocHeader AS _ClearingDocHeader ON CAClearingDocumentNumber = _ClearingDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _CAHeader ON ContractAccount = _CAHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CAPeriodCode AS _PeriodCode ON CAPeriodCode = _PeriodCode.CAPeriodCode  -- association [0..1]
LEFT OUTER JOIN I_CAClearingReason AS _ClearingReason ON CAClearingReason = _ClearingReason.CAClearingReason  -- association [0..1]
;