topic Re: Fetching Account Document Details in Application Development and Automation Discussions

Fetching Account Document Details

Former Member — Thu, 13 Sep 2012 12:32:16 GMT

Hi Experts,

Can anyone tell me Bapi/F.M/D.B Tables to retrieve account document details which is parked/posted in FV60. I can get header record from BKPF table.

Regards,

Pavan.

Re: Fetching Account Document Details

iftah_peretz — Thu, 13 Sep 2012 22:40:14 GMT

Hi,

Try table BSEG.

Let me know if this helped you!

Best,

Iftah

Re: Fetching Account Document Details

Former Member — Fri, 14 Sep 2012 02:51:24 GMT

From BKPF, you can get the detail from BSEG using the following field :

Company Code (BUKRS)

Document No (BELNR)

Fiscal Year (GJAHR)

Re: Fetching Account Document Details

Former Member — Fri, 14 Sep 2012 03:46:38 GMT

Hi,

If you are talking about any of the table bseg/bset/bsec/bsis/bsas/bsak/bsik/bsad/bsid please excuse. I tried all. Any useful suggestions?

Regards,

Pavan.

Re: Fetching Account Document Details

Sijin_Chandran — Fri, 14 Sep 2012 05:23:42 GMT

Hi Pavan ,

But these all are the correct answers.

BSEG/BSET/BSAS/BSIS....

You must get Line item details in BSEG for sure.

Re: Fetching Account Document Details

Former Member — Fri, 14 Sep 2012 06:07:54 GMT

Hi Sijin,

You are right if the document is posted. But i am parking the document here.

Regards,

Pavan.

Re: Fetching Account Document Details

iftah_peretz — Fri, 14 Sep 2012 06:28:38 GMT

Hi parvan,

The data you need is in one of these tables:

VBSEGA Document Segment for Document Parking - Asset Database

VBSEGD Document Segment for Customer Document Parking

VBSEGK Document Segment for Vendor Document Parkiing

VBSEGS Document Segment for Document Parking - G/L Account Datab

Best,

Iftah

Re: Fetching Account Document Details

Former Member — Fri, 14 Sep 2012 06:35:46 GMT

Hi iftah,

Table VBSEGK helped me.

Regards,

Pavan.