on 09-20-2008 7:48 AM
Hi,
Is it possible to allocate a BP to one or more Profit centers when creating a BP Master in SAP;such that, on creation of a marketing document the Profit center is directly picked up instead of selecting it.
Please comment.
Regards,
Projects can be associated with a Business Partner in the Master data definition but not Profit Center.
Profit Center have associated distribution rules and are linked to G/L account or a transaction at the row level.
You could do this. Create a UDF in the BP Master to enter the profit Center information.
In the Sales Order Rows..in the Profit Center field create a Formatted Search to pull the Profit Center from the BP Master UDF
Example: Let us say your Profit Center User field on the BP Master is called U_PC
then your Formatted Search on the Marketing document would be
<B> <Font Color=BLUE> SELECT T0.U_PC FROM [dbo\].[OCRD\] T0 WHERE T0.CardCode = $\[$4.0.0]
</FONT></B>
Set it to Auto Refresh on Item Code ....check Display Saved Values
If you want 2 Profit Centers on the BP Master and the user would select it in the Marketing document then let us presume your UDF's are U_PC1 and U_PC2,
the FMS would be
<B> <Font Color=BLUE>
SELECT T0.U_PC1 FROM [dbo\].[OCRD\] T0 WHERE T0.CardCode = $\[$4.0.0]
UNION ALL
SELECT T0.U_PC2 FROM [dbo\].[OCRD\] T0 WHERE T0.CardCode = $\[$4.0.0]
</FONT></B>
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suda,
Thanks for your reply!
I tried following you steps as instructed, U_PC1 works fine....however the second Profit center (U_PC2) in the marketing doc does not seem to pick up the values, instead if I select more than one items, the "Choose from list " appears multiple times prompting to select the U_PC2 values....
Can you revert on the possible causes for such a result?
Awaiting your reply!
Regards,
Hi,
Profit center deals with expense and revenue accounts. Both are in the P&L. Meanwhile the BP will not have the account but it is balance sheet account i.e. liabilities and asset.
The solution is creating UDF in the BP master data or using business partner properties, so that it can be used in the aging selection criteria when you want to generate BP aging report.
The BP properties can be used directly in the marketing document by using query FMS.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vishal,
The answer is no because BP can only link to GL account by control account. Unless you GL accounts has one to one relationship with profit center (seems imposible), you only choice might be utilizing property fields to map BP with profit center. The link will be very weak in this way.
You can also use UDF to build the link too.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.