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: 
Read only

Data Retrival from BSEG Table

Former Member
0 Likes
759

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
Read only

viquar_iqbal
Active Contributor
0 Likes
738

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

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

4 REPLIES 4
Read only

viquar_iqbal
Active Contributor
0 Likes
739

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

Read only

Former Member
0 Likes
738

Hi,

Check this link

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

Cheers,

Surinder

Read only

Former Member
0 Likes
738

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

Read only

Former Member
0 Likes
738

Hi,

Thanks to every body for the helpful answers.

Regards,

Krishnam Raju