Skip to main content

Posts

Showing posts with the label BDC

Increase efficiency and speed of your sap support tasks with the help of Microsoft Excel and VBA

Background SAP Tcode SM30, is a very widely used transaction. Many IMG activities are simply update of table views using SM30. For example MRP controller IMG activity is nothing but sm30 on sap table view V_T024D. Apart from IMG activities, most of the SAP installations use many custom tables which are maintained using SM30. usually, the volume of such IMG activities in a support environment is a few records. As mentioned earlier, the amount of  MRP controllers that needs to be created when a new plant is created is usually huge. Here comes the problem. Many medium sized companies use a couple of 100 mrp controllers. The same problem happens when the business wants to add a new MRP controller to all existing plants. This again is easily a couple of hundreds. Moreover MRP controller IMG activity is not a table control; it has to be added one by one. This trick explained in this blog is very useful and saves time if the number of records exceeds hundred. This is limited to inserting...

Consumption values in MM02

Issue: A BDC updating consumption values in material master using MM02, presuming that by default the screen shows total consumption. You can switch to unplanned consumption using the button. But for some materials the initial consumption value is unplanned instead of total. So for these materials unplanned consumption is updated instead of total consumption. Solution: A parameter Consumption indicator of Forecast ( V438A-PROVB ) in MRP type configuration (OMDQ), decides the default consumption data.