Personal Folder

     Freeze PO on Fully Release state do trouble. Urgent PO need to be revised and time to make direct edit to table. To edit PO net price, we need to edit Net price (and total price) (EKPO) and edit Condition (KONV). Link between EKKO and KONV is field KNUMV.

Go to SE16N, type &sap_edit to activate direct edit mode on table. Key in parameter, and input desired value.
SE16N

&SAP_EDIT

Do direct edit

     One of procurement audit finding is, PO release has to be reset whether PO value increase or decrease. Old fashion way, PO release only reset if total value is increase only. Testing and googling shows that there is no way PO release reset if total value is decrease. So we choose freeze PO on its fully release state.
SPRO > IMG > Materials Mangement > Purchasing > Purchase Order > Release Procedure for Purchase Orders > Define Release Procedure for Purchase Orders > Release Indicator

But then problem occur. If user want to edit the PO, it has to be un-released first. And still PO cant be un-released if PO has been issued (error is ‘Document has already been outputted… ’). We still waiting the solution from SAP. Or we need to create new different procurement procedure for this. Or, another solution is using user-exit.

     Something interesting found in this non valuated material. I’ve GR non val material 1700000015 for 15 EA. But in my customized report ZMMF001, the total stock is not updated. But in SAP standard report MB52, the quantity is updated. In report ZMMF001 I use account MBEW-LBKUM as a reference. While on MB52 it use MARD-LABST as reference.
ZMMF001

MB52

MM03 > Accounting1, field Total Stock (MBEW-LBKUM)

MM03 > Plant stock, field Unsres.use stock (MARD-LABST)

One of store audit finding result that we need to maintain ex-project material which has no value. This will be ‘non valuated material’. We need to define non valuated material type, material group, and valuation class.
1. Define material type OMS2

Create NVAL  material type reference to UNBW Nonvaluated materials

Select View. Set Internal/External Purchase Order to 0 since it will not go to procurement process. Set quantity updating in all valuation areas, and value updating in no val areas.

2. Define Number Range MMNR
Create new number range group and interval. Then assign the interval to the groups.



Experiment shows that on number range transport, current number is also transported to target system. We’ll set the number range for this non valuated material type manually.

3. Set valuation class OMSK
Create NVAL Account Category ref


Create NonValuated valuation class

Assign val class to Account Category Ref

Dear All,
Saya tidak bisa melakukan reservasi SAP 201 (withdraw stocl from Sparepart Room Warehouse) di hari Sabtu dan Minggu.
Bisa dijelaskan?
Trims
imamsn
-------
Dear pak Imam SN,
    Untuk bisa melakukan reservation di sabtu minggu, clear option "Check against cal." checkbox.

          Accounting staff try to create PPL for vendor 500011. At FBL1N there are overdue item for this vendor, but when she try to create PPL, no list generated. This problem occur sometimes, usually when user try it again later, it back to normal. But this time, the problem is persist. The payment identification is Y1011.
Overdue item on FBL1N

----
Answer:
We need to check whether PPL already created prior to this vendor.  It will need to delete that before you can run for this newly created PPL. For the next time when you experience the same issue, please follow steps below:
a. Go to transaction code: SE16; Enter table REGUH and execute.
b. From the list of the fields, key in vendor code. In this example; it will be 500011. This will show all the payment related to this vendor.
c. In each completed transactions, you should see 2 records with the same Run date and Identification. So, from here, it is clearly showed that PPL for Identification Y1011 has been run but not the payment. Need to delete this proposal if you want to generate the new one.

          LSMW will produce error if text data transported have carriage return character. We have to replace it with another character. But, how to search that character on text. I’m using ms excell to search and replace the character. On the search/replace window, hold down alt and type 013, release alt key. Carriage return key will be found/replaced. For line feeds character, type 010.
In excell, long text with carriage return will go across the screen. To view them as multiple line, go to Format Cells menu, tab Alignment, tick the Wrap text check box.