Skip to Content
avatar image
Former Member

List recurring transaction templates linked to a blanked agreement

Nov 30, 2016 at 03:59 PM | 41 Views

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    DIEGO LOTHER
    Nov 30, 2016 at 04:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded