11-25-2009 6:47 AM
Hi all,
i have to make a Z report in which user can chech the material availability before order confirmation, so that i need to take those materials which are coming in item over view during order confirmation. but problem is that i m not getting the table.
can anyone plz help me? i have checked the table RESB.
regards saurabh.
11-25-2009 8:39 AM
Hi,
For Order ITem level Table AFPO --> MATNR
For Order ITem level Table AFKO --> MATNR
Or optionally at header level CAUFV --> PLNBZ
It depends on so many factors. if the order is against the Sales Order then go to MSKA tabel if it is against the Project Stock then go to MSPR table, RESB will also work for you.
IF you simply looking for Material against the Production order above tables are good one.
Cheerz
Ram
11-25-2009 8:33 AM
11-25-2009 8:39 AM
Hi,
For Order ITem level Table AFPO --> MATNR
For Order ITem level Table AFKO --> MATNR
Or optionally at header level CAUFV --> PLNBZ
It depends on so many factors. if the order is against the Sales Order then go to MSKA tabel if it is against the Project Stock then go to MSPR table, RESB will also work for you.
IF you simply looking for Material against the Production order above tables are good one.
Cheerz
Ram
11-25-2009 9:26 AM
yes RESB is the right table. which is material reservation for that particular order.
you have AUFNR field in RESB, you can query based on order number.
thanks,
venkat
11-25-2009 11:20 AM
Noooo i dont have to consider materials after order, i have to check the materials before order creation.
can anyone plz tell me the table or FM or BAPI for finding those materials coming in tcode CS13?
saurabh.
Edited by: saurabh srivastava on Nov 26, 2009 12:48 PM
11-26-2009 11:59 AM
For material availability try BAPI_MATERIAL_AVAILABILITY
cs13 - csap_mat_bom_read is used for BOM explosion.
11-26-2009 12:11 PM
hello ksd thanks for reply,
i m passing the material in this FM but problem is that i m getting only 4 material that is of single level, while in CS13 it is showing 12 material. plz tell how can i get all 12 materials coming in CS13.
regards.
11-26-2009 12:14 PM
11-26-2009 12:18 PM
dear KSD but i have multi level BOM for that material. then how many times will i pass the output material?
11-26-2009 12:41 PM
Till the last level
Check this link fo inverse explosion ( Child to Parent )
link:[http://wiki.sdn.sap.com/wiki/display/Snippets/InverseorReverseBomwithQtyRequired]
In your case use the function module( Parent parts to child parts ) i provided and use the similar logic as per your requirement.
11-27-2009 5:00 AM
hello KSD,
thanx for reply, but this link is not fulfilling my requirement, actually i need only those material which are coming in CS13.
plz help.
11-27-2009 5:04 AM
can you check CS_BOM_EXPL_MAT_V2
you can use the function module i gave earlier.
just loop through each levels recursively.
in the link which i gave it explodes fro bottom level to top level.
For you its from top level to bottom levek. just apply the same logic and change the function module.
Then it will give you the multilevel bom
Edited by: ksd on Nov 27, 2009 10:40 AM
11-27-2009 5:38 AM
Dear KSD,
i checked this FM in SE37 but it don't have any data, so i think this FM is not applicable in ECC6.0?
regards.
11-27-2009 5:59 AM
do it with csap_mat_bom_read . surely it will list you the bill of material matrix
11-27-2009 6:17 AM
Dear KSD,
plz see....i have to make the report for checking material availabity coming during order creation in CO01 in component overview. so plz don't cosider it as Multilevel BOM only, just consider it from CO01 point of view.
regards.