FINDER_CACHE

FINDER_CACHE is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY RecipeFinderCacheLineUUID RecipeFinderCacheLineUUID 2
KEY RecipeFinderCacheUUID RecipeFinderCacheUUID 3
Material Material 2
RecipeFinderSearchItem RecipeFinderSearchItem 2
RecipeUUID RecipeUUID 2
RecipeWhereUsedResultQtyInPct RecipeWhereUsedResultQtyInPct 1
SourceRecipeUUID SourceRecipeUUID 2
Specification Specification 2
SpecificationInternalID SpecificationInternalID 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 FINDER_CACHE (
    RECIPEFINDERCACHELINEUUID,
    RECIPEFINDERCACHEUUID,
    MATERIAL,
    RECIPEFINDERSEARCHITEM,
    RECIPEUUID,
    RECIPEWHEREUSEDRESULTQTYINPCT,
    SOURCERECIPEUUID,
    SPECIFICATION,
    SPECIFICATIONINTERNALID,
    PRIMARY KEY (RECIPEFINDERCACHELINEUUID, RECIPEFINDERCACHEUUID)
);