cancel
Showing results for 
Search instead for 
Did you mean: 

How to extract Cleared and Open Items from SAP R/3?

Former Member
0 Kudos

Hi experts,

I have a requirement from user to extract cleared and open invoice items from SAP R/3.

Can someone tell me how to do that?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Use the Data source 0FI_AR_4 to Know the status (0FI_DOCSTAT) of payment to be done by customer.

OR

Enhance the 2LIS_13_VDITM with VBUP fields which will give the status of Billing.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi Anil,

Thanks. However, I am doing report on AP module. Should I use 0FI_AP_4 instead?

Thanks!

Former Member
0 Kudos

Hi,

Yes you can, if want to give report for open or closed Payments to Vendors from the company.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi Anil,

Which field should I use to extract it from SAP R/3?

Former Member
0 Kudos

Hi,

Do you mean the field for Item status? If so, the R/3 field is STATUSPS and it is mapped with 0FI_DOCSTAT by standars content .

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Brilliant!

Former Member
0 Kudos

Hai Anil Kumar,

After enhancing 2lis_13_vditm with VBUP field, to which Info Object we need map this new field i.e VBUP.

Regards

Guru

Answers (0)