TABLES: afpo,
                mkal,
                plpo,
                crhd,
                crtx.
        SELECT SINGLE * FROM afpo
          WHERE aufnr = t_afru-aufnr
            AND matnr = c_gorm_mat.
        SELECT SINGLE * FROM mkal
          WHERE verid = afpo-verid
            AND matnr = afpo-matnr
            AND werks = t_afru-werks.
        SELECT SINGLE * FROM plpo
          WHERE plnnr = mkal-plnnr
            AND zaehl = mkal-alnal
            AND werks = mkal-werks
            AND vornr = '0010'
            AND plnty = '2'.
        SELECT SINGLE * FROM crhd
          WHERE objid = plpo-arbid.
        SELECT SINGLE * FROM crtx
          WHERE objid = plpo-arbid.

        item_tab-arbpl = crhd-arbpl.
        item_tab-ktext = crtx-ktext.

        SELECT SINGLE crhd~arbpl crtx~ktext
          INTO (item_tab-arbpl, item_tab-ktext)
          FROM afpo
          JOIN mkal ON mkal~verid = afpo~verid
                   AND mkal~matnr = afpo~matnr
          JOIN plpo ON plpo~plnnr = mkal~plnnr
                   AND plpo~zaehl = mkal~alnal
                   AND plpo~werks = mkal~werks
          JOIN crhd ON crhd~objid = plpo~arbid
          JOIN crtx ON crtx~objid = plpo~arbid
          WHERE afpo~aufnr = t_afru-aufnr
            AND afpo~matnr = c_gorm_mat
            AND mkal~werks = t_afru-werks
            AND plpo~vornr = '0010'
            AND plpo~plnty = '2'.

LEFT JOIN crhd ON crhd~objid = plpo~arbid
LEFT JOIN crtx ON crtx~objid = plpo~arbid