Processing CUSSEA : Customer Search
SQLREQ: After any field modification
This entry point is used to give users the ability to edit the search sql request. It is called from Customer Search screen in APRES_MODIF after any field (with the exception of the grid) modification.
Context and operating method
Transaction
There is no transaction in progress.
Log file
There is no open log file.
Additional information
The SQL_CLOB variable is originally defined as the following:
SQL_CLOB = select BPRNUM_0,cast(BPCFLG_0 as varchar(1)),BPRNAM_0,BPRNAM_1,BPDNAM_0,BPDNAM_1, BPAADD_0,BPAADDLIG_0,BPAADDLIG_1,BPAADDLIG_2,CTY_0,SAT_0,POSCOD_0,TEL_0,WEB_0, CNTNUM_0,CNTFNA_0,CNTLNA_0,CCNTEL_0,CNTMOB_0,CNTEMA_0,CCNWEB_0 from VCUSSEA where 1=1
Below is an example on how to modify the SQL_CLOB variable:
Append SQL_CLOB, " and (BPRNUM_0 like upper(‘BPR001’))"
Available variables and masks
The [M:CSE] class is available when in Customer search screen (Common data >> BPs)
Variable or mask | Definition |
Mask [M:CSE] | Customer search |
Variable SQL_CLOB(5) clbfile |
Open tables
Table | Significant content | Table Title |
ADOSSIER | No | Folder table |
TABCOUNTRY | No | Countries |
BPDLVCUST | No | Ship-to customer |
BPCUSTOMER | No | Customers |
BPARTNER | No | Business partner |
SEACAT: After any field modification
This entry point is used to give users the ability to include added search category fields. It is called from Customer Search screen in APRES_MODIF after any field (with the exception of the grid) modification.
Context and operating method
Transaction
There is no transaction in progress.
Log file
There is no open log file.
Additional information
SEACAT function which is called in APRES_MODIF and the added entry point code.
Funprog SEACAT
Local Char CAT
CAT += [M]BPRNUM
CAT += [M]BPRNAM
CAT += [M]TEL
CAT += [M]WEB
CAT += [M]ADDLIG
CAT += [M]CTY
CAT += [M]SAT
CAT += [M]POSCOD
CAT += [M]CNTNAM
CAT += [M]CNTTEL
CAT += [M]CNTMOB
CAT += [M]CNTWEB
GPOINT="SEACAT" : Gosub ENTREE From EXEFNC
End CAT
Available variables and masks
The [M:CSE] class is available when in Customer search screen (Common data >> BPs)
Variable or mask | Definition |
Mask [M:CSE] | Customer search |
Variable CAT char |
Open tables
Table | Significant content | Table Title |
ADOSSIER | No | Folder table |
TABCOUNTRY | No | Countries |
BPDLVCUST | No | Ship-to customer |
BPCUSTOMER | No | Customers |
BPARTNER | No | Business partner |