Relationship between PAYR and VBRK

[Former Member]

Hi All,

Below are the fields related to Party Wise Ledger.

Bill no--( VBRK-VBELN )

Inv. Date--( VBRK-FKDAT )

Destination-- ( KNVA-ABLAD )

Quantity-- ( VBRP-FKIMG )

Inv. Amount-- ( VBRP-WAVWR )

Cheque No.-- ( PAYR-BANCD )

Cheque Date-- ( PAYR-CHECT )

Credit Amt-- ( PAYR-RWBTR )

How i can join all tables to create party ledger.

Regards,

Sidhik.

[Former Member]

THANKS Shrinath & Lakshmipati,

AS suggested found out relations mentioned below.

VBRK-VBELN = VBRP-VBELN.

VBRK-BELNR = BKPF-BELNR

VBRK-GJAHR = BKPF-GJAHR

VBRK-BUKRS = BKPF-BUKRS

BKPF-BUKRS = PAYR-ZBUKR

BKPF-BELNR = PAYR-VBLNR

BKPF-GJAHR = PAYR-GJAHR

is this ok.

[former_member217082]

Hi Sidiq

Try through SQVI As you want to have a relation between PAYR and VBRK

VBRK->VBRP->BKPF->PAYR

If the perivous one doesn't work then try with

VBRK->VBRP->BSEG->PAYR

Regards

Srinath

[Lakshmipathi]

Try in SQVI by Table Join in the following sequence

VBRK ==> VBRP ==> PAYR

If the above combination does not work, then try with

VBRK ==> VBRP ==> BKPF ==> PAYR

thanks

G. Lakshmipathi