4 weeks ago
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?
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
105 | |
39 | |
6 | |
5 | |
4 | |
3 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.