Purchase Order SAP abap statement

[former_member229716]

Hi ABAP Expert,

Need your help to solve my issue;

If i what to get the detail on the PO number , i can get from table EKPO

get EKPO-EBELN from EKPO

how do i use sap statement to get the detail below

1. PO with GR and Invoice

2. PO with GR without Invoice

3. PO without GR and Invoice

[gopi_narendra]

You can get these from the table EKBE with the field BEWTP

Check the table EKBE.

1. PO with GR and Invoice

2. PO with GR without Invoice

3. PO without GR and Invoice

Regards

Gopi

[former_member229716]

How do i use the SAP Sql statement to grap the data