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

Combining Sales and Billing ODS

I am working on 2LIS_11_VAITM & 2LIS_13_VDITM and have taken them into individual ODS (Sales & Billing). I have taken Sales Doc and Sales Item as key fields. In the next stage I have combined Sales and Billing ODS into a single ODS with Sales Doc and Sales Item as key field. But when I checked the data, the billing doc is not showing all the relevant items e.g

Sales Doc Sales Item Billing Doc BillItem

10006765 10 3300000016 12

The Billing doc is having two more items like 10, 11 along with 12. The result is showing only the last item of the billing doc. And this is wrong for all the other doc nos. Why ?? Could you throw some light on this???

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2005 at 07:16 AM

    You have to put also Billing Doc and Bill Item in the key; otherwise you'll get only the last value and KF are summarized.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2005 at 07:21 AM

    Hi,

    I hope in the last ODS you have taken "Sales Doc" and "Sales Item" as the key fields , And "Billing Doc" and "BillItem" as data fields .

    Have you taken the 'overwrite' as 'update type' in the update rule of "BillItem"? (for the update rule of final DT)

    Instead of taking ODS as the final data target take Info cube as the DT.

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2005 at 07:38 AM

    Anil, u are right. I have taken Sales doc & item as key field and bill doc & item as data field. The update type for billing item was already set to overwritten. Still the problem is coming. Any other solutions ???

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      otherwise instead of poupalting data from Billing ODS and Sales ODS to final ODS , Define the Info set on the Billing ODS and Sales ODS.

      May I know, the technical names of key fields in both ODS (Billing ODS and Sales ODS to final ODS) .And aslo the respective fileds(technical name) from respective Data source.

      With rgds,

      Anil Kumar Sharma .P

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 05:06 AM

    Hi Paolo and Anil, thanks for your inputs. I have tried both the options mentioned by you.

    Option 1: For both Sales & Billing ODS, I have taken 0DOC_NUMBER, 0S_ORD_ITEM, 0BILL_NUM, 0BILL_ITEM as key fields as suggetsed by you and some of the data fields as billing qty, sales qty, net price, invoice net price etc. In the query result set, if I take the sales details and billing details, the sales details are coming in extra row with hash though I am getting the sales doc no & item no. The key figure values are coming in extra row with hash. Is it required to write some routine for billing doc & item in the final ODS as from sales ODS I am not getting any billing doc & item, it is coming from only the billing ODS. Please let me know. If so what kind of code I have to write?

    So is the case for option 2 with cube as final DT.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      It seems I have given wrong approach. I am sorry for that.

      Try this:

      For Sales ODS :

      Key fields are 0DOC_NUMBER, 0S_ORD_ITEM

      For Billing ODS :

      Key fields are 0DOC_NUMBER, 0S_ORD_ITEM, 0BILL_NUM, 0BILL_ITEM

      Then Use Info set with link as:

      0DOC_NUMBER of sales ODS = 0DOC_NUMBER of Billing ODS

      0S_ORD_ITEM of sales ODS = 0S_ORD_ITEM of Billing ODS

      With rgds,

      Anil Kumar Sharma .P

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.