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

0PUR_C01 and 0PUR_C04 cubes remodeling impact

Hi experts,

I have two questions regarding to 2LIS_02_ITM and 2LIS_02_SCL data sources enhancement.

1. I need to map many fields from 2LIS_02_ITM and 2LIS_02_SCL data sources to target infoproviders infobjects. I'm thinking about remodeling cubes 0PUR_C01 and 0PUR_C04. Which are your recommendations in order to decide "in which cube to add each infobject"? Which should be the criteria to perform remodeling? I need to add following infojects:

0DOC_DATE, 0DOCTYPE, 0DOC_CAT, 0PSTNG_DATE, 0DOC_NUM, 0PUR_GROUP, 0PURCH_ORG, LOC_CURRCY, 0VAL_START, 0VAL_END, 0VENDOR, 0INV_PTY, 0PO_STATUS, 0ENTRY_DATE, ORDER_CURR, 0REQUESTER, 0PUR_REASON, 0DOC_ITEM, 0COMPL_DEL, 0FINAL_INV, 0CONTRACT, 0CONT_ITEM, 0BASE_UOM, 0MATL_GROUP, 0MATERIAL, 0PO_UNIT, 0NETPRICE, 0PRICE_UNIT, 0ITM_CAT, 0PROD_DESCR, 0GR_BASE_IV, 0PLANT, 0EVAL_R_S, 0BBP_REQ_ID, 0BBP_RQITEM, 0PUR_GROVAL, 0ORDER_VAL, 0DLV_COSTS, 0SCL_DELDAT, 0INV_PARTY

Do you think it's excessive to add all of them?

2. As I told you, I need to add 0DOC_NUM and 0DOC_ITEM infobjects to 0PUR_C01/0PUR_C04 cubes. Which is the impact of remodeling this standard cubes? I mean, by remodeling these cubes adding these two infobjects I'm converting them into line item ones. What happens with calculated key figures related to quantity of items? Should I make some changes in ABAP routines?

3. Any extra recommendation in order to migrate data flow into 7.x version?

Thanks in advance.

Best regards.

Ana

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 09, 2014 at 02:29 AM

    Hi,

    Is this new flow or existing flow?

    Adding info objects is purely depend client/user needs. if you have proper technical specs, please check your requirement and add required info objects.

    0Doc_num - Am guess this info object holds more granular data, better design as Line item dimension at info cube level, other wise you may face loading issues.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 05:02 AM

    Dear Friend,

    We have 2 things here.... 😊 first is new flow if you going for new flow then you can add directly add all char and KF in the cube and before data load into cube you can make line item dimension but in dimension must be a single char don't any other char in dimension.

    or if you have already data in target then you can go for remodeling. 😊

    regards,

    SM

    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.