dictionary

[Former Member]

what is diffrence between select single and select single * ?

[Former Member]

Vijay,

[Please|;

[Search|;

[In SDN|;

[Former Member]

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]

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]

Vijay,

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

behind please search in SDN?

Amit.