SAP ABAP Programming for all ENTRIES in use Guide concatenate a table with an inner table

Source: Internet
Author: User

In ABAP development, for a clustered table that cannot use joins or for an inner table that needs to use Select, we generally use the for all entries in statement to concatenate the table with the inner table . query out the required data, such as

TYPES :  BEGIN of T_asnum,
Asnum like Asmd-asnum,
END of T_asnum.
DATA :gt_asnum TYPE TABLE of T_asnum.

CLEAR: G_matkl,Gt_asnum.
SELECT SingleMatkl fromZmm_ys_jsdlx intoG_matklWHEREJsdlx= G_jsdlx1.
SELECTAsnum fromAsmd intoTABLEGt_asnumWHEREMatkl= G_matkl.

SELECT *
fromZmm_ys_yw
intoTABLEGt_order
for AllENTRIESinchGt_asnum
WHEREAsnum= Gt_asnum-Asnum.

so the query condition is The value of the Asnum field exists in the Asnum field value of the inner table Gt_asnum

SAP ABAP Programming for all ENTRIES in use Guide concatenate a table with an inner table

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.