Skip to Content
avatar image
Former Member

Relationship between DFKKOP and DFKKOPK

Hi,

I have been working on a report which involves in getting data from SAP tables DFKKOP and DFKKOPK. All of the data that I need to have this report going is already in DFKKOP except for GL account (hkont) and profit center (prctr). This is where I need to bring data from DFKKOPK.

Up till now, I have not been able to establish a line item link between these two tables.

Is there any way we can successfully identify a documents line item from DFKKOP in DFKKOPK table and associate it with its correct GL account and profit center?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 31 at 08:13 PM

    One is header table and the other is item table with 1:n relationship. Everything that is in header is applicable to all related items. You won't be able to line them up at item level.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01 at 07:32 AM

    Are you not aware of SQVI where you can table join these two tables and generate the required report ? Both these tables have couple of common fields like OPBEL and OPUPK

    Add comment
    10|10000 characters needed characters exceeded