January 2025

SAP Codejam 2025 in Herne

hello, we would like to organize a SAP Codejam. location: Herne topic: Build AI services using the SAP Cloud Application Programming Model, SAP AI Core and SAP generative AI Hub maximum number of people: 25 people when: from April 2025 we would be happy to host another sap codejam

SAP Codejam 2025 in Herne

hello, we would like to organize a SAP Codejam. location: Herne topic: Build AI services using the SAP Cloud Application Programming Model, SAP AI Core and SAP generative AI Hub maximum number of people: 25 people when: from April 2025 we would be happy to host another sap codejam

SAP Codejam 2025 in Herne

hello, we would like to organize a SAP Codejam. location: Herne topic: Build AI services using the SAP Cloud Application Programming Model, SAP AI Core and SAP generative AI Hub maximum number of people: 25 people when: from April 2025 we would be happy to host another sap codejam

Combine two internal tables based on condition

Hello all,  I want to combine two internal tables, which don’t have a key. I would have used another JOIN but there are conditions that use the same field. Any ideas would be greatly appreciated. Also, the parts which have a ‘*’ don’t work somehow. SELECT vbak~bstnk, vbfa~vbelv, vbap~posnr, vbfa~vbelnFROM vbfa AS vbfaINNER JOIN vbak AS vbakON vbfa~vbelv = vbak~vbelnINNER JOIN vbap AS vbapON vbak~vbeln = vbap~vbelnINNER JOIN likp AS likpON likp~vbeln = vbfa~vbelnINNER JOIN vbkd AS vbkdON vbfa~vbelv = vbkd~vbelnINNER JOIN vbuk AS vbukON vbuk~vbeln = vbfa~vbelvWHERE   vbfa~vbtyp_n = ‘J’ AND*        vbkd~podkz = ‘X’ AND*        vbuk~wbstk = ‘C’ AND        vbak~vkorg IN @s_vkorg AND        vbak~vtweg IN @s_vtweg AND        vbap~vstel IN @s_vstel AND        vbak~kunnr IN @s_kunde AND        vbak~bstnk IN @s_bstnnr AND        vbak~auart IN @s_auart AND        vbap~pstyv IN @s_pos AND        vbak~vbeln IN @s_vbeln AND        vbak~erdat IN @s_audat AND        likp~vbeln IN @s_liefnr AND        likp~erdat IN @s_lidatINTO TABLE @DATA(it_bel). SELECT vbfa~vbelv, vbfa~vbeln  FROM vbrk AS vbrk  INNER JOIN vbfa AS vbfa  ON vbrk~vbeln = vbfa~vbeln  INNER JOIN likp AS likp  ON likp~vbeln = vbfa~vbelv  WHERE vbfa~vbtyp_n = ‘U’ AND        likp~vbeln IN @s_liefnr AND        likp~erdat IN @s_lidatINTO TABLE @DATA(it_pro).  

Combine two internal tables based on condition

Hello all,  I want to combine two internal tables, which don’t have a key. I would have used another JOIN but there are conditions that use the same field. Any ideas would be greatly appreciated. Also, the parts which have a ‘*’ don’t work somehow. SELECT vbak~bstnk, vbfa~vbelv, vbap~posnr, vbfa~vbelnFROM vbfa AS vbfaINNER JOIN vbak AS vbakON vbfa~vbelv = vbak~vbelnINNER JOIN vbap AS vbapON vbak~vbeln = vbap~vbelnINNER JOIN likp AS likpON likp~vbeln = vbfa~vbelnINNER JOIN vbkd AS vbkdON vbfa~vbelv = vbkd~vbelnINNER JOIN vbuk AS vbukON vbuk~vbeln = vbfa~vbelvWHERE   vbfa~vbtyp_n = ‘J’ AND*        vbkd~podkz = ‘X’ AND*        vbuk~wbstk = ‘C’ AND        vbak~vkorg IN @s_vkorg AND        vbak~vtweg IN @s_vtweg AND        vbap~vstel IN @s_vstel AND        vbak~kunnr IN @s_kunde AND        vbak~bstnk IN @s_bstnnr AND        vbak~auart IN @s_auart AND        vbap~pstyv IN @s_pos AND        vbak~vbeln IN @s_vbeln AND        vbak~erdat IN @s_audat AND        likp~vbeln IN @s_liefnr AND        likp~erdat IN @s_lidatINTO TABLE @DATA(it_bel). SELECT vbfa~vbelv, vbfa~vbeln  FROM vbrk AS vbrk  INNER JOIN vbfa AS vbfa  ON vbrk~vbeln = vbfa~vbeln  INNER JOIN likp AS likp  ON likp~vbeln = vbfa~vbelv  WHERE vbfa~vbtyp_n = ‘U’ AND        likp~vbeln IN @s_liefnr AND        likp~erdat IN @s_lidatINTO TABLE @DATA(it_pro).  

Scroll to Top