Find
This method searches for all vendors, that store a transferred contentin a transferred table field. The search terms are transferred instructure SELOPT_TAB. The vendors that are found are collected in the table RESULT_TAB. The probable blocks or deletion flags will be marked for the vendors found.
The number of hits can be restricted by the parameter MAX_CNT. Value "0" means that there is no restriction on the search result. The standard search is for the exact field content (Field SELOPT_TAB-FIELDVALUE). If the parameter PL_HOLD is selected, the use
of wild cards is allowed. "*" is for any character string and "+" for any character. The search terms are processed individually and not joined to othersearch terms, that is, only one field from the vendor master table is examined at a time. The method is case sensitive with the exception of the match code fields that are maintained in the table TFMC.
Example- Vendors should be found that have "23" in the field KNB1-PERNR(personnel number) for the company code 0001. All the vendors that arefound should be displayed. The search should be carried out exactly, that is, without match codes.
The required entries:
Table SELOPT_TAB Field Content ----------------------------------------- COMP_CODE 0001 TABNAME LFB1 FIELDNAME PERNR FIELDVALUE 23
IMPORT Parameter MAX_CNT 0 PL_HOLD SPACE The transfer of import parameter MAX_CNT and PL_HOLD is optional, as the values named above correspond to the standard settings. - Vendors should be found that have that "SAP" at the beginning of field
KNB5-KNRMA (account number of the dunning recipient). The search shouldbe cross-company code and the number of hits should be restricted to 100. The use of wild cards is allowed.
The required entries:
Table SELOPT_TAB Field Content ----------------------------------------- COMP_CODE SPACE
TABNAME LFB5 FIELDNAME LFRMA FIELDVALUE SAP*
IMPORT Parameter MAX_CNT 100 PL_HOLD X The import parameters MAX_CNT and PL_HOLD have to be transferred, asthe values named above do not correspond to the standard settings.
|