Skip to content

Instantly share code, notes, and snippets.

@benjnw
Created August 6, 2025 14:29
Show Gist options
  • Select an option

  • Save benjnw/b0d126022699894c071ef43cad349f36 to your computer and use it in GitHub Desktop.

Select an option

Save benjnw/b0d126022699894c071ef43cad349f36 to your computer and use it in GitHub Desktop.
select_inner_for_all_entries
SELECT k~kunnr k~land1 k~name1 k~ort01 k~pstlz k~spras
a~name1
INTO TABLE lt_update_pf
FROM kna1 AS k
INNER JOIN adrc AS a
ON k~adrnr = a~addrnumber
FOR ALL ENTRIES IN gt_kna1_excel_pf
WHERE k~kunnr = gt_kna1_excel_pf-kunnr
AND k~loevm NE 'X'
AND k~ktokd EQ 'Z006'.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment