0 Replies Latest reply: May 17, 2013 5:59 AM by Bruno Martins Lêdo RSS

    SUBSELECT VBPA and VBFA tables

    Bruno Martins Lêdo

      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