on 11-18-2008 3:03 PM
Dear All,
Is their any table in which If we input purchase order number Then the system should display all the PR and sales order number(If it is Third party item).
Or guide me to create a Zreport In which The input parameter will Purchase order And system should display PR No as well as Sales order number and the sales order value.
Regards
Dear Shafi,
Definitely, you have to go for Z-Report.
Though, I don't have much knowledge on the same, as I havn't met with such requirement; but I did work on one such requirement, where Report must show
Quotation No. --> Sales Orders No. --> Sales Order Items Details (Material, Confirmed Qty, Delivered Qty, Open Value, Delivery Nos., Invoices created etc..)
Now, coming to your requirement, I searced the Forum, and found to such thread (somewhat):
All I contribute:
Different tables used in P.O. are: EKKO, EKPO, EKET, LFA1, MKPF, MSEG.
This might help you while writing your requirement.
Best Regards,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I m closing this thread
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use EKPO and EKKN tables. These table will not display sales order value.
EKPO table displays Customer (KUNNR) material MATNR , PR number BANFN .
EKKN table displays sales order number VBELN , sales document item VBELP, schedule line number VETEN , quantity MENGE.
Regards,
Chandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
Is there any table in which If we input the sales order number Then the system should display The CUSTOMER CODE with Customer name(Against whom the sales order is created) and the total net sales order value.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
check in MC01 it is trial.
pls guide if i was wrong by giving solution
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I am not sure but you can try TCode VBFA.
Rgds
San
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.