Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table for material Coming in CO01

former_member1284402
Participant
0 Kudos

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.

1 ACCEPTED SOLUTION

former_member1245113
Active Contributor
0 Kudos

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

14 REPLIES 14

Former Member
0 Kudos

check table AUFP

former_member1245113
Active Contributor
0 Kudos

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

venkatesan_nagiah
Active Participant
0 Kudos

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

0 Kudos

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

kesavadas_thekkillath
Active Contributor
0 Kudos

For material availability try BAPI_MATERIAL_AVAILABILITY

cs13 - csap_mat_bom_read is used for BOM explosion.

0 Kudos

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.

0 Kudos

Thats the level one.

Pass the output materials again to that fm

0 Kudos

dear KSD but i have multi level BOM for that material. then how many times will i pass the output material?

0 Kudos

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.

0 Kudos

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.

0 Kudos

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

0 Kudos

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.

0 Kudos

do it with csap_mat_bom_read . surely it will list you the bill of material matrix

0 Kudos

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.