topic Re: dictionary in Application Development and Automation Discussions

dictionary

Former Member — Wed, 30 Jul 2008 17:12:24 GMT

what is diffrence between select single and select single * ?

Former Member — Wed, 30 Jul 2008 17:15:41 GMT

Vijay,

[Please|;

[Search|;

[In SDN|;

Former Member — Wed, 30 Jul 2008 17:16:39 GMT

SELECT SINGLE field1 field2 FROM MARA WHERE MATNR = v_matnr.

will bring only field1 and field2

SELECT SINGLE * FROM MARA WHERE MATNR = v_matnr.

will bring all the fields

former_member190578 — Wed, 30 Jul 2008 17:21:56 GMT

select single * : all field will selected from the table into a structure or table

select single ???: you have to decide what field do you want, and in what field or structure or table the contents will fill.

example:

ST_MARA type MARA. " only a structure like DDIC-table MARA

select single * from MARA where MATNR eq P_MATNR into ST_MARA.

All data/fields for this material are move into the structure ST_MARA.

select single werks from MARA where MATNR eq P_MATNR into ST_MARA_WERKS.

ONLY the data for the field WERKS is selected into the field WERKS from the structure ST_MARA

For more than one field:

select single WERKS MTART from MARA where MATNR eq P_MATNR into corresponding fields of ST_MARA.... (or into (ST_MARA-WERS, ST_MARA_MTART)....

Former Member — Wed, 30 Jul 2008 17:45:06 GMT

Vijay,

Have you you look at link which i gave you Above?

behind please search in SDN?

Amit.