FJE

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

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CADocumentNumber CADocumentNumber 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
CADocContainsCashFlowItems CADocContainsCashFlowItems 1
CADocumentTypeForGLTransfer CADocumentTypeForGLTransfer 1
CAPostingDate CAPostingDate 1
CAReversedDocumentNumber CAReversedDocumentNumber 1
DocumentDate DocumentDate 1
HasUniqueClrgDate HasUniqueClrgDate 2
IsEUTriangularDeal IsEUTriangularDeal 1
TaxReportingDate TaxReportingDate 1
UniqueAcctgDocClrgDate UniqueAcctgDocClrgDate 2

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 FJE (
    CADOCUMENTNUMBER,
    COMPANYCODE,
    FISCALYEAR,
    CADOCCONTAINSCASHFLOWITEMS,
    CADOCUMENTTYPEFORGLTRANSFER,
    CAPOSTINGDATE,
    CAREVERSEDDOCUMENTNUMBER,
    DOCUMENTDATE,
    HASUNIQUECLRGDATE,
    ISEUTRIANGULARDEAL,
    TAXREPORTINGDATE,
    UNIQUEACCTGDOCCLRGDATE,
    PRIMARY KEY (CADOCUMENTNUMBER, COMPANYCODE, FISCALYEAR)
);