JOURNALENTRYWITHCOMPTYPE

12 Fields

JOURNALENTRYWITHCOMPTYPE is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY SourceLedger SourceLedger 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
DocumentReferenceID DocumentReferenceID 1
ElectronicInvoiceUUID ElectronicInvoiceUUID 1
TaxNumber1 TaxNumber1 1
TransactionCurrency TransactionCurrency 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 JOURNALENTRYWITHCOMPTYPE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    DOCUMENTREFERENCEID,
    ELECTRONICINVOICEUUID,
    TAXNUMBER1,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More