PP help

[Former Member]

Hi Friends,

I have material no, plant & operation no(VORNR).

Now I wanted to get the short text for operation (LTXA1). Anybody will please suggest me the how to get it.

[amit_khare]

Get it from table PLPO or AFVC.

Regards,

Amit

Reward all helpful replies.

Check this FM - CEV5_DISPLAY_OPERATION_TEXT

Also, check this piece of caode it may be of some help.

SELECT MAPL~MATNR

MAPL~WERKS

MAPL~PLNNR

MAPL~PLNTY

PLKO~ANDAT

PLKO~PROFIDNETZ

MAKT~MAKTX

INTO TABLE T_MAPL FROM MAPL JOIN PLKO ON MAPL_{PLNNR = PLKO}PLNNR AND

MAPL_{PLNTY = PLKO}PLNTY

JOIN MAKT ON MAPL_{MATNR = MAKT}MATNR

WHERE MAPL~MATNR IN S_MATNR AND

MAPL~WERKS IN S_WERKS AND

• PLKO~ANDAT IN S_STTAG AND

PLKO~PROFIDNETZ = P_PROF AND

MAPL~PLNTY = 'N'.

IF NOT T_MAPL IS INITIAL.

SELECT MAPL~MATNR

PLPO~VORNR

PLPO~LTXA1

PLPO~BMSCH

PLPO~VGW01

PLPO~VGE01

PLPO~LAR01

INTO TABLE T_PLPO

FROM PLPO JOIN MAPL ON PLPO_{PLNNR = MAPL}PLNNR AND

PLPO_{PLNTY = MAPL}PLNTY

FOR ALL ENTRIES IN T_MAPL

WHERE PLPO~PLNNR = T_MAPL-PLNNR AND

PLPO~PLNTY = T_MAPL-PLNTY.

ENDIF.

Message was edited by:

Amit Khare

[Former Member]

Hi Amit,

I know the database table name. I would like to ask How I can get the PLPO-LTXA1 field based on material(MATNR), operation no(VORNR) & plant(WERKS).

In PLPO there is no material field. PLPO having operation no & plant. As per my understanding for a same plant we have N no of material & may be for different material we have same operation no.

Say like we have Plant 100 having material N1, N2, N3.

Now for N1 material having operation no A1, A2, A3.

Similarly for N2 material we have operation no A1, A2, A4, A5.

Similarly for N3 also.

Now I have Plant 100 having material N2. I have operation no A2.

Now I would like to get the short text (PLPO-LTXA1) based on above selection.

Anybody will tell me how to navigate between different database table so that I can get short text for routing (PLPO-LTXA1).

any help will be appriciated.

[Former Member]

Hi,

Hit Where-used-list on VORNR field to know in which are all the tables this field is used. Apart from Master table there will be another table which contains descriptions usually starts with 'T'. From that T table you will get descriptions.

thanks,

sksingh

[Former Member]

Hi,

It is true that same Operation Number can be attached to multiple TaskLists. The concept is on a particular material let us say, a WorkOrder is generated with some Tasks that need to be performed on that material. Each individual Task will have further Operations to be carried out. Hence whatever the criteria is, please follow the method Where-used-list on the dataelement of field VORNR which i described in my previous message, you will get the table which contains descriptions.

thanks,

sksingh

[Former Member]

Hi

Simply use the VIEW

<b>VIAUF_AFVC</b>

You have Material(SERMAT), Plant(WERKS), VORNR(operation) and the required

LTXA1 (operation short text field)

<b>

Reward points if useful</b>

Regards

Anji