Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 09, 2017 at 07:30 AM

    Thanks Raymond!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2017 at 02:55 PM

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

    Regards,
    Raymond

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2017 at 07:58 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2017 at 08:00 AM

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

    Add comment
    10|10000 characters needed characters exceeded