Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bruno_martins_l
Contributor

SUBSELECT VBPA and VBFA tables

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

Community Browser