{"id":1472,"date":"2017-05-30T01:48:28","date_gmt":"2017-05-30T01:48:28","guid":{"rendered":"http:\/\/www.erpworkbench.com\/tutorials\/?p=83"},"modified":"2019-02-07T04:59:33","modified_gmt":"2019-02-07T04:59:33","slug":"setting-sap-rec-client-parameter","status":"publish","type":"post","link":"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/","title":{"rendered":"Setting SAP Rec\/Client Parameter for Logging database changes"},"content":{"rendered":"

First of all there is a very simple way to activate change history for database tables in SAP, including your own custom z tables. Within transaction SE11 simply go to menu option ‘Technical Settings’ and check the ‘Log data changes’ checkbox for your desired database table which will therefore instruct SAP to start recording all changes for this table. But before this will work you need to ensure that the rec\/client parameter is set to the appropriate entry from.<\/p>\n

Set Rec\/Client parameter to activate the log data changes via RZ11<\/h2>\n

<\/span><\/p>\n

Here are the available options for the rec\/client parameter with the default being ‘OFF’.<\/p>\n

OFF<\/span><\/p>\n

logging is turned off for all tables<\/p>\n

ALL<\/p>\n

\u200blogging is turned on for all tables<\/p>\n

Specific client i.e. 500,100…<\/p>\n

\u200blogging is turned on for specific clients. Cross-client tables are logged in all clients.<\/p>\n

\u200b<\/p>\n

Steps  to set the profile parameter rec\/client for table logging<\/h3>\n

1<\/span><\/p>\n

Call transaction RZ11.<\/span><\/p>\n

Execute transaction RZ11 and enter ‘rec\/client’ as the parameter that you want to change <\/p>\n

\"set<\/span>2<\/span><\/p>\n

<\/span>View Rec\/Client parameter value<\/span><\/p>\n

Now press the display button to see what the current value is. As you can see from this image the current value is set to 800 so it will only record change logs on SAP client 800 <\/p>\n

\"rec\/client<\/span>3<\/span><\/p>\n

Change Rec\/Client parameter value and save<\/span><\/p>\n

Now to change a parameter value you would need to use the menu option Edit->Change Value if available!!!<\/p>\n

\"change<\/span><\/p>\n

Unfortunately this is not available for this parameter as it is not dynamically changeable, which basically means you can’t change it on the fly without restating the system. To change the value of the rec\/client parameter you need to add\/change it via a parameter profile using RZ10<\/a><\/p>\n

…having said that at this point I will point out that it should really be the role of the basis team to change this value so at least get them involved and discuses any performance implications your requirement may have on the overall SAP landscape .<\/p>\n","protected":false},"excerpt":{"rendered":"

First of all there is a very simple way to activate change history for database tables in SAP, including your own custom z tables. Within transaction SE11 simply go to menu option ‘Technical Settings’ and check the ‘Log data changes’ checkbox for your desired database table which will therefore instruct SAP to start recording all […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[48,60],"tags":[],"yoast_head":"\nSetting SAP Rec\/Client Parameter for Logging database changes<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting SAP Rec\/Client Parameter for Logging database changes\" \/>\n<meta property=\"og:description\" content=\"First of all there is a very simple way to activate change history for database tables in SAP, including your own custom z tables. Within transaction SE11 simply go to menu option ‘Technical Settings’ and check the ‘Log data changes’ checkbox for your desired database table which will therefore instruct SAP to start recording all […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/\" \/>\n<meta property=\"og:site_name\" content=\"SAP Help, Training and Education\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-30T01:48:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-07T04:59:33+00:00\" \/>\n<meta property=\"og:image\" content=\"\/\/www.erpworkbench.com\/tutorials\/wp-content\/uploads\/2017\/05\/rz11.png\" \/>\n<meta name=\"author\" content=\"se80\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"se80\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/\",\"url\":\"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/\",\"name\":\"Setting SAP Rec\/Client Parameter for Logging database changes\",\"isPartOf\":{\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#website\"},\"datePublished\":\"2017-05-30T01:48:28+00:00\",\"dateModified\":\"2019-02-07T04:59:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/ddc6a049c1b0790f62d70278be75e511\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.se80.co.uk\/training-education\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting SAP Rec\/Client Parameter for Logging database changes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#website\",\"url\":\"https:\/\/www.se80.co.uk\/training-education\/\",\"name\":\"SAP Help, Training and Education\",\"description\":\"Learn SAP\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.se80.co.uk\/training-education\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/ddc6a049c1b0790f62d70278be75e511\",\"name\":\"se80\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3fd4e388f05bf3c763e46cd1f77afeb2?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3fd4e388f05bf3c763e46cd1f77afeb2?s=96&d=retro&r=g\",\"caption\":\"se80\"},\"url\":\"https:\/\/www.se80.co.uk\/training-education\/author\/se80\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting SAP Rec\/Client Parameter for Logging database changes","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/","og_locale":"en_US","og_type":"article","og_title":"Setting SAP Rec\/Client Parameter for Logging database changes","og_description":"First of all there is a very simple way to activate change history for database tables in SAP, including your own custom z tables. Within transaction SE11 simply go to menu option ‘Technical Settings’ and check the ‘Log data changes’ checkbox for your desired database table which will therefore instruct SAP to start recording all […]","og_url":"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/","og_site_name":"SAP Help, Training and Education","article_published_time":"2017-05-30T01:48:28+00:00","article_modified_time":"2019-02-07T04:59:33+00:00","og_image":[{"url":"\/\/www.erpworkbench.com\/tutorials\/wp-content\/uploads\/2017\/05\/rz11.png"}],"author":"se80","twitter_card":"summary_large_image","twitter_misc":{"Written by":"se80","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/","url":"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/","name":"Setting SAP Rec\/Client Parameter for Logging database changes","isPartOf":{"@id":"https:\/\/www.se80.co.uk\/training-education\/#website"},"datePublished":"2017-05-30T01:48:28+00:00","dateModified":"2019-02-07T04:59:33+00:00","author":{"@id":"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/ddc6a049c1b0790f62d70278be75e511"},"breadcrumb":{"@id":"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.se80.co.uk\/training-education\/setting-sap-rec-client-parameter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.se80.co.uk\/training-education\/"},{"@type":"ListItem","position":2,"name":"Setting SAP Rec\/Client Parameter for Logging database changes"}]},{"@type":"WebSite","@id":"https:\/\/www.se80.co.uk\/training-education\/#website","url":"https:\/\/www.se80.co.uk\/training-education\/","name":"SAP Help, Training and Education","description":"Learn SAP","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.se80.co.uk\/training-education\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/ddc6a049c1b0790f62d70278be75e511","name":"se80","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3fd4e388f05bf3c763e46cd1f77afeb2?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3fd4e388f05bf3c763e46cd1f77afeb2?s=96&d=retro&r=g","caption":"se80"},"url":"https:\/\/www.se80.co.uk\/training-education\/author\/se80\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/posts\/1472"}],"collection":[{"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/comments?post=1472"}],"version-history":[{"count":4,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/posts\/1472\/revisions"}],"predecessor-version":[{"id":1638,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/posts\/1472\/revisions\/1638"}],"wp:attachment":[{"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/media?parent=1472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/categories?post=1472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/tags?post=1472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}