FINS_PLAN_SCOPE

Transparent Table System Table (SAP only)
11 Fields 1 CDS Views

Plan data upload: scope

FINS_PLAN_SCOPE is an SAP database table in S/4HANA. Plan data upload: scope. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinPlanningUploadScopeItem view from BASIC Basis View for plan data scope item

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uuid FINS_PLAN_UUID UUID
KEY pos FINS_PLAN_POS Item Number
KEY fieldname FINS_PLAN_FIELDNAME Field Name
sign FINS_PLAN_SCOPE_SIGN Sign
opt FINS_PLAN_SCOPE_OPTION Option
low FINS_PLAN_SCOPE_LOW Low
high FINS_PLAN_SCOPE_HIGH High
createdat TIMESTAMP Time Stamp
fieldname_tech FIELDNAME Field Name
field_desc FINS_PLAN_FIELD_DESC Description of field

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.

-- Plan data upload: scope
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_PLAN_SCOPE (
    MANDT,           -- Client [MANDT]
    UUID,            -- UUID [FINS_PLAN_UUID]
    POS,             -- Item Number [FINS_PLAN_POS]
    FIELDNAME,       -- Field Name [FINS_PLAN_FIELDNAME]
    SIGN,            -- Sign [FINS_PLAN_SCOPE_SIGN]
    OPT,             -- Option [FINS_PLAN_SCOPE_OPTION]
    LOW,             -- Low [FINS_PLAN_SCOPE_LOW]
    HIGH,            -- High [FINS_PLAN_SCOPE_HIGH]
    CREATEDAT,       -- Time Stamp [TIMESTAMP]
    FIELDNAME_TECH,  -- Field Name [FIELDNAME]
    FIELD_DESC,      -- Description of field [FINS_PLAN_FIELD_DESC]
    PRIMARY KEY (MANDT, UUID, POS, FIELDNAME)
);

Learn More