on 12-24-2008 8:23 AM
Hi Experts,
I have created a ABAP QUERY.
I have connected three TABLES --> QALS,QAMR and QAVE.
Scenario 1: Result Recording Done and UD done.--> QUERY WORKING FINE.
It is working fine, when the data is available in all the three tables.
Scenario 2 : Result Recording Not Done, But UD done.QUERY NOT WORKING --> NO OUTPUT.
When Result Recording is not done --> No value is availble in QAMR,
but UD done --> Value is available in QAVE, The query is not working.
Scenario 3 : Result Recording Done, But UD NOT DONE.QUERY NOT WORKING --> NO OUTPUT.
Result recording Done --> VALUE IS AVAILBLE IN QAMR,
UD has not done --> VALUE IS NOT AVAILABLE IN QAVE.
If we run the query for the specific Inspection Lot, out put is not displayed.
System gives the information as "NO DATA AVAILABLE".
The client requirement --> As UD is done,the query output must contain the UD detail.
RR detail must be empty.
The output lay out is given below.
1 Column.--> S.No
2 Column. --> Material
3 Column --> Inspection Lot No.
4 Column --> Created Date
5 Column --> Inspectaion Type
Above columns --> 1 to 5 --> Belong to QALS Table.
6 Column --> Result recorded by
7 Column --> Original Value
8 Column --> Date on which Result Recorded
Above columns --> 6 to 8 --> Belong to QAMR Table.
9 Column --> Code
10 Column --> Code Date
11 Column --> UD Made By
12 Column --> Code Valuation
Above columns --> 9 to 12 --> Belong to QAVE Table.
==========================================================================
Scenario 1: Result Recording Done and UD done.--> QUERY WORKING FINE.
Scenario 2 : Result Recording Not Done, But UD done.QUERY NOT WORKING --> NO OUTPUT.
Scenario 3 : Result Recording Done, But UD NOT DONE.QUERY NOT WORKING --> NO OUTPUT.
==========================================================================
Client requirement
If Result Recording is not done, but UD done --> Query Output is required.
If RR done, but UD is due --> Query Output is required.
CLIENT WANTS THAT THE QUERY HAS TO WORK IN ALL THE THREE SCENARIOS.
PLEASE ADVICE.
With Best Records,
Raghu Sharma.
Edited by: RAGHU SHARMA on Dec 24, 2008 9:25 AM
Dear Gajesh,
I agree with you.
This is a development work.
We have developed the prog. and it is working fine.
Hence I am closing the issue.
With Best Regards,
Raghu sharma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Raghu,
This a pure ABAP issue.QALS is the only table which will have the initial value. If you dont do result recording QAMR table will be blank, it will not get updated for the lot number if you dont do result recording. Same is the same of Usage decision. If you dont do Usage decision QAVE table will be blank. The problem might be with field being blank returning nothing and giving the errors. Please ask the abaper to pass the inspection lot number in all the tables seperately and return if value is available.
If you join the 3 tables it wont work.
Regards
Gajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Gajesh,
Please accept my thanks for your Spontaneous reply.
Selection Screen data is given below.
1 --> Material Number
2 --> Inspection Lot Number
3 --> Date of Lot Creation
4--> Inspection Type
Normally the clint will give the Inspection Type ie 4th input and Date of Lot creation ie 3rd Input (Range of Date).
Please do the needful.
With Best Regards,
Raghu Sharma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
What is the input you are giving for the report
Regards
Gajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.