SALESPLAN_ITEM - Sales Plan Item

Sales Plan Item information is stored in SAP table SALESPLAN_ITEM.
It is part of development package VDM_SD_SP in software component SD-ANA-SP. This development package consists of objects that can be grouped under "VDM SD Sales Planning".

Fields for table SALESPLAN_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
SALESPLANITEMUUID	Sales Plan Item UUID	X	SALES_PLAN_ITEM_UUID	RAW	16
SALESPLANUUID	Sales Plan Object UUID		SALES_PLAN_UUID	RAW	16	SALESPLAN
SALESORGANIZATION	Sales Organization		VKORG	CHAR	8
DISTRIBUTIONCHANNEL	Distribution Channel		VTWEG	CHAR	4
ORGANIZATIONDIVISION	Organization Division		ORGANIZATION_DIVISION	CHAR	4
SALESOFFICE	Sales office		VKBUR	CHAR	8
SALESGROUP	Sales group		VKGRP	CHAR	6
SALESDISTRICT	Sales District		BZIRK	CHAR	12
CUSTOMER	Sold-to Party		KUNAG	CHAR	20
CUSTOMERGROUP	Customer Group		KDGRP	CHAR	4
SHIPTOPARTY	Ship-to Party		KUNWE	CHAR	20
BILLTOPARTY	Bill-to Party		KUNRE	CHAR	20
PAYERPARTY	Payer		KUNRG	CHAR	20
ADDITIONALCUSTOMERGROUP1	Customer Group 1		KVGR1	CHAR	6
ADDITIONALCUSTOMERGROUP2	Customer Group 2		KVGR2	CHAR	6
ADDITIONALCUSTOMERGROUP3	Customer Group 3		KVGR3	CHAR	6
ADDITIONALCUSTOMERGROUP4	Customer Group 4		KVGR4	CHAR	6
ADDITIONALCUSTOMERGROUP5	Customer Group 5		KVGR5	CHAR	6
DIVISION	Division		SPART	CHAR	4
PRODUCT	Material Number		MATNR	CHAR	80
PRODUCTGROUP	Material Group		MATKL	CHAR	18
MATERIAL	Material Number		MATNR	CHAR	80
MATERIALGROUP	Material Group		MATKL	CHAR	18
ADDITIONALMATERIALGROUP1	Material Group 1		MVGR1	CHAR	6
ADDITIONALMATERIALGROUP2	Material Group 2		MVGR2	CHAR	6
ADDITIONALMATERIALGROUP3	Material Group 3		MVGR3	CHAR	6
ADDITIONALMATERIALGROUP4	Material Group 4		MVGR4	CHAR	6
ADDITIONALMATERIALGROUP5	Material Group 5		MVGR5	CHAR	6
SALESEMPLOYEE	Sales Employee		SALES_EMPL	NUMC	16
PLANT	Plant		WERKS_D	CHAR	8
SHIPPINGTYPE	Shipping Type		VSARTTR	CHAR	4
PROFITCENTER	Profit Center		PRCTR	CHAR	20
COSTCENTER	Cost Center		KOSTL	CHAR	20
COMPANYCODE	Company Code		BUKRS	CHAR	8
CONTROLLINGAREA	Controlling Area		KOKRS	CHAR	8
BUSINESSAREA	Business Area		GSBER	CHAR	8
COUNTRY	Country/Region Key		LAND1	CHAR	6
BILLTOPARTYCOUNTRY	Destination Country/Region of Sales Order		LLAND_AUFT	CHAR	6
REGION	Region (State, Province, County)		REGIO	CHAR	6
BILLTOPARTYREGION	Region of Sales Order		REGIO_AUFT	CHAR	6
SALESPLANPERIOD	Sales Plan Period		SALES_PLAN_PERIOD	DATS	16
SALESPLANAMOUNT	Sales Plan Amount		SALES_PLAN_AMOUNT	CURR	10
SALESPLANCURRENCY	Sales Plan Currency		SALES_PLAN_CURRENCY	CUKY	10
SALESPLANQUANTITY	Planned Quantity		SALES_PLAN_QUANTITY	QUAN	8
SALESPLANUNIT	Unit of Measure Used in Sales Plans		SALES_PLAN_UNIT	UNIT	6
.INCLUDE				SDSALESDOC_INCL_EEW_PS	0
DUMMY_SALESDOC_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				SDSALESDOCITEM_INCL_EEW_PS	0
DUMMY_SLSDOCITEM_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				SDBILLINGDOC_INCL_EEW_PS	0
DUMMY_BILLINGDOC_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				SDBILLGDOCITEM_INCL_EEW_PS	0
DUMMY_BILLGDOCITEM_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2