List recurring transaction templates linked to a blanked agreement

[Former Member]

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

[former_member185682 · Accepted solution]

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

[Former Member · Accepted solution]

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

[former_member185682 · Accepted solution]

Hi Kim,

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

Kind Regards,

Diego Lother