hi
i am encountering error like the values not getting populated in internal table though values are in dbtable...so if u can help me out in the join query it will be of gr8 help
SELECT a1~guid a1~posting_date a1~process_type b1~sales_org b1~division b1~dis_channel INTO CORRESPONDING FIELDS OF TABLE it_ordel FROM ( ( crmd_orderadm_h AS a1 INNER JOIN crmd_link AS c1 ON a1~guid = c1~guid_hi ) INNER JOIN crmd_orgman AS b1 ON c1~guid_hi = b1~guid ) WHERE c1~objtype_hi = '05' AND c1~objtype_set = '21'. AND a1~process_type IN so_prst AND a1~posting_date IN so_podt AND b1~division IN so_div.
thnx
SELECT a1~guid a1~posting_date a1~process_type b1~sales_org b1~division b1~dis_channel INTO CORRESPONDING FIELDS OF TABLE it_ordel FROM ( ( crmd_orderadm_h AS a1 INNER JOIN crmd_link AS c1 ON a1~guid = c1~guid_hi ) INNER JOIN crmd_orgman AS b1 ON c1~guid_hi = b1~guid ) WHERE c1~objtype_hi = '05' AND c1~objtype_set = '21'. AND a1~process_type IN so_prst AND a1~posting_date IN so_podt AND b1~division IN so_div.
SELECT a1~guid a1~posting_date a1~process_type b1~sales_org b1~division b1~dis_channel INTO CORRESPONDING FIELDS OF TABLE it_ordel FROM ( ( crmd_orderadm_h AS a1 INNER JOIN crmd_link AS c1 ON a1~guid = c1~guid_hi ) INNER JOIN crmd_orgman AS b1 ON c1~guid_hi = b1~guid ) WHERE c1~objtype_hi = '05' AND c1~objtype_set = '21' ". delete that period its wrong AND a1~process_type IN so_prst AND a1~posting_date IN so_podt AND b1~division IN so_div.
Add a comment