SALESPLAN_ITEM_D - I_SALESPLANTP I_SALESPLANITEMTP

I_SALESPLANTP I_SALESPLANITEMTP information is stored in SAP table SALESPLAN_ITEM_D.
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_D

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
SALESPLANITEMUUIDSales Plan Item UUIDXSALES_PLAN_ITEM_UUIDRAW16
SALESPLANUUIDSales Plan Object UUIDSALES_PLAN_UUIDRAW16
SALESORGANIZATIONSales OrganizationVKORGCHAR8
DISTRIBUTIONCHANNELDistribution ChannelVTWEGCHAR4
ORGANIZATIONDIVISIONOrganization DivisionORGANIZATION_DIVISIONCHAR4
SALESOFFICESales officeVKBURCHAR8
SALESGROUPSales groupVKGRPCHAR6
SALESDISTRICTSales DistrictBZIRKCHAR12
CUSTOMERSold-to PartyKUNAGCHAR20
CUSTOMERGROUPCustomer GroupKDGRPCHAR4
SHIPTOPARTYShip-to PartyKUNWECHAR20
BILLTOPARTYBill-to PartyKUNRECHAR20
PAYERPARTYPayerKUNRGCHAR20
ADDITIONALCUSTOMERGROUP1Customer Group 1KVGR1CHAR6
ADDITIONALCUSTOMERGROUP2Customer Group 2KVGR2CHAR6
ADDITIONALCUSTOMERGROUP3Customer Group 3KVGR3CHAR6
ADDITIONALCUSTOMERGROUP4Customer Group 4KVGR4CHAR6
ADDITIONALCUSTOMERGROUP5Customer Group 5KVGR5CHAR6
DIVISIONDivisionSPARTCHAR4
PRODUCTProduct NumberPRODUCTNUMBERCHAR80
PRODUCTGROUPProduct GroupPRODUCTGROUPCHAR18
MATERIALProduct NumberPRODUCTNUMBERCHAR80
MATERIALGROUPProduct GroupPRODUCTGROUPCHAR18
ADDITIONALMATERIALGROUP1Material Group 1MVGR1CHAR6
ADDITIONALMATERIALGROUP2Material Group 2MVGR2CHAR6
ADDITIONALMATERIALGROUP3Material Group 3MVGR3CHAR6
ADDITIONALMATERIALGROUP4Material Group 4MVGR4CHAR6
ADDITIONALMATERIALGROUP5Material Group 5MVGR5CHAR6
SALESEMPLOYEESales EmployeeSALES_EMPLNUMC16
PLANTPlantWERKS_DCHAR8
SHIPPINGTYPEShipping TypeVSARTTRCHAR4
PROFITCENTERProfit CenterPRCTRCHAR20
COSTCENTERCost CenterKOSTLCHAR20
COMPANYCODECompany CodeBUKRSCHAR8
CONTROLLINGAREAControlling AreaKOKRSCHAR8
BUSINESSAREABusiness AreaGSBERCHAR8
COUNTRYCountry/Region KeyLAND1CHAR6
BILLTOPARTYCOUNTRYDestination Country/Region of Sales OrderLLAND_AUFTCHAR6
REGIONRegion (State, Province, County)REGIOCHAR6
BILLTOPARTYREGIONRegion of Sales OrderREGIO_AUFTCHAR6
SALESPLANPERIODSales Plan PeriodSALES_PLAN_PERIODDATS16
SALESPLANAMOUNTSales Plan AmountSALES_PLAN_AMOUNTCURR10
SALESPLANCURRENCYSales Plan CurrencySALES_PLAN_CURRENCYCUKY10
SALESPLANQUANTITYPlanned QuantitySALES_PLAN_QUANTITYQUAN8
SALESPLANUNITUnit of Measure Used in Sales PlansSALES_PLAN_UNITUNIT6
ACTIVEUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
.INCLUDESDRAFT_WRITE_DRAFT_ADMIN0
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC11
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC11
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft - Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR2
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR2
.INCLUDESDBILLGDOCITEM_INCL_EEW_PS0
DUMMY_BILLGDOCITEM_INCL_EEW_PSDummy function in length 1DUMMYCHAR2
.INCLUDESDBILLINGDOC_INCL_EEW_PS0
DUMMY_BILLINGDOC_INCL_EEW_PSDummy function in length 1DUMMYCHAR2
.INCLUDESDSALESDOCITEM_INCL_EEW_PS0
DUMMY_SLSDOCITEM_INCL_EEW_PSDummy function in length 1DUMMYCHAR2
.INCLUDESDSALESDOC_INCL_EEW_PS0
DUMMY_SALESDOC_INCL_EEW_PSDummy function in length 1DUMMYCHAR2
Privacy Policy