P_CN_JOURNALENTRYITEM

CDS View
12 Fields 5 CDS Views

P_CN_JOURNALENTRYITEM is a CDS View in S/4HANA. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_CN_BkRecnclnMchnLrngApplyItm view inner CONSUMPTION Apply Data for Bank Reconciliation ML
C_CN_BkRecnclnMchnLrngTrnItm view inner CONSUMPTION Training Data for Bank Reconciliation ML
C_CN_RecnclnJournalEntryItem view left_outer CONSUMPTION Journal Entry Items for BkRecnclnStmnt
P_CN_BKRECNCLN_V02 view inner CONSUMPTION
P_Cn_Recnclnjournalentryitem view from CONSUMPTION

Fields (12)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 3
AssignmentReference AssignmentReference 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentItemText DocumentItemText,JournalEntryItemText 3
PostingDate PostingDate 3
TransactionCurrency Currency,TransactionCurrency 3
ValueDate ValueDate 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_CN_JOURNALENTRYITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    COMPANYCODECURRENCY,
    DOCUMENTITEMTEXT,
    POSTINGDATE,
    TRANSACTIONCURRENCY,
    VALUEDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR)
);

Learn More