topic Re: Data Retrival from BSEG Table in Application Development and Automation Discussions

Data Retrival from BSEG Table

Former Member — Thu, 19 Feb 2009 16:06:13 GMT

Hi,

Can any one tell me how to retrive the partial payment accounting documents from BSEG table as I

Can't use REBZG field of BSEG which is not a primary key ?

Regards,

Krishnam Raju

viquar_iqbal — Thu, 19 Feb 2009 16:36:28 GMT

you can consider getting data from

BSAD Accounting: Secondary Index for Customers (Cleared Items)

BSAK Accounting: Secondary Index for Vendors (Cleared Items)

BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items)

BSID Accounting: Secondary Index for Customers

BSIK Accounting: Secondary Index for Vendors

BSIS Accounting: Secondary Index for G/L Accounts

instead of BSEG as its a cluser table

Former Member — Thu, 19 Feb 2009 16:43:03 GMT

Hi,

Check this link

[http://www.sapmaterial.com/bseg_alternative.html]

Cheers,

Surinder

Former Member — Thu, 19 Feb 2009 16:52:25 GMT

U need to get all payments and check if they are partial payment.

I don't know which kind of items (vendor or customer) u need to control, but if u need to check the customer payments:

- A) Select the payments from cleared items (BSAK table)

- B) Check if the field REBZG is filled

Max

Former Member — Fri, 20 Feb 2009 05:10:10 GMT

Hi,

Thanks to every body for the helpful answers.

Regards,

Krishnam Raju