Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
OrderNo | Status |
100123687 | ABGR ABGS ABRV ADVS CCOK CLSD CMPL CNF DRUC GMPS KKMP KPOK NMAT PRT |
100162353 | KPOK NMAT PRT RESA RÜCK SETC SSAP TABG TECO TFAK |
100162887 | CCOK CNF DRUC KKMP PTBL |
100162989 | CNF PTBL RESA RÜCK SETC SSAP TABG TECO TFAK |
100162999 | PRT PTBL RESA RMWB RÜCK SETC SSAP TABG TECO TFAK VORA WABE |
100163492 | NMAT PRT PTBL RESA RÜCK SETC SSAP TABG TECO TFAK |
100164509 | KPOK NMAT PRT PTBL RESA RÜCK SETC SSAP TABG TECO TFAK |
100941788 | ABGR ABRV ADVS CCOK CNF |
100946497 | ABGR ABRV ADVS CCOK CNF GMPS KKMP |
100950777 | GMPS KKMP KPOK MANC NMAT NMVP TECO |
100950874 | KPOK MANC NMAT NMVP PTBL TABG TECO |
100951880 | KKMP KPOK PCNF PTBL RESA SETC SSAP TABG TECO |
100952884 | ABGR ABRV ADVS CCOK CNF GMPS KKMP |
OrderNo Status
100123687 ABGR ABGS ABRV ADVS CCOK CLSD
100162353 KPOK NMAT PRT SSAP TABG TECO TFAK
100162887 CCOK CNF DRUC KKMP PTBL
100162989 CNF PTBL RESA RÜCK SETC SSAP TABG TECO TFAK
100162999 PRT PTBL RESA RMWB RÜCK SETC SSAP TABG TECO TFAK
100163492 NMAT PRT PTBL RESA RÜCK SETC SSAP TABG TECO TFAK
100164509 KPOK NMAT PRT PTBL RESA RÜCK SETC SSAP TABG TECO TFAK
100941788 ABGR ABRV ADVS CCOK CNF
100946497 ABGR ABRV ADVS CCOK CNF GMPS KKMP
100950777 GMPS KKMP KPOK MANC NMAT NMVP TECO
100950874 KPOK MANC NMAT NMVP PTBL TABG TECO
100951880 KKMP KPOK PCNF PTBL RESA SETC SSAP TABG TECO
100952884 ABGR ABRV ADVS CCOK CNF GMPS KKMP
OrderNo | Status |
100123687 | ABGR ABGS ABRV ADVS CCOK CLSD CMPL CNF DRUC GMPS KKMP KPOK NMAT PRT |
100162353 | KPOK NMAT PRT RESA RÜCK SETC SSAP TABG TECO TFAK |
100162887 | CCOK CNF DRUC KKMP PTBL |
100162989 | CNF PTBL RESA RÜCK SETC SSAP TABG TECO TFAK |
100162999 | PRT PTBL RESA RMWB RÜCK SETC SSAP TABG TECO TFAK VORA WABE |
100163492 | NMAT PRT PTBL RESA RÜCK SETC SSAP TABG TECO TFAK |
100164509 | KPOK NMAT PRT PTBL RESA RÜCK SETC SSAP TABG TECO TFAK |
100941788 | ABGR ABRV ADVS CCOK CNF |
100946497 | ABGR ABRV ADVS CCOK CNF GMPS KKMP |
100950777 | GMPS KKMP KPOK MANC NMAT NMVP TECO |
100950874 | KPOK MANC NMAT NMVP PTBL TABG TECO |
100951880 | KKMP KPOK PCNF PTBL RESA SETC SSAP TABG TECO |
100952884 | ABGR ABRV ADVS CCOK CNF GMPS KKMP |
you need to use load resident like that:
TableResident:
Load Count(OrderNo) as CountABGR
Resident Table
Where Status = 'ABGR'
or Status = 'ABGR ABRV';
And then peek fuction for asign in a variable:
LET vCountABGR = Peek('CountABGR',0,'TableResident')
using substring count solve the issue.
Thanks for your help.