Logic to derive Offsetting Account in GL

[shyam_uthaman]

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'.

[former_member472435]

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/11853413cf124dde91925284133...

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 ?

[shyam_uthaman]

Hi Mihir,

I do not have a BW system. Only a native HANA pulling base tables via SLT. That's why I need to recreate this logic.

[former_member472435]

Dear Shyam,

Do you have SDI or BODS tool in your licenses available ? If SDI is available you can use ABAP adapter to connect (subscribe) to ODP queue. If you are using BODS 4.2 you can still connect (subscribe) to ODP queue.

If both are not available you can explore on below link for "Odata based data distribution". Not sure if additional licences are required for below case.

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

Above options can be used to provision extractor data in Native HANA environment.

Regards,

Mihir