Skip to Content
avatar image
Former Member

best way to join CDHDR and CDPOS

Howdy,

I neeed to get some change documents for a customer and so I was thinking of joining CDHDR and CDPOS.

Don't suppose anyone could tell me the bset way to join CDHDR and CDPOS?

would this be okay (dunno which was round to put CDHDR and CDPOS ):

SELECT *

INTO TABLE itab_change

FROM cdhdr INNER JOIN CDPOS

ON cdhdrobjectid = cdposobjectid

WHERE

objectclas = 'DEBI'

objectid = p_kunnr.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 18, 2005 at 05:42 PM

    <i>Look for FM's CHANGEDOCUMENT or something similar. There is no need to do a select query.</i>

    Also refer the help:

    http://help.sap.com/saphelp_47x200/helpdata/en/2a/fa01d0493111d182b70000e829fbfe/frameset.htm

    The FM is <b>CHANGEDOCUMENT_READ</b>

    Regards,

    Subramanian V.

    Message was edited by: Subramanian Venkateswaran

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2005 at 07:07 PM

    Hi Steve,

    CDPOS is a cluster-table -> no join!

    But logically complete key of CDHDR has to be equal in CDPOS.

    From performance point of view, own database selection can be faster - otherwise FM will be easier.

    Regards,

    Christian

    Add comment
    10|10000 characters needed characters exceeded