on 02-19-2009 6:47 AM
Hi Gurus,
I need to extract customer credit used based on Sales area for a credit control area.
Eg : Customer 21XXX got credit limit of 10,000 , total credit used is 4000
he raised SO for SG01,AI,AA worth of 1000
SO's for SG01,AI,LG worth of 3000
i need a table to capture sales area wise credit limit.
WIll be rewarded.
Thanks
hi ,
Go through the table .
1,KNA1
2.KNVV
3.VBAK
4.VBAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yuvraj
Check the following tables to retrieve the customer credit value based on your sales area
KNA1 , KNVV , VBAK , VBAP
Regards
Srinath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
First go to table KNVV & find the customers based on your sales area.
Then go to table KNKK & pass the customers into this table.
Also check table KNKA
Hope this helps.
Regds......
Sumit
Edited by: Sumit Rayaguru on Feb 19, 2009 8:49 AM
Edited by: Sumit Rayaguru on Feb 19, 2009 8:58 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.