What is SAP Table Tvarvc used for?

Enhancing SAP standard transactions FBL3N / FBL1N / FBL5N with extra fields in the output list via BTE

This blog talks about how to add some extra fields like Vendor Number, Customer Number, separate fields for credit & debit indicators and opening balance, closing balance per posting date wise in the output screen of SAP standard transactions FBL3N / FBL1N / FBL5N.

Solution: We can use openFI 1650 (BTE) to add any fields to ALV output list in FBL3N / FBL1N / FBL5N at the same time.

SAP has already provided the place for Open FI BTE (1650) in the standard program that will trigger the custom function module assigned to the event 1650 in FIBF T-code.

FBL3N: G / L Account Line Item Display

FBL1N: Vendor Line Item Display

FBL5N: Customer Line Item Display

Step 1:Create all required fields using append structure in structures RFPOS, RFPOSX

Step 2: Create a custom function module by copying the same interface parameters of FM SAMPLE_INTERFACE_00001650.

Step 3: Write the logic to populate the extra fields inside this custom function module as per your requirement.

FUNCTION zfi_fm_fbl3n.

*”———————————————————————-

* ”*” Local Interface:

* ”IMPORTING

* ”VALUE (I_POSTAB) LIKE RFPOS STRUCTURE RFPOS

* ”EXPORTING

* ”VALUE (E_POSTAB) LIKE RFPOS STRUCTURE RFPOS

*”———————————————————————-

* & Function Module Name: ZFI_FM_FBL3N

* & Modules: FI

* & Functional Consultant:

* & Author Name: Manoj Kumar Pradhan

* & Date Of Creation: 24/07/2012

* & Description: This fm populates values ​​for additional fields

* like vendor, customer, separate fields for debit & credit

* indicator which will be displayed in FBL3N / FBL1N / FBL5N

* output list.

*

* It triggers from T-codes FBL3N / FBL1N / FBL5N

* for BTE event 00001650 & configured

* in FIBF T-code for customer products Z1650 for the event 00001650.

* & Transport Request:

* & Tcode: NA

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

***** Data Declaration ***************

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

 

DATA: e_fiscal_yr TYPE bapi0002_4-fiscal_year,

e_period TYPE bapi0002_4-fiscal_period,

e_prev_period TYPE bapi0002_4-fiscal_period,

e_ret TYPE bapireturn1,

e_first_day_of_period TYPE bapi0002_4-posting_date,

lf_prev_day_of_post_date TYPE budat,

e_ret2 TYPE bapireturn1,

e_ret3 TYPE bapireturn,

e_ret4 TYPE bapireturn,

lf_sum_dmbtr TYPE dmbtr,

lf_sum_dmbtr_k TYPE dmbtr,

lf_sum_dmbtr_d TYPE dmbtr.

 

e_postab = i_postab.

SELECT SINGLE lifnr kunnr

FROM bseg

INTO (e_postab-zzlifnr, e_postab-zzkunnr)

WHERE bukrs = i_postab-bukrs

AND gjahr = i_postab-gjahr

AND belnr = i_postab-belnr

AND (kunnr <> ”OR lifnr <>”).

IF i_postab-shkzg = 'S'.

e_postab-zzdeb_ind = 'S'.

ELSEIF i_postab-shkzg = ‘H’.

e_postab-zzcr_ind = ‘H’.

ENDIF.

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

Step 4: Activate Open FI: t-CODE - FIBF & Create product of a customer by inputting product name, text & activate the same.

Step 5: Create P / S MODULES of a customer in FIBF and assign custom function modules to event 1650 & product.

Step 6: Finally run standard program RFPOSXEXTEND to regenerate structure & run program BALVBUFDEL to clear ALV.

Grade: These two programs can only be run by user who has admin authority. Contact Basis user or IT administrator for assistance

After the completion of the above steps, we will be able to view these extra fields on execution of T-codes FBL3N / FBL1N / FBL5N.