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.