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?
Thank you!
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?
Thank you!
You can link using BKPF.AWKEY = /OPT/VIM_1HEAD.BUS_OBJKEY
Hey @nathalie.magal Try this out 👉 PU_FIRST("BKPF","VIM_1HEAD"."DOCID")
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.