SAP Query

[Former Member]

Hi Gurus,

I have to create a SAP query, using VBRK and VBRP tables. I need to add company code (1000,1050) posting period and fiscal year to the same report.

I tried

VBRK-GJAHR ( for Fiscal Year)

VBRK - POPER ( for Posting Periods)

VBRK - BUKRS (for company code)

But i am not getting the output data ( No Data Found).

Can you please let me know how to proceed.

Will assign good points.

Thanks for your help

[Former Member]

answered

[Former Member]

hi,

jus check if there is data as per the input given. also check the infoset if the join has been established.

saurabh

[Former Member]

These fields are available in BSEG table.

But it can't be used being a cluster table.

You have to use ABAP programming and club BSID and BSAD table for the desired result.