FM or BAPI required

[Former Member]

Hi,

1 . I need to fetch customer open line items for selection parameters:

a) Customer

b) Company code

c) document type (S_blart - all doc types except clearing doc type)

d) Posing date (Very important)

All are the select options. (Say i fetch data from BSAD in internal table i_bsad)

2. After this I need to fetch all the cleared items for matching values for data fetched in step 1 the condition being

bukrs IN s_bukrs

customer = i_bsad-kunnr

blart IN s_Clearing_doc_type

belnr = i_bsad-augbl (Important)

Can any 1 please suggest me an FM or BAPI to retrieve the data (Tcode FBL5N but we need to go by posting date)

I do not want to fetch data from table BSAD as the data is archieved.

I fear I cannot use BAPI_AR_ACC_GETOPENITEMS

Kindly suggest.

Best Regards,

Himanshu.

[Former Member]

Hi Himanshu,

Have u tried using FM /DSD/HH_DL_OPEN_ITEMS

and give entries required in tables TP_CUSTACC & TP_OPEN_ITEMS

try using FM CUSTOMER_OPEN_ITEMS

Let me know if u get it ...

All the best !!!

Thanks

Ravi

[former_member212005]

Himanshu...this is going to be a bit expensive for you...since you cannot use select statements..

Try using the function module..

FM_READ_BSID