Skip to Content
0

List recurring transaction templates linked to a blanked agreement

Nov 30, 2016 at 03:59 PM

29

avatar image
Kim Chenot

Hello,

for a project I need to be able to list all the recurring transaction templates that are linked to a particular blanket agreement. Is it possible? They're not appearing in the ORCP or OOAT tables, so i don't know where to look for them.
For example, I've a blanket agreement regarding a BP, this agreement has 3 recurring transaction templates. I'd like to be able to list them with a query

Thanks

SAP Business One
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
DIEGO LOTHER Answered Nov 30, 2016 at 04:13 PM
0

Hi Kim

You are able to get this information linking the OOAT table with OAT4 and then with ORCP.

Look this sample:

SELECT 
	T0.Number,
	T0.BpCode,
	T0.BpName,
	T2.Code,
	T2.DocObjType,
	T2.DraftEntry
FROM
	OOAT T0
	INNER JOIN OAT4 T1 ON T0.AbsID = T1.AgrNo
	INNER JOIN ORCP T2 ON T2.AbsEntry = T1.RcpEntry

Kind Regards,

Diego Lother

Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Kim Chenot
Nov 30, 2016 at 04:25 PM

Thank you very much. I'm new to sap and i've been looking for that info for hours... I feel stupid because when I read your answer it's so logic and no so complicated

0
DIEGO LOTHER
Kim Chenot
Nov 30, 2016 at 04:49 PM

Hi Kim,

Don't worry and Welcome to SAP Business One Forum.

Kind Regards,

Diego Lother

0
Comment