Skip to Content
0

Logic to derive Offsetting Account in GL

Jan 10 at 01:23 AM

106

avatar image

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'.
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jan 12 at 08:55 AM
0

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 ?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.

0
Former Member

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/11853413cf124dde91925284133c007d.html

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

Regards,

Mihir

0