Query

[Former Member]

Hi SDN,

I got little bit query with the ABAP query object. I have generated some fields in the output by using abap query from LIPS and LIKP. I created one new field by using EXTRAS which refer to LIKP-LFIMG.

Now my query is while displaying the output for that new field another field SALUES UNIT is also generated. I didn’t mention any where either in SQ01 or SQ02. Please can I your valuable suggestion why that field is getting generated and reason? Let me know for further details if u want.

Your help will be greatly appreciated.

Regards,

Ravi.

[VXLozano]

Maybe you are getting a QUANtity field, which unit related field is that SALES UNIT you are getting.

I'm not much sure about it, but it looks logical. SAP tends to make you get a unit field for each quantity one...

[Former Member]

Hi Lozano,

Thnaks for the immediate response. So it seems that value SALES UNIT is populated automatically with the value??

Regards,

ravi

[VXLozano]

I think so. Your LIKP AND LIPS tables had not accepted quantity values without assigned units. If my theory is correct, you'll getting the appropiate unit of the corresponding quantity field (if you are getting an "unwanted" SALES UNIT, you had to get somewhere a SALES QUANTITY field).

[Former Member]

Hi Lozano,

Thnaks for the immediate response. I am getting value EA (EACH) under the SALES UNIT field automatically.

Regards,

Ravi.....

[VXLozano]

The field LFIMG is located in the LIPS table, not the LIKP. It's (as has been said) a quantity field, and has a unit field associated (LIPS-VRKME: Sales unit).

When you create your query getting your field, the system gets automatically the appropiate UNIT field, in your case, using a LFIMG-related field, the LIPS-VRKME one.

The value of the corresponding row for your field is EA, and it's the value you are finding in your retrieved query.

I will not think about it as a problem, but as a nice thing the system did for you, because sooner or later, the user will ask you "which units are we talking about here?" or something less nice

Good luck,

Vic

[Former Member]

Hi Lozano,

Very Thanks for the immediate response and your valuable suggestions. I got cleared because of your valuable suggestion. My query was cleared. Finally can I have final suggestion from you. That field is automatically generated by system, so I believe it is not possible to restrict in the output because user didn’t want that field in the output. Looking forward your kind cooperation and your help is greatly appreciated.

Regards,

Ravi……