Skip to Content
0

GL Line Items in FICA

Jul 25, 2017 at 03:03 PM

132

avatar image
Former Member

Hello,

We are trying to capture GL Line Items and observed two main tables DFKKOP & DFKKOPK. DFKKOP does not capture all GL accounts and we started using DFKKOPK to get all GL accounts.

How do we get the relation from DFKKOPK to Contract Account, Business Partner, Posting Date .

Thanks

Srinivas

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Anand Sharma Jul 26, 2017 at 10:43 AM
1

Hello Srinivas,

The three tables DFKKKO (header table), DFKKOP (line items) and DFKKOPK (GL posting items) can be used to determine the document details.

As per your question you are trying to map the FICA document using the GL details which is present in the table DFKKOPK. So in this case you can get the combination of GL and Recon key (FIKEY) from table DFKKOPK and pass them in the table DFKKKO to get the corresponding FICA documents.

Once the FICA documents are obtained pass these values in the table DFKKOP to get the exact details like posting date, etc.

Hope it helps !

Thanks,

Anand

Share
10 |10000 characters needed characters left characters exceeded
William Eastman
Jul 25, 2017 at 05:42 PM
0

You cannot get that information with 100% certainty using those tables.

Share
10 |10000 characters needed characters left characters exceeded
MaDhU ReDdY Jul 26, 2017 at 12:02 AM
0

Hi

DFKKOP captures Subledger (BP lines) & DFKKOPK - General ledger lines. If you are only looking for General Ledger lines, then you need to link Header table - DFKKKO through document number to get Posting information.

Share
10 |10000 characters needed characters left characters exceeded
Amlan Banerjee
Aug 03, 2017 at 09:42 AM
0

Hi Srinivas,

Have you checked the transaction FPT5 for yoUr requirement?

Thanks,

Amlan

Share
10 |10000 characters needed characters left characters exceeded