cancel
Showing results for 
Search instead for 
Did you mean: 

If any CDS view or API to get serial number's status status

Bin_Eric_Hou
Participant
0 Kudos

Hi expert,

Does any CDS view or API exist to allow me to get stock status of serial number?

Thanks,

Eric

Accepted Solutions (1)

Accepted Solutions (1)

Enda
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Eric ,

The app "View Browser" shows all CDS views available . Unfortunately for Serial Numbers the CDS views available such as I_SerialNumberStockSegment are not released yet

(https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F2170')/S15OP )

A Feature request would be needed as outlined in the KBA 2780129 for such as CDS view or API to be created to allow this

Best Regards

Enda

Answers (1)

Answers (1)

NIZAR_KHELIFI
Explorer
0 Kudos

define view ZPM_GET_ORDER_SERV

as select from aufk as A

inner join jest as J

on J.objnr = A.objnr

{ // A.aufnr,

J.stat ,

count(*) as tot_ordre }

where //A.autyp = '10' and

//J.inact = '' and

// TJ02T table System status texts

J.stat <> 'I0001' or // CRTD = Created

J.stat <> 'I0002' or // DLFL = deletion flag

J.stat <> 'I0045' or // TECO = technically completed

J.stat <> 'I0046' or // CLSD = closed

J.stat = 'I0002' or //REL = released

J.stat = 'I0009' or //CNF = confirmed

J.stat = 'I0010' //PCNF = partially confirmed

group by J.stat