As far as I know, there is no object type for List of Transaction template. But still you can do this by own. Just place a grid on your designed form. And use table ORCP to fetch the data and place it on the grid.
Thank for the reply. I did as you told me to do. But when I open the transaction template field in SAP it shows Recurrence field as like 'Every 1', Weekly something like this. But in database table it is going as '1' or something like integer.
Yes, you are right you need to do use a query using Case keyword. I have used it somewhere but I have not the content with me. Once I will get that I will make it provide it to you.
"Select code as Template, StartDate as 'Start Date', EndDate as 'Valid Until', case (Frequency) when 'M' then 'Monthly' when 'W' then 'Weekly' when 'D' then 'Daily' when 'Q' then 'Quarterly' when 'S' then 'Semiannually' when 'A' then 'Annually' when 'O' then 'One Time' end as 'Recurrence Period', CASE (DocObjType) when '13' then 'A/R Invoice' when '17' then 'Sales Order' when '23' then 'Sales Quotation' when '15' then 'Delivery' when '16' then 'Return' when '14' then 'A/R Credit Memo' when '203' then 'A/R Down Payment' end as 'Object Type', CASE(Remind) when '1001' then 'On 1' when '1002' then 'On 2'when '1003' then 'On 3'when '1004' then 'On 4'when '1005' then 'On 5'when '1006' then 'On 6'when '1007' then 'On 7'when '1008' then 'On 8'when '1009' then 'On 9'when '1010' then 'On 10'when '1011' then 'On 11'when '1012' then 'On 12'when '1013' then 'On 13'when '1014' then 'On 14'when '1015' then 'On 15'when '1016' then 'On 16'when '1017' then 'On 17'when '1018' then 'On 18'when '1019' then 'On 19'when '1020' then 'On 20'when '1021' then 'On 21'when '1022' then 'On 22'when '1023' then 'On 23'when '1024' then 'On 24'when '1025' then 'On 25'when '1026' then 'On 26'when '1027' then 'On 27'when '1028' then 'On 28'when '1029' then 'On 29'when '1030' then 'On 30'when '1031' then 'On 31' when '1' then 'On Sunday'when '2' then 'On Monday'when '3' then 'On Tuesday'when '4' then 'On Wednesday'when '5' then 'On Thursday'when '6' then 'On Friday'when '7' then 'On Saturday'when '101' then 'Every 1'when '102' then 'Every 2'when '103' then 'Every 3'when '104' then 'Every 4'when '105' then 'Every 5'when '106' then 'Every 6'when '107' then 'Every 7'when '108' then 'Every 8'when '109' then 'Every 9'when '110' then 'Every 10'when '115' then 'Every 15'when '130' then 'Every 30'when '145' then 'Every 45'when '160' then 'Every 60' end as 'Remind' from ORCP"
You can also filter this using 'Where' keyword if you want transaction template list for a particular document.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.