Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Get Due Date or Days in Arrears in SAP user query

Hello,

I am creating a user query (SQ01) in SAP, in which I combine Customer Open Items (table BSID) with several master data tables.

This is working fine, but now I would like to add the Due Date or Days in Arrears to the query.

Are those fields in any table I can use in Query? I can't find them in BSID or BSEG. In FLB5N they are in structure RFPOSXEXT.

I can't use that in query!?

If not in any table, is it possible to calculate them? How would I do that?

Hope someone can help.

Thanks!

Ed

replied

Hi Ed,

You can use some Function Modules to get those fields:

Field:= Net Due Date (RFPOSXEXT-FAEDT)

FM1:= DETERMINE_DUE_DATE (used in FBL5N/FAGLL03)

FM2:= NET_DUE_DATE_GET

Field:= Arrears after net due date (RFPOSXEXT-VERZN)

FM1:= ITEM_OVERDUE_DAYS (used in FBL5N)

FM2:= FAGL_ITEM_OVERDUE_DAYS (used in FAGLL03)

Create two new fields in your infoset, and add codings using those FMs.

If you don't know how to add new field to infoset, please see the following link:

Adding Custom fields to the ABAP Query - Community Profiles - SCN Wiki

I hope i'ts helpful.

Best Regards!

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question