C_Apcheckbook

DDL: C_APCHECKBOOK SQL: CAPCHECKBOOK Type: view CONSUMPTION
25 Fields 1 Data Sources 3 Associations

CDS View Checkbook consumption

C_Apcheckbook is a Consumption CDS View that provides data about "CDS View Checkbook consumption" in SAP S/4HANA. It reads from 1 data source (I_APCheckbook) and exposes 25 fields with key fields PaymentCompanyCode, HouseBank, HouseBankAccount, Chequebook. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_APCheckbook I_APCheckbook from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _Company _Company.CompanyCode = $projection.PaymentCompanyCode
[0..1] I_HouseBankAccount _HouseBank _HouseBank.CompanyCode = $projection.PaymentCompanyCode and _HouseBank.HouseBank = $projection.HouseBank and _HouseBank.HouseBankAccount = $projection.HouseBankAccount
[1..1] E_Apcheckbook _Extension _Extension.PaymentCompanyCode = $projection.PaymentCompanyCode and _Extension.HouseBank = $projection.HouseBank and _Extension.HouseBankAccount = $projection.HouseBankAccount and _Extension.Chequebook = $projection.Chequebook

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CAPCHECKBOOK view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View Checkbook consumption view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PaymentCompanyCode I_APCheckbook PaymentCompanyCode
KEY HouseBank I_APCheckbook HouseBank House Bank
KEY HouseBankAccount I_APCheckbook HouseBankAccount House Bank Account
KEY Chequebook I_APCheckbook Chequebook
ChequebookFirstCheque I_APCheckbook ChequebookFirstCheque
ChequebookLastCheque I_APCheckbook ChequebookLastCheque
NextChequebook I_APCheckbook NextChequebook
LastAssignedCheque I_APCheckbook LastAssignedCheque
ChequebookName I_APCheckbook ChequebookName
ChequebookIsNonSequential I_APCheckbook ChequebookIsNonSequential
ChequebookPurchaseDate I_APCheckbook ChequebookPurchaseDate
ChequebookPaymentMethodList I_APCheckbook ChequebookPaymentMethodList
ChequebookMinimalChequeCount I_APCheckbook ChequebookMinimalChequeCount
ChequebookPurchaser I_APCheckbook ChequebookPurchaser
ChequebookCreatedByUser I_APCheckbook ChequebookCreatedByUser
ChequebookCreationDate I_APCheckbook ChequebookCreationDate
ChequebookCreationTime I_APCheckbook ChequebookCreationTime
CheckbookCreationDateTime
ChequeType I_APCheckbook ChequeType
ChequebookStatus I_APCheckbook ChequebookStatus
CompanyName _Company CompanyCodeName Company Name
Country _Company Country Venue: Ctry/Reg
HouseBankName
BankAccount _HouseBank BankAccount Bank acct
BankAccountName BankAccountName Account Name

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 C_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: CAPCHECKBOOK

CREATE VIEW C_Apcheckbook AS
SELECT
  I_APCheckbook.PaymentCompanyCode AS PaymentCompanyCode,
  I_APCheckbook.HouseBank AS HouseBank,
  I_APCheckbook.HouseBankAccount AS HouseBankAccount,
  I_APCheckbook.Chequebook AS Chequebook,
  I_APCheckbook.ChequebookFirstCheque AS ChequebookFirstCheque,
  I_APCheckbook.ChequebookLastCheque AS ChequebookLastCheque,
  I_APCheckbook.NextChequebook AS NextChequebook,
  I_APCheckbook.LastAssignedCheque AS LastAssignedCheque,
  I_APCheckbook.ChequebookName AS ChequebookName,
  I_APCheckbook.ChequebookIsNonSequential AS ChequebookIsNonSequential,
  I_APCheckbook.ChequebookPurchaseDate AS ChequebookPurchaseDate,
  I_APCheckbook.ChequebookPaymentMethodList AS ChequebookPaymentMethodList,
  I_APCheckbook.ChequebookMinimalChequeCount AS ChequebookMinimalChequeCount,
  I_APCheckbook.ChequebookPurchaser AS ChequebookPurchaser,
  I_APCheckbook.ChequebookCreatedByUser AS ChequebookCreatedByUser,
  I_APCheckbook.ChequebookCreationDate AS ChequebookCreationDate,
  I_APCheckbook.ChequebookCreationTime AS ChequebookCreationTime,
  cast(dats_tims_to_tstmp(ChequebookCreationDate, ChequebookCreationTime, abap_system_timezone($session.client, 'NULL'), $session.client,'NULL') as timestamp) AS CheckbookCreationDateTime,
  I_APCheckbook.ChequeType AS ChequeType,
  I_APCheckbook.ChequebookStatus AS ChequebookStatus,
  _Company.CompanyCodeName AS CompanyName,
  _Company.Country AS Country,
  _HouseBank._HouseBank._Bank.BankName AS HouseBankName,
  _HouseBank.BankAccount AS BankAccount,
  BankAccountName
FROM I_APCheckbook
LEFT OUTER JOIN I_CompanyCode AS _Company ON _Company.CompanyCode = PaymentCompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBank ON _HouseBank.CompanyCode = PaymentCompanyCode AND _HouseBank.HouseBank = HouseBank AND _HouseBank.HouseBankAccount = HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN E_Apcheckbook AS _Extension ON _Extension.PaymentCompanyCode = PaymentCompanyCode AND _Extension.HouseBank = HouseBank AND _Extension.HouseBankAccount = HouseBankAccount AND _Extension.Chequebook = Chequebook  -- association [1..1]
;

Learn More