on 03-20-2007 3:44 AM
Hello Experts,
I got the requirement to prepare a report for advance shipping notifications.. can any one guide what r the tables involved and the fileds involved to prepare the report.. or any one post me a sample code that would be really helpful for me
thanks alot in advanse
~~Guduri
Hi,
I think ASN stands for Advance Shipping Notifications. This notification is send by vendor which contains details about the purchase order and quantity which he is shipping to us.
The table to be used for ASN quantities is EKES ( Vendor Confirmations ). The field Confirmation category (EKES-VBTYP) indicates the ASN quantity when it is equal to 'LA'.
You can query this table using the purchase order and item no.
The quantity field (EKES-MENGE) can be used to get the total quantity.
I think this is all you need. Let me know your requirement in details incase it is not possible to create report with above info.
Regards,
Shahu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Shahuraj,
I got most of the info that i need for my requirements. But i need some more info for my following requirements.
1) List All Open ASN : what does Open ASN means and how do i find it?
2) List all ASNs from a certain vendor: Any further details ?
3) List all ASNs for a certain material: I guess we can get this from EMATN field of EKES table. Am i right?
4) List all ASNs under a certain MM Scheduling Agreement: Pls throw some light on this ?
are there any function modules which get me this details? this would avoid me writing the code from scratch..
Thanks,
Kishore Babu
Hello Shahuraj,
I got most of the info that i need for my requirements. But i need some more info for my following requirements.
1) List All Open ASN : what does Open ASN means and how do i find it?
2) List all ASNs from a certain vendor: Any further details ?
3) List all ASNs for a certain material: I guess we can get this from EMATN field of EKES table. Am i right?
4) List all ASNs under a certain MM Scheduling Agreement: Pls throw some light on this ?
are there any function modules which get me this details? this would avoid me writing the code from scratch..
Thanks,
Kishore Babu
User | Count |
---|---|
94 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.