SALESPLAN_ITEM

Transparent Table Application Table
46 Fields 3 CDS Views

Sales Plan Item

SALESPLAN_ITEM is an SAP database table in S/4HANA. Sales Plan Item. It contains 46 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_SalesPlanItem view from EXTENSION Sales Plan Item Extension
I_SalesPlanItem view from BASIC Sales Plan Item
P_SalesPlanItemWithDraft view from COMPOSITE Sales Plan Item for Draft Handling

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY salesplanitemuuid sales_plan_item_uuid SP Item UUID
salesplanuuid sales_plan_uuid Sales Plan UUID
salesorganization vkorg Sales Org.
distributionchannel vtweg Distr. Channel
organizationdivision organization_division Org. Division
salesoffice vkbur Sales Office
salesgroup vkgrp Sales Group
salesdistrict bzirk Sales District
customer kunag Sold-to Party
customergroup kdgrp Customer Group
shiptoparty kunwe Ship-to Party
billtoparty kunre Bill-to Party
payerparty kunrg Payer
additionalcustomergroup1 kvgr1 Customer Grp 1
additionalcustomergroup2 kvgr2 Customer Grp 2
additionalcustomergroup3 kvgr3 Customer Grp 3
additionalcustomergroup4 kvgr4 Customer Grp 4
additionalcustomergroup5 kvgr5 Customer Grp 5
division spart Division
product matnr Material
productgroup matkl Material Group
material matnr Material
materialgroup matkl Material Group
additionalmaterialgroup1 mvgr1 MaterialGroup 1
additionalmaterialgroup2 mvgr2 MaterialGroup 2
additionalmaterialgroup3 mvgr3 MaterialGroup 3
additionalmaterialgroup4 mvgr4 MaterialGroup 4
additionalmaterialgroup5 mvgr5 MaterialGroup 5
salesemployee sales_empl Sales Employee
plant werks_d Plant
shippingtype vsarttr Shipping Type
profitcenter prctr Profit Center
costcenter kostl Cost Center
companycode bukrs Company Code
controllingarea kokrs CO Area
businessarea gsber Business Area
country land1 Country/Reg.
billtopartycountry lland_auft Dst.CtryRg.Ord.
region regio Region
billtopartyregion regio_auft Region Order
salesplanperiod sales_plan_period Sales Plan period
salesplanamount sales_plan_amount Sales Plan amount
salesplancurrency sales_plan_currency Currency
salesplanquantity sales_plan_quantity Planned Qty
salesplanunit sales_plan_unit Unit of Measure

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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SALESPLAN_ITEM (
    MANDT,                     -- Client [mandt]
    SALESPLANITEMUUID,         -- SP Item UUID [sales_plan_item_uuid]
    SALESPLANUUID,             -- Sales Plan UUID [sales_plan_uuid]
    SALESORGANIZATION,         -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,       -- Distr. Channel [vtweg]
    ORGANIZATIONDIVISION,      -- Org. Division [organization_division]
    SALESOFFICE,               -- Sales Office [vkbur]
    SALESGROUP,                -- Sales Group [vkgrp]
    SALESDISTRICT,             -- Sales District [bzirk]
    CUSTOMER,                  -- Sold-to Party [kunag]
    CUSTOMERGROUP,             -- Customer Group [kdgrp]
    SHIPTOPARTY,               -- Ship-to Party [kunwe]
    BILLTOPARTY,               -- Bill-to Party [kunre]
    PAYERPARTY,                -- Payer [kunrg]
    ADDITIONALCUSTOMERGROUP1,  -- Customer Grp 1 [kvgr1]
    ADDITIONALCUSTOMERGROUP2,  -- Customer Grp 2 [kvgr2]
    ADDITIONALCUSTOMERGROUP3,  -- Customer Grp 3 [kvgr3]
    ADDITIONALCUSTOMERGROUP4,  -- Customer Grp 4 [kvgr4]
    ADDITIONALCUSTOMERGROUP5,  -- Customer Grp 5 [kvgr5]
    DIVISION,                  -- Division [spart]
    PRODUCT,                   -- Material [matnr]
    PRODUCTGROUP,              -- Material Group [matkl]
    MATERIAL,                  -- Material [matnr]
    MATERIALGROUP,             -- Material Group [matkl]
    ADDITIONALMATERIALGROUP1,  -- MaterialGroup 1 [mvgr1]
    ADDITIONALMATERIALGROUP2,  -- MaterialGroup 2 [mvgr2]
    ADDITIONALMATERIALGROUP3,  -- MaterialGroup 3 [mvgr3]
    ADDITIONALMATERIALGROUP4,  -- MaterialGroup 4 [mvgr4]
    ADDITIONALMATERIALGROUP5,  -- MaterialGroup 5 [mvgr5]
    SALESEMPLOYEE,             -- Sales Employee [sales_empl]
    PLANT,                     -- Plant [werks_d]
    SHIPPINGTYPE,              -- Shipping Type [vsarttr]
    PROFITCENTER,              -- Profit Center [prctr]
    COSTCENTER,                -- Cost Center [kostl]
    COMPANYCODE,               -- Company Code [bukrs]
    CONTROLLINGAREA,           -- CO Area [kokrs]
    BUSINESSAREA,              -- Business Area [gsber]
    COUNTRY,                   -- Country/Reg. [land1]
    BILLTOPARTYCOUNTRY,        -- Dst.CtryRg.Ord. [lland_auft]
    REGION,                    -- Region [regio]
    BILLTOPARTYREGION,         -- Region Order [regio_auft]
    SALESPLANPERIOD,           -- Sales Plan period [sales_plan_period]
    SALESPLANAMOUNT,           -- Sales Plan amount [sales_plan_amount]
    SALESPLANCURRENCY,         -- Currency [sales_plan_currency]
    SALESPLANQUANTITY,         -- Planned Qty [sales_plan_quantity]
    SALESPLANUNIT,             -- Unit of Measure [sales_plan_unit]
    PRIMARY KEY (MANDT, SALESPLANITEMUUID)
);

Learn More