topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Fri, 04 Aug 2006 09:56:54 GMT

Hi Friends,

Could u please send me the details

1. Part No. (NDC#) QALS- MATNR CHAR 18 Selected based on the Inspection Lot Number(QALS-PRUEFLOS) in transaction QA32.

‘NDC’ before Part Number

The part number will include dashes.

Example:

0398-0457-08-C1

NDC No. =

‘NDC 0398-0457-08-C1’

Regards

Srinu

Re: Query

naimesh_patel — Fri, 04 Aug 2006 10:07:12 GMT

Hello,

If I understood right,

Concatenate 'NDC' '0398-0457-08-C1' into l_text separted by ' '.

regards,

Naimesh

Re: Query

Former Member — Fri, 04 Aug 2006 10:11:16 GMT

hi friends,

Could u please send me the details how to write to this type of query

. Part No. (NDC#) QALS- MATNR CHAR 18 Selected based on the Inspection Lot Number(QALS-PRUEFLOS) in transaction QA32.

‘NDC’ before Part Number

Regards

srinu

Re: Query

Former Member — Fri, 04 Aug 2006 10:13:18 GMT

hi,

the following sample code would help:

data : partno type qals-matnr,

ndcno(21) type c value 'NDC'.

select matnr from qals into partno where prueflos = 'XXXX'.

if sy-subrc eq 0.

concatentate ndcno partno into ndcno.

endif.

Hope this helps you, reward if helpful.

Re: Query

Former Member — Fri, 04 Aug 2006 10:16:53 GMT

hi friends,

Could u please send me the details

Select the Characteristic Value (AUSP-ATWRT), where the Internal characteristic(AUSP-ATINN) equals ‘AVE_TABLET_WEIGHT’, the Class type (AUSP-KLART) equals ‘023’, and the Object(AUSP-OBJEK) = the material number’s Finished product material number(MARA-MATNR).

To find this, remove the last 3 digits from the material number.

Ex.

0378-0457-01-C1

0378-0457-01

Regards

Re: Query

Former Member — Fri, 04 Aug 2006 10:26:13 GMT

hi friends,

Could u please send me the details how can we write the query

To find this, remove the last 3 digits from the material number.

Ex.

0378-0457-01-C1

0378-0457-01

Regards

Laxmi

Re: Query

Former Member — Fri, 04 Aug 2006 12:26:57 GMT

l_matnr = mara-matnr. "removing the last three chars

condense l_matnr.

l_len = strlen(l_matnr).

l_flen = l_len - 3.

write l_matnr+0(l_flen) to f_matnr.

SELECT ATWRT INTO ITFIN-STRENGTH FROM AUSP

WHERE AUSP-ATINN = ‘AVE_TABLET_WEIGHT' and

KLART = ‘023’ and OBJEK = f_MATNR.

Regards

Anurag