Skip to main content
Question

How to link the BSEG table with either /OPT/VIM_1HEAD or /OPT/VIM_1ITEM to retrieve the DOCID field?

  • January 31, 2024
  • 2 replies
  • 49 views

We have an OLAP table and most of the columns are from the BSEG, BKPF, and LFA1 tables. However, we would like to also have the DOC ID field from either /OPT/VIM_1HEAD or /OPT/VIM_1ITEM tables. How do we connect these tables?

 

image 

Thank you!

2 replies

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

You can link using BKPF.AWKEY = /OPT/VIM_1HEAD.BUS_OBJKEY


bunyod.sap
Level 7
Forum|alt.badge.img
  • Level 7
  • February 3, 2024

Hey @nathalie.magal  Try this out 👉 PU_FIRST("BKPF","VIM_1HEAD"."DOCID")