Skip to Content
0
Dec 16, 2011 at 02:52 PM

How to get the Equity Share (%) based on a BSEG record

85 Views

Dear JVA experts,

I have to model a relation with BSEG and JVA tables to get the Equity Share from T8JQ.

it has been proposed to me to build a relation as follows:

BSEG-BELNR - BKPF-BELNR

BKPF-AWKEY -> JVSO1-REFDOCNR

BKPF-GJAHR -> JVSO1-REFYEAR

BKPF-BUKRS -> JVSO1-RBUKRS

get JVSO1-VNAME

finally get T8JQ-VNAME and get T8JQ-EQSHARE.

My question to you.

I have found that in BSEG there are some JVA fields. Would it be possible to model another relation in order to get the Equity Share from T8JQ from a BSEG record, avoiding the reading of JVSO1 ?

thanks in advance for your help ?

best regards,

Lory