Fetch/link records from table VBRK with a link to GLPCA into query

[Former Member]

Hello everyone,

I would like to fetch records from table VBRK into an already existing SAP query.

The SAP query runs on an infoset that has been built on table GLPCA. I do not want to join the tables GLPCA and VBRK in my infoset as that then removes a lot of records which I need. I want to fetch records VBRK-KUNAG (Sold to Party) into my query with the link being GLPCA-REFDOCNR and VBRK-VBELN.

Can I do this? How would I write the code for this? Any advice would be much appreciated.

Thanks

[Jean_Sagi]

Never heard about the GLPCA table, but if joining VBRK against it filters records then consider using a left outer join so no records of table GLPCA will be missing.

BTW: I don't know if I could do an outer join in an infoset query (never used infosets before); maybe others could help here.

J.

[raymond_giuseppi]

Either

• Add the table with a JOIN, then right-click on the join and select 'left outer join' (help)
• Add the second table as an 'add. structure' with a code to perform the select. (help)