Default Print Layout Design selected for different SAP Users

[kedalenechong]

Hi all

Is it possible to read the selected Default Print Layout Design for Sales Invoice for different SAP Users at one goal?

Kedalene

[KennedyT21 · Accepted solution]

Try This

SELECT T3.NAME AS 'TEMPLATE TYPE',

      (T0.DFLTREPORT+ ' ' + '-' +' ' +

       T2.DOCNAME) as' DEFAULT TEMPLATE',

       CASE T0.USERID

         WHEN '-1' THEN 'All Users'

         ELSE T1.U_NAME

       END  AS 'FOR WHICH USER',

       CASE T0.CARDCODE

         WHEN '-1' THEN 'For All BPs'

         ELSE T0.CARDCODE

       END AS 'FOR WHICH BP Code'

FROM   RDFL T0

       LEFT JOIN OUSR T1

         ON T0.USERID = T1.INTERNAL_K

       INNER JOIN RDOC T2

         ON T0.DFLTREPORT = T2.DOCCODE

       INNER JOIN RTYP T3

         ON T0.DOUMNTDODE = T3.CODE

WHERE  T0.DOUMNTDODE = '[%0]'

Rgds

Kennedy

[kedalenechong · Accepted solution]

Hi Kennedy

How to fill in the Code parameter?

[KennedyT21 · Accepted solution]

The Layout ID, or this below query

SELECT  T0.DOUMNTDODE , T3.NAME AS 'TEMPLATE TYPE',

      (T0.DFLTREPORT+ ' ' + '-' +' ' +

       T2.DOCNAME) as' DEFAULT TEMPLATE',

       CASE T0.USERID

         WHEN '-1' THEN 'All Users'

         ELSE T1.U_NAME

       END  AS 'FOR WHICH USER',

       CASE T0.CARDCODE

         WHEN '-1' THEN 'For All BPs'

         ELSE T0.CARDCODE

       END AS 'FOR WHICH BP Code'

FROM   RDFL T0

       LEFT JOIN OUSR T1

         ON T0.USERID = T1.INTERNAL_K

       INNER JOIN RDOC T2

         ON T0.DFLTREPORT = T2.DOCCODE

       INNER JOIN RTYP T3

         ON T0.DOUMNTDODE = T3.CODE

Hope helpful

Regards

Kennedy

[kedalenechong · Accepted solution]

Hi Kennedy

no data at all.

I am not able to enter Layout ID like RDR20002 in the earlier Query?

[Former Member · Accepted solution]

Hi Kedalene,

Try:

SELECT T3.NAME AS 'TEMPLATE TYPE',

      (T0.DFLTREPORT+ ' ' + '-' +' ' +

       T2.DOCNAME) as' DEFAULT TEMPLATE',

       CASE T0.USERID

         WHEN '-1' THEN 'All Users'

         ELSE T1.U_NAME

       END  AS 'FOR WHICH USER',

       CASE T0.CARDCODE

         WHEN '-1' THEN 'For All BPs'

         ELSE T0.CARDCODE

       END AS 'FOR WHICH BP Code'

FROM   RDFL T0

       LEFT JOIN OUSR T1

         ON T0.USERID = T1.INTERNAL_K

       INNER JOIN RDOC T2

         ON T0.DFLTREPORT = T2.DOCCODE

       INNER JOIN RTYP T3

         ON T0.DOUMNTDODE = T3.CODE

WHERE  T0.DOUMNTDODE LIKE '[%0]%'

Thanks,

Gordon

[kedalenechong · Accepted solution]

Hi Gordon

Thanks but the result gives no data too.

I am not able to type RDR20002 at all in the Code.

[Former Member · Accepted solution]

Can you type rdr2 instead?

[kedalenechong · Accepted solution]

Hi Gordon

Thanks for your reply.

I tried RDR2 result is no data.

I tried removed the selection criteria it shows only Inventory Status Report Template.

So there is data if I enter ITM in selection criteria.

[kedalenechong · Accepted solution]

Hi Kennedy

There data for Inventory status report template only.

[KennedyT21 · Accepted solution]

Share Tv to check the same...

[kedalenechong · Accepted solution]

Hi Kennedy

What is Share TV?

[KennedyT21 · Accepted solution]

Share Team viewer  access to your system to check the same... Usi

[kedalenechong · Accepted solution]

Hi Kennedy

You mean you can see more report templates in your own Database? 

I am testing in Demo Database only

[KennedyT21 · Accepted solution]

Try This

SELECT T0.DOUMNTDODE,

       T3.NAME AS 'TEMPLATE TYPE',

       (T0.DFLTREPORT + ' ' + '-' + ' ' + T2.DOCNAME) AS ' DEFAULT TEMPLATE',

       CASE T0.USERID

            WHEN '-1' THEN 'All Users'

            ELSE T1.U_NAME

       END AS 'FOR WHICH USER',

       CASE T0.CARDCODE

            WHEN '-1' THEN 'For All BPs'

            ELSE T0.CARDCODE

       END AS 'FOR WHICH BP Code'

FROM   RDFL T0

       LEFT JOIN OUSR T1

            ON  T0.USERID = T1.INTERNAL_K

       LEFT OUTER JOIN RDOC T2

            ON  T0.DFLTREPORT = T2.DOCCODE

       LEFT OUTER JOIN RTYP T3

            ON  T0.DOUMNTDODE = T3.CODE

Regards

Kennedy

[kedalenechong · Accepted solution]

Hi Kennedy

The result is still the same.

[KennedyT21 · Accepted solution]

What is the output you get...

Regards

[kedalenechong · Accepted solution]