Skip to Content
0
Former Member
Jul 18, 2012 at 08:26 AM

How to add Billing number and sales order in standard 0sd_c03

61 Views

Hi All BI Gurus,

I wanted to know how to add sales order number and billing
document number in 0sd_c03.i have a requirement to show billing document number
wise including sales order number in them.

  1. Do we need to create a seperate dimension in cube or input them
    in any of the existing dimensions.
  2. If added do we need to place both of them as line item
    dimensions or not?
  3. I knew 0doc_number is in 11 data sources mapped to vbeln
    bringing sales order number and 0bill_number is in 13 data sources mapped to
    vbeln in itm data source but not in hdr data source.(i am confused)
  4. Can we add all the characteristics required in standard cube and
    transport or do we need to modify the cube(Z) and again built all the std.
    update rules and transfer rules accordingly and transport them.

Env: BI 7.0 ,Ecc 6

0sd_c03

3.5 flow

2lis_vahdr

2lis_vaitm

2lis_12_vchdr

2lis_12_vcitm

2lis_13_vdhdr

2lis_13_vditm

please help me in resolving this.