351758 SAP OSS Note - View does not return all TXW_MAT records

SAP OSS Note 351758 version 0005 contains details of a know issue related to View does not return all TXW_MAT records . This includes any associated symptoms and instructions on how to fix it, see below for full details. Also check out the comments section to view/add related contributions, questions or screen shots, based on real life experience of this oss note and problem.

...For more information about the SAP support system known as OSS please check out the SAP OSS NOTES SECTION, whih includes how to download & implement them onto your SAP system using transaction code SNOTE.

Note 351758 Details:

When does this problem occur

A view includes a join with segment TXW_MAT (Material master). The join

conditions include the fields MATNR (material number) and WERK

S (plant). The view does not return those records where the plant field

is blank.

If an earlier version of this note was implemented, the symptom may be

that dependent material records are linked even if both materia

l and plant are blank.

Cause of the problem and Pre-requisites

DART ignores blank values for performance reasons, because normally

blank values do not have dependent records. However, TXW_MAT-WERKS

 is an exception.

Solution instructions

See the attached source code repair.

For R/3 3.0D - 4.5B, this repair is included in DART 1.07 patch level 2.
If you implemented an earlier version of this note, please check the
revised correction instructions.

Description of problem

Solution instructions

Please import the corrections attached to this OSS note into your SAP system using SNOTE.

You can also view the full details of this OSS note and download it to your SAP system ready for implementation using transaction code SNOTE. Once it has been downloaded you can read the full details, check out any installation instructions including manual changes and see if there are any pre-requisites.

You can also check if a new version of note 351758 has been released as well as see if the note is valid for your current SAP system landscape.

Check if SAP OSS note 351758 has already been downloaded and is valid

To check if this note has already been download, what status it has and if it is valid for your system first execute t-code SNOTE and click on the SAP Note Browser icon
Icon used to execute SAP Note Browser report within SNOTE

From here you can just enter the note number 351758 and press execute. If the note already exists it's details will be displayed. See here for full step by step instructions on how to check if an SAP note has been downloaded and is valid for your system.

If note 351758 does not exist on your system you will receive the message "Unable to find SAP Note that meets specified criteria"
Icon used to execute SAP Note Browser report within SNOTE

If this is the case you will need to download the note to you SAP system also using transaction SNOTE. For further details see Download note using SNOTE. Even if it does exist you may still want to check if you have downloaded the latest version of the note.

Alternatively you can find full details of this note on the SAP service market place(SNumber / Service market place login will be required)