Skip to Content
avatar image
Former Member

Fetching values using select query

Hi i want to get the details of belnr and bukrs using the where codn fields bukrs,anlkl,brdatu,ktansw,budat,WBS element.

1)The value of bukrs is entered in the selection screen

2)the value of asset class is optional and present in the anka

3)brdatu is already fetched and placed in a table.field brdatu is present in table j_ittaxdep

4)ktansw is entered in the selection screen and present in table j_ittaxdep

5)budat is fetched and placed in a table.

6)wbs element already fetched and is present in prps table.

Can anyone please tell how to code.actually the values of bukrs,anlkl ktansw, are present in structure anlav,brdatu is present in structure rbada and budat is present in structure anek.By using this structure is there way to get the belnr and bukrs value.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 02, 2008 at 05:52 AM

    Use BSEG table,

    I meane your avilable all entries prsent in BSEG table.

    Just go through to it.

    Regards

    ricky

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      KTANSW is GL Account same as BSEG-SAKNR,

      BRDATU IS FROM J_1ITAXDEP IS SAME AS SY-DATUM,

      Regards

      ricky

      Edited by: Ricky Maheshwari on Sep 2, 2008 8:36 AM