2010 May 19 3:32 PM
Hi Experts,
I need to fetch list of Inbound delivery number which has not been Post Goods Receipted in VL31n ?
Kindly provide me logic to get the data.
Regards,
Vikram
Hi Experts,
I need to fetch list of Inbound delivery number which has not been Post Goods Receipted in VL31n ?
Kindly provide me logic to get the data.
Regards,
Vikram
2010 May 19 5:24 PM
U need to see those goods for which there is the delivery data in LIKP and LIPS but there is no data in MKPF and MSEG corresponding to the materials in delivery tables.
Also u can filter out the data for VL31N by selecting those VBELN from LIKP which are related to inbound delivery.
Edited by: vijetasap on May 19, 2010 6:42 PM
2010 May 19 5:27 PM
Hi,
Select the delivery number from LIKP. Search the delivery numbers in VBFA to find out whether PGR document has been created.
Select <fields> from vbfa
where vbelv = <delivery number>
and posnv = <delivery line item>
and vbtyp_n = 'R'.If the record available for above select statement, then PGR document is created for the delivery number, else PGR document
is not available for the delivery.
Regards
Vinod