View Source

<div id="google_translate_element"></div>

<script type="text/javascript">
function googleTranslateElementInit() {
  new google.translate.TranslateElement({pageLanguage: 'en', layout: google.translate.TranslateElement.InlineLayout.SIMPLE}, 'google_translate_element');
}
</script>

<script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>

Problem

How to retrieve information of GBU in WP2

Solution

Using sales order data:

You need to have under hands :

The company code
The sales area
The division of the material

With these informations, you can access to the GBU information which are stored in SAP with a classification link (transaction CL20N)

You need to have access to table zwfat111 which contains the reference with the GBU link. And in the table t25b0 to get the texts

An exemple of code exists to retrieve GBU information (the selection of division is not copiable). FORM get_gbu of program ZWEBI02110.

Another way from Order information (Thanks Jorge)

***    GBU calculation  ***
    loop at  i_vbap assigning <st_vbap>.
      replace all occurences of '|' in <st_vbap>-ARKTX with ' '.
      replace all occurences of '|' in <st_vbap>-KDMAT with ' '.
      read table i_vbak
      with key vbeln = <st_vbap>-vbeln
           assigning <st_vbak>.
      if sy-subrc eq 0.
        clear: zgbu, zclint, zclass, zdcdv, zbukrs.
        zbukrs = <st_vbak>-bukrs_vf.
        ZDCDV(2) = <st_vbak>-vtweg.
        ZDCDV+2(2) = <st_vbap>-spart.
        select single clint from kssk into zclint
         where objek = zdcdv
           and kssk~mafid = 'O'
           and kssk~klart = 'ZS1'.
        if sy-subrc = 0.
          select single class from klah into zclass where clint = zclint.
          if sy-subrc = 0.
            select single mgn_mk from zwfat111 into zgbu
                 where bukrs = zbukrs
                 and   wwe01 = zclass
                 and   datab le sy-datum
                 and   datbi ge sy-datum.
          endif.
        endif.
        <st_vbap>-gbu = zgbu(2).
      endif.
    endloop.
***    GBU calculation  ***

Using only the material and plant:

From the material master data, get the profit center from the table MARC.
From the plant, get the company code from the table T001K.
From the company code, get the controlling area from the table TKA02.
From the profit center and the controlling area, get the latest valid row from the table ZWFAT186. The two-letter code in ZWFAT186-DESCRIPT2 gives the GBU.

GBU two-letter codes

GBU code	GBU	Group
SD	Soda Ash	ECo
PE	Peroxides	ECo
SI	Silica	ECo
CH	Special Chem (HF)	ECo
RE	Special Chem (Rare Earth)	ECo
CT	Coatis & Fibras	ECo
RU	Rusvynil	ECo
SP	Specialty Polymers	SCo
CM	Composites	SCo
CS	Novecare	SCo
PA	Aroma	SCo
TS	Technology Solutions	SCo
OG	Oil & Gas	SCo
CB	Corporate Business Services	shared
NB	New Business Development	shared
GY	Energy	shared

Problem

Solution

Using sales order data:

Using only the material and plant:

GBU two-letter codes

Related articles