cancel
Showing results for 
Search instead for 
Did you mean: 

Include BSEG-BEWAR in 0FI_GL_4

Former Member
0 Kudos

Hi expert guys ¡¡

I´m FI/CO Consultant and I dont know much about BW, so maybe my question is not very accurated, but I´m sure you´ll be able to help me;

I would like to know if it´s possible to include field BSEG-BEWAR in extractor 0FI_GL_4, and in brief how it could be done.

Thanks in advance,

Víctor

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanxs

Former Member
0 Kudos

Hi Victor,

Since 0FI_GL_4 Extractor will get data from BSEG table you can add the field in to the extractor.

Process of including the field .

1) Append the Field in the extract structure

2) need to write include logic to populate the data for 0FI_GL_4

3) Include logic can be performed in CMOD tcode.

sample code mentioned below

This is the code you have to write in tocde CMOD if you are enhancing the master data. It applies for any master data, although, I have taken 0VENDOR_ATTR as the example. I assume that You have already added/appended the fields in the extract structure of 0VENDOR_ATTR i.e. to the structure BIW_LFA1_S. ( Check this link for how to enhance the DataSource : https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b0af763b-066e-2910-a784-dc673166... )

We have enhanced the datasorce for the following two fields from table LFA1:

ERDAT- Date on which the Record Was Created

KRAUS - Credit information number.

We have also enhaced the structure for the following fields from table LFB1.

MINDK - Minority Indicators

ZTERM - Terms of payment key

CERDT - Certification date.

Now we will poulate these two fields in the code written in CMOD tcode. Here is the code:

Go to the tcode CMOD in R3 and select the component EXIT_SAPLRSAP_002. Write this code in INCLUDE ZXLOFU01.

data : l_t_data like biw_lfa1_s.

data : l_tabix like sy-tabix.

CASE i_datasource.

WHEN '0VENDOR_ATTR'.

LOOP AT i_t_data INTO l_t_data.

l_tabix = sy-tabix.

CLEAR: l_t_data-yyerdat,

l_t_data-yykraus.

SELECT SINGLE erdat kraus FROM lfa1 INTO

( l_t_data-yyerdat, l_t_data-yykraus)

WHERE lifnr EQ l_t_data-lifnr.

SELECT SINGLE mindk zterm cerdt FROM lfb1 INTO

(l_t_data-yymindk, l_t_data-yyzterm, l_t_data-yycerdt)

WHERE lifnr = l_t_data-lifnr.

MODIFY i_t_data FROM l_t_data INDEX l_tabix.

CLEAR: l_t_data, l_tabix.

ENDLOOP.

ENDCASE.

Former Member
0 Kudos

if there is a link between them and the extraction view of the data source, then you can.. go to rsa6 , find yoru extractor and then click on extractstructure it should started with z or 0. open it you will have to append the sap structure and see i fyou can ad dthe field. then you will have to populate it in cmod using some programming.