Skip to Content
Dec 16, 2006 at 08:09 AM

Reading table using ABAP


dear all,

below is a sql stmt which does a query to an ODS in BW. What i'm trying to archieve is to assign value bbp_po_id to a key field within an ODS. I dont know ABAP and how to return a single value back to BW. Can someone please show guide me?

SELECT bbp_po_id bbp_poitem


INTO TABLE lt_cfsrm_po

WHERE bbp_po_id = COMM_STRUCTURE-bbp_po_id

AND bbp_poitem = COMM_STRUCTURE-bbp_poitem

AND prod_type = '02'.