Skip to Content

expire item

Hi expets,

i have following Characteristic

MATERIAL -


Material Data With Prodcut hierarchy ( 3 Levels)

SLFLIFE -


It is an Normal Attribute (Mean Not Display or Navigational Attribute) it contains particular product Age (Life of the product in terms of Days)

PKM -


It is an Attribute of Some other Dimension it contains packed date of the particular product in the from of Character data type

0QUANTITY --- quantity Keyfigure

Now My problem is

When report executed the selection screen display like this

Date----


here i will enter current date.

when i say execute, to display the Expire quantity, through following logic

Take current date and compare the date with PKM, if the return value is greater than value of the SLFLIFE that particular proudct is expire other wise good.

but i don't i to achieve this problem, can anybody help me.

Advance Thanks

ANR

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2005 at 07:52 AM

    Hi,

    Two options:

    a) this could be a typical scenario for a virtual characteristic. Add a characteristic Expired to your cube. And implement the virtual characteristic badi with the corresponding logic. (You would also need to code the user exit for variables to get the variable entry to your virutal characteristic badi. See

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/g-i/how to use variable time references in currency conversion for more details how to do that

    b) Create a user exit formula variable for the date. Create a formula variable with replacement path from SLFLIFE and a formula variable with replacement path from Characteristic XYZ with replacement from attribute PKM. Then create a calculated key figure formula variable for current date - PKM formula variable - SLFLIFE formula variable. Then create a condition on this caluclated key figure with value < 0.

    for information on formula variables check:

    http://help.sap.com/saphelp_nw04/helpdata/en/03/6ba03cc24efd1de10000000a114084/frameset.htm

    Heike

    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.