P_APCHECKBOOK

CDS View

P_APCHECKBOOK is a CDS View in S/4HANA. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_APCheckbook view from BASIC Cheque book

Fields (17)

KeyField CDS FieldsUsed in Views
KEY Chequebook Chequebook 1
KEY HouseBank HouseBank 1
KEY HouseBankAccount HouseBankAccount 1
KEY PaymentCompanyCode PaymentCompanyCode 1
ChequebookCreatedByUser ChequebookCreatedByUser 1
ChequebookCreationDate ChequebookCreationDate 1
ChequebookCreationTime ChequebookCreationTime 1
ChequebookFirstCheque ChequebookFirstCheque 1
ChequebookIsNonSequential ChequebookIsNonSequential 1
ChequebookLastCheque ChequebookLastCheque 1
ChequebookMinimalChequeCount ChequebookMinimalChequeCount 1
ChequebookName ChequebookName 1
ChequebookPaymentMethodList ChequebookPaymentMethodList 1
ChequebookPurchaser ChequebookPurchaser 1
ChequeType ChequeType 1
LastAssignedCheque LastAssignedCheque 1
NextChequebook NextChequebook 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_APCHECKBOOK (
    CHEQUEBOOK,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    PAYMENTCOMPANYCODE,
    CHEQUEBOOKCREATEDBYUSER,
    CHEQUEBOOKCREATIONDATE,
    CHEQUEBOOKCREATIONTIME,
    CHEQUEBOOKFIRSTCHEQUE,
    CHEQUEBOOKISNONSEQUENTIAL,
    CHEQUEBOOKLASTCHEQUE,
    CHEQUEBOOKMINIMALCHEQUECOUNT,
    CHEQUEBOOKNAME,
    CHEQUEBOOKPAYMENTMETHODLIST,
    CHEQUEBOOKPURCHASER,
    CHEQUETYPE,
    LASTASSIGNEDCHEQUE,
    NEXTCHEQUEBOOK,
    PRIMARY KEY (CHEQUEBOOK, HOUSEBANK, HOUSEBANKACCOUNT, PAYMENTCOMPANYCODE)
);