New Table-Selection in S/4 HANA versus old ECC Table-Selections in FI/CO

[antonio_cianciarulo3]

Hello everyone

what would be the new statements/table-selections for these old examples in S/4 HANA?

SELECT * FROM cosp
INTO TABLE t_cosp
FOR ALL ENTRIES IN pt_kstar
WHERE lednr = '00'
AND objnr = pv_objnr
AND wrttp = '01'
AND versn = ps_evvs-versn_co
AND kstar = pt_kstar-table_line .

or

SELECT * FROM coss
INTO TABLE t_coss
FOR ALL ENTRIES IN pt_kstar
WHERE lednr = '00'
AND objnr = pv_objnr
AND wrttp = '01'
AND versn = ps_evvs-versn_co
AND kstar = pt_kstar-table_line.

I'm interested in your answers.

Best regards

Toni

[antonio_cianciarulo3 · Accepted solution]

Thanks Raymond!

[Former Member]

Sorry, info regarding SELECT * is in note 2185026...

[Former Member]

Hi, in addition to Raymond I recommend to read info about programming in HANA, because statement "SELECT * FROM" is not very good for HANA

[raymond_giuseppi]

First you should Search and carefully Read notes like 2185026 - Compatibility views COSP, COSS, COEP, COVP: How do you optimize their use?

Regards,
Raymond