P_JOURNALENTRYITEM

P_JOURNALENTRYITEM is an SAP database table in S/4HANA. It contains 8 fields.

Fields (8)

KeyField CDS FieldsUsed in Views
AccountingDocumentItem AccountingDocumentItem 3
Customer Customer 1
FinancialAccountType FinancialAccountType 3
InvoiceReference InvoiceReference 3
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 3
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
Supplier Supplier 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_JOURNALENTRYITEM (
    ACCOUNTINGDOCUMENTITEM,
    CUSTOMER,
    FINANCIALACCOUNTTYPE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    SUPPLIER
);