on 01-23-2020 5:30 PM
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"
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.