cancel
Showing results for 
Search instead for 
Did you mean: 

PO Num,GR Num,GR Date in a single query

Former Member
0 Kudos

Dear friends,

There is requirement, where I need to have PO Num,GR Num,GR Date in a single query.Is there any standard provider or standard Infosource for this kind of query.Even if its not there kindly help me with ur valuable suggestions.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I think that BC cubes and ODS contain information that might be not very suitable for you. For this you can look at 0PUR_C01 cube. But you can build your own ODS or cube based on 2LIS_02_CGR and 2LIS_02_SGR datasources that have almost everything what you want:

http://help.sap.com/saphelp_nw04/helpdata/en/ed/62073c44564d59e10000000a114084/frameset.htm

Best regards,

Eugene

Former Member
0 Kudos

Hi,

There is no standard extrction and Standard report as per your reuirement.

Here to get your query, you have to do enhancements.I think,

GR Num,GR Date can be available from 2lis_12_vcitm. So enhance

this DS to get respetive PO ( in case the reocrd from 2lis_12_vcitm is a delivery document of PO) .

You can also enhance PO extractors ( GR Num,GR Date )to get ,but in case ,if a PO has multiple delivery documents, then we donot get multiple records to BW.

Discuss with ABAP team to get proper knowledge on flow of document processing and on Tables are being used.

With rgds,

Anil Kumar Sharma .P