Skip to Content
0
Former Member
Apr 28, 2008 at 08:23 PM

FICA SAP Query

464 Views

Has anyone tried building an SAP Query (SQ01) against the FICA transaction tables: DFKKKO (header) + DFKKOPK (GL line items) + DFKKOP (BP line items)?

I'm getting duplicate line items (OPUPK) on my SAP Query.

My INFOSET was created by creating an inner join between DFKKKO to DFKKOPK and DFKKO to DFKKOP. The join is based on document number (OPBEL).

I also tried an INFOSET by joining DFKKKO to DFKKOPK to DFKKOP by doc number. This is also diplaying duplicate line items.