Current Position:Home > Custom message(low stock) on alv layout cell(plng folder)

Custom message(low stock) on alv layout cell(plng folder)

Update:11-30Source: network consolidation
Advertisement
hi friends,
in plng folder(alv layout), can system displays message dynamically on a particular cell(row & col combination). eg: "low stock" via fox code. Simply i 'm deriving one cell value based on fox code (formula).  If stock > 0, show stock value, else in that cell i want "low stock".
In excel , this facility is availble using "IF', formula on particular cell.
thanks

The Best Answer

Advertisement
Hi Raju,
what you could do is:
- define a new calculated keyfigure which takes the stock value if it is > 0 and the value 0 in all other cases.
- define your query setting View->Properties->Value Display->Zero value display->show zero values to "low stock".
This has a similar effect. All value which are 0 in the query are displayed as text "low stock". Another option to highlight "low stock" material would be using exceptions.
Maybe this fulfills your requierement. Binding messages raised in planning function to certain cells in excel is not possible.
Regards Matthias Nutt
SAP Consulting Switzerland
  • Custom message(low stock) on alv layout cell(plng folder) Update:11-30

    hi friends, in plng folder(alv layout), can system displays message dynamically on a particular cell(row & col combination). eg: "low stock" via fox code. Simply i 'm deriving one cell value based on fox code (formula).  If stock > 0, sho

  • Dragging one cell value(copy) across columns or across rows in ALV layout Update:11-30

    Hi friends, In bps layouts, data is displayed in ALV grid as interface. At plng folder level, can i incorporate excel feature like dragging one cell value across columns or across rows?  Simply if user enter one value in cell of ALV grid, that should

  • Button in alv grid cell using REUSE_ALV_GRID_DISPLAY Update:10-11

    Hi all,   I want to make the contents of 2 columns of my alv grid as push button with values as text on it. I am not using classes or methods but alv grid fm. On clicking the button one dialog box has to pop up which gives edit option for the values

  • Error message when I calling planning layout in the STS Update:10-11

    Dear I'm trying to use Status and Tracking System with BPS ( SEM 4.0 SP10,  BW 3.5 SP14 ). But I got some error messages when I calling planning layout in the STS screen.. I designed 2 lower unit(A,B) and 1 upper unit(C) for the test. and using Botto

  • Buttons in ALV Grid cell need focus to be clicked :-( Update:10-11

    Hi, I have an ALV Grid with single cells displayed as buttons (dependend on the data in the corresponding row). Unfortunatelly the button-cells need focus to be clicked. So you need two clicks: one to get the focus to the desired cell and one to real

  • Dynamic change the ALV layout Update:11-30

    Alle experts: In ALV layout report, how to dynamic change the layout int ABAP porgram? e.g. I have save 5 layout, I need to change them base the my selection in ABAP program? How to do this? Thanks in advance!Try to call fieldcatlog dymnamically. Ref

  • Urgent help needed!! Layout table and Draw layout cell dissapeared. Update:10-11

    I need some urgent help. I'm using CS3 but for a while my Layout Table and Draw Layout Cell icons appear greyed and can't use them at all. Is there any kind soul out there who knows how to fix this? I'm going nuts trying all the possible options but

  • ALV layout variant missing in background job. Update:10-11

    hi guys, Having problem on getting the default ALV layout variant when run the job in backgorund. Please advise any correction needed in the following code. Thanks. *&  Include           Z_MM_KBR_AGSUBCONINV_MOD2                        * MODULE statu

  • How to change the "n/a" message when stock level unavailable Update:10-11

    When and if a product is not inventory controlled or the in stock quantity is unknown, the "In Stock" tag on the product page will read "n/a". How do I change the "n/a" message? Customer think that stock is unavailable but I

  • Add custom message to PO_DATA for PO_STANDARD_XSLFO.xsl Update:10-11

    Problem Description: How do Add a custom message to PO_DATA for use withing PO_STANDAR_XSLFO.xsl stylesheet? <fo:table> <fo:table-column column-width="180mm"/> <fo:table-body> <fo:table-row> <fo:table-cell> <fo:b