ABAP QUERY IS NOT WORKING WHEN VALUE IS NOT AVAILABLE IN ONE TABLE .

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