cancel
Showing results for 
Search instead for 
Did you mean: 

Business Partner Series from SeriesSerivce

anrodse
Participant
0 Kudos

I've seen I can query document series by document type, but it seems there is nothing for IC or Items.

Is it possible to query IC series series using the series service?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

agustin_marcoscividanes
Active Contributor

Hi

you have as objectcode '4' for IC and '2' for items.

The tables are ONNM and NNM1.

Kind regards

Agustín

Answers (1)

Answers (1)

MD1
Active Contributor

try this

---FMS
SELECT T0."SeriesName"
FROM NNM1 T0
WHERE T0."ObjectCode" = '4' AND T0."Series" = $[OITM."Series"]
----Document query
SELECT *
FROM OIGN T0
INNER JOIN IGN1 T1 ON T0."DocEntry" = T1."DocEntry"
INNER JOIN NNM1 T2 ON T0."Series" = T2."Series"

anrodse
Participant
0 Kudos

I was trying to use DI Api, not sql query. Thank you anyway!