cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction Type OF OINM TABLE

MED_KADRI
Explorer
0 Kudos
154

 

Hello All,

I have successfully extracted data from the OINM table in SAP B1 10.0.

Could you please provide details on the types of transactions recorded in this table?

the transactions here :

Thank you for your assistance.

 

Transaction Type
310000001
20
60
67
59
21
19
18
202
15
10000071
69
View Entire Topic
JoseLuisCastillo
Explorer
0 Kudos

in SAP B1, OINM not is a table, is a View that is make for:

[OIVL] T0 INNER JOIN [IVL1] T1 ON T0.[TransSeq] = T1.[TransSeq] 

LEFT OUTER JOIN [OIVQ] T2 ON T1.[TransSeq] = T2.[TransSeq] AND T1.[LayerID] = T2.[LayerID] 

INNER JOIN [OIVK] T3 ON T1.[TransSeq] = T3.[TransSeq] AND T1.[LayerID] = T3.[LayerID] 

INNER JOIN [OILM] T4 ON T0.[MessageID] = T4.[MessageID] 

LEFT OUTER JOIN [OADM] T5 ON T5.[Code] = T5.[Code]

If you make a Query is best use this tables.