vehicle availability status doubts

[former_member1241202]

Dear sir,

• Here they are using customized tcode to see the vehicle status(i.e if it is green-vehicle available,if it red-vehicle is breakdown).we could not able to find that in which table they have status information.
• 
• Now customer required management level report to see month wise vehicle available status.
• how to take each day wise vehicle status-please let me know how to process
• I have tried in JCDS table its not showing exactly day wise staus

Regards

Rajasekaran

[jogeswararao_kavala · Accepted solution]

Rajasekaran,

This query is technical centered. As you told this is a Z report, the traffic light status field comes from the logic in the program. This might be coded in a way that the code finds the User status/Sy Status of the Equipment (tables JEST, TJ02T/TJ30T etc) the depending upon that it assigns the green, red traffic light signal to a Zfield of the internal table. If this is the logic, you need to develop a program for management level report using the above tables (also EQUI). So this is an ABAPer's job.

KJogeswaraRao

[jogeswararao_kavala · Accepted solution]

Also as RAKESH mentioned, your ABAPer may need to use CDPOS and CHCDR tables also. In fact the management level report is not a set of individual records. It is a statistical report using COLLECT syntax. So give these inputs to your technical man as Functional specifications.

KJogeswaraRao

[former_member1241202]

Dear all,

Thanks for your suggestions

we have done it,customized status report working fine as per customer requirement

Regards

Rajasekaran

[Former Member]

There are challenges in such sort of Reporting.

Please note if we change the equipment status twice or more on a particular date then which one to consider. You need to make agreement with Customer regarding this.

Then go for development.

Best of luck.

Regards

Santosh

[former_member1241202]

Dear santhosh,

Thanks for your suggestions

Regards

Rajasekaran

[peter_atkin]

Rajasekaran

You need to talk to your ABAP team who will be able to determine how these status icons are generated.

Form there you will then be able to answer some of your questions above.

PeteA

[rakesh_mane]

Hello

Please use the Table CDPOS and CDHDR which will gave you the date and time when status was changed.

Br

Ralesh