topic Re: Problem in adding fields in FBL3N in Application Development and Automation Discussions

Problem in adding fields in FBL3N

Former Member — Mon, 28 Nov 2011 11:39:52 GMT

Dear all,

I have tried to add two fields to my list in FBL3N, vendor name and item.

While i tried to append the structure with two fields namely zzname1 and zzlifnr in RFPOS ,the sytem throws me the following warnings,hence help me to resolve the same.I have done the rest other steps in BTE and its FM sample_INTERFACE_00001650 correctly but still i could not add the 2 new fields.

Activation of worklist (WABAP5 / 28.11.2011 / 17:01:18 /)

=========================================================================

Technical log for mass activation

See log WABAP520111128170105:ACT

TABL RFPOS activated

=========================================================================

Adjustment of active dependent objects

=========================================================================

TABL FMLGD_STRUC_RFPOSX was adjusted

Check table FMLGD_STRUC_RFPOSX (WABAP5/28.11.11/17:01)

Field name INDEX is reserved (Do not use structure as include in DB table)

Table FMLGD_STRUC_RFPOSX was checked with warnings

TABL J_3RS_DISPLAY_TABLE was adjusted

Check table J_3RS_DISPLAY_TABLE (WABAP5/28.11.11/17:01)

Field name ROWNUM is reserved (Do not use structure as include in DB table)

Field name ORDER is reserved (Do not use structure as include in DB table)

Table J_3RS_DISPLAY_TABLE was checked with warnings

TABL RFPSD was adjusted

=========================================================================

End of activation of worklist

=========================================================================

Re: Problem in adding fields in FBL3N

RaymondGiuseppi — Mon, 28 Nov 2011 12:17:19 GMT

You can ignore those warnings as RFPOS (and RFPOSX in which you must add the same fields) and the two structures whose name are in the log are not database tables but structures.

If other problems arise, read [Note 984305 - Line item: Definition of special fields (T021S)|https://service.sap.com/sap/support/notes/984305]

Regards,

Raymond

Re: Problem in adding fields in FBL3N

Former Member — Tue, 29 Nov 2011 02:57:56 GMT

Dear Friend,

The problem is even though not cleared,the two added fields are not reflecting in the table BSEG. i did the process as below,hence kindly correct me .

1. Include field ZZLIFNR & ZZNAME1 as add.structure in RFPOS, RFPOSX.

2. Copy func.module SAMPLE_INTERFACE_00001650 in ZFM_FBL3N and developing use ZZLIFNR & ZZNAME1 field...

following is the code written.

FUNCTION ZSAMPLE_INTERFACE_00001650.

*"----

""Local Interface:

*" IMPORTING

*" VALUE(I_POSTAB) TYPE RFPOS

*" EXPORTING

*" VALUE(E_POSTAB) TYPE RFPOS

*"----

Start of change INC000000025271/TAS000000001956

****************************************************************

IF I_POSTAB-BUKRS EQ 'ER01'. " FBL5N & FS10N.

DATA: L_LIFNR TYPE LIFNR,

L_NAME1 TYPE NAME1.

SELECT SINGLE LIFNR FROM BSEG INTO L_LIFNR

WHERE BUKRS = I_POSTAB-BUKRS AND

BELNR = I_POSTAB-BELNR AND

GJAHR = I_POSTAB-GJAHR AND

KOART = 'K'.

IF NOT L_LIFNR IS INITIAL.

SELECT SINGLE NAME1 FROM LFA1 INTO L_NAME1

WHERE LIFNR = L_LIFNR.

I_POSTAB-ZZLIFNR = L_LIFNR.

I_POSTAB-ZZNAME1 = L_NAME1.

ENDIF.

********************************************

End of change INC000000025271/TAS000000001956

********************************************

E_POSTAB = I_POSTAB.

ENDFUNCTION.

********************************************

End of change INC000000025271/TAS000000001956

3.Activate OpenFI (FIBF tr.code)., Create product of a customer

4. Add Z1650 and Text and activate ,Create P/S Modules of a customer

5.Assign Func.Module ZFM_FBL3N to Event 1650 & Product Z1650

6.Run RFPOSXEXTEND (regenerate structure) and BALVBUFDEL (clear ALV).

Re: Problem in adding fields in FBL3N

RaymondGiuseppi — Tue, 29 Nov 2011 07:18:26 GMT

- Check name of FM : Once you wrote ZSAMPLE_INTERFACE_00001650 and once ZFM_FBL3N (with FBL5N in comment)

- The fields wont be inserted in BSEG : They are only displayed in ALV items report (FBL*N, etc.)

- I_POSTAB is importing parameter and should not be changed, move your code after the E_POSTAB = I_POSTAB and then update subfields of E_POSTAB.

- For performance, you could try to bufferize some data (LIFNR+NAME1 for example) in a global internal table of the function group.

Regards,

Raymond

Re: Problem in adding fields in FBL3N

Former Member — Tue, 29 Nov 2011 10:25:27 GMT

hi Raymond,

Plz instruct me the steps that needed to be done for the above mentioned suggestion of yours. i have modified the FM as follows.

E_POSTAB = I_POSTAB.

IF I_POSTAB-BUKRS EQ 'ER01'(003). " FBL5N & FS10N.

DATA: L_LIFNR TYPE LIFNR,

L_NAME1 TYPE NAME1.

SELECT SINGLE LIFNR FROM BSEG INTO L_LIFNR

WHERE BUKRS = I_POSTAB-BUKRS AND

BELNR = I_POSTAB-BELNR AND

GJAHR = I_POSTAB-GJAHR AND

KOART = 'K'(001).

ENDIF.

IF NOT L_LIFNR IS INITIAL.

SELECT SINGLE NAME1 FROM LFA1 INTO L_NAME1

WHERE LIFNR = L_LIFNR.

I_POSTAB-ZZLIFNR = L_LIFNR.

I_POSTAB-ZZNAME1 = L_NAME1.

ENDIF.

Re: Problem in adding fields in FBL3N

eduardo_hinojosa — Tue, 29 Nov 2011 11:11:04 GMT

See SAP Note 368310 - LI: Open FI: long text for special G/L transacs. You have in the correction a sample for the BTE. Check if you have started program RFPOSXEXTEND as the note suggests.

I hope this helps you

Regards

Eduardo