Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formatted Search

Dear All

I have created 2 UDT table in Sales Order Screen called MAWB (Master Airway Bill) which contains MAWB Number, FlightNo, AccountCode3, Account Name and HAWB (House Airway Bill) Which is Linked with the Master Airway Bill.

I have the following FMS to search for Master Airway Bill

select * from MAWB.

I have 2nd FMS which picks House Airway Bill

SELECT HAWB from HAWB where MAWB = $[$U_MASTER.0.0]

I have 3rd FMS which picks Flight No.

SELECT flightno from HAWB WHERE MAWB = $[$U_MASTER.0.0]

All the Above FMS are displaying the Correct Values.

In the Sales Order Main Window I need to Display AccountCode3 from MAWB Table in the Customer Code.

I have the Following FMS

SELECT account3 from HAWB WHERE MAWB = $[$U_MASTER.0.0]

When I execute the above FMS I get error message

Internal Error (3006) occurred [Message 131-183]

Kind Regards

Raju Parmar

replied

Hi,

If you got answer,please close this thread by marking correct answer.

Thanks.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question