wrong value in pstat

[Former Member]

Hi

I have a problem with the value of mara~pstat, instead of displaying the right value it only displays the character B on that column and here is the sample of code that i used:

DATA: BEGIN OF i_tab OCCURS 0,

..............

..............

pstat LIKE mara-pstat,

...............

..............

DATA: END OF i_tab.

SELECT mara_{matnr marc}werks mara_{mbrsh mara}ernam mara_{aenam mara}mtart

mara_{ersda mara}laeda mara_{vpsta mara}pstat mara_{lvorm marc}lvorm AS lvorm1

mara_{meins mara}matkl mara_{bismt mara}extwg mara_{spart mara}labor mara~mstae

mara_{normt mara}wrkst mara_{ekwsl marc}ekgrp marc_{mmsta marc}kordb mara~mprof

marc_{webaz marc}kzkri marc_{kautb marc}dispr marc_{dispo marc}dismm marc~disls

marc_{mabst marc}minbe marc_{maabc marc}plifz AS tplifz marc_{fhori marc}sobsl AS ssobsl

marc_{mtvfp mara}stoff marc_{prctr marc}eprio marc~sernp

INTO CORRESPONDING FIELDS OF TABLE i_tab

FROM mara JOIN marc ON mara_{matnr EQ marc}matnr

WHERE mara~ernam IN s_ernam

AND mara~ersda IN s_ersda

AND mara~aenam IN s_aenam

AND mara~laeda IN s_laeda

AND mara~matnr IN s_matnr

AND marc~werks IN s_werks

AND mara~mtart IN s_mtart

AND mara~lvorm IN s_lvorm

AND mara~wrkst IN s_wrkst.

[Sandeep_Panghal]

Hi Fred,

Are there any single values specified for the domain PSTAT like Maintenance status (K, E, D, B, L, A).

Rgds,

Sandeep

[Former Member]

Hi Sandeep,

There are no single values for the domain pstat, it is KEDLB or something longer than this.

Regards,

Fred.

[GauthamV]

hi,

PSTAT field gives views for material.

You can use table T133A for its values and descriptions.

[Former Member]

Hi,

My question is answered and thanks for the effort.

Regards,

Fred