Technical Details for SAP TM Planning Profile and Settings


Introduction

SAP TM optimizer uses the Planning Profile to plan the Freight Units into Freight Order using the best possible way on available Vehicles via available routes.

Planning profiles are created to check how system needs to do the planning and what we do in planning profile that system use to get the desired result for optimization.

A Planning Profile can contain many different settings like:

  • Capacity Selection Settings
  • Capacity Availability Settings
  • Optimizer Settings
  • Cost & Constraints Settings
  • Load Planning Settings
  • Incompatibility Settings
  • Carrier Selection Settings
  • Manual Planning Settings

Now, there can be requirements where we need to know where the planning profile information resides in the SAP System. For example, we need to see the Resource assigned in the Capacity Selection Settings in the ABAP code to get the resource calendar.

This blog explains how to find the planning profiles and the settings in the SAP backend tables.

Technical Details for Planning Profiles and Settings

The planning Profile and the associated settings assigned all are stored as Business Objects in the SAP System. And to view them , you need to go to the BOBF Transaction and look under the Metadata Object Section as shown in the screenshot below.

Now back to our use case,

We need to find the resource assigned to Capacity Selection Settings for a Planning Profile .

  • We have the Planning Profile Name , and we can use this to find the Capacity Selection Settings for the same.
  • Business Object for Planning Profile: /SCMTMS/VSR_PLANNING_PROFILE
  • Now we can directly find the table – /SCMTMS/D_PLAPRO from the root node to fetch the data or use the BOPF methods to get the root data. Check the BOBT testing using the alt key PROFILE_ID
    • The screenshot below shows the Planning Profile details and the Field UUID043 holds the Capacity Selection Settings Name
  • Now once you get the Capacity Selection Settings name, we can use the Business Object for Capacity Selection Settings to get the data stored.
  • Business Object for Capacity Selection Settings – /SCMTMS/VSR_CAPA_SEL_PROF
  • Again, either you can traverse the nodes directly using tables (ROOT/SCMTMS/D_CAPAPR, Node –RES_BY ATTRIBUTE/SCMTMS/D_CARESA or use BOPF to do so (recommended).
  • Check the BOBT test screen to see where the resources are stored.
    • The resources are stored in the child node RES_BY_ATTRIBUTE.

Conclusion

We found the resource/resources assigned to the Planning profile via Capacity Selection Settings. Similarly, we can use the Business Objects for each profile setting to get the details.

For a one-stop check, I have listed the business objects for each setting.

Profile/Settings Business Objects
Planning Profile /SCMTMS/VSR_PLANNING_PROFILE
Capacity Selection Settings /SCMTMS/VSR_CAPA_SEL_PROF
Optimizer Settings /SCMTMS/VSR_OPT_SETTING_PROF
Cost & Constraints Settings /SCMTMS/VSR_OPT_PLANCOSTS
Load Planning Settings /SCMTMS/LSO_OPT_SETTING_PROF
Incompatibility Settings /SCMTMS/INCOMP_SETTINGS
Carrier Selection Settings /SCMTMS/TSPS_PROFILE
Manual Planning Settings /SCMTMS/VSR_MP_SETTINGS
Capacity Availability Settings /SCMTMS/VSR_CAPA_AVAIL_PROF

I Hope this blog would be helpful to someone. Until next time, Adios!