SAP SALESPLAN_D Table in S/4 HANA - I_SALESPLANTP I_SALESPLANTP
SALESPLAN_D is a standard SAP Table which is used to store I_SALESPLANTP I_SALESPLANTP data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP SALESPLAN_D table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Transparent table
Database Table: SALESPLAN_D
SALESPLAN_D table structure field list
Below is the full SALESPLAN_D field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
| SALESPLANUUID | Sales Plan Object UUID | SALES_PLAN_UUID | RAW | 16(0) | SYSUUID | |||||
| SALESPLAN | Sales Plan | SALES_PLAN | CHAR | 40(0) | TEXT40 | |||||
| SALESPLANVERSION | Sales Plan Version | SALES_PLAN_VERSION | CHAR | 40(0) | TEXT40 | |||||
| SALESPLANDESCRIPTION | Sales Plan Description | SALES_PLAN_DESC | CHAR | 80(0) | TEXT80 | |||||
| SALESPLANVERSIONDESCRIPTION | Sales Plan Version Description | SALES_PLAN_VERSION_DESC | CHAR | 80(0) | TEXT80 | |||||
| SALESPLANSTATUS | Sales Plan Release Status | SALES_PLAN_STATUS | CHAR | 1(0) | SALES_PLAN_STATUS | |||||
| SALESPLANCURRENCY | Sales Plan Currency | SALES_PLAN_CURRENCY | CUKY | 5(0) | WAERS | |||||
| SALESPLANPERIODTYPE | Sales Plan Period Type | SALES_PLAN_PERIOD_TYPE | CHAR | 1(0) | SALES_PLAN_PERIOD_TYPE | |||||
| SALESPLANFROM | Sales Plan Start Year Month | SALES_PLAN_FROM | DATS | 8(0) | DATE | |||||
| SALESPLANTO | Sales Plan End Year Month | SALES_PLAN_TO | DATS | 8(0) | DATE | |||||
| SALESPLANPURPOSE | Purposes of Sales Planning | SALES_PLAN_PURPOSE | CHAR | 1(0) | SALES_PLAN_PURPOSE | |||||
| SALESPLANTYPE | Type of Sales Plan | SALES_PLAN_TYPE | CHAR | 1(0) | SALES_PLAN_TYPE | |||||
| CREATEDBYUSER | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
| CREATIONDATETIME | Creation Date Time | CREATION_DATE_TIME | DEC | 21(7) | TZNTSTMPL | |||||
| LASTCHANGEDBYUSER | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
| LASTCHANGEDATETIME | Last Changed Date Time | LAST_CHANGED_DATE_TIME | DEC | 21(7) | TZNTSTMPL | |||||
| REFERENCESALESPLANUUID | Reference Sales Plan Object UUID | REF_SALES_PLAN_UUID | RAW | 16(0) | SYSUUID | |||||
| ASSIGNEDTEAMID | Sales Plan Team Assignment - Team ID | SP_ASSIGNED_TEAM | NUMC | 8(0) | HROBJID | |||||
| ASSIGNEDTEAMNAME | Sales Plan Team Assignment -Team Name | SP_ASSIGNED_TEAM_NAME | CHAR | 40(0) | CHAR40 | |||||
| SALESPLANITEMUPDATEDDESC | Plan Data Updated | PLAN_DATA_UPDATED | CHAR | 60(0) | CHAR60 | |||||
| ACTIVEUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16(0) | SYSUUID | |||||
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 1(0) | BOOLE | |||||
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 21(7) | TZNTSTMPL | |||||
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 21(7) | TZNTSTMPL | |||||
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16(0) | SYSUUID | |||||
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 1(0) | SDRAFT_CONSISTENCY_STATUS | |||||
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 1(0) | SDRAFT_OPERATION_CODE |
Search for further information about these or an SAP related objects