Problem with Sap Query (Infoset)

[Former Member]

Hello togehter,

I have a problem with my Query. I have created a query with the following table: vbak, vbap and vbrp. Vbap and Vbrp is left outer join. Now, I want to list me the Partner Role, and the Partner number and also the requirement tracking number. I need the tables EKKO and EKPO but also VBRK, but I have no solutions for this. Please can anyone help me?

Its 2 days that I have to resolve this problem......but nothing can help me.

Thank you in advance for the answer

Gianpiero

[Former Member]

Hello togehter,

I have a problem with my Query. I have created a query with the following table: vbak, vbap and vbrp. Vbap and Vbrp is left outer join. Now, I want to list me the Partner Role, and the Partner number and also the requirement tracking number. I need the tables EKKO and EKPO but also VBRK, but I have no solutions for this. Please can anyone help me?

Its 2 days that I have to resolve this problem......but nothing can help me.

Thank you in advance for the answer

Gianpiero

[Former Member]

Hi,

I could not understand clearly about your issue here. May be you can try as below.

For partners, you can make use of VBPA table for joining with existing tables.

If you want pull some data from EKKO or purchase related stuff, then you can pull the related data based on the VBFA and search how can these be related.

[mrahhaoui]

Hi,

I don't know which fields are exactly in those 3 tables but you have to find a field which is similar in those 3 tables so, you could to build a select join.

Regards,

Moh.

[Former Member]

Hello,

I do so but the field are empty. The query doesn't find any data

Please help

thank you

Gianpiero

[mrahhaoui]

Is there something in your table?

Regards,

Moh.

[Former Member]

No i I have the follwing table joined:

vbak with vbap (vbeln)

vbap with vbrp (left join) (vbeln, posnr). With this three tables the query is ok. As listing I have the following items:

VBAK-BUKRS_VF, VBAK-VBELN,VBAK-VTWEG,VBAK-VKORG,VBAK-SPART,VBAP-NETWR,VBAP-ARKTX,VBAP-WERKS,VBAP-PRCTR,VBAP-POSNR,VBAP-NETPR,VBAP-MATNR,VBAP-KWMENG,VBAP-AUFNR.

AS Selection the following fields: VBAK-VBELN,VBAK-VTWEG,VBAK-VKORG,VBAK-SPART,VBAK-AUART,VBAK-AUDAT,VBAP-WERKS,VBAP-MATNR.

So its important to listening the following tables too: Faktura (invoice), Partner Role, Partnernumber and the requierements number. The table are EKKO EKPO AND VRKPA OR vbkd, but if I join this table the query doesn't listining any results. If I cancel this 3 or 4 table and I start the query, the listening are ok.

I hope that you understand better my problem. Thanks for helpin me.

Gianpiero

[Former Member]

> So its important to listening the following tables too: Faktura (invoice), Partner Role, Partnernumber and the requierements number. The table are EKKO EKPO AND VRKPA OR vbkd, but if I join this table the query doesn't listining any results. If I cancel this 3 or 4 table and I start the query, the listening are ok.  
> 

I am not sure what business process you are describing here - is it some kind of third-party sales order? If so, your join is wrong.

From VB E P, firled BANFN and BNFPO you can go to table EBAN, where in field EBELN you will find the number of the purchase order (if somebody already had an MRP+Me58 run over the PR) which will lead you to table EKKO, and EKPO.

So what we have here (essentially is):

VBAK -> VBAP -> VBEP -> EBAN -> EKKO -> EKPO

But that only solves one of your problems - you still have a long way to go to get invoices, partner and partner roles into there and I am beginning to ask myself what exactly it is you want to evaluate.

Care to explain?

Edited by: Mylène Dorias on Apr 1, 2010 2:10 PM