How To Fix SRF_AUTHORING242 - Loop query &1 does not fully specify foreign key for outer loop query &2

SAP Error Message - Details

• Message type: E = Error

• Message class: SRF_AUTHORING - Message class for SRF Authoring

• Message number: 242

• Message text: Loop query &1 does not fully specify foreign key for outer loop query &2

What causes this issue?

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.

System Response

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

How to fix this 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.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.