How To Fix SRF_AUTHORING242 - Consulta loop &1 no especifica completam.clave ext.p.consulta loop ext.&2

SAP Error Message - Details

• Message type: E = Error

• Message class: SRF_AUTHORING - Message class for SRF Authoring

• Message number: 242

• Message text: Consulta loop &1 no especifica completam.clave ext.p.consulta loop ext.&2

¿Qué causa este problema?

According to the data mapping for the current element, loop query &V1&
is nested in loop query &V2&.
Loop query &V1& does not fully specify the foreign key for loop query
&V2&.
Missing fields from primary key or secondary keys (list may be
truncated):
&V3&&V4&
Example:
The outer loop query is based on journal entry items with key fields
company code, fiscal year, document number, and document item number.
The nested loop query is based on tax items with key fields company
code, fiscal year, document number, and tax item number.
For each journal entry item all tax items of the corresponding journal
entry are included identically in the generated document.

Respuesta del sistema

Performance optimization for nested loop queries can not be applied. It
might take longer to generate the document.

¿Cómo arreglar este error?

If this behavior is intended and you would like to benefit from
performance optimization for nested loop queries, include the missing
key fields in the nested loop query (document item number in the example
above) and define a corresponding filter condition on the nested loop
query (document item number from tax item = document item number from
journal entry item). Since tax items do not have a relation to journal
entry items, you also need to enhance the corresponding query source
with a join to journal entry items such that the same tax items are
returned for all items of one journal entry. Thus, the system can push
down more logic to the database, which will speed up generation time
whenever the nested loop query (tax item) returns only few records per
record of the outer loop query (journal entry item).
This message might also appear because the underlying query source of
&V2& does not describe key fields properly. In this case you should
update that query source if possible.

Procedimiento para Administradoras de Sistemas

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

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