cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 - First and Last Journal Entry for Business Partner

jon19
Explorer
0 Kudos

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"

Accepted Solutions (1)

Accepted Solutions (1)

jitin_chawla
Advisor
Advisor

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

Answers (0)