SAP B1 - First and Last Journal Entry for Business Partner

[jon19]

Dear SAP Community,
I'd like to know from which table can I get information for First Journal Entry Create Date (FirstJECreateDate) and Last Journal Entry Create Date (LastJECreateDate), including it's Count, for all Business Partner in a database.

I'd like to link it to this OCRD query (below), which works on its own. Thank you.

T0."CardCode", T0."CardName", T0."CardFName", T0."CardType", T0."GroupCode", T0."LicTradNum", T0."RegNum", T0."CreateDate", T0."Series", T0."ZipCode", T0."City", T0."Country", T0."validFor", T0."validFrom", T0."validTo", T0."ValidComm", T0."frozenFor", T0."frozenFrom", T0."frozenTo", T0."FrozenComm", T0."GroupNum", T0."BankCountr", T0."BankCode", T0."DflBranch", T0."DflAccount", T0."DflIBAN", T0."DflSwift", T0."HousBnkCry", T0."HouseBank", T0."HousBnkAct", T0."HousBnkBrn", T0."PymCode"

[jitin_chawla · Accepted solution]

Hi,

You can check the OJDT table for the Max(CreateDate) and Min(CreateDate) and use the Condition Shortname <> Account to filter out the BP entries and then join the same with the OCRD table.

Check if you can manage a query yourself.

regards,

Jitin C