SPPGENSEL: Modification of the selections to determine the content of the catalo

This entry point is called when creating a price catalog.

It is used to replace the standard processing to determine customer/product pairs for which the price catalog must be generated.

This entry point is located in the SUBSPP processing.

Context and operating mode

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Different call cases

The entry point is called upon clicking the "Validation" button.

Available variables and masks

The [F:SPP] buffer is loaded with the active setup record.

Filter constitution

On calling the entry point, the filter variables to use in the Filter evaluates (…) are loaded.

- FILBPCSTR   FILBPCEND FILBPCSUP              Customer filters

- FILBPRSUP                                                           BP filter

- FILITMSTR   FILITMEND   FILITMSUP                   Product filters

- FILITSSUP                                                              Products sales filter

The entry point is used to modify the content of these variables by exploiting the values contained in the selections stored in [F:SPP]. It is necessary to use the [F:SPP] class.

If additional filters (for example on the ship-to customers and/or customer products) are required, they must be reserved in the entry point.

Customer/product pair search loop

The loop must be rewritten (see the standard loop). It is necessary to use the [F:xxxJ] classes because pointers could be disturbed since the price list processings reread the standard [F] classes. On the other hand it is necessary to load the standard [F] classes before the call "Gosub TAR_CLIART From SUBSPP".

GPE variable

The GPE variable must be set to 1 to prevent the standard search loop to start.  

Open tables

Table

Significant content

Table Title

SPPRTCONF

Yes

Price catalog definition

 

 

 

BPARTNER

No

BP

BPCUSTOMER

No

Customers

BPCUSTMVT

No

Customer transactions

BPDLVCUST

No

Ship-to customers

ITMMASTER

No

Products

ITMSALES

No

Products - sales

ITMBPC

No

Products - Customers

ITMMVT

No

Product - site totals

ITMFACILIT

No

Products - sites

FACILITY

No

Sites

ATABDIV

No

Miscellaneous tables

TABCUR

No

Currency table

TABCHANGE

No

Currency exchange rate tables

TABVAC

No

Tax determination table

TABVAT

No

Tax code table

TABRATVAT

No

Tax rate

TABUNIT

No

Unit table

TABCOEFF

No

Coefficient table

PRICSTRUCT

No

Price list structures

SPRICCONF

No

Customer price list setup

SPRICFICH

No

Customer price list (Record)

SPRICLIST

No

Customer price list (Lines)

SPRICLINK

No

Sales price search (Link)

SFOOTINV

No

Sales invoicing elements

SPREASON

No

Sales price list reasons

 

 

 

BPARTNER

No

 under the abbreviation [BPRJ]

BPCUSTOMER

No

 under the abbreviation [BPCJ]

BPDLVCUST

No

 under the abbreviation [BPDJ]

ITMMASTER

No

 under the abbreviation [ITMJ]

ITMSALES

No

 under the abbreviation [ITSJ]

ITMBPC

No

 under the abbreviation [ITUJ]

 

 

 

 

SPPGENWRT: Modification of a line in the price catalog

This entry point is called before each catalog line is written.

This entry point is located in the SUBSPP processing.

Context and operating mode

Transaction

A transaction is in process.

Log file

There is no open log file.

Different call cases

The entry point is called upon clicking the "Validation" button.

Available variables and masks

The SPRICPRTQ [SPQ] record contains all the data for the catalog line. It is therefore possible to modify them.

If the record is written in the entry point and not in the standard process, it is necessary to set [F:SPW]=[F:SPQ] in order not to write lines more than once in the catalog.

Variable IJ1

The IJ1 variable is tested before the write of the line. In order not to write this line, it is necessary to set the IJ1 variable to 0. 

 

Open tables

Table

Significant content

Table Title

SPPRTCONF

Yes

Price catalog definition

 

 

 

BPARTNER

No

BP

BPCUSTOMER

No

Customers

BPCUSTMVT

No

Customer transactions

BPDLVCUST

No

Ship-to customers

ITMMASTER

No

Products

ITMSALES

No

Products - sales

ITMBPC

No

Products - Customers

ITMMVT

No

Product - site totals

ITMFACILIT

No

Products - sites

FACILITY

No

Sites

ATABDIV

No

Miscellaneous tables

TABCUR

No

Currency table

TABCHANGE

No

Currency exchange rate tables

TABVAC

No

Tax determination table

TABVAT

No

Tax code table

TABRATVAT

No

Tax rate

TABUNIT

No

Unit table

TABCOEFF

No

Coefficient table

PRICSTRUCT

No

Price list structures

SPRICCONF

No

Customer price list setup

SPRICFICH

No

Customer price list (Record)

SPRICLIST

No

Customer price list (Lines)

SPRICLINK

No

Sales price search (Link)

SFOOTINV

No

Sales invoicing elements

SPREASON

No

Sales price list reasons

 

 

 

BPARTNER

No

 under the abbreviation [BPRJ]

BPCUSTOMER

No

 under the abbreviation [BPCJ]

BPDLVCUST

No

 under the abbreviation [BPDJ]

ITMMASTER

No

 under the abbreviation [ITMJ]

ITMSALES

No

 under the abbreviation [ITSJ]

ITMBPC

No

 under the abbreviation [ITUJ]

 

 

 

 

RECHTARIF: Intervention before the price list search

Context and operating mode

This entry point is located in the RECHTARIF sub-program of the TRTVENTAR processing:  RECHTARIF