Offset length for a field in AMDP select query?

[winona86]

Hi I am trying to join the vbap and cdpos table for the vbeln and posnr.I am able to compare the vbeln with the object iD , however for the posnr, I am unable to compare with objectkey . Code attached below.

[shashankmistry3175]

Try - substr(d.posnr,6,13)

[winona86]

shashankmistry3175 thanks so much!

[SatheeshKumarNendrambaka]

Please try similar below query ( select tkonn_ex, tkonn, tposn, erdat from :lt_gr_aif as gr_aif inner join wbgt on gr_aif.cr_po_nbr = wbgt.tkonn_ex and CAST( SUBSTRING( wbgt.posnr, 2, 5 ) AS "$ABAP.type( ebelp )" ) = gr_aif.tc_po_itm and wbgt.vbeln = gr_aif.tc_po_nbr and wbgt.doc_type = 'C' )

[MKreitlein · Accepted solution]

Hello @winona86 

I'm not sure if you are able to do an offset comparison in a SELECT statement at all (or maybe only in the WHERE clause it would not work)?!

Based on the idea of @shashankmistry3175 ... I would include the prepared field in the upper SELECT statement already - if this works? Then you have the correct length in your lower INNER JOIN:

(might be the syntax is slightly different - I did not test it - but you know what I mean)

BR, Martin

[winona86 · Accepted solution]

Martin, Perfect, worked as expected!

[shashikanthM]

It worked , awesome