Material number,quantity and delivery number in FBL5N & FBL1N

[Former Member]

Hello,

We have a requirement to see

1) material number, quantity and delivery number in FBL5N.

2) material number, quantity and delivery date and number in FBL1N.

We tried to use the functionality "define additional fields for line items" in configuration for customer and vendor.

But material number and quantity pulls data from table BSEG which shows data for GL line item and not for customer or vendor line item. So, even field material number and quantity is shown in FBL5N and FBL1N, but there is no value. All are blank.

Please advise how can we add above fields in FBL5N and FBL1N with actual data.

Best Regards,

Tapan

[fernando_evangelista]

Hi Tapan,

in general if you want to inlude a special field to the line item

display, you have tp proceed as described in the note 215798. These

fields have to be defined in transaction OBVU. Then the special field

should exist in structure RFPOSXEXT. The program RFPOSXEXTEND eliminates

inconsistency in RFPOSXEXT and program BALVBUFDEL eliminates buffer

inconsistency.

However these fields are different from the normal special fields:

For the FBL*N you have defined the 'Material Number (BSEG-MATNR),

Quantity (BSEG-MENGE) and Purchase (BSEG-EBELN)' as a special field.

Such a special field is not read from the index tables (BSIK/BSAK) like

the other ones, it directly gets read from the BSEG or BKPF table.

If you check all items for the Company Code xxxx now in the FB*1N

nowhere is the 'Material Number, Quantity and Purchase' displayed.

But this is absolutely correct, as also in the BSEG table there is

no material number, quantity and purchase updated for the 'Vendor'

line items of all documents.

Reason:

Since Release 3.0, several purchase orders can be offset in one invoice.

As a result, different purchasing document numbers (BSEG-EBELN) can be

contained in the different G/L account line items.

As a result, it is no longer possible to enter a unique purchasing

document number in the customer/vendor line item. Field BSEG-EBELN

is not filled in the vendor line item and therefore cannot be

displayed in the line item display for customers/vendors. Please also

check note 152335.

So if you check you will see that in the vendor line item none of these

fields are filled so they are not in the table BSEG. That is the reason

why the value is not displayed because is not filled in the table which

gets read. So the values of these fields cannot be shown in FBL1N.

In the FI normally the Quantity is not a 'real' important field, as it

is more related to the MM area.

But in the old 'Profit Center Accounting' and the old' Special Ledger'

the field has been important.

As the same logic of these areas to 'store' the Quantity is also used

in the NewG/L the field get only filled in the line, where it make

'sense' because only in the 'goods receipt'

lines a 'real' Quantity is posted to the system.

So as before in the PCA and SL, now also in the NewG/L the Quantity is

filled in the correct and important lines and postings.

Transaction FAGLL03 shows the quantity like posted in table FAGLFLEXA.

Please have a look at the note 1063198 which explains why the

quantity is different in BSEG and FAGLFLEXA.

In FI as standard we would not expect to see VBEL2 populated in FBL*N

as this field is not included in BSIS. The reason why SAP designs

this way is that sometimes many sales orders are paid by one billing

document.

The field billing document 'VBELN' is contained in table BSEG AND in

table BSID but NOT in table BSIS.

Same occurs with BSEG-MATNR (material) and BSEG-MENGE (quantity).

In order to display these fields, you will need to create them as

special fields:

1)Please create fields BSEG-VBEL2, BSEG-MATNR and BSEG-MENGE as special

fields in transaction OBVU (FBL3N >MENU >SETTINGS >SPECIAL FIELDS);

2)SE38->program "BALVBUFDEL"->select indicator "Reset only EUINFO/LTEX"

->run

3)Create a variant in FBLN to include this field (FBLN > SETTINGS >

DISPLAY VARIANT > CURRENT... Add the required fields (1-U-VBEL2...)

If they do not come up as a Special Fields in the Hidden Fields list,

run RFPOSXEXTEND and wait for a few hours. 1-U-VBEL2... should then be

available in the list.

Also check Notes 215798 and 373268.

Please consider that you can display sales,material document and

quantity in transaction FBL*N, but only if the field is filled in.

Kindly check in tables BSEG and BSIS if they are updated.

Should the same are empty in the data base tables it would be totally

correct if the fields are shown blank in FBL*N.

Kind Regards,

Fernando Evangelista

[fernando_evangelista]

Hi Tapan,

As fields BSEG-MATNR (material) and BSEG-MENGE (quantity) are special

fields for line item display, please define the same as follows:

1.FBL*N->menu "settings->special fields"-> define fields BSEG-MATNR

and BSEG-MENGE

2.SE38->program "BALVBUFDEL"->select indicator "Reset only EUINFO/LTEX"

->run

3.FBL*N->menu "settings->-current."->include the required fields

Additionally check note 215798.

Kind Regards,

Fernando Evangelista

[Former Member]

Hi Fernando,

I have defined special fields as BSEG-MATNR and BSEG-MANGE for Material number and quantity respectively. As result of that now I can see these 2 fields with content in FAGLL03 (GL line item display).

But when I look into FBL5N, then I see the fields are available but contents are blank. Materianl no and quantity both fields are with no data.

Is it because of BSEG has data for GL line item and not for Customer or Vendor line item?

Please advise.

Best Regards,

Tapan Patro

[atif_farooq]

Dear :

Please use BTE (Business Transaction Events) using FIBF for fetching the fields in required reports if they are not being fetched through standard way.

Regards