Skip to Content
0
Former Member
Apr 20, 2010 at 01:55 AM

where to connect bsis to get zuonr

115 Views

Hi Experts,

Im working on pdc and I use bsis to get the data but also need to get zuonr. I check with bseg but the connection i got is bseg-augbl = bsis-belnr. augbl is not a key field. could anyone help on how can i transfer the data of it_bseg_b to my final table. many thanks. below is my code.

  SELECT bukrs
         hkont
         gjahr
         belnr
         budat
         waers
         blart
         shkzg
         wrbtr
         dmbtr
         augdt
         xragl
         buzei
         augbl
  FROM bsis
  INTO TABLE it_bsis
  WHERE hkont EQ c_sales_pdc
    AND bukrs IN s_bukrs
    AND belnr IN s_belnr
    AND budat LE p_budat.

  DELETE it_bsis WHERE blart NE 'DZ'
                 AND   blart NE 'PD'.
  DELETE it_bsis WHERE xragl NE ''.

 SELECT bukrs belnr kunnr  gjahr augbl zuonr
  FROM bseg INTO TABLE it_bseg_b
  FOR ALL ENTRIES IN it_bsis
  WHERE bukrs = it_bsis-bukrs
    AND kunnr IN s_kunnr
    AND belnr = it_bsis-belnr
    AND gjahr = it_bsis-gjahr.

  LOOP AT it_bsis.

    it_final3-bukrs = it_bsis-bukrs.
    it_final3-hkont = it_bsis-hkont.
    it_final3-gjahr = it_bsis-gjahr.
    it_final3-belnr = it_bsis-belnr.
    it_final3-budat = it_bsis-budat.
    it_final3-waers = it_bsis-waers.
    it_final3-blart = it_bsis-blart.
    it_final3-shkzg = it_bsis-shkzg.
    it_final3-wrbtr = it_bsis-wrbtr.
    it_final3-dmbtr = it_bsis-dmbtr.
    it_final3-augdt = it_bsis-augdt.
    it_final3-xragl = it_bsis-xragl.

    READ TABLE it_bseg_b WITH KEY belnr = it_final3-belnr
                                  bukrs = it_final3-bukrs.

    it_final3-kunnr = it_bseg-kunnr.
    it_final3-vbeln = it_bseg-vbeln.
    it_final3-zuonr = it_bseg-zuonr.

    APPEND it_final3.
    CLEAR  it_final3.
  ENDLOOP.