topic Help with SQL query in Application Development and Automation Discussions

Help with SQL query

former_member1142222 — Thu, 16 Mar 2023 20:27:37 GMT

Hi,

I am quite new in this query stuff from SAP and I wanted to ask for help regarding the following error, when I try to execute I get this:

1) Incorrect table name or table alias name "LIKP". "LIKP". table alias name "LIKP". table alias name "LIKP". table alias name

and

2) "LIKP". table alias name "LIKP". table "".

The query is this:

select distinct

LIPS~VBELN AS DELIVERY_NOTE_NUMBER,

LIPS~VGBEL AS ORDER_NUMBER,

LIKP~BOLNR AS TRACKING_NUMBER,

VBKD~BSTKD AS PURCHASE_ORDER_NUMBER,

VBAK~AUART,

VBAK~VSBED,

VBAK~ERDAT AS ERDAT_ORDER,

VBAK~ERZET AS ERZET_ORDER,

LIPS~WERKS,

T001W~KUNNR,

T001W~NAME1 AS FROM_NAME,

T001W~STRAS AS FROM_STREET,

T001W~PSTLZ AS FROM_ZIP_CODE,

T001W~ORT01 AS FROM_CITY,

T001W~LAND1 AS FROM_COUNTRY

from LIPS

join VBAK on LIPS~VGBEL = VBAK~VBELN and LIPS~VTWEG = VBAK~VTWEG and LIPS~SPART = VBAK~SPART

join VBAP on VBAK~VBELN = VBAP~VBELN and LIPS~VGPOS = VBAP~POSNR

join VBKD on VBKD~VBELN = VBAK~VBELN

join T001W on LIPS~WERKS = T001W~WERKS

where VBAK~AUART in ('ZV90','ZV9H','ZV9F')

and VBAK~VSBED = 'L4'

and VBAK~ERDAT >= '20220901'

and LIPS~WERKS not in ('0201','0202')

Thanks in advance

Re: Help with SQL query

AlexGourdet — Thu, 16 Mar 2023 20:27:47 GMT

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Profile https://developers.sap.com/tutorials/community-profile.html
Tips for Questions: https://community.sap.com/resources/questions-and-answers
Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

Re: Help with SQL query

andreas_baldauf — Fri, 17 Mar 2023 16:01:17 GMT

Hello,

Your question is tagged with "SAP IQ". I assume that you are not using SAP IQ, but SAP HANA database.
If you want to execute the statement in the SQL Editor (transaction DBACOCKPIT, DB02 or ST04), you should replace all "~" with ".". If it is not working you should provide more information and screenshots.

Example:
select distinct LIPS~VBELN AS DELIVERY_NOTE_NUMBER from LIPS
select distinct LIPS.VBELN AS DELIVERY_NOTE_NUMBER from LIPS

Best regards,
Andreas

Re: Help with SQL query

chaouki_akir — Mon, 20 Mar 2023 12:40:59 GMT

Table LIKP is missing in FROM clause.

So, you can

add JOIN LIKP in the FROM clause
or
you can remove in the SELECT clause the line refering to table LIKP "LIKP~BOLNR AS TRACKING_NUMBER"

Re: Help with SQL query

RaymondGiuseppi — Mon, 20 Mar 2023 12:46:42 GMT

With a proper label like ABAP Development, you would have gotten an answer faster.