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

[Former Member]

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

[Former Member]

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

[former_member186399]

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

[Former Member]

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

[former_member186399]

Hello

What is the input you are giving for the report

Regards

Gajesh