Finding over due entry from BSID

[former_member539238]

Hi guys I was trying to get over due date from BSID table. Found MSCHL which gives the level of over due. can we use it to check if the entry is overdue. if not then how do we find if the entry is overdue?

[RaymondGiuseppi · Accepted solution]

Field MSCHL would only be maintained by F150 transaction, so not every overdue record will appear. Most SAP reports dynamically calculate the due date with a FM such as DETERMINE_DUE_DATE. You could analyze FBL5N transaction or form got_bsega in sapbsega.

[former_member539238 · Accepted solution]

Well basically I have only BSID data so I tried to move it into FAEDE structure and then call the FM DETERMINE_DUE_DATE. But it gave me an error for type of account.

Then can we take the pricing condition data from table T052, to get "number of days from baseline date" and add it to baseline date in BSID to get due date. Compare this due date with sy-datum to check if it is due or not?

[RaymondGiuseppi · Accepted solution]

As you read BSID, just pass 'D' to KOART, many BSEG fields are not in BSID.

Hint: In case of doubt, look, as already suggested, at FBL5N RFITEMAR for KOART.

[former_member539238 · Accepted solution]

The table column KOART is not in BSID.

What I need is non over due amount. So the plan was to check if the BSID entry is non overdue then add it to a variable.

[RaymondGiuseppi · Accepted solution]

FAEDE-KOART = 'D'. " d'oh!

[former_member539238 · Accepted solution]

Thanks : )