Skip to Content

How to use PAYR Datasource

Hi All,

I have a requirement to create cube which picks data from following datasources

ODS 0FIAP_O03

Custom ODS based on EKBE table

Custom ODS based on PAYR table

ODS 0FIAP_O03 & Custom ODS based on EKBE table are having Key figures to update but Custom ODS based on PAYR table do not have Key Figures to update.

When I create update rules based on above datasources, I am able to create succussfully update rules for ODS 0FIAP_O03 & Custom ODS based on EKBE table but for Custom ODS based on PAYR table its giving error and I am not able to activate Update rule since its not having Key Figure.

I see only one option, I dont create Update rule for Custom ODS based on PAYR table & look up for data of PAYR in update rule of ODS 0FIAP_O03 for the characterstics I want from PAYR ODS.

I have only one doubt, 0FIAP_O03 is delta compatible where as ODS on PAYR and EKBE are not delta compatible as far as R/3 is concerened.

If there is a change in BSIK/BSAK table then only I will get Delta for 0FIAP_O03 and since look up for PAYR characterstics is done in update rule of 0FIAP_O03 delta may not take place if there is no change.

I want to know whether change in PAYR means change in BSIK/BSAK ?

if that is a case then look up in Update rule of 0FIAP_O03 will work otherwise not?

I need your advice asap.

Happy New Year to all.

Thanks & Regards,

Ajay

(203-674-4129)

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 09, 2004 at 11:26 AM

    Hi ,

    This sounds like it may be a consulting issue. If you are not able to obtain sufficient information from your fellow community members here, we recommend that you contact your consultant from SAP or its partners to get further advice.

    Best regards,

    Alex PETER, SAP AG

    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.