SAP Tips and Tricks

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.

Material forecasts are stored in PROW table. But it is not indexed by material number. It is indexed by pointer. The link to PROW is through PROP through MAPR. MAPR-> Get POinter for forecast Parameters (PNUM1)-> Read PROP ->Get Pointer for forecast results (PNUM2)->Read PROW using PNUM2.

Wikipedia offers a very simple definition for consignment . It is a process of placing a thing in the hand of another, but retaining the ownership until the goods are sold or used. In SAP consignment business process can be implemented very easily using the following steps. Activate Consignment inforecords using tcode OMEV. This activates the consignment prices to be picked up using the consignment info records. configure a special procurement type using IMG->Production->MRP->Master Data->Define special procurement type. In OBYC configure the consignment payables account (transaction KON). Assign the special procurement type created in step 2 to all the materials that are to use the consignment process. This is done in the MRP2 view of the material master maintenance transaction Create Consignment info record using tcode ME11. Select info category as consignment. Create general data, Purchase Org data and conditions. Conditions allow you to create time dependent prices. Cre...

Here is a piece of code to write ABAP reports and format them easily and quickly. The following code can be created as an include and used whenever required. This code uses the ABAP objects and created as local class. This include can be used for printing Internal tables, either by passing the whole table or by passing individual lines. Using the following steps the report output can be easily formatted. Create object with referance to lcl_report. Create column formats for individual columns by building the t_format structure and calling the method add_column as follows call method x->add_column exporting l_format = comp_print = 'K' (to print the column with key color) comp_print = 'H' (to print the column as hotspot) Call method write_table for listing the whole internal table. call method x->write_table exporting p_table = Call method write_line for listing one line at a time. May be used in cases where loop control is with the main program. call method x...

Many times in the past, other application support teams and even business teams had requested for soft copy of the characteristic hierarchy, so that they can replicate information in the hierarchical way SAP is showing. The following tables store the details of the tree structure TKCHH SAP-EIS: Hierarchy header TKCHHT SAP-EIS: Texts for hierarchy header TKCHN SAP-EIS Hierarchy nodes TKCHNT SAP-EIS: Hierarchy node texts TKCHV SAP-EIS: Hierarchy variants TKCHVT SAP-EIS: Description of hierarchy variants TKCHW SAP-EIS: Hierarchy data The tree structure can be replicated using the TKCHW table, which stores the tree relationship.

I remember, when I learnt COBOL, our instructor used to give us problems to solve. One of the problems often repeated in all programming classes was to write the code for rounding off numbers, without using built in functions. In SAP it is a bit tricky, as SAP stores amout fields as currency types. These fields are stored internally with 2 decimals, irrespective of the currency used. It can be easily done using write statement if you want to round the amount field in the report. How to do it if you want to round it store it as a currency amount field itself. This is a problem in SAP query reports. In my case the user wanted to amount fields to appear rounded to nearest integer. SAP has some built-in-functions like ceil, floor but they can not be used as it is, due to the fact that the amount is stored internally with 2 decimals. Most of the currencies are with 2 decimals and it is still not a problem. This can be easily achieved by the following operation. A constant need to be defin...

I received this request in many forms from various users including auditors. Though it came in differant flavours, the basic requirement is to identify, the different approvars and the final approvar who caused the release of the document. In our company we are using workflow mainly for PR and PO approvals. All the previous instances I avoided looking into that saying that it is difficult to get our hands into the workflow system and it is complicated. Finally this time I thought, let me see how this can be done. After spending half a day, I realised that it is not that difficult at all. There are two function modules, which satisfies my requirement. But this can be improved based on individual requirement. The first function module is SAP_WAPI_WORKITEMS_TO_OBJECT. This one gives the list of work items for a specific object. This even allows to select based on a time frame. The output table contains the workitem ID of the workflow apart from many other details. Again in our company ...