Skip to Content
author's profile photo
Former Member

Doubt in 0CCA_C11 with 0QUANTITY

Hi,

working with BI 7.0.

I am Using 0CCA_C11 Costs and Allocations cube.

data sources are

0CO_OM_CCA_1 and 0CO_OM_CCA_9.

after scheduling , I am getting all Data <b>Except 0QUANTITY Field Records</b>.

only 0QUANTITY Data is not comming All other Data is comming correct.

I checked in RSA3 for Consumption Quantity Field ie SMEG

For the Data souce 0CO_OM_CCA_9, Records are available.

but for the Data source 0CO_OM_CCA_1 No Records are available.

<b>Following is the Quantity Rule in Transformation</b>

For the Data sources 0CO_OM_CCA_1 & 0CO_OM_CCA_9

Target Info Object is 0QUANTITY

Target Unit 0UNIT

Source Unit MEINH

Source Fields of Rule

MEINH --- Unit of Measure

SMEG -


Consumption Qty

Target Fields of Rule

OQUANTITY --- Quantiry

0UNIT --- Unit of Measure

Please Help me to find the solution.

Thanks

prasanna

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 04:20 PM

    Are you aware of the fact that:

    0CO_OM_CCA_9 is Actual Costs - Line Items (Delta)

    and

    0CO_OM_CCA_1 Cost Centers: Costs and Allocations (all costs actual, plan, and commitments)?

    So if your setup is correct (to avoid duplicate data) you should be loading plan only with 0co_om_cca_1 and maybe no planning occurs for quantities, actuals should come from 0co_om_cca_9 in delta and commitments should come up in delta from their own datasource 0CO_OM_CCA_10, this should also lead to faster data loads

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Pabloj Thank you for the Responce, can you please go for in detail.

      I notice another point here,

      <b>in R/3 Consuption Quantity Field is SMEG QUAN length is 15</b>,

      <b>But in BI 0QUANTITY field is QUAN length 9</b>

      I am mapping 0QUANTITY to Consuption Quantity SMEG Field,

      may be that's why the Data is not comming.(for the difference of the length)

      <b>But how to create QUANTITY Field with length 15,</b>

      <b>If I try to create a Quantity Field in BI then It takes default length 9.</b>

      Can you please help me to solve this Problem.

      Thanks

      Prasanna