P_APCheckbook

DDL: P_APCHECKBOOK SQL: PAPCHECKBOOK Type: view BASIC
20 Fields 1 Data Sources

P_APCheckbook is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (pcec) and exposes 20 fields with key fields PaymentCompanyCode, HouseBank, HouseBankAccount, Chequebook.

Data Sources (1)

SourceAliasJoin Type
pcec pcec from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName PAPCHECKBOOK view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PaymentCompanyCode zbukr Paying CoCd
KEY HouseBank hbkid House Bank
KEY HouseBankAccount hktid House Bank Account
KEY Chequebook stapl Lot Number
ChequebookFirstCheque checf Check number
ChequebookLastCheque chect Check number
NextChequebook fstap Next lot
LastAssignedCheque checl Number Status
ChequebookName stapi Short Info
ChequebookIsNonSequential xchch Non-Sequential
ChequebookPurchaseDate purdt Purchase date
ChequebookPaymentMethodList zwels Pymt Meth.
ChequebookMinimalChequeCount minialertnum Minimal Alert Number
ChequebookPurchaser purchaseby Purchase By
ChequebookCreatedByUser createby User Name
ChequebookCreationDate createdate Time Stamp
ChequebookCreationTime createtime Time
CheckbookCreationDateTime
ChequeType checktype Check Type
ChequeNumberLength

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_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: PAPCHECKBOOK

CREATE VIEW P_APCheckbook AS
SELECT
  zbukr AS PaymentCompanyCode,
  hbkid AS HouseBank,
  hktid AS HouseBankAccount,
  stapl AS Chequebook,
  checf AS ChequebookFirstCheque,
  chect AS ChequebookLastCheque,
  fstap AS NextChequebook,
  checl AS LastAssignedCheque,
  stapi AS ChequebookName,
  xchch AS ChequebookIsNonSequential,
  purdt AS ChequebookPurchaseDate,
  zwels AS ChequebookPaymentMethodList,
  minialertnum AS ChequebookMinimalChequeCount,
  purchaseby AS ChequebookPurchaser,
  createby AS ChequebookCreatedByUser,
  createdate AS ChequebookCreationDate,
  createtime AS ChequebookCreationTime,
  cast(dats_tims_to_tstmp(createdate, createtime, abap_system_timezone($session.client, 'NULL'), $session.client,'NULL') as timestamp) AS CheckbookCreationDateTime,
  checktype AS ChequeType,
  length( chect ) AS ChequeNumberLength
FROM pcec
;

Learn More