Problem in screen design

[o.kappert at qc.aibn.com]

Maybe I am missing something but....

Based upon the info provided,  part 12844161 is not in the report 
generated; therefore everything works as you wanted it to.
 
Olav.

Pandurang Rajpurohit wrote:

>
> All
>
> I am on screen design where a record which do not contain data passed 
> are only be selected. Could you please help with query how can achieve.
>
> Here is example
>
>
> > acc apmisumi
> > show item
>
>                                              INPUT OUTPUT
> APMISUMI                                TYPE SCALE SCALE  DEC PICTURE
>   APMISUMI-KEY                          CHAR                  X(43)
> * .DOC-CHAR                             CHAR                  X(15)
>   .SOURCE-CODE                          CHAR                  X(16)
>   .GM-PART                              CHAR                  X(12)
>   DOC-TYPE                              CHAR                  X(2)
>   ORD-NUM                               CHAR                  X(13)
>   CUST-ORD                              CHAR                  X(20)
>   ORD-TYPE                              CHAR                  X(2)
>   ORD-PART                              CHAR                  X(20)
>   PART-QTY                              NUM     0     0    0  ^.^^^.^^^
>   WHM-QTY-ORD                           NUM     0     0    0  ^^^^^^^^
>   WHM-QTY-REC                           NUM     0     0    0  ^^^^^^^^
>   SHIP-DATE                             DATE                  YYYY/MM/DD
>   WHM-REC-DATE                          DATE                  YYYY/MM/DD
>   FLAG-905                              CHAR                  X(1)
>   PRIC-UNIT                             NUM     3     0    3 
>  ^.^^^.^^^.^^...
>   VAT-CODE                              CHAR                  X(2)
>   CURR-CODE                             CHAR                  X(3)
>   ACT-COST-L                            NUM     4     0    4 
>  ^^^.^^^.^^^,...
>   ACT-COST-F                            NUM     4     0    4 
>  ^^^.^^^.^^^,...
>   AVC-COST                              NUM     3     0    3 
>  ^.^^^.^^^.^^...
>   BEAF-INV                              CHAR                  X(1)
>   LOC-CUST                              CHAR                  X(9)
>   TOT-LINES                             NUM     0     0    0   ^.^^^
>   WHM-PLAN-CODE                         CHAR                  X(4)
>   WHM-IN-TYPE                           CHAR                  X(4)
>   FILLER                                CHAR                  X(42)
>
>
> > acc apmisumi
> > select if source-code = "632654450" and gm-part = "    12844161"
> > rep doc-char source-code gm-part flag-905
> > go
> 2010/03/13                  OPEL P&A DATA DICTIONARY                   
> PAGE   1
>
>   Document number  SOURCE CODE       Gm Part       Flag
>                                                    905
>
>   000000000225071  632654450             12844161   C
>
>
>
> > acc apmisumi
> > select if source-code = "632654450" and gm-part <> "    12844161" 
> and (flag-905="P" or flag-905="C")
> > rep doc-char source-code gm-part  flag-905
> > go
> 2010/03/13                  OPEL P&A DATA DICTIONARY                   
> PAGE   1
>
>   Document number  SOURCE CODE       Gm Part       Flag
>                                                    905
>
>   000000000225071  632654450              4726568   C
>   000000000225071  632654450              5064431   C
>   000000000225071  632654450              5325626   C
>   000000000225071  632654450              5409420   C
>   000000000225071  632654450              9121795   P
>   000000000225071  632654450             12790592   C
>   000000000225071  632654450             13219393   C
>   000000000225071  632654450             13253738   C
>   000000000301004  632654450              5333794   P
>   000000000301004  632654450             11609598   P
>   000000000301004  632654450             12762510   P
>   000000000301004  632654450             12767670   P
>   000000000301004  632654450             12797804   P
>   000000000302065  632654450              9270120   P
>
>
>
> I need select only doc-char which does not contain part  12844161 for 
> source code 632654450 but with this query the doc-char 000000000225071 
> is also selected even though it contain part 12844161
>
> Can any one  help me
>
> Thanks & Regards
> Pandurang Rajpurohit,
> -----------------------------------------------------------------
> Project Manager
> GM - Powerhouse Tower (DDS)
> IBM Global Services India Pvt. Ltd. Pune
> Contact No : +91 020 40116372
> Mobile No : +91 9049009973
> EMAIL : pandurang.rajpurohit at in.ibm.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100313/9eef42fc/attachment.htm