OINM AND OJDT Fields..

[Former Member]

Hi SAP Gurus,

i am trying to execute query based on common fields of OINM and OJDT Tables, but i am not able to find Common Fields between the two tables.

does any one have any idea..?

i appreciate your help...

Thanks and Regards,

kaviprashu

[Former Member]

Hi Kaviprashu

You can try:

FROM OINM T0 JOIN JDT1 T1 ON T1.Ref1=T0.Ref1 AND T1.TransType= T0.TransType

Thanks,

Gordon

[Former Member]

Hi,

Thanks Gordon, but the query is returning different values in OINM Table.

to check, i executed two queries below:

normally after Sales Delivery, journal entries are automatically updated in OINM Table,

and after invoice , journal entries are updated in OJDT/JDT1 Table.

actually i am trying to find the discrepancies between the two tables

i.e, which entries are missing between two tables.

i appreciate your help...

Thanks and Regards,

kaviprashu

[Former Member]

You need to check all data related to the JE and base documents. Analyze them to find them out. It is not a simple query.

[Former Member]

Hi,

sincere Thanks to all of you , SAP Gurus for assisting me, problem.solved...

Thanks and Regards,

kaviprashu