Get Due Date or Days in Arrears in SAP user query
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.
mgitur mgitur replied
You can use some Function Modules to get those fields:
Field:= Net Due Date (RFPOSXEXT-FAEDT)
FM1:= DETERMINE_DUE_DATE (used in FBL5N/FAGLL03)
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:
I hope i'ts helpful.