Mensagens

Count on internal tables - in new abap 7.4

Imagem
  Requirement Getting count of rows agains a key combination in ABAP 7.4. Here is a simple example of code where you can get the count of a key combination on an internal table table in new abap 7.4, as the following syntax shows:   Here is quite more complex requirement in SD Module, where i prevent the deletion of invoiced outbound deliveries (with no partial credits), but for this I need to count both invoices and credit notes, as my following code shows:    

CONSIDERING DELIVERY COSTS WHEN POST AN INVOICE ON MIRO

Imagem
  If you want to post planned delivery costs on MIRO you should select the option below on MIRO transaction, but note that if you find the button as greyed out, you also have the option to select those on the left button of the screen: Selecting from left button: Selecting from right button: If you want to hold these data, you can go to path: "system"-> "user profile"->"hold date"  You may have even another option, which is to configurate this setting on ESDUS Table, and more precisely on MIRO/ GOODS_DELCOSTS_DISPLAY field and select this value as "3" to always contempalte planned delivery costs by default, you can check this on LMR1MF5D include:

ERROR IN CONTRACTS UPDATING PRICE ON DATABASE (EKPO)

  Problem: If you work with purchasing contracts in SAP, you may have noticed that if you change the price of an item of the contract, that price may not be updated on the database, i am talking about the field NETPR on EKPO table. Solution: Run Report RM06ENP0. This report execution will correct any prices on every contract on the database    RM06ENP0. This report has test mode and can also just simply schedule a job to correct this prices everytime.

CLASS MAINTENANCE BY CLMM

Imagem
  This topic will be about class maintenance, for instance when you have an object or multiple objects assigned to a class, we can do the mass maintenance of that object or multiple objects by running the CLMM transaction: The first option “Copy values assigned to a object” allows you to copy all the characteristic values to another object or multiple objects: Just insert the values on the characteristics that you want to insert and then click on the "copy characteristics value" button and the values will be memorized, on the second tab you may put the destination objects : Right above you will get two options: test mass change or actual mass change: As you can see if you make these changes on test mode you will get the simulation of the values change, but if you press the other option obviously you will get the effective changes: Anyway I advise you to be careful when you try ovewrite values, just check carefully all the data before you execute the effetive change in order t...

MIGO SETTINGS

Imagem
 Problem: In MIGO transaction items are not being selected ->  Example: the PO is fully delivered but after that I set or increase the overdelivery tolerance in the PO, but after that the items are yet not displayed in MIGO: Inside MIGO transaction, please go to "Settings"-> "Default Values". Then make sure all check-boxes are ticked and you also select "Propose all Items" Then check if all the items are set on the screen: I hope this is helpful.

CALL TRANSACTION MIGO

Imagem
  One useful tip for ABAP/MM consultants, when you make a "call transaction" statement that can be tricky when you do it for MIGO, because you as you may know  for MIGO we have several modes: A01 is for good receipts -> BES ID parameter A04 is for displaying material documents->MBN ID parameter So if you want to make that hotspot for the MIGO transaction in display mode in one of your reports, you can use the standard "MIGO DIALOG" MF with the following import parameters values: I_ACTION  =  'A04' I_REFDOC  =  'R02' Here is an example of my code for this purpose, and in this case I will always select the year of my document on the MSEG table because I don't want to have trouble if I'm accessing consecutive document from different years (MJA is the parameter for the year value):   ELSEIF  rs_selfield - sel_tab_field  =  'XXXX'          AND NOT  rs_selfield - value...

Define Seletion Parameters

Imagem
  Hi all, in this small section I will show how to create/change selection Parameters for standard reports. Please proceed accessing the following SPRO path: Materials Management -> Purchasing -> Reporting -> Maintain Purchasing Lists-> Selection Parameters-> Define Selection Parameters In this case, I will select the "WEWONINVOIC" Selection Parameter: In this case is defined that this parameter will select POs which have delivered quantity superior than the invoiced quantity, but note that we have a few other options that can be very useful, for instance I can select the "final invoice" indicator, which could be useful because by selecting this option it will remove this flagged POs in this situation from my lists: