How To Fix SRF_AUTHORING242 - Fremdschl. für Abfrage &2 der äußeren Schl. in Abfrage &1 nicht vollst.

SAP Error Message - Details

• Message type: E = Error

• Message class: SRF_AUTHORING - Message class for SRF Authoring

• Message number: 242

• Message text: Fremdschl. für Abfrage &2 der äußeren Schl. in Abfrage &1 nicht vollst.

Was verursacht dieses Problem?

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.

Systemantwort

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

Wie behebe ich diesen Fehler?

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.

Vorgehensweise für Systemadministratoren

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE