SUBSELECT VBPA and VBFA tables

bruno_martins_l — Mon, 26 Jan 2026 21:26:37 GMT

Hello,

I want to filter the datas of the tabel VBPA (Sales Partner) in SAP from the table VBFA to have a load in delta with the ERDAT of VBFA and others restrictions.

I have create a SUBSELECT Query :

SQL SUBSELECT MANDT VBELN HITYP PARVW LIFNR KUNNR LAND1 POSNR PERNR PARNR ADRNR ABLAD ADRDA XCPDK PRFRE BOKRE HISTUNR KNREF LZONE HZUOR STCEG PARVW_FF ADRNP KALE

from VBPA WHERE VBELN POSNR IN (SELECT VBELV POSNV FROM VBFA WHERE VBTYP_V = 'C' AND VBTYP_N = 'R' AND ERDAT >= '$(vStartDate)' )

;

My problem is that query don't load the good lines of VBPA because they are not complets. The Client Code KUNNR and the type of Partner PARVW is empty for exemple.

Can you help me please for this SUBSELECT ?

Thanks a lot.

Kind regards,

Bruno

topic SUBSELECT VBPA and VBFA tables in QlikView

SUBSELECT VBPA and VBFA tables