cancel
Showing results for 
Search instead for 
Did you mean: 

Relationship between DFKKOP and DFKKOPK

Former Member
0 Kudos
2,707

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

Lakshmipathi
Active Contributor
0 Kudos

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

frank_1973
Member
0 Kudos

The OPUPK is an item number but there doesn't need to be an one-2-one relateion between the two tables DFKKOP and DFKKOPK (at least in our system). So linking on these fields can deliver incorrect gl-codes.

P14397410
Participant
0 Kudos

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.