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".
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 |
---|---|---|---|---|---|---|
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 | ||
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 | Product Number | PRODUCTNUMBER | CHAR | 80 | ||
PRODUCTGROUP | Product Group | PRODUCTGROUP | CHAR | 18 | ||
MATERIAL | Product Number | PRODUCTNUMBER | CHAR | 80 | ||
MATERIALGROUP | Product Group | PRODUCTGROUP | 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 | ||
ACTIVEUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16 | ||
HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
.INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 | ||
.INCLUDE | SDBILLGDOCITEM_INCL_EEW_PS | 0 | ||||
DUMMY_BILLGDOCITEM_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 | SDSALESDOCITEM_INCL_EEW_PS | 0 | ||||
DUMMY_SLSDOCITEM_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 2 | ||
.INCLUDE | SDSALESDOC_INCL_EEW_PS | 0 | ||||
DUMMY_SALESDOC_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 2 |