11 Replies Latest reply: Feb 24, 2017 9:20 AM by james anderson RSS

    Incremental load for SAP table - GLPCA

    james anderson

      Hi Guys,

       

      I was trying to do an incremental load for the GLPCA table( contains Actual Line Items Information) that i pulled from SAP.

      But i was thrown with an error that the fields are not found.

      I was able to do the initial load.

      I am new to SAP. Could you guys please help.

       

       

      Here's the code for the qvd:

       

      LIB CONNECT TO 'COR-SAP';

      [SAP_GLPCA]:

      LOAD

          GL_SIRID,

          RYEAR,

          DRCRK,

          POPER,

          DOCNR,

          RACCT,

          HSL,

          SGTXT,

          BUDAT,

          REFDOCNR,

          KOSTL,

          KUNNR,

          LIFNR,

          BLART

      FROM [lib://GL-QVD (ja_andrsn)/SAP_GLPCA.QVD]

      (qvd);

       

       

      [Sort_SAP_GLPCA]:

      Load *

      Resident [SAP_GLPCA]

      Order by BUDAT;

       

       

      LET vUpdateDate=Peek('BUDAT',-1,'[Sort_SAP_GLPCA]');

       

       

      drop table [SAP_GLPCA];

       

      Error1.JPGError2.JPG