Call transaction and select Cleared Items on FBL1N

[Baz]

I am a functional S&D/AR Developer, helping out with some ABAP work. I have written a basic report to search Vendor Line Items by amount. I am aware that FBL1N already searches by amount, but this report is 10 times quicker....

The user wishes to drilldown into FBL1N.

I have used the following code, but I wish to select all All items, as the default is Open items.

Code: Select all

*Hotspot for drill down

    FORMAT HOTSPOT ON.
    WRITE:/1 idat-lifnr, 15 idat-bldat, 30 idat-xblnr, 55 idat-wrbtr,
          75 idat-blart, 80 idat-belnr, 95 idat-augdt.

    HIDE: idat-bukrs, idat-gjahr, idat-lifnr.
    FORMAT HOTSPOT OFF.

  ENDLOOP.

*Call FBL1N, enter vendor number, company code and All Items
*At Line-Selection------------------------------------------------------
AT LINE-SELECTION.

  SET PARAMETER ID 'LIF' FIELD idat-lifnr.
  SET PARAMETER ID 'BUK' FIELD idat-bukrs.
  CALL TRANSACTION 'FBL1N' AND SKIP FIRST SCREEN.

The field I wish to select has the following data/properties:

Program RFITEMAP
Structure: ITEMSET
Field Name: XAISEL
Data Element: XAISEL_IT
DE Supplement: 0
Screen Field: X_AISEL

can anyone help??

Or point me in the right direction??

[kumar]

Try using

SUBMIT RFITEMAP WITH .... <Your Param>

KRK

[Baz]

Thank you Kumar.

Without meaning to sound stupid.... I have added the amended coding as follows...

Code: Select all

FORMAT HOTSPOT ON.
    WRITE:/1 idat-lifnr, 15 idat-bldat, 30 idat-xblnr, 55 idat-wrbtr,
          75 idat-blart, 80 idat-belnr, 95 idat-augdt.

    HIDE: idat-bukrs, idat-lifnr.
    FORMAT HOTSPOT OFF.

  ENDLOOP.

*Call FBL1N, enter vendor number, company code and All Items
*At Line-Selection------------------------------------------------------
AT LINE-SELECTION.


  SET PARAMETER ID 'LIF' FIELD idat-lifnr.
  SET PARAMETER ID 'BUK' FIELD idat-bukrs.
  SUBMIT rfitemap WITH x_aisel = 'X'.

The report works to a point... now when I drill down, all is well until I press F3 and it takes me back to the SAP Easy Access menu, and not back to the details in my report. Any thoughts?

[wiraone]

Try to add AND RETURN to the SUBMIT line.

[Guest]

Many thanks Wiraone and Kumar.

All working peechy now

[Baz]

Many thanks Wiraone and Kumar.

All working peechy now

My coding for this is as follows:

Code: Select all

  FORMAT HOTSPOT ON.
    WRITE:/1 idat-lifnr, 15 idat-bldat, 30 idat-xblnr, 55 idat-wrbtr,
          75 idat-blart, 80 idat-belnr, 95 idat-augdt.

    HIDE: idat-bukrs, idat-lifnr.
    FORMAT HOTSPOT OFF.

  ENDLOOP.

*Call FBL1N, enter vendor number, company code and All Items and return
*At Line-Selection------------------------------------------------------
AT LINE-SELECTION.


  SET PARAMETER ID 'LIF' FIELD idat-lifnr.
  SET PARAMETER ID 'BUK' FIELD idat-bukrs.
  SUBMIT rfitemap WITH x_aisel = 'X' AND RETURN.

many thanks for your prompt responses.