Fields to link BSAD, VBRK and VBRP tables

[Former Member]

Hi All

I am required to retrive DMBRT field from BSAD table. From the selection screen i am getting values of FKDAT value as select option and sales group (VKGRP) field.

Can omeone tell me how can i link the these three tables so as to retrive DMBRT field?

Plese this is bit urgent as the project go live is near.

Thanks in advance.

Gaurav

[Former Member]

The problem is solved.

[Former Member]

Hi,

What I understand from your question is that using a selection criteria for FKDAT and VKGRP, you need to extract the val in loc curr (DMBTR). If this is so, then,

The linking field between VBRK (header table) and VBRP is VBELN; VBRK will supply FKDAT, VBRP will give the VKGRP field for selection. You can define a join between them.

The only field that links VBRK to BSAD is again VBELN. This is also present in the BSAD table. This may also be defaulted in the reference field (XBLNR) for RV document type if set in customising.

Cheers