Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Retrival from BSEG Table

Former Member
0 Kudos
238

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

1 ACCEPTED SOLUTION

viquar_iqbal
Active Contributor
0 Kudos
217

hi

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

4 REPLIES 4

viquar_iqbal
Active Contributor
0 Kudos
218

hi

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
0 Kudos
217

Hi,

Check this link

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

Cheers,

Surinder

Former Member
0 Kudos
217

Hi

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
0 Kudos
217

Hi,

Thanks to every body for the helpful answers.

Regards,

Krishnam Raju