Skip to Content
author's profile photo Former Member
Former Member

Sales Document number in FBL5N

Hi Friends,

In FBL5N (customer line item report) there is a field "Sales Document" Field Name "VBEL2". But the accounting document which is generated in FBL5N for billing document from SD in not populating the sales order number in this field, this field is blank.

this field is getting populated for down payments with relevant sales document number and not for invoice document.

Our client wants the sales order number to be reported in customer line item report for their tracking.

Can any one please suggest how this can be achieved.

Thanks & Regards

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2010 at 04:52 PM

    You can map Sales Order number to either 'Assignment' or 'Reference' fields in accounting document using Copy control function in SD. Please use transaction VTFA, this needs to be maintained for combinations of billing type and sales document type. Please ensure these fields are not currently used in your system for other information.

    Following fields can be mapped to 'Assignment' or 'Reference'.

    A Purchase order number

    B Sales order number

    C Delivery number

    D External delivery number

    E Current billing document number

    F External delivery no. if available, otherwise delivery no.

    If you currently use 'Assignment' or 'Reference' fields for other details, you can use user exit EXIT_SAPLV60B_008.

    Thanks

    Venkata Ganesh Perumalla

    Edited by: Venkata Ganesh Perumalla on Oct 4, 2010 11:52 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2010 at 01:53 PM

    Hi

    In FBL5N, Sales Document number will be displayed only for Down Payments & for the rest, field will be empty.

    even it is the same for FBL1N also, PO number will be displayed only for Down Payments.

    SAP given a NOTE for this mentioning that Field will be displayed in the report but it will be empty.

    i will check and let u know the NOTE.

    regards

    venkat

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      If you check that OSS note, the solution mentioned is:-

      The display of the purchasing document number for customers/vendors via the line item display is not possible. However, you can branch from the vendors/customers line item display into the document overview and there display the purchasing document number for the individual G/L account line items.

      Similarily for sales document number in FBL5N

      Regards,

      SDNer

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.