2009 Feb 19 4:06 PM
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
2009 Feb 19 4:36 PM
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
2009 Feb 19 4:36 PM
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
2009 Feb 19 4:43 PM
Hi,
Check this link
[http://www.sapmaterial.com/bseg_alternative.html]
Cheers,
Surinder
2009 Feb 19 4:52 PM
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
2009 Feb 20 5:10 AM
Hi,
Thanks to every body for the helpful answers.
Regards,
Krishnam Raju