How To Fix AQV154 - ¿Se conocen todos los campos necesarios? (utilice la Ayuda)

SAP Error Message - Details

• Message type: E = Error

• Message class: AQV - Message texts for SAP Query

• Message number: 154

• Message text: ¿Se conocen todos los campos necesarios? (utilice la Ayuda)

¿Qué causa este problema?

<ZH>This is only a warning. A generated version of the functional area
is always provided.</>
When generating query reports for queries with this functional area,
access to database and additional tables is optimized so that only the
fields really needed are provided (GET or SELECT with field list). This
greatly improves performance over the technique in which all the fields
of a table line are provided (GET without field list or SELECT *).
The current functional area might not contain all the information for
determining the required fields. In query reports this could mean that
required fields only contain their initial value when the reports are
processed.
<ZH>You should therefore check if one of the cases described below is
true and correct your functional area accordingly.</>
To optimize access to the database and addditionyl tables, the fields
needed to generate a query report are determined when you generate a
functional area. These can be the following fields:
Fields inserted in functional groups
Fields used to formulate WHERE conditions in assigned tables
Fields addressed in the coding of additional fields
Fields addressed in the coding at timepoints GET / GET LATE or during
record processing
The current functional area contains ABAP code for defining additional
fields or at timepoints GET / GET LATE or during record processing.
Because ABAP language elements can be used freely, you can access these
fields within such codings without explicitly specifying them (field
symbols, external perform, DO ... VARYING, ADD ... THEN ... UNTIL,
etc.).
To ensure that you generate the query report without errors, you must
be able to determine the fields accessed from each (!) piece of coding
(additional field, GET / GET LATE / record processing). This requires
that each field used is also specified in this piece of coding.

Respuesta del sistema

El sistema emite un mensaje de error y no le permitirá continuar con esta transacción hasta que se resuelva el error.

¿Cómo arreglar este error?

If one of the pieces of coding contains ABAP statements that implicitly
access fields, use the FIELDS statement within the coding to ensure
that all the database, table and additional fields used are also
specified explicitly.
Example:
Table KNC1 contains fields UM01U, UM02U and UM03U with the monthly
business volume for the first three months of a year. An additional
field Q1 that should contain the business volume for the first quarter
computes the sum of these three fields using an external perform.
PERFORM QUARTAL1(pppppppp) USING Q1.
Fields KNC1-UM01U, KNC1-UM02U and KNC1-UM03U are accessed with the
common storage area for table KNC1 in the query report and in the
called program pppppppp. You cannot see in the given coding that the
specified fields are required. You therefore have to change this piece
of coding as follows:
PERFORM QUARTAL1(pppppppp) USING Q1.
FIELDS: KNC1-UM01U, KNC1-UM02U, KNC1-UM03U.
Note that you must do this separately for each piece of coding since a
piece of coding is only copied the query report if this is necessary.
It therefore has to be determined separately for each piece of coding
that requires fields.
Also note that only the fields used immediately have to be specified in
the coding.
Example
The additional fields F1 and F2 are defined with the following coding:
F1: F1 = tab-field. " tab-field is a database field
F2: F2 = F1 + 2.
Although F2 indirectly accesses tab-field , you do not have to specify
tab-field in the coding of F2 as a used field. Such indirect references
are automatically resolved when you generate the functional area. The
codings for both additional fields are correct in the present form.
In exceptions, the statement
FIELDS tab.
can be used in coding, where tab is a database table or an additional
table. This causes all fields of table tab to be provided in the query
report. Note that in this case you switch off optimized access to table
tab and thus greatly reduce performance when processing queries.

Extracto de mensaje de error del sistema SAP. Copyright SAP SE.