SPCINCFIL: Add criteria to selection filter for price list records to be revised

This entry point is used to complete the selection filter of the price list records to be revised.

It is called in the new price list record calculation process FUNSPCINC.

Context and operating mode

Transaction

There is no transaction in process.

Log file

There is no open log file.

Different call cases

This entry point is called at the start of the process.

Available variables

The record range as well as the validity date are used to constitute the standard filter variable FILTRESPF.

This entry point allows the use of the fields in the SPRICFICH table to complete the FILTRESPF variable.

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context.

Table

Abbreviation

Significant content

Table Title

SINCENT

SNE

Yes

Price list revision definition

SINCDET

SND

Yes

Price list revision definition (lines)

SPRICCONF

SPC

Yes

Customer price list setup

PRICSTRUCT

PRS

Yes

Price list structure

SPREASON

SPR

No

Sales price list reasons

SPRICFICH

SPF

No

Customer price list (Record)

SPRICLIST

SPL

No

Customer price list (Lines)

SPRICFICH

SPFN

No

Customer price list (Record)

SPRICINCR

SPI

No

Price list increase (new line values)

ITMMASTER

ITM

No

Products

ITMSALES

ITS

No

Product-sales

ITMBPC

ITU

No

Products-customers

ITMFACILIT

ITF

No

Products - Sites

ITMCOST

ITC

No

Products-costs

BPARTNER

BPR

No

Business Partner

BPCUSTOMER

BPC

No

Customers

BPCUSTMVT

MVC

No

Customer transactions

BPADDRESS

BPA

No

Addresses

TABCUR

TCU

No

Currency table

SPCINCCTL: Selection of price list record to be revised based on its content

This entry point is used to determine if the current record must be revised.

It is called in the new price list record calculation process FUNSPCINC.

Context and operating mode

Transaction

There is no transaction in process.

Log file

There is no open log file.

Different call cases

This entry point is called after the read of the price list record. It is used to refine the selection when the selection criteria are not contained in the fields in the SPRICFICH table.

Available variables

Set the GPE variable to 1 to not revise the current record.

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context.

Table

Abbreviation

Significant content

Table Title

SINCENT

SNE

Yes

Price list revision definition

SINCDET

SND

Yes

Price list revision definition (lines)

SPRICCONF

SPC

Yes

Customer price list setup

PRICSTRUCT

PRS

Yes

Price list structure

SPREASON

SPR

No

Sales price list reasons

SPRICFICH

SPF

Yes

Customer price list (Record)

SPRICLIST

SPL

No

Customer price list (Lines)

SPRICFICH

SPFN

No

Customer price list (Record)

SPRICINCR

SPI

No

Price list increase (new line values)

ITMMASTER

ITM

No

Products

ITMSALES

ITS

No

Product-sales

ITMBPC

ITU

No

Products-customers

ITMFACILIT

ITF

No

Products - Sites

ITMCOST

ITC

No

Products-costs

BPARTNER

BPR

No

Business Partner

BPCUSTOMER

BPC

No

Customers

BPCUSTMVT

MVC

No

Customer transactions

BPADDRESS

BPA

No

Addresses

TABCUR

TCU

No

Currency table

UPDNEWCRD: Modification of the new record before the update of the table

This entry point is used to insert additional logic before the end of the price list revision transaction.

It is called in the new price list record calculation process FUNSPCINC.

Context and operating mode

Transaction

There is one transaction in progress

To refuse the record update, it is necessary to set the GOK variable to 0.

Log file

There is no open log file.

Different call cases

This entry point concerns the modification, copying or changes in a record currency.

It is called for each record, when the work table SPRICINCR contains a group of the calculated price list lines, but before the transfer to the price list lines table SPRICLIST.

Available variables

[F :SNE]TYP determines the update type ( 1= record duplication / 2=record modification / 3=currency change).

At this level of processing, for the 3 update types, the SPRICINCR work table contains all the calculated lines.

Duplication: Creation of a new record from the contents of SPRICINCR

- Search for a record number

- Write the lines of a new record from the work table.

- If the end date of the original record is greater than the start date of the new record, the original record is adjusted (end date = start date for the new record -1).

Modification:   

- Deletion of original lines

- Write the lines from the work table

Currency change: Creation of a new record from the contents of SPRICINCR

- Search for a record number

- Write the lines of a new record from the work table.

By assigning it in the EP, the WNEW_PLI variable allows to modify the price list code of the new records created in case of duplication and modification. WARNING: The parameter of this price list code must exist; the processing does not perform any verification.

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context.  

Table

Abbreviation

Significant content

Table Title

SINCENT

SNE

Yes

Price list revision definition

SINCDET

SND

Yes

Price list revision definition (lines)

SPRICCONF

SPC

Yes

Customer price list setup

PRICSTRUCT

PRS

Yes

Price list structure

SPREASON

SPR

No

Sales price list reasons

 

 

 

 

SPRICFICH

SPF

Yes

Customer price list (Record)

SPRICLIST

SPL

Yes

Customer price list (Lines)

SPRICFICH

SPFN

No

Customer price list (Record)   

SPRICINCR

SPI

Yes

Price list increase (new line values)

 

 

 

 

ITMMASTER

ITM

No

Products

ITMSALES

ITS

No

Product-sales

ITMBPC

ITU

No

Products-customers

ITMFACILIT

ITF

No

Products - Sites

ITMCOST

ITC

No

Products-costs

BPARTNER

BPR

No

Business Partner

BPCUSTOMER

BPC

No

Customers

BPCUSTMVT

MVC

No

Customer transactions

BPADDRESS

BPA

No

Addresses

TABCUR

TCU

No

Currency table