Select Query not Wroking

[Former Member]

Hi

I am facing a broblem in select query.

Its simple but dont know whats getting wrong.

The query is as simple as below :

SELECT * FROM zmm_rtm_fields_c INTO TABLE WS_RTM

where zwerks = P_plant and CODDIS = p_matnr.

The Z Table zmm_rtm_fields_c has the plant and material are in char data type and not data elements.

When seen in SE16, it works fine but select query does not work.

Sy-subrc = 4.

Any clue?

[Former Member]

Hi

I am facing a broblem in select query.

Its simple but dont know whats getting wrong.

The query is as simple as below :

SELECT * FROM zmm_rtm_fields_c INTO TABLE WS_RTM

where zwerks = P_plant and CODDIS = p_matnr.

The Z Table zmm_rtm_fields_c has the plant and material are in char data type and not data elements.

When seen in SE16, it works fine but select query does not work.

Sy-subrc = 4.

Any clue?

[Former Member]

Hi

pranu

zmm_rtm_fields_c and WS_RTM might differ better use INTO corresponding fields of it might help

plzz reward if helpful

feel free to ask any quiries my mail id [email protected]

[amit_khare]

are p_plant & p_matnr have same data types as of zwerks & coddis?

Regards,

Amit

[Former Member]

hai,

does the structure of zmm_rtm_fields_c and WS_RTM same.

the query is wright , check the P_plant and p_matnr fetches value in debugging mode .

[kesavadas_thekkillath]

send the declaration part and data types of these fields in table...

[former_member402443]

Hi Pranu,

First check that the structure of internal table and the table from where you passing the data into the internal table should be same.

Because you are using the Query

Select * tablename into internal table.

For this case the structure of the table should be same.

Otherwise use the corresponding fields statement in the select the query. i.e.

select * from tablename into corresponding fields of table itab.

Reward points, if useful.

Regards

Manoj Kumar

[Former Member]

Here is the code below ::

&----

---

*& Report ZMM_RTM

*&

&----

---

*&

*&

&----

---

REPORT ZMM_RTM_TMP1 line-size 255.

TYPE-POOLS: slis.

data flag(3) type c value 1.

*DATA : WS_RTM TYPE STANDARD TABLE OF RTM with header line,

data : CT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV with header line.

DATA: BEGIN OF WS_RTM occurs 0,

mandt TYPE ZMM_RTM_FIELDS_C-mandt,

CODREC TYPE ZMM_RTM_FIELDS_C-CODREC,

CODDIS TYPE ZMM_RTM_FIELDS_C-CODDIS,

WERKS TYPE ZMM_RTM_FIELDS_C-WERKS,

CODFABBDIS TYPE ZMM_RTM_FIELDS_C-CODFABBDIS,

CODTIPMODDISPROG TYPE ZMM_RTM_FIELDS_C-CODTIPMODDISPROG,

NUMSCART TYPE ZMM_RTM_FIELDS_C-NUMSCART,

DAULTMOVDISSTAB TYPE ZMM_RTM_FIELDS_C-DAULTMOVDISSTAB,

CODORDIS TYPE ZMM_RTM_FIELDS_C-CODORDIS,

DENDIS TYPE ZMM_RTM_FIELDS_C-DENDIS,

FORDIS TYPE ZMM_RTM_FIELDS_C-FORDIS,

MATRICOLA_DIS TYPE ZMM_RTM_FIELDS_C-MATRICOLA_DIS,

SIGTIPVEI TYPE ZMM_RTM_FIELDS_C-SIGTIPVEI,

FILLER TYPE ZMM_RTM_FIELDS_C-FILLER,

NUMOMOL TYPE ZMM_RTM_FIELDS_C-NUMOMOL,

CONTROMOL TYPE ZMM_RTM_FIELDS_C-CONTROMOL,

ORD_DI_MOD1 TYPE ZMM_RTM_FIELDS_C-ORD_DI_MOD1,

DASTALETTERACID TYPE ZMM_RTM_FIELDS_C-DASTALETTERACID,

DAEMISSLETCID TYPE ZMM_RTM_FIELDS_C-DAEMISSLETCID,

FLAGDISBAS TYPE ZMM_RTM_FIELDS_C-FLAGDISBAS,

NUMDISVARDAL TYPE ZMM_RTM_FIELDS_C-NUMDISVARDAL,

FILLER1 TYPE ZMM_RTM_FIELDS_C-FILLER1,

CIDDIS_BAS TYPE ZMM_RTM_FIELDS_C-CIDDIS_BAS,

DATSTAMPCID_DISB TYPE ZMM_RTM_FIELDS_C-DATSTAMPCID_DISB,

DATAEMISCID_DB TYPE ZMM_RTM_FIELDS_C-DATAEMISCID_DB,

UNITMIS TYPE ZMM_RTM_FIELDS_C-UNITMIS,

CODENRESMOPART TYPE ZMM_RTM_FIELDS_C-CODENRESMOPART,

NUMPROGMODPART1 TYPE ZMM_RTM_FIELDS_C-NUMPROGMODPART1,

ANNOEMISMODPART TYPE ZMM_RTM_FIELDS_C-ANNOEMISMODPART,

COD_ASPETTO_PRO1 TYPE ZMM_RTM_FIELDS_C-COD_ASPETTO_PRO1,

COD_TIPO_INTERV1 TYPE ZMM_RTM_FIELDS_C-COD_TIPO_INTERV1,

FLAG_VINCOLO_IM1 TYPE ZMM_RTM_FIELDS_C-FLAG_VINCOLO_IM1,

COD_STAB_RESP_P1 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P1,

ADDMODPART1 TYPE ZMM_RTM_FIELDS_C-ADDMODPART1,

IVDTCODSTRUTTDIS TYPE ZMM_RTM_FIELDS_C-IVDTCODSTRUTTDIS,

UNITMISMAT TYPE ZMM_RTM_FIELDS_C-UNITMISMAT,

VALOREPESO TYPE ZMM_RTM_FIELDS_C-VALOREPESO,

FLAGPESPROV TYPE ZMM_RTM_FIELDS_C-FLAGPESPROV,

CLMERCMAT TYPE ZMM_RTM_FIELDS_C-CLMERCMAT,

PROVESTSTABDIS TYPE ZMM_RTM_FIELDS_C-PROVESTSTABDIS,

PROVENDALLA TYPE ZMM_RTM_FIELDS_C-PROVENDALLA,

CODENRESMODPART TYPE ZMM_RTM_FIELDS_C-CODENRESMODPART,

NUMPROGMODPART2 TYPE ZMM_RTM_FIELDS_C-NUMPROGMODPART2,

ANNOEMMODPART TYPE ZMM_RTM_FIELDS_C-ANNOEMMODPART,

COD_ASPETTO_PRO2 TYPE ZMM_RTM_FIELDS_C-COD_ASPETTO_PRO2,

COD_TIPO_INTERV2 TYPE ZMM_RTM_FIELDS_C-COD_TIPO_INTERV2,

FLAG_VINCOLO_IM2 TYPE ZMM_RTM_FIELDS_C-FLAG_VINCOLO_IM2,

COD_STAB_RESP_P2 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P2,

ADDMODPART2 TYPE ZMM_RTM_FIELDS_C-ADDMODPART2,

CODDIS1 TYPE ZMM_RTM_FIELDS_C-CODDIS1,

CODFABBDIS1 TYPE ZMM_RTM_FIELDS_C-CODFABBDIS1,

FLVARORG TYPE ZMM_RTM_FIELDS_C-FLVARORG,

CODDIS2 TYPE ZMM_RTM_FIELDS_C-CODDIS2,

CODFABBDIS2 TYPE ZMM_RTM_FIELDS_C-CODFABBDIS2,

FLVARORG2 TYPE ZMM_RTM_FIELDS_C-FLVARORG2,

CODDISALTERN TYPE ZMM_RTM_FIELDS_C-CODDISALTERN,

CODTIPCOMM TYPE ZMM_RTM_FIELDS_C-CODTIPCOMM,

DATACONSCAMP TYPE ZMM_RTM_FIELDS_C-DATACONSCAMP,

DAPRENTRMODIF TYPE ZMM_RTM_FIELDS_C-DAPRENTRMODIF,

CODCAUSMODIS TYPE ZMM_RTM_FIELDS_C-CODCAUSMODIS,

COD_STAB_RESP_P3 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P3,

MODELLO1 TYPE ZMM_RTM_FIELDS_C-MODELLO1,

QTA_UTIL_GIORNA1 TYPE ZMM_RTM_FIELDS_C-QTA_UTIL_GIORNA1,

NUMAXVETTPRODGG1 TYPE ZMM_RTM_FIELDS_C-NUMAXVETTPRODGG1,

QTADISORDCOMMLI1 TYPE ZMM_RTM_FIELDS_C-QTADISORDCOMMLI1,

DESCR_TIPO_IMPI1 TYPE ZMM_RTM_FIELDS_C-DESCR_TIPO_IMPI1,

CODSTAPILPRESER1 TYPE ZMM_RTM_FIELDS_C-CODSTAPILPRESER1,

DATA_PRESER1 TYPE ZMM_RTM_FIELDS_C-DATA_PRESER1,

CLIENT1 TYPE ZMM_RTM_FIELDS_C-CLIENT1,

COD_STAB_RESP_P4 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P4,

MODELLO2 TYPE ZMM_RTM_FIELDS_C-MODELLO2,

QTA_UTIL_GIORNA2 TYPE ZMM_RTM_FIELDS_C-QTA_UTIL_GIORNA2,

NUMAXVETTPRODGG2 TYPE ZMM_RTM_FIELDS_C-NUMAXVETTPRODGG2,

QTADISORDCOMMLI2 TYPE ZMM_RTM_FIELDS_C-QTADISORDCOMMLI2,

DESCR_TIPO_IMPI2 TYPE ZMM_RTM_FIELDS_C-DESCR_TIPO_IMPI2,

CODSTAPILPRESER2 TYPE ZMM_RTM_FIELDS_C-CODSTAPILPRESER2,

DATA_PRESER2 TYPE ZMM_RTM_FIELDS_C-DATA_PRESER2,

CLIENT2 TYPE ZMM_RTM_FIELDS_C-CLIENT2,

COD_STAB_RESP_P5 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P5,

MODELLO3 TYPE ZMM_RTM_FIELDS_C-MODELLO3,

QTA_UTIL_GIORNA3 TYPE ZMM_RTM_FIELDS_C-QTA_UTIL_GIORNA3,

NUMAXVETTPRODGG3 TYPE ZMM_RTM_FIELDS_C-NUMAXVETTPRODGG3,

QTADISORDCOMMLI3 TYPE ZMM_RTM_FIELDS_C-QTADISORDCOMMLI3,

DESCR_TIPO_IMPI3 TYPE ZMM_RTM_FIELDS_C-DESCR_TIPO_IMPI3,

CODSTAPILPRESER3 TYPE ZMM_RTM_FIELDS_C-CODSTAPILPRESER3,

DATA_PRESER3 TYPE ZMM_RTM_FIELDS_C-DATA_PRESER3,

CLIENT3 TYPE ZMM_RTM_FIELDS_C-CLIENT3,

COD_STAB_RESP_P6 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P6,

MODELLO4 TYPE ZMM_RTM_FIELDS_C-MODELLO4,

QTA_UTIL_GIORNA4 TYPE ZMM_RTM_FIELDS_C-QTA_UTIL_GIORNA4,

NUMAXVETTPRODGG4 TYPE ZMM_RTM_FIELDS_C-NUMAXVETTPRODGG4,

QTADISORDCOMMLI4 TYPE ZMM_RTM_FIELDS_C-QTADISORDCOMMLI4,

DESCR_TIPO_IMPI4 TYPE ZMM_RTM_FIELDS_C-DESCR_TIPO_IMPI4,

CODSTAPILPRESER4 TYPE ZMM_RTM_FIELDS_C-CODSTAPILPRESER4,

DATA_PRESER4 TYPE ZMM_RTM_FIELDS_C-DATA_PRESER4,

CLIENT4 TYPE ZMM_RTM_FIELDS_C-CLIENT4,

COD_STAB_RESP_P7 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P7,

MODELLO5 TYPE ZMM_RTM_FIELDS_C-MODELLO5,

QTA_UTIL_GIORNA5 TYPE ZMM_RTM_FIELDS_C-QTA_UTIL_GIORNA5,

NUMAXVETTPRODGG5 TYPE ZMM_RTM_FIELDS_C-NUMAXVETTPRODGG5,

QTADISORDCOMMLI5 TYPE ZMM_RTM_FIELDS_C-QTADISORDCOMMLI5,

DESCR_TIPO_IMPI5 TYPE ZMM_RTM_FIELDS_C-DESCR_TIPO_IMPI5,

CODSTAPILPRESER5 TYPE ZMM_RTM_FIELDS_C-CODSTAPILPRESER5,

DATA_PRESER5 TYPE ZMM_RTM_FIELDS_C-DATA_PRESER5,

CLIENT5 TYPE ZMM_RTM_FIELDS_C-CLIENT5,

COD_STAB_RESP_P8 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P8,

MODELLO6 TYPE ZMM_RTM_FIELDS_C-MODELLO6,

QTA_UTIL_GIORNA6 TYPE ZMM_RTM_FIELDS_C-QTA_UTIL_GIORNA6,

NUMAXVETTPRODGG6 TYPE ZMM_RTM_FIELDS_C-NUMAXVETTPRODGG6,

QTADISORDCOMMLI6 TYPE ZMM_RTM_FIELDS_C-QTADISORDCOMMLI6,

DESCR_TIPO_IMPI6 TYPE ZMM_RTM_FIELDS_C-DESCR_TIPO_IMPI6,

CODSTAPILPRESER6 TYPE ZMM_RTM_FIELDS_C-CODSTAPILPRESER6,

DATA_PRESER6 TYPE ZMM_RTM_FIELDS_C-DATA_PRESER6,

CLIENT6 TYPE ZMM_RTM_FIELDS_C-CLIENT6,

COD_STAB_RESP_P9 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_P9,

MODELLO7 TYPE ZMM_RTM_FIELDS_C-MODELLO7,

QTA_UTIL_GIORNA7 TYPE ZMM_RTM_FIELDS_C-QTA_UTIL_GIORNA7,

NUMAXVETTPRODGG7 TYPE ZMM_RTM_FIELDS_C-NUMAXVETTPRODGG7,

QTADISORDCOMMLI7 TYPE ZMM_RTM_FIELDS_C-QTADISORDCOMMLI7,

DESCR_TIPO_IMPI7 TYPE ZMM_RTM_FIELDS_C-DESCR_TIPO_IMPI7,

CODSTAPILPRESER7 TYPE ZMM_RTM_FIELDS_C-CODSTAPILPRESER7,

DATA_PRESER7 TYPE ZMM_RTM_FIELDS_C-DATA_PRESER7,

CLIENT7 TYPE ZMM_RTM_FIELDS_C-CLIENT7,

COD_STAB_RESP_10 TYPE ZMM_RTM_FIELDS_C-COD_STAB_RESP_10,

MODELLO8 TYPE ZMM_RTM_FIELDS_C-MODELLO8,

QTA_UTIL_GIORNA8 TYPE ZMM_RTM_FIELDS_C-QTA_UTIL_GIORNA8,

NUMAXVETTPRODGG8 TYPE ZMM_RTM_FIELDS_C-NUMAXVETTPRODGG8,

QTADISORDCOMMLI8 TYPE ZMM_RTM_FIELDS_C-QTADISORDCOMMLI8,

DESCR_TIPO_IMPI8 TYPE ZMM_RTM_FIELDS_C-DESCR_TIPO_IMPI8,

CODSTAPILPRESER8 TYPE ZMM_RTM_FIELDS_C-CODSTAPILPRESER8,

DATA_PRESER8 TYPE ZMM_RTM_FIELDS_C-DATA_PRESER8,

CLIENT8 TYPE ZMM_RTM_FIELDS_C-CLIENT8,

FILLER2 TYPE ZMM_RTM_FIELDS_C-FILLER2,

COMMDIS TYPE ZMM_RTM_FIELDS_C-COMMDIS,

SGOP TYPE ZMM_RTM_FIELDS_C-SGOP,

CLASICURE TYPE ZMM_RTM_FIELDS_C-CLASICURE,

CDCMAGIMPDIS TYPE ZMM_RTM_FIELDS_C-CDCMAGIMPDIS,

CODCEN_COSRIC TYPE ZMM_RTM_FIELDS_C-CODCEN_COSRIC,

CODLAVSUPPLDIS TYPE ZMM_RTM_FIELDS_C-CODLAVSUPPLDIS,

FLAGDIS_AUTOM TYPE ZMM_RTM_FIELDS_C-FLAGDIS_AUTOM,

NASTRO TYPE ZMM_RTM_FIELDS_C-NASTRO,

NASTRO1 TYPE ZMM_RTM_FIELDS_C-NASTRO1,

JIT_RIFORN_PROPO TYPE ZMM_RTM_FIELDS_C-JIT_RIFORN_PROPO,

NUMDISPROG TYPE ZMM_RTM_FIELDS_C-NUMDISPROG,

NUMDISRIFPROG TYPE ZMM_RTM_FIELDS_C-NUMDISRIFPROG,

TAB_FORNITORI_VD TYPE ZMM_RTM_FIELDS_C-TAB_FORNITORI_VD,

CODCON_LAVCNTE TYPE ZMM_RTM_FIELDS_C-CODCON_LAVCNTE,

FLAG_TRAGUARDO_D TYPE ZMM_RTM_FIELDS_C-FLAG_TRAGUARDO_D,

COD_POLO_ACQ TYPE ZMM_RTM_FIELDS_C-COD_POLO_ACQ,

DATA_ELAB TYPE ZMM_RTM_FIELDS_C-DATA_ELAB,

DATA_PEZZO TYPE ZMM_RTM_FIELDS_C-DATA_PEZZO,

CODICE_TAVOLA TYPE ZMM_RTM_FIELDS_C-CODICE_TAVOLA,

COSTO_INIZIALE_P TYPE ZMM_RTM_FIELDS_C-COSTO_INIZIALE_P,

DELTA_COSTO_PEZZ TYPE ZMM_RTM_FIELDS_C-DELTA_COSTO_PEZZ,

INIZIATIVA TYPE ZMM_RTM_FIELDS_C-INIZIATIVA,

FLAG_COLORATO TYPE ZMM_RTM_FIELDS_C-FLAG_COLORATO,

CODICE_MDR TYPE ZMM_RTM_FIELDS_C-CODICE_MDR,

COD_DISPOS TYPE ZMM_RTM_FIELDS_C-COD_DISPOS,

COD_PRECONF TYPE ZMM_RTM_FIELDS_C-COD_PRECONF,

COD_RIV_PAR TYPE ZMM_RTM_FIELDS_C-COD_RIV_PAR,

QTA_DISEGNO_X_CO TYPE ZMM_RTM_FIELDS_C-QTA_DISEGNO_X_CO,

STATO_MDR TYPE ZMM_RTM_FIELDS_C-STATO_MDR,

DATA_MOV_IMB TYPE ZMM_RTM_FIELDS_C-DATA_MOV_IMB,

ESTEN_QUALIF TYPE ZMM_RTM_FIELDS_C-ESTEN_QUALIF,

CLASSE_FUNZIONAL TYPE ZMM_RTM_FIELDS_C-CLASSE_FUNZIONAL,

SEGNO_COSTO_INIZ TYPE ZMM_RTM_FIELDS_C-SEGNO_COSTO_INIZ,

SEGNO_DELTA_COST TYPE ZMM_RTM_FIELDS_C-SEGNO_DELTA_COST,

FILLER3 TYPE ZMM_RTM_FIELDS_C-FILLER3,

ZNEW TYPE ZMM_RTM_FIELDS_C-ZNEW,

ZWERKS TYPE ZMM_RTM_FIELDS_C-ZWERKS,

END OF WS_RTM.

PARAMETERS: P_plant like zmm_rtm_fields_c-ZWERKS,

p_matnr like zmm_rtm_fields_c-CODDIS,

p_CODTIP like zmm_rtm_fields_c-CODTIPMODDISPROG,

p_DAULTM like zmm_rtm_fields_c-DAULTMOVDISSTAB,

p_PROVES like zmm_rtm_fields_c-PROVESTSTABDIS,

p_COD_P1 like zmm_rtm_fields_c-COD_STAB_RESP_P1,

p_COD_P2 like zmm_rtm_fields_c-COD_STAB_RESP_P2,

p_COD_P3 like zmm_rtm_fields_c-COD_STAB_RESP_P3,

p_COD_P4 like zmm_rtm_fields_c-COD_STAB_RESP_P4,

p_new like zmm_rtm_fields_c-ZNEW .

start-of-selection.

SELECT * FROM zmm_rtm_fields_c INTO corresponding fields of TABLE WS_RTM

where zwerks = P_plant.

and CODDIS = p_matnr.

*and CODTIPMODDISPROG = p_CODTIP

*and DAULTMOVDISSTAB = p_DAULTM

*and PROVESTSTABDIS = p_PROVES

*and COD_STAB_RESP_P1 = p_COD_P1

*and COD_STAB_RESP_P2 = p_COD_P2

*and COD_STAB_RESP_P3 = p_COD_P3

*and COD_STAB_RESP_P4 = p_COD_P4

*and ZNEW = p_new.

*

CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'

EXPORTING

I_STRUCTURE_NAME = 'ZMM_RTM_FIELDS_C'

CHANGING

CT_FIELDCAT = CT_FIELDCAT[].

IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

loop at CT_FIELDCAT.

if flag eq 1.

CT_FIELDCAT-SELTEXT_M = 'Clint'.

modify CT_FIELDCAT.

elseif flag eq 2.

CT_FIELDCAT-SELTEXT_M = 'Record Type'.

modify CT_FIELDCAT.

elseif flag eq 3.

CT_FIELDCAT-SELTEXT_M = 'Material Code'.

modify CT_FIELDCAT.

elseif flag eq 26.

CT_FIELDCAT-SELTEXT_M = 'Unit of Measure'.

modify CT_FIELDCAT.

elseif flag eq 169.

CT_FIELDCAT-SELTEXT_M = 'NEW'.

modify CT_FIELDCAT.

elseif flag eq 170.

CT_FIELDCAT-SELTEXT_M = 'RTM Plant'.

modify CT_FIELDCAT.

else.

CT_FIELDCAT-SELTEXT_M = CT_FIELDCAT-FIELDNAME.

modify CT_FIELDCAT.

endif.

flag = flag + 1.

endloop.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

IT_FIELDCAT = CT_FIELDCAT[]

TABLES

T_OUTTAB = WS_RTM

• EXCEPTIONS

• PROGRAM_ERROR = 1

• OTHERS = 2

.

IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

*INCLUDE ZMM_RTM_081_BUILD_FIELD_CATF01.

[kesavadas_thekkillath]

1)check whether any of these fields in table are stored with leading zeros.if so Just try putting leading zeros in the where clause values.

Because its a character type this could be the problem.

try the same in the debugging mode.