Link between KONV and BSEG(Need to get WRBTR and KSCHL in output)

[Former Member]

Hello guys,

Am new to this blog...Am not sure if this is the way to ask questions.

Am working on an report and i customer wants to have customer and vendor invoices in the output and for customer invoices there needs to be condition type and needs to be amount calculated for that condition type.

Could you help me in knowing the link between KONV and BSEG and how i can link.

I know there is link VBRK --> KNUMV  KONV-->KNUMV and there is link between VBRK  and BSEG

But please ellaborate how can i get condition type and related to the Amount field in BSEG that is WRBTR..

Thanks in advance..

[former_member201275]

http://scn.sap.com/message/13890130

[Former Member]

Hi Radhev,

You cannot directly link or use SQL Join Query on KONV and BSEG tables because both are cluster tables which are excluded from Join statement.

The approach sugg. by you is correct i.e. -

Link BSEG to VBRK and link VBRK to KONV. Consolidate all data and show.

BR.

[former_member188251]

Hi Radhev,

Every line of an invoice can have an accounting document created. So you have to link VBRP and BSEG, instead of VBRK.  You'll find the below thread helpful.

http://scn.sap.com/thread/309022

BR,

Shankar.