11 Replies Latest reply: Dec 13, 2013 4:21 AM by s j RSS

    Incremental Load on BSEG and MSEG

      Hi,

       

      Can anybody Explain Incremental Load on SAP Cluster Tables BSEG & MSEG


        • Re: Incremental Load on BSEG and MSEG
          s j

          Incremental load

           

          BSEG: Refer BKPF as reference table in sub query.

          MSEG : Refer MKPF material document number in sub query.

           

          let me know if it is not clear to you.

           

          Regards;

          Sunil Jain

          • Re: Incremental Load on BSEG and MSEG
            s j

            One altenative option is You can create view in SAP to avoid the use of header and detail table use during delta extraction.

             

            it will increase speed of data extraction from SAP R/3.

            • Re: Incremental Load on BSEG and MSEG

              The QlikView Connector manual has a very specific example of getting data from BSEG (and BKPF).   Because it's a clustered table, as you know, you are limited to the SQL you can execute against it.   The connector gives you the ability to use a SUBSELECT statement so you can use the date fields out of BKPF to determine which BSEG records to extract and do your incremental load.  I am using it and it works very well. 

              • Re: Incremental Load on BSEG and MSEG

                Hi All,

                 

                For everyone information, BSEG is cluster table and hence sub queries & joins not work directly from QV or ABAP as well. The alternate to this is

                a. To ask customer to write a program in ABAP to fetch incremental records from SAP and store it in some xml or txt or tab delimited file and you can append the same in your incrmental load.

                b. Use new GL table FAGLFLEXA (This is Transparent table and joins works on this)

                 

                For MSEG use the following code:-

                Select
                MSEG~MBLNR MSEG~ZEILE MSEG~BWART MSEG~MATNR MSEG~MJAHRMSEG~WERKS (one can add as many field as required followed by Spaces)
                from MSEG INNER JOIN MKPF ON MSEG~MBLNR EQ MKPF~MBLNR
                WHERE MKPF~CPUDT GE '$(LastDtReload)' ;  where LastDtReload is last relaod date or can be day since when you require incremental load.

                Regards

                Ashwani Bhatia

                • Re: Incremental Load on BSEG and MSEG

                  Hi Concern,

                   

                  BSEG is cluster table and hence sub queries & joins not work directly from QV or ABAP as well. The alternate to this is

                  a. To ask customer to write a program in ABAP to fetch incremental records from SAP and store it in some xml or txt or tab delimited file and you can append the same in your incrmental load.

                  b. Use new GL table FAGLFLEXA (This is Transparent table and joins works on this)

                   

                  For MSEG use the following code:-

                  Select
                  MSEG~MBLNR MSEG~ZEILE MSEG~BWART MSEG~MATNR MSEG~MJAHRMSEG~WERKS (one can add as many field as required followed by Spaces)
                  from MSEG INNER JOIN MKPF ON MSEG~MBLNR EQ MKPF~MBLNR
                  WHERE MKPF~CPUDT GE '$(LastDtReload)' ;  where LastDtReload is last relaod date or can be day since when you require incremental load.

                  Regards

                  Ashwani Bhatia