topic Re: Table Maintenance Generator - View JOIN in Application Development and Automation Discussions

Table Maintenance Generator - View JOIN

glauco — Tue, 01 Mar 2016 11:47:02 GMT

Hi buddies.

I need to make a correlation table between entities (rows) of same table T001W but I need to put text field together.

I tryied to create a join in a view but SAP let me create only ONE join, not 2 joins which I need.

e.g.

==> new ZTABLE of correlations of T001w

MANDT

WERKS_from (foreing key to T001W 1:N)

WERKS_to (foreing key to T001W 1:N)

This:

==>New View, so I can make correlations and put descriptions together

MANDT

WERKS_from (foreing key to T001W)

WERKS_to (foreing key to T001W)

NAME_WERKS_from

NAME_WERKS_to

How can I make the JOIN here in this VIEW ?

Remember WERKS_from and WERKS_to come from the same table T001W, and I save these in ZTABLE.

Re: Table Maintenance Generator - View JOIN

jemil_victoria — Tue, 01 Mar 2016 12:05:58 GMT

Dear Glauco,

why do you need to connect Join 2 times to the same table and its definetly possible to make two Joins to the table T001w .

Regards,

Jemil

Re: Table Maintenance Generator - View JOIN

glauco — Tue, 01 Mar 2016 12:25:02 GMT

Answers bellow:

"why do you need to connect Join 2 times to the same table"

>> I need creating a custom business process configuration Ztable, like "from to" transportation process. So "from" werks is in the same table (T001W) of "to" werks (T001W) but, of course, in different rows.

Content example:

---------------------------------------------

| WERKS_FROM | WERKS TO |

---------------------------------------------

0001	0002
0003	0005
0004	0006

Re: Table Maintenance Generator - View JOIN

jemil_victoria — Wed, 02 Mar 2016 07:13:23 GMT

Dear Glauco,

Please tell me whats your aim :

e.g) table has information like this:

T001W
001
002
003

should the result be as below:

Re: Table Maintenance Generator - View JOIN

glauco — Wed, 02 Mar 2016 10:45:13 GMT

Yes. Thank you very much.

But I need more fields as informations about each center like bellow:

center_from

NAME1 (only show, not modifiable)

NAME2 (only show, not modifiable)

STRAS (only show, not modifiable)

ORT01 (only show, not modifiable)

LAND1 (only show, not modifiable)

REGIO (only show, not modifiable)

ADRNR (only show, not modifiable)

center_to

NAME1_to (only show, not modifiable)

NAME2_to (only show, not modifiable)

STRAS_to (only show, not modifiable)

ORT01_to (only show, not modifiable)

LAND1_to (only show, not modifiable)

REGIO_to (only show, not modifiable)

ADRNR_to (only show, not modifiable)

I see it is not possible because ECC does not let us to put 2 different JOINS to same table.

This guy here got the result, but he was lucky because he could use the TEXT table of MARA in his join, but in my case T001W does not have a TEXT table, because each center have its own name and not needing of translation (so does not have a TEXT table like MARA has MAKT).

http://scn.sap.com/thread/1205836

My solution will be a custom search for informations when user enters each center in SM30. but unfortunatly I must create all these fields listed above in my Zcenters_table (from-to). So "by-by" good practices - of dictionary and having a table with only these 2 (center_from, center_to) fields - because is not possible automaticaly.

Re: Table Maintenance Generator - View JOIN

jemil_victoria — Wed, 02 Mar 2016 11:40:40 GMT

Dear Glauco,

your absolutely right. you must create a custom Extended Table Maintenance Events

as soon as they enter the (From plant/ To Plant) in SM30 the details will be got from the

T001W and the customer master table if you require that's the best solution.

1) table maintenance :

2) select modifications events.