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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

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 comment
    10|10000 characters needed characters exceeded