topic SAP ABAP QUERY in Application Development and Automation Discussions

SAP ABAP QUERY

Former Member — Wed, 27 Nov 2019 10:32:20 GMT

HI Gurus,

Pls share code for this

Write a select query list all Manager Id & Manager names who have at least One ‘MALE’ employee and one ‘FEMALE’ employee reporting to them.\

NOTE its has to be acheived through query no by using read,collect, delete .. etc.

There are 2 tables

ZGGL_MANAGER (Manager table)

PRIMARYKEY MANAGER_ID MANAGER_NAME

Table: ZGGL_EMPLOYEE

MANAGER_ID EMPLOYEE_ID GENDER_ID EMPLOYEE_NAME

Re: SAP ABAP QUERY

former_member555471 — Sun, 10 Oct 2021 18:08:42 GMT

Hi did you get answer of this question?

Re: SAP ABAP QUERY

ThorstenHoefer — Tue, 19 Oct 2021 15:25:50 GMT

Hi rahul.singh311,

try this:

select m~manager_id
    , m~manager_name
from ZGGL_MANAGER as m
where exists ( select 1   " or @abap_true ?
                 from ZGGL_EMPLOYEE as e1
                  where e1~manager_id = m~manager_id
                    and e1~gender = 'M' )
and exists ( select 1  " or @abap_true ?
                 from ZGGL_EMPLOYEE as e2
                  where e2~manager_id = m~manager_id
                    and e2~gender = 'F' )