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

SNP Orders DataSource - No Extraction of Data Records without Key Fig Value

Hello experts,

I have a problem with a datasource.

I created a datasource in APO (/N/SAPAPO/MSDP_ADMIN --> Planning Area --> Extras --> Data Extraction Tool).

In datasource properties, I flagged "no extraction of data records without key fig value", but it doesn't work fine; in fact, the datasource extracts all records with all key figure values = 0.

There are some others parameters to set?

I found the sap note 1497062, but we have a lower support package than the first available to apply the note.

Could you help us?

Thanks in advance.

Regards,

Vito Savalli.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 02, 2011 at 08:55 PM

    Hi,

    The flag 'No extraction of data records without key fig value" is to prevent filling up the zero values in BW for the

    combinations which doesn't have any value in APO.If we unflag this indicator then system fills all the Keyfigure values with zeros in BW for the combinations which doesn't have any value in APO.but i think in your case for some keyfigures in planning area you selected the 'Zero allowed' flag.So system differentiates zero and null in this case.I think In your system in this planning area these keyfigures are filled with zeros.That means these keyfigures have some value i.e zero in APO system.While extracting system only ignores the null values ,but not zero values in this case .

    Hope this will helps you.

    Regards,

    Sunitha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2011 at 11:29 PM

    You can also delete those records in the transformation by coding the delete statement.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 01, 2011 at 06:22 AM

    Hi,

    Is you key figure has the 'Zero Allowed' set?

    What is the result if you remove this setting?

    If the setting 'Zero Allowed' is the problem, but you cannot apply note 1497062, maybe you'd better consider upgrading the SP level first.

    Best Regards,

    Ada

    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.