RECIPE

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 RECIPE (
    RECIPEUUID,
    _AUTHORIZATIONGROUP,
    _CREATEDBYUSER,
    _FORMULAFORKEYDATE,
    _LASTCHANGEDBYUSER,
    _LOGACCMOBJECTTYPEACTIVE,
    _LOGACCMOBJECTUSERAUTHZN,
    _LOGACCMOBJSECUREIDASSGMT,
    _PLANT,
    _PRIMARYOUTPUTSPECIFICATION,
    _RECIPEDESCRIPTION,
    _RECIPEPOMATERIALTEXT,
    _RECIPEPURPOSE,
    _RECIPESTATUS,
    _RECIPETYPE,
    MATERIAL,
    RCPFMLAITEMTYPE,
    RCPFMLAITEMUUID,
    RCPFMLAUUID,
    RECIPE,
    RECIPEALTERNATIVENUMBER,
    RECIPEAUTHORIZATIONGROUP,
    RECIPECREATEDBYUSER,
    RECIPECREATIONDATETIME,
    RECIPEFMLAITEMALTVISUSED,
    RECIPEISARCHIVED,
    RECIPEISDELETED,
    RECIPELASTCHANGEDATETIME,
    RECIPELASTCHANGEDBYUSER,
    RECIPEPRIMARYOUTPUTINTERNALID,
    RECIPEPRIMARYOUTPUTMATERIAL,
    RECIPEPRIMOUTPSPECTYPE,
    RECIPEPRIMOUTPSUBSTNATR,
    RECIPEPRIMOUTPSUBSTNATRDESC,
    RECIPEPRIMOUTPUTMATERIALNAME,
    RECIPEPROCESSUUID,
    RECIPEPROPERTYSPECINTERNALID,
    RECIPEPURPOSE,
    RECIPESTATUS,
    RECIPESTATUSSCHEMA,
    RECIPETYPE,
    RECIPEUNIQUEID,
    RECIPEVALIDITYENDDATE,
    RECIPEVALIDITYMAXQUANTITY,
    RECIPEVALIDITYMINQUANTITY,
    RECIPEVALIDITYSTARTDATE,
    RECIPEVALIDITYUNIT,
    RECIPEVERSIONNUMBER,
    PRIMARY KEY (RECIPEUUID)
);