How To Fix STRALAN_MSAG042 - Some tables are excluded (see long text)

SAP Error Message - Details

• Message type: E = Error

• Message class: STRALAN_MSAG - Language Transport Messages

• Message number: 042

• Message text: Some tables are excluded (see long text)

What causes this issue?

When you supplement a language, you supplement all tables that are
flagged as relevant for translation in your technical settings. You can
use Transaction SE13 to check the technical settings of a table.
However, it does not make sense to supplement some tables, regardless
of their technical settings. These include, for example, tables that
are flagged as relevant for translation, but which are translated using
a special procedure that produces more information than just a text
(such as indexes or header data).

System Response

When this option is chosen, the tables that are stored as follows are
not supplemented.
The tables that are excluded from supplementation are stored in the
table TLANNOTTA. In this table, you can specify one or more languages
for each table which you do not want to supplement.

How to fix this error?

SAP delivers the table TLANNOTTA with default entries. You can use
Transaction SM30 to change or add to these entries. If you do not want
to supplement a table for any language, enter '+' in the language
field.
<ZH>All tables that have the supplementation flag set to "false" are
not supplemented for the specified languages.</>
You can also override the TLANNOTTA settings by adding the tables to
the list of tables you want to supplement in Transaction SMLT.

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.

Smart SAP Assistant

• What is the cause and solution for SAP error message STRALAN_MSAG042 - Some tables are excluded (see long text) ?

  The SAP error message STRALAN_MSAG042 indicates that some tables are excluded from a certain operation, typically related to data extraction or reporting processes. This message is often encountered in the context of SAP BW (Business Warehouse) or data modeling scenarios.
  Cause:
  The error can occur due to several reasons, including:
  
  
  Data Model Configuration: Certain tables may be excluded from the data model due to configuration settings. This could be intentional based on business rules or data governance policies.
  
  
  Authorization Issues: The user executing the operation may not have the necessary authorizations to access certain tables, leading to their exclusion from the process.
  
  
  Data Source Settings: The data source from which the data is being extracted may have specific settings that exclude certain tables.
  
  
  Technical Settings: There may be technical settings in the data extraction process that prevent certain tables from being included.
  
  
  Solution:
  To resolve the issue, consider the following steps:
  
  
  Check Configuration: Review the data model configuration to ensure that the tables in question are included. This may involve checking InfoObjects, DataSources, or other relevant settings.
  
  
  Review Authorizations: Ensure that the user has the necessary authorizations to access all relevant tables. This may involve checking user roles and permissions in the SAP system.
  
  
  Examine Data Source Settings: Look into the settings of the data source being used for extraction. Ensure that it is configured to include all necessary tables.
  
  
  Consult Long Text: The error message typically has a long text that provides additional context. Review this long text for specific details about which tables are excluded and why.
  
  
  Check for Notes and Documentation: Look for SAP Notes or documentation related to this error message. SAP may provide specific guidance or patches that address the issue.
  
  
  Testing: After making changes, perform tests to ensure that the tables are now included in the operation.
  
  
  Related Information:
  
  SAP Notes: Search for relevant SAP Notes in the SAP Support Portal that may address this specific error message.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered and resolved similar issues.
  Documentation: Review SAP documentation related to data modeling, extraction, and reporting for best practices and troubleshooting tips.
  
  If the issue persists after following these steps, it may be beneficial to consult with an SAP Basis or BW consultant who can provide deeper insights into the system configuration and data flow.