Vendor & Customers in FBL3N

[Former Member]

Hi,

I want to see Vendor/Customers in FBL3N for Sales/Purchases GL's. I'm able to see the fields in the layout but data is not displaying. is there any special settings required to get the data. I've already seen BSEG table and there KUNNR field is appearing.

Please tell me the way to appear the data for this fields.

Thanks

Swapna

[uygur_burak · Accepted solution]

Hello Swapna,

You can not assign vendor or customer number to sales/purchase GL account with standart settings.

You must do some development for it.

You can add additonal field to FBL*N reports with using BTE exit.

First of all, if you don't use BTE before, You must create a product on FIBF.

Call FIBF transaction -> Settings -> Products -> ...of a customer

Create a new line,

Product : ZFI

Text : BTE Products for FI Exit

Product active : tick check fro activation.

Then you must call SE11 for structure RFPOS.

You must use append structure function for this structure and you can define ZFI_RFPOS append structure

Define 4 fields.

Component : KUNNR - Component type : KUNNR

Component : NAMED - Component type : NAME1

Component : LIFNR - Component type : LINFR

Component : NAMEK - Component type : NAME1

Then save and active your RFPOS structure.

After that, you must do same step for structure RFPOSX.

Then go to SE37 and copy from SAMPLE_INTERFACE_00001650 to ZFI_INTERFACE_00001650 FM.

After copy action, you must uncomment this line on ZFI_INTERFACE_00001650 FM's source code. It's very very important;

E_POSTAB = I_POSTAB.

Then you should add some ABAP code for getting customer & vendor details.

I give you some examples, you can use it. (next message on this thread, please check)

Then save and active FM.

Call FIBF transaction again.

FIBF -> Settings -> Process Modules -> ...of a customer

Define a new line.

Process : 00001650

Function Module : ZFI_INTERFACE_00001650

Product : ZFI

and this customizing.

Then you go to SE38 transaction.

start report RFPOSXEXTEND. After starting, a pop-up appears, you must click YES.

After those operations, you can see customer/vendor code and their names on FBL3N.

I hope it helps to you.

Regards,

Burak.

[Former Member]

Hi Burak,

When i am trying to call FIBF again for Settings -- > Process Modules --> Of a customer, i do not find any

Process : 00001650.

i can find Product ZFI but not Process.

Please guide.

Regards

Zunaid

[Former Member]

Hi guys,

I follow step provide from Mr Burak Uygur and i able to view NAME1 (vendor & customer name) in FBL3N.

But go one steps need to change....

Steps:

FIBF -> Settings -> Process Modules -> ...of a customer

It should be:

FIBF -> Settings -> P/S Modules -> ...of a customer

Try and see.

regards,

ng chong chuan

[Former Member]

Dear all,

thanks to all

[Former Member]

Hi Swapna,

FBL3N can display only GL Line items. Use FBL1N for Vendor Line item display and FBL5N for customer line item display.

Thanks,

Uma Toraskar

[Former Member]

Hi Swapna,

Go to Transaction Code OBVU and maintain BSEG - KUNNR and BSEG - LIFNR.

Execute the report after maintaining and check if the fields have been updated.

Thanks and Regards,

Anit

[uygur_burak]

Hello Swapna,

ABAP source example,

TABLES : bseg, kna1, lfa1.
IF sy-tcode = 'FBL3N'.
  CLEAR : bseg.
  SELECT SINGLE *
  FROM bseg
  WHERE bukrs = i_postab-bukrs
       AND belnr = i_postab-belnr
       AND gjahr = i_postab-gjahr
       AND koart = 'K'.
  IF sy-subrc EQ 0.
    e_postab-lifnr = bseg-lifnr.
    CLEAR: lfa1.
    SELECT SINGLE *
    FROM lfa1
    WHERE lifnr = bseg-lifnr.
    IF sy-subrc EQ 0.
      e_postab-namek = lfa1-name1.
    ENDIF.
  ENDIF.
  CLEAR : bseg.
  SELECT SINGLE *
  FROM bseg
  WHERE bukrs = i_postab-bukrs
       AND belnr = i_postab-belnr
       AND gjahr = i_postab-gjahr
       AND koart = 'D'.
  IF sy-subrc EQ 0.
    e_postab-kunnr = bseg-kunnr.
    CLEAR: kna1.
    SELECT SINGLE *
    FROM kna1
    WHERE kunnr = bseg-kunnr.
    IF sy-subrc EQ 0.
      e_postab-named = kna1-name1.
    ENDIF.
  ENDIF.
ENDIF.

Regards,

Burak

[Former Member]

Hi,

You can try FK10N and FD10N to see the Purchase and Sales Ledger Customer and Vendor wise. If this meets your requirement then ok, otherwise please write in detail what exactly you are looking for.

Regards,

Sanjay

[Former Member]

This message was moderated.

[Former Member]

Hi,

I don't think you still would be able to display vendor or customer in FBL3N, since vendor and customer appears in Posting Key 31, 21 or 01, 11 whereas in FBL3N line items with posting keys 40 or 50 would be displayed.

Regards,

Sanjay

[Former Member]

Hello Dear

Goto Transaction OBVU

Insert Special fields from Table BSEG like

BSEG-KUNNR - for Customer

BSEG-LIFNR - for Vendor

Go to FBL3N and Insert these fields in your layout

Hope it Solves

Cheers

IMK

[former_member1290459]

Hi,

Execute FBL3N--> Go to Change Layout (Ctrl + F8) and search the field in Hidden fields. Customer/ vendor is available .

Select the required field and click on show selected field

Select Copy

SKS