on 03-28-2011 7:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.