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

Reading table using ABAP

21 Views

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

FROM /BIC/AZCF_O100

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'.