STAT

STAT is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
KEY anln1 anln1 1
KEY anln2 anln2 1
KEY bukrs bukrs 1
KEY gjahr gjahr 1
aworg aworg 1
awref belnr 1
awsys awsys 1
awtyp awtyp 1
bldat bldat 1
budat budat 1
bzdat bzdat 1
LastActionTs LastActionTs 1
LastWriteTs LastWriteTs 1
panl1 anlu1 1
panl2 anlu2 1
sgtxt sgtxt 1
SrvcMgmtObjectStatusIsInactive ServiceOrderIsNotNew,ServiceQuotationIsNotNew 2
vorgn vorgn 1
zuonr zuonr 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 STAT (
    ANLN1,
    ANLN2,
    BUKRS,
    GJAHR,
    AWORG,
    AWREF,
    AWSYS,
    AWTYP,
    BLDAT,
    BUDAT,
    BZDAT,
    LASTACTIONTS,
    LASTWRITETS,
    PANL1,
    PANL2,
    SGTXT,
    SRVCMGMTOBJECTSTATUSISINACTIVE,
    VORGN,
    ZUONR,
    PRIMARY KEY (ANLN1, ANLN2, BUKRS, GJAHR)
);