add a field to determine standard sorting for line items

[former_member338347]

hi everybody,

i need to add a field FELDN to the list of fields through which i can use this one to determine standard sorting for line items. the field FELDN is not there in the drop down list. points will be assigned.

thanks in advance ,

govindaraja

[Former Member]

Here is one way to add special fields to a line item report, not sure if it applies to your case...

Please check attached note 207436. It describes you how you should act

to see the field XREF* in transaction FBL*N. Informational only.

These fields need to be setup as Special Fields in T021S. You can do

this by the following path in IMG:

Financial Accounting->General Ledger Accounting->G/L Accounts->

Line Items->Display Line Items with ALV->Define Special Fields for

Finding and Sorting Data. (transaction OBVU).

Regarding the Special Fields, please see attached Note 215798. This

note will explain that the special fields need to be in table T021S

as well as in the RFPOSXEXT structure which can be verified via

se11. If these fields are not yet in RFPOSXEXT see Note 215798

(you can verify this in RFPOSXEXT by going to the bottom of the

structure and see under column 'Component' that special fields are

denoted by 'U_XREF1'). You may see a field XREF1

under the 'Component' column, but these fields are NOT the special

field. The special field is denoted by U_fieldname!!!

Also, to ensure you are using the Special Field in the display variant

-FBL*N when you select->Current display variant right mouse click on

the pop-up box and choose 'Show technical names'. The special fields

will be displayed as follows: 'U_XREF1'.

This will ensure that it is truly the special field you are using.

You will notice that there will be a field 'XREF1'. These

are NOT the special fields. You MUST use 'U_XREF1' in

the display variant to view the data.

In regards to vendor:

Please, check notes 984305 and 215798 in order to define special fields.

Please, also consider that if you refer to field LIFNR, transaction

FBL3N only displays vendor number for documents with document type WE

and not for other document types.

For Invoice Receipts only the vendor line item would populate

LIFNR, the G/L lines for IR documents do not populate LIFNR.

The reason for this is as follows:

"Vendor number and name is only stored in the vendor line (line number

001) not in the G/L line (line number 002). So report RFEPOS00 can not

display the vendor data, since it selects only the G/L lines. There is

no way to make FBL3N to display data from vendor lines also.

Hope that helps...

Jon