on 10-17-2017 9:56 AM
Dear experts, I am working on a purchase report and fetching material documents from WB2_V_RBKP_RESG2 table from fields LFBNR and LFPOS, but when the GR Based IV is not ticked in PO the LFBNR and LFPOS are blank. Please suggest a solution to this or an work around for fetching material document by referring to invoice.
Thanks in advance.
You may need to think a different way. In case of GR based IV unchecked, system does not make any reference between GR and Invoice as invoice can be posted before GR. So there is no direct link. You may tale the po number from your table or RSEG and take the material document number from MSEG table.
But still you will have problem during case of multiple GR documents for same purchase order.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you had not explained why you at all selected this table and what the goal of your report is, hard to make a suggestion without having much background on the target solution.
I would fetch material documents from MSEG table instead of a RBKP/RSEG combination which is about invoice documents.
Are you looking for invoice documents or for material documents? With a purchasing report I would usually start with purchasing tables, e.g. EKBE which is the purchase order history which has material documents and invoice documents per PO item.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jurgen,
My report is based on Invoice hence i am shortlisting the invoices from WB2_V_RBKP_RSEG2 table and for entries found in this table i am trying to fetch GR documents against which this invoice was posted in fields LFBNR and LFPOS. My goal is to get GR document by from Invoice document.
Thanks.
Hi Dibyendu,
The GR document is not found in RSEG as per the scenario. You are right that we get material document in RSEG or even the table that i have mentioned WB2_V_RBKP_RSEG2 but only if the GR based IV is checked in PO. I want to know if the GR based IV is unchecked can we still get material document reference in invoice. If not in above tables any other tables.
Thanks.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
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.