topic Re: Network order status in Application Development and Automation Discussions

Network order status

Former Member — Wed, 22 Mar 2006 12:31:27 GMT

Hi,

Using CN22 transaction, I am setting a network order to closed status.How do I check programmatically the same thing. That is if I have a

network order no. how do I know if it is closed or not. In which table this entry is maintained. I have checked in table AUFK, there is one field name 'PHAS3' closed. But when I change the network order to closed,

those changes are not getting reflecting in this field entry.

Thanks & Regards,

Vishnu Priya.

Re: Network order status

Former Member — Wed, 22 Mar 2006 12:49:08 GMT

All the objects related to status management are stored in table JEST. U can query the JEST to get all the user and system status of network order.

Get OBJNR from AUFK for a given network and pass it to JEST and u will get all the user and system status.

But these values will be internal format, so inorder to find out the internal value of status 'CLOSED'. check out the entries of JEST for a network which is not closed, later set the close status and find out the entry which has been added.

Re: Network order status

Former Member — Wed, 22 Mar 2006 12:51:48 GMT

Hello,

you could use the function modules beginning with 'STATUS', e.g. 'STATUS_CHECK'. Key to them is the OBJNR, you'll find in AUFK.

The values of system status are defined in Table TJ02/TJ02T. The values to the entities ( e.g. network orders) are in Table JEST.

Regards Wolfgang

Re: Network order status

Former Member — Wed, 22 Mar 2006 12:59:43 GMT

Hi,

Use function module BAPI_BUS2002_GET_STATUS for network order status (Both System & User Status)

From the Following tables using join we can check system-status for network order

PROJ,PRPS,AFVC,JEST and TJ02T by using following join

PRPS-PSPHI = PRoj-PSPNR and AFVC-PROJN = PRPS-PSPNR and JEST-OBJNR = AFVC-objnr and AFVC-INACT = SPACE

Same join you can use for User status Instead of tables JEST , TJ02T use JSTO abd TJ30T.

Better to use function i mentioned.

if you find this useful , Please reward me points.

Thanks

Ramesh B