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 Sales Plan for Draft Handling

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