Which table we can get the information about on which date a particular User status has been set in a maintenance order? We get that information in Order Log, but I want to know in which table that information is stored.
Table JEST gives the system /user status associated with an order, but it doesnot give any information about on which date a given status was set. I tried search infomation in table CDHDR/CDPOS but no success.
I found out the related table. Its JCDS.
I believe that’s user status of Equipment, not Maintenance order.
He is correct. JCDS is the change document or version history of JEST which is the primary status table.
Statuses are handled separately from the object in question since each object can have multiple statuses and since statuses can be applicable to more than one object type. That means that the status tables contain statuses for many different objects like equipment, work orders, functional locations, sales orders, etc.
The status tables are based on object numbers which are a concatenation of the object type and the table of that object. Order #816025 would be stored as "OR000000816025". Equipment 20701817 would be stored as "IE000000000020701817". Sales order item 10 of 5215 would be stored as "VB0000005215000010".
Here are some key status tables:
JEST - Object Status
JCDS - Change Documents for Statuses
JSTO - Status Object Information
JCDO - Change Documents for Status Objects
TJ02 - System Statuses
TJ03 - Object Types
TJ04 - Status Control for Object Type
TJ20 - Status Profiles
TJ30 - User Statuses
Just to add in your valuable info on table...
TJ02T - Text for system status
TJ30T - Text for user status.
Many "check" tables (like TJ02 and TJ03) also have text tables as you've mentioned. You can easily find a text table for another table by going to "goto --> Text table" (not to mention that they're usually suffixed with a "T" anyway).
Saturday 7 June 2008
User Status Set Date in Maintenance order
Posted by: aroeltsm
aroeltsm.blogspot.com, Updated at: 1:27 am
Subscribe to:
Post Comments (Atom)
Post Populer
-
Kini hadir FIFORLIF - Solusi Usus Sehat : Sebagai Minuman segar kaya serat berNUTRISI tinggi yang membersihkan saluran cerna dengan cara m...
-
Apakah teh daun JATI CINA itu ? Nama lain Daun Senna (Cassia angustifolia Vahl), yaitu berupa tanaman berbentuk daun, ukuran nya sangat keci...
-
Kupluk pelangi ala mbah surip menjadi trenz masa kini. Mbah surip meninggalkan beberapa yang fenomenal yaitu : "TERTAWA ala HA...HA..HA...
-
Silahkan hubungi kami, kami akan merespon setiap informasi dari anda, silahkan isi form di bawah ini : Nama Telp Email Judul Pesan...
-
Doom-filled warnings arrive from AT&T this week. The company says that without substantial investment in network infrastructure, the Int...
-
Loker & Kumpulan Soal/Informasi CPNS PT. CARGILL INDONESIA Posted: 23 May 2010 09:53 PM PDT Cargill is a...
-
Dengan perkembangan teknologi digital, ada banyak jumlah format video. Kadang-kadang kita ingin menonton video dalam beberapa format tapi ...
-
Berita Lagu Terbaru Berita terbaru untuk lagu | tangga lagu | rilis lagu | Lirik Lagu | Arti Lagu, dll yang diupdate terus dan selalu te...
-
Rp. 60.000 dan SUKSES DI KRSHARE KRShare.Com sengaja dirancang sedemikian rupa sehingga Sangat Handal dan Efektif , namun benar-benar disia...
-
Setahun telah terlewati, banyak perbuatan baik dan buruk kita lakukan. Entah disadari atau tidak oleh diri ini. Tanpa di sadari waktu terus ...
0 komentar:
Post a Comment
Silahkan tinggalkan pesan disini