on 12-04-2014 3:38 AM
Hello Experts,
Currently we are using custom table 903 with combination of these 5 fields - SalesOrg/Dest.Ctry/AAG/AAG/AcctKey and system is using Destination country & AAG from Sold-To party for deriving Revenue Account Determination.
Business user now wants Revenue account determination based on the Destination country & Account Assignment group values of fields from Ship-To party.
Though I have updated the screen layout of Ship-To party SalesArea=> BillingTab to include Account assignment group newly and Ship-To customer is assigned with "Foreign Revenue", I am not sure how to make system to derive values from Ship-To and not the SoldTo party (which has "Domestic Revenue").
Upon searching on blogs I have read about using USEREXIT_ACCOUNT_PREP_KOMPCV, I am not clear how the system is going to read values from Ship-To Vs Sold-To.
I appreciate your time and guidance on this.
Thank you,
Devi
This issue is resolved after implementing user exit USEREXIT_ACCOUNT_PREP_KOMKCV which will overwrite the KTGRD value with Ship-To party value if Ship-To party is different from Payer. This was one of the option suggested by Samier Danish as well.
Thank you all for your time and inputs I got for resolving this issue.
Devi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Devi,
This is not a straight-forward requirement. Some coding needs to be done, and then testing.
I suggest don't add field Account assignment group customer KTGRD in SH. SAP standard takes this from Payer, even if there is a AAG in SH it will not populate in sales order and then bill. Take another field with which you can group SH. See that this field is in the catalog and then create a table accordingly with this new field. See below link.
You want to include the destination country of SH, in bill do you have SH as one of the partners? or else with coding, the LAND1 of SH, from sales order needs to be retrieved (VBFA table). In the sales order, if you have different SH, then the correct line item of order needs to be identified; coming back from bill.
https://help.sap.com/saphelp_45b/helpdata/en/00/f62c7dd435d1118b3f0060b03ca329/content.htm
TW
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi TW,
Thank you for looking at my query! Unfortunately I cannot control the business process and the business need and they would want to consider a sale based on the destination where our product is shipped.
Yes SH-Ship-to party is defined as one of the partners.
And about creating a new table including possibly another field on which SH can be grouped, if I understand right, I need to have the following 5 fields in the new table: SalesOrg,AAG(material),Acctkey + SH Destination & SH AAG.
However I am not sure how can we make the system to differentiate between the Destination & AAG of current Sold-to & Ship-to party fields?
Thank you,
Devi
I need to have the following 5 fields in the new table: SalesOrg,AAG(material),Acctkey + SH Destination & SH AAG.
The accounting entry is
Customer A/c (Payer) Dr
To Revenue A/c Cr
Even if u add extra field as Ship to party this will hit only your revenue a/c.
If u want to change Customer A/c from Payer to Ship to party,then abap coding is required.
Pradeep.M
Is your ship to party & Payer is same always--pl Confirm.
If yes--then no need for Development.
If differs--you need to follow the other way.
But interested to know how requirement at Revenue account determination can control this?
hope you are already trying at exits at Billing level..
But before going for this--can you try by having one more billing type(thereby different rev.A/c.Det.Procedure can be assigned at VOFA)& you need to instruct all your users to use this Billing type--when Ship to party & Payer differs.
Note: but it depends on user discipline while going for Billing in VF01 with correct Billing type.
If it was not controlled then you can go with separate doc types from Sales order onwards.
Hope this helps...
Phanikumar
Hi Devi,
Please check this user exit too 'EXIT_SAPLJF60_007' (IS-M/SD: Modify Fields for Account Determination (Item Fields)).
I'm not sure but if we can change the AAG of Payer to AAG of Ship-to Party, this should work. I think, in coding, we can write to fetch Ship-to Party with 'WE' and read KNVV-KTGRD, and finally pass on to KOMPCV.
Regards
SD
Thank you for your time Phanikumar! We have this issue only because, Payer and ship-to are different and a Sold-To party can have more than one Ship-To party.
I am working with offshore SD resource and what you suggested is also one of the option we are considering. I shall keep posted on our progress.
Hi,
If i am wrong kindly rectify me,account determination happens based on Payer.It is standard
You may check with abaper .
Pradeep
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 | |
8 | |
7 | |
4 | |
4 | |
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.