Sage: find article (FindArticle)

Sage: find article (FindArticle)

Read the data for one or more articles. In the input parameter group, multiple parameters can be filled with the corresponding search criteria. If the parameters contain the character %, a search is made with like, otherwise with =. The individual search criteria are connected with AND. All arrays in the table g000 can be entered as well as the caption arrays: ben, ben1, werkstoff, gegrp, abmessung, kurzben, klasse, norm, and normnr. By filling the parameter lang_ext, you can control which language is to be read. The function returns all the articles found in an indexed parameter group. The indexation of the parameter group is adjusted if necessary. If unknown search criteria are used, the service delivers a corresponding error message. This is entered via the parameter Message. Before evaluating the output parameter group, the parameter Message should be verified.

The following parameters in the parameter group are filled:

abmessung, aendnr, agr, altern, aplidentnr, aplvar, ben, ben1, bestell, bild, bild_inet, bonuskz, breite, bs, cadkz, cadnr, ch, dataen, datneu, doku, dpreis, ekpreism, epreis, gewicht, hoehe, identnr, kalkpreis, klasse, kn_sebl, kn_variant, kn_vsperre, kontovb, kontovr, kontowe, kontowv, kostst, kurz_ben, laenge, lang_ext, lgnr, mc_var, me, me_abmessung, mep, mev, mevk, norm, normnr, objektid, orpreis, pe, peek, pevk, preisgrp, prodgr, rabattkz, staffel, stlidentnr, stlvar, ts_m, ts_w, txt_nr, umrech, umrechp, umrechvk, updatenr, useraen, userneu, var, var_akt, volumen, vpreis, werkstoff, wgr, zeichnr.