cancel
Showing results for 
Search instead for 
Did you mean: 

SPG Counter

vasileiosfasolis
Active Contributor
0 Kudos

Hello to all!

could you please inform me what stands for the SPG Counter?

i saw in show differences menu (ACRD table) that there is a modification from a user and there is a record for SPG counter

thank you so much for your time!

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer SAP note:

1650126 - SPP Counter in Change Log

Thanks & Regards,

Nagarajan

vasileiosfasolis
Active Contributor
0 Kudos

Hi Naga!

unfortunatelly i cannot log in

i do not have username pass

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Here,

Symptom

The OSPP table is the special prices for Business Partners table. There is a
field in the OCRD table called SPPcounter which gets increased when you add a
special price for a specific Business Partner. Every time you update the special
price the counter increments.

SPP Counter change could be viewed in Business Partner Change
Log

Solution

Consulting

Other terms

SAP Business One, price list, history, changed field, previous value, new
value

Hope helpful.

Thanks & Regards,

Nagarajan

vasileiosfasolis
Active Contributor
0 Kudos

Hi Naga

i am not asking about SPP COunter but for SPG counter

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please advice SAP version and PL.

Thanks & Regards,

Nagarajan

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer below:

Symptom

Starting from 2007 A SP01 PL09 and 2007 B PL18, the user will have the
ability to use the Discount Groups through the DI API.
After this exposure
you will find:

  • When users Add/Update a BP in Buisniess One Application(on GUI), field
    "SPGCounter" in table OCRD will stay unchanged.

  • When users Add/Update a BP via DI-API with the code below, field "SPGCounter
    in OCRD will be incremented.

SAPbobsCOM.BusinessPartners bps =

oCompany.GetBusinessObject

(BoObjectTypes.oBusinessPartners);

bps.GetByKey("BP1");

bps.Update();

To

detail explain the Application and DI difference:

  • Business One Application Operations

When Add/Update a Buniess Partner on "Business Partner Master Data" form,

Discount Groups won't be opened, The two does not have connection that field

"SPGCounter" in OCRD won't be changed.

  • DI-API Operations

In DI, The Discount Groups Object like a child object of Business

Partner.

    • When Add/Update a BP, DiscountGroups Object will be updated with
      BP
    • When Add/Update Discount Groups(Application or DI-API), the field
      "SPGCounter" of Discount Groups' current BP will be automatically
      incremented.

    • DiscountGroups Object cannot be created/updated independently in DI-API, it
      must be created/updated through it's father object BP.

    • Based on above, when create/update a BP in DI-API, DicountGroups will be
      updated with BP, then "SPGCounter" of current BP will be
      incremented

Cause

Functionality Description

Solution

This is system behavior

Thanks & Regards,

Nagarajan

Answers (0)