Skip to Content

Logic to derive Offsetting Account in GL

Hi,

I am trying to understand the FM GET_GKONT to derive Offseting account from GL.

The below code seems to be the logic but doesn't give the correct output as compared to the GL_14 extractor for BW. What am I missing here? I need to create this logic in HANA using the base tables like BSEG, BKPF, FAGLFLEXA and can't use the datasource.

Please let me know. Thanks.

CASE BSEG-KOART.
 WHEN 'D'.
 GKONT_S = BSEG-KUNNR.
 Ghkon_S = BSEG-hkont.
 KOART_S = BSEG-KOART.
 WHEN 'K'.
 GKONT_S = BSEG-LIFNR.
 Ghkon_S = BSEG-hkont.
 KOART_S = BSEG-KOART.
 WHEN OTHERS.
 GKONT_S = BSEG-HKONT.
 Ghkon_S = BSEG-hkont.
 KOART_S = 'S'.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 12 at 08:55 AM

    Dear Shyam,

    Any reason you are re engineering the standard extractor ? Maybe below screenshot is helpful to you ? If SAP DS and SDI are not in your customer licenses for provisioning in Native HANA (which I guess is your requirement), you check on Odata based data distribution ? Not sure if additional license is needed for this option but you can refer below link and follow the hierarchy in the left of webpage over this link :

    https://help.sap.com/viewer/ccc9cdbdc6cd4eceaf1e5485b1bf8f4b/7.5.9/en-US/11853413cf124dde91925284133c007d.html

    About your code in your post, 'D' line stands for Customer (AR), 'K' line stands for Vendor (AP), 'S' line stands for GL. Hence KUNNR, LIFNR and HKONT are seen respectively in each of the when cases. But I believe your query is something different ?

    Add comment
    10|10000 characters needed characters exceeded