benjnw/renaming_inner_join.abap

## renaming_inner_join.abap
BEGIN OF ty_template.
        INCLUDE STRUCTURE lfa1 AS lfa1 RENAMING WITH SUFFIX _lf.
        INCLUDE STRUCTURE lfb1 AS lfb1 RENAMING WITH SUFFIX _lb.
TYPES:
END OF ty_template.


SELECT *
  FROM lfa1 AS lf
  INNER JOIN lfb1 AS lb
     ON lb~lifnr = lf~lifnr
  INTO TABLE gt_template
  WHERE lf~lifnr EQ p_lifnr
    AND lb~bukrs EQ p_bukrs.
	BEGIN OF ty_template.
	INCLUDE STRUCTURE lfa1 AS lfa1 RENAMING WITH SUFFIX _lf.
	INCLUDE STRUCTURE lfb1 AS lfb1 RENAMING WITH SUFFIX _lb.
	TYPES:
	END OF ty_template.


	SELECT *
	FROM lfa1 AS lf
	INNER JOIN lfb1 AS lb
	ON lb~lifnr = lf~lifnr
	INTO TABLE gt_template
	WHERE lf~lifnr EQ p_lifnr
	AND lb~bukrs EQ p_bukrs.
No results found