Skip to Content
0

Relationship between DFKKOP and DFKKOPK

Jan 26 at 12:22 AM

97

avatar image
Former Member

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?

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

2 Answers

avatar image
Former Member Jan 31 at 08:13 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
G Lakshmipathi
Feb 01 at 07:32 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded