topic FI & SD Link in Application Development and Automation Discussions

FI & SD Link

Former Member — Tue, 18 Apr 2006 05:53:51 GMT

Hello All,

Based on the Selection screen criteria i am accessing Data from BSAD (FI, specifically for Document Type DA and RV).

If the Document type is 'DA' its a Finance document and all the information can be obtained from BSAD itself.

If the Document type is 'RV' its a SD document and the rest of the information is received from VBRK and VBRP.

Would like to have the Linking fields between BSAD and VBRK/VBRP and

VBRK and VBRP being Header an Line Item data do you think that its the right way to access this data within the Loop of BSAD.

Step1 - Select the Data from BSAD (DA and RV).

Step2 - Loop at BSAD and based on Document type go to VBRK/VBRP

Step3 - loop at VBRK within the Loop at BSAD

Is there an more appropriate way to approach this.

Regards,

- PSK

Former Member — Tue, 18 Apr 2006 06:01:31 GMT

Hi,

BSAD is the Customer index for cleared items.

With this accounting doc number u can go to table BSID.

This is the general index. Here u will find the sales document numbers BSID-VBEL2 and BSID-POSN2.

You will also find the billing doc number which is BSID-VBELN.

You can use these to get the sales documents.

Thanks,

Rashmi.

Message was edited by: Rashmi Joshi

Former Member — Tue, 18 Apr 2006 06:03:08 GMT

Hi Sravan,

From BSAD you can get the billing document number VBELN and from this you can lookup directly into vbrk/vbrp.

Try avoiding writing a select within a loop.

Hope this helps.

Cheers

Former Member — Tue, 18 Apr 2006 06:04:34 GMT

Hi Sravan,

From BSAD you can get the billing document number VBELN and from this you can lookup directly into vbrk/vbrp.

Regards,

Suresh

Former Member — Tue, 18 Apr 2006 06:12:51 GMT

did u try BELNR/GJAHR fields.

Former Member — Tue, 18 Apr 2006 06:24:49 GMT

Hi,

if Document type is 'pv' , in this case bill document no same as finance document no.

So From BSAD you can get the finance document number belnr and from this you can lookup directly into vbrk/vbrp where vbeln = bsad-belnr.

regards,

srinivasarao oleti