SALESPLAN_ITEM_D

Transparent Table Application Table
57 Fields 1 CDS Views

I_SALESPLANTP I_SALESPLANITEMTP

SALESPLAN_ITEM_D is an SAP database table in S/4HANA. I_SALESPLANTP I_SALESPLANITEMTP. It contains 57 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SalesPlanItemWithDraft view union_all COMPOSITE

Fields (57)

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 PRODUCTNUMBER Product
productgroup PRODUCTGROUP Product Group
material PRODUCTNUMBER Product
materialgroup PRODUCTGROUP Product 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
activeuuid /BOBF/UUID Key
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_billgdocitem_incl_eew_ps DUMMY Dummy function in length 1
dummy_billingdoc_incl_eew_ps DUMMY Dummy function in length 1
dummy_slsdocitem_incl_eew_ps DUMMY Dummy function in length 1
dummy_salesdoc_incl_eew_ps DUMMY Dummy function in length 1

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.

-- I_SALESPLANTP I_SALESPLANITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SALESPLAN_ITEM_D (
    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,                         -- Product [PRODUCTNUMBER]
    PRODUCTGROUP,                    -- Product Group [PRODUCTGROUP]
    MATERIAL,                        -- Product [PRODUCTNUMBER]
    MATERIALGROUP,                   -- Product Group [PRODUCTGROUP]
    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]
    ACTIVEUUID,                      -- Key [/BOBF/UUID]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_BILLGDOCITEM_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    DUMMY_BILLINGDOC_INCL_EEW_PS,    -- Dummy function in length 1 [DUMMY]
    DUMMY_SLSDOCITEM_INCL_EEW_PS,    -- Dummy function in length 1 [DUMMY]
    DUMMY_SALESDOC_INCL_EEW_PS,      -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, SALESPLANITEMUUID)
);

Learn More