I_APCheckbook

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_APCheckbook.
-- 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: IAPCHECKBOOK

CREATE VIEW I_APCheckbook AS
SELECT
  cb.PaymentCompanyCode AS PaymentCompanyCode,
  cb.HouseBank AS HouseBank,
  cb.HouseBankAccount AS HouseBankAccount,
  cb.Chequebook AS Chequebook,
  cb.ChequebookFirstCheque AS ChequebookFirstCheque,
  cb.ChequebookLastCheque AS ChequebookLastCheque,
  cb.NextChequebook AS NextChequebook,
  cb.LastAssignedCheque AS LastAssignedCheque,
  cb.ChequebookName AS ChequebookName,
  cb.ChequebookIsNonSequential AS ChequebookIsNonSequential,
  case cb.ChequebookPurchaseDate when '' then cast ( ' ' as abap.dats ) else cast ( cb.ChequebookPurchaseDate as abap.dats ) end as ChequebookPurchaseDate AS datsendasChequebookPurchaseDate,
  cb.ChequebookPaymentMethodList AS ChequebookPaymentMethodList,
  cb.ChequebookMinimalChequeCount AS ChequebookMinimalChequeCount,
  cb.ChequebookPurchaser AS ChequebookPurchaser,
  cb.ChequebookCreatedByUser AS ChequebookCreatedByUser,
  cb.ChequebookCreationDate AS ChequebookCreationDate,
  cb.ChequebookCreationTime AS ChequebookCreationTime,
  cb.ChequeType AS ChequeType,
  cast( ' ' as abap.char(10)) AS ChequebookStatus,
  _HouseBankAccount.HouseBankAccountDescription AS BankAccountName
FROM P_APCheckbook AS cb
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccount ON _HouseBankAccount.CompanyCode = PaymentCompanyCode AND _HouseBankAccount.HouseBank = HouseBank AND _HouseBankAccount.HouseBankAccount = HouseBankAccount AND _HouseBankAccount.Language = $session.system_language  -- association [0..1]
;