SALESPLAN

Transparent Table Application Table
21 Fields 2 CDS Views

Sales Plan

SALESPLAN is an SAP database table in S/4HANA. Sales Plan. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SalesPlan view from BASIC Sales Plan Header
P_SalesPlanWithDraft view from COMPOSITE

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY salesplanuuid SALES_PLAN_UUID Sales Plan UUID
salesplan SALES_PLAN Sales Plan
salesplanversion SALES_PLAN_VERSION Version
salesplandescription SALES_PLAN_DESC Plan Description
salesplanversiondescription SALES_PLAN_VERSION_DESC Version Description
salesplanstatus SALES_PLAN_STATUS Release Status
salesplancurrency SALES_PLAN_CURRENCY Currency
salesplanperiodtype SALES_PLAN_PERIOD_TYPE Planned By
salesplanpurpose SALES_PLAN_PURPOSE Planned For
salesplantype SALES_PLAN_TYPE Type
salesplanfrom SALES_PLAN_FROM Planned From
salesplanto SALES_PLAN_TO Planned To
createdbyuser ERNAM Created By
creationdatetime CREATION_DATE_TIME Created On
lastchangedbyuser AENAM Changed By
lastchangedatetime LAST_CHANGED_DATE_TIME Last Changed On
referencesalesplanuuid REF_SALES_PLAN_UUID Reference UUID
assignedteamid SP_ASSIGNED_TEAM Shared with Team
assignedteamname SP_ASSIGNED_TEAM_NAME Shared with Team
salesplanitemupdateddesc PLAN_DATA_UPDATED Plan Data Updated On

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.

-- Sales Plan
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SALESPLAN (
    MANDT,                        -- Client [MANDT]
    SALESPLANUUID,                -- Sales Plan UUID [SALES_PLAN_UUID]
    SALESPLAN,                    -- Sales Plan [SALES_PLAN]
    SALESPLANVERSION,             -- Version [SALES_PLAN_VERSION]
    SALESPLANDESCRIPTION,         -- Plan Description [SALES_PLAN_DESC]
    SALESPLANVERSIONDESCRIPTION,  -- Version Description [SALES_PLAN_VERSION_DESC]
    SALESPLANSTATUS,              -- Release Status [SALES_PLAN_STATUS]
    SALESPLANCURRENCY,            -- Currency [SALES_PLAN_CURRENCY]
    SALESPLANPERIODTYPE,          -- Planned By [SALES_PLAN_PERIOD_TYPE]
    SALESPLANPURPOSE,             -- Planned For [SALES_PLAN_PURPOSE]
    SALESPLANTYPE,                -- Type [SALES_PLAN_TYPE]
    SALESPLANFROM,                -- Planned From [SALES_PLAN_FROM]
    SALESPLANTO,                  -- Planned To [SALES_PLAN_TO]
    CREATEDBYUSER,                -- Created By [ERNAM]
    CREATIONDATETIME,             -- Created On [CREATION_DATE_TIME]
    LASTCHANGEDBYUSER,            -- Changed By [AENAM]
    LASTCHANGEDATETIME,           -- Last Changed On [LAST_CHANGED_DATE_TIME]
    REFERENCESALESPLANUUID,       -- Reference UUID [REF_SALES_PLAN_UUID]
    ASSIGNEDTEAMID,               -- Shared with Team [SP_ASSIGNED_TEAM]
    ASSIGNEDTEAMNAME,             -- Shared with Team [SP_ASSIGNED_TEAM_NAME]
    SALESPLANITEMUPDATEDDESC,     -- Plan Data Updated On [PLAN_DATA_UPDATED]
    PRIMARY KEY (MANDT, SALESPLANUUID)
);

Learn More