OBJECTID AS OBJECTID_KEY
SQL SELECT * FROM CDHDR
INNER JOIN (CDHDR)
MANDT&PLNTY&PLNNR AS OBJECTID_KEY
SQL SELECT * FROM CDPOS
not sure about the SQL scripting but the above script should work as per your requirement.
Since CDPOS is huge data table I would suggest to restrict the data set using where clause.