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

Equivalent field for Sales Document type AUART in deliveries

Dear SD friends,

I am a BI professional and have a question relating to Sales Document Types (AUART). I am extracting data into BI for Sales Orders and Deliveries. For Sales Orders i have filtered them by certain Sales Doc Types ( field AUART). Now when extracting deliveries into BI i want to know what field to filter on in the deliveries side which will be an equivalent to Sales Doc type field. Any help will be appreciated.

Thanks

Raj

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 04:46 AM

    Hi,

    1. For Order types.

    In order to find the corresponding delivery type for the sales order type you can use TVCPL table where you can pass the order type (AUART) to TVCPL-AUARV and get TVCPL-LFARN. The selected list will give possible order type that can be used for an order. Use this with LIKP-LFART and you can get the list of delivery documents for the corresponding order types.

    2. For single sales order if you want to find corresponding delivery.

    Use VBFA or RV_ORDER_FLOW_INFORMATION (Function module) to get the list of deliveries created for the sales order.

    Regards

    Mani

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 05:27 PM

    hi,

    you should not look for the delivery document type corresponding to sales document type, since one delivery document type can be used for 'n' no of sales document type.

    go to vbfa table and enter your sales document type's sales order no. you will get corresponding delivery document no.

    i hope this will be helpful.

    rgs,

    ak

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2008 at 05:16 PM

    Hi,

    Check in tcode VTLA what are the rules to copy SO to deliveries. In this tcode you will have the correlation between types.

    Too you can check it in table TVCPL. Use tcode SE16N.

    I hope this help you

    Regards,

    Eduardo

    Add a comment
    10|10000 characters needed characters exceeded

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

    Thanks a lot for your time guys.The problem is resolved.I am doing a lookup in BW from deliveries on sales order data to get the corresponding doc type and then restricted it by that doc type.

    Thanks

    Raj

    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.