We are seeing that on check tables such as T005 (Countries) the MANDT is being added as part of the key with LAND1. This then drives the autogen process to require a RuleXRef.
These are not real multi key check tables.
Is there a generic way to remove this from MAP?
The OnLine Help for Collect Target Sources Page, Vertical View, Sap Settings contains this info about Remove Client From Key: If enabled, builds primary keys without the client field (usually MANDT). This feature can only be used if only 1 client is downloaded (i.e., All Clients is disabled). Used for RFC and SAP Text data downloads. Default value is Disabled.
The generic way to remove MANDT from being added as part of the key is to check the Remove Client from Key box for the Target Source.
System Types will be enhanced in DSP 6.6.2 to include a checkbox to exclude the client field on import. This will easily remove MANDT from the entire mapping process.
Hello Tim,
In addition to my colleague answers;
In your scenario, you would need to manually change the Lookup table configuration to avoid the RuleXref.
You likely already know, but let me describe the two steps you have to follow in case someone else need it.
1. Design > Configuration > Lookup Table Setup > look for T005
Here, I guess you have Value table Column 1 = MANDT and Value Table Column 2 = LAND1. If so, you have to remove MANDT from Value table Column 1 and replace it for LAND1 (you also have to remove LAND1 from Value table Column 2).
2. To keep consistent the design, you will need to apply this change also to your system type,
Common > System Types > Tables > Look for T005 and make the same change. This action is slightly different depending on your DSP version, I am only have the latest so I cannot check, but as far I remember, prior to 6.6 you would need to change all the table that contain T005, after 6.6, you only have to change T005 and it would be updated in all tables.
Keep both synced is important because otherwise, when you import a table, if the lookup table configuration does not match, it is not inherited into the Target Design.
Please let us know if we have answered your quesiton
Regards
Please sign in to leave a comment.
Comments
3 comments