Skip to Content

add a field to determine standard sorting for line items

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 ,


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 02:28 PM

    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...


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.