Connection between OCRT and OINV (SAP B1)

[barbaragalantin]

What's the connection between OCRT and OINV (SAP B1), please?

I saw this example: OINV ON OINV."DocEntry" = RCT2."DocEntry", but in my case this doesn't work. Do you, guys, know, other way?

[ManishPant · Accepted solution]

Hi @barbaragalantin ,

SELECT T0."DocNum",T0."InvoiceId",T0."DocEntry",T0."InvType",T0."SumApplied",T1."DocEntry",T1."DocNum"
FROM RCT2 T0
INNER JOIN OINV T1 ON T0."DocEntry" = T1."DocEntry" AND T0."InvType" = T1."ObjType";

I have tried this query in 5 different localisation SBO companies and each one gives me the correct result.
Could you please try this one or share the one you have prepared?

Thanks.

Manish

[barbaragalantin · Accepted solution]

It's right, I was doing a thing wrong! Thanks!!