Skip to Content
0

Auto BP code based on BP group

Oct 24, 2016 at 09:00 PM

74

avatar image

Hi Experts!

I need help with BP code auto generation. Is it possible to generate auto BP code based on BP group?

I have attached a screenshot below for your reference.

For instance, all BP vendor under the BP group "Employee" begins with VE. The same applies with customers. All customer under BP group "Tenant" must begin with CT.

Thank you! :)

1.jpg (277.4 kB)
3.jpg (298.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Johan Hakkesteegt Oct 25, 2016 at 06:15 AM
0

Hi,

There are reasons why this is a bad idea to begin with:

  • Someone accidentally chooses the wrong group.
  • A Business Partner is moved to another group for some reason.

...and trust me, these things will happen a lot more often than you would like.

Once either of these things happens, your business logic becomes unreliable, and you will become dependent on the right person, at the right moment, remembering all the exceptions to the rule.

If you nonetheless insist on doing this, you can use a Formatted Search in the BP code field, with a query with a CASE statement.

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded
Pradnya S Oct 31, 2016 at 08:38 AM
0

Hi,

In my opinion, do not generate BP codes based on the BP group. Else, follow SAP standard of numbering on the basis of customer and vendor.

Because BP code in your case is completely dependent on BP group and finally will impact MIS.

What if there occurs an error while selecting a BP group ?

Request you to give a second thought.

If at all you want to achieve this then, can be done through FMS or SPTN

All the best.

Regards

Narayani

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Oct 31, 2016 at 12:47 PM
0

Hi,

Instead of creating BP code based on item group, create customer code with standard like customer group and use BP properties to differentiate each BP.

Thanks

Share
10 |10000 characters needed characters left characters exceeded