SAP

[olguita2014]

Hi,

I have two tables on SAP, VBRK and VBRP. And I need to filter only one year, but the date only has this table: VBRK

Please help me

[lcontezini]

you can link (or join) the tables with the VBELN field, like:

VBRK:

LOAD

     VBELN AS DOCUMENT_NUMBER,

     GJAHR AS YEAR

FROM VBRK;

VBRP:

LOAD

     VBELN AS DOCUMENT_NUMBER,

     FKLMG AS QUANTITY

FROM VBRP;

When you select YEAR, it will select data from both tables. If you want to load only one year, I'd suggest you do the following:

VBRK:

LOAD

     VBELN AS DOCUMENT_NUMBER,

     GJAHR AS YEAR

FROM VBRK

WHERE GJAHR = '2018';

LEFT JOIN(VBRK)

LOAD

     VBELN AS DOCUMENT_NUMBER,

     FKLMG AS QUANTITY

FROM VBRP;

something like this.