{"id":496,"date":"2024-11-26T13:09:44","date_gmt":"2024-11-26T12:09:44","guid":{"rendered":"https:\/\/www.pierre-vincent.com\/memosap\/?p=496"},"modified":"2024-11-26T13:09:44","modified_gmt":"2024-11-26T12:09:44","slug":"lsmw-data-manipulation","status":"publish","type":"post","link":"http:\/\/www.pierre-vincent.com\/memosap\/2024\/11\/26\/lsmw-data-manipulation\/","title":{"rendered":"LSMW data manipulation"},"content":{"rendered":"\n<p>When loading data with LSMW, you can be stuck by incorrect date formating : Here is how to convert a field read in the file in DDMY (no matter what date separator the loading file provide) to SAP Date format YYYYMMDD : Add the following in the Mapping &amp; Conversion Rules :<\/p>\n\n\n\n<p>MATMAS9-ZKDAT+0(2) = MATMAS09-ZKDAT+6.<br>MATMAS9-ZKDAT+2(2) = MATMAS09-ZKDA+4.<br>MATMAS9-ZKDAT+4(4) = MATMAS09-ZKDAT.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"808\" height=\"115\" src=\"https:\/\/www.pierre-vincent.com\/memosap\/wp-content\/uploads\/2024\/11\/image.png\" alt=\"\" class=\"wp-image-497\" srcset=\"http:\/\/www.pierre-vincent.com\/memosap\/wp-content\/uploads\/2024\/11\/image.png 808w, http:\/\/www.pierre-vincent.com\/memosap\/wp-content\/uploads\/2024\/11\/image-300x43.png 300w, http:\/\/www.pierre-vincent.com\/memosap\/wp-content\/uploads\/2024\/11\/image-768x109.png 768w, http:\/\/www.pierre-vincent.com\/memosap\/wp-content\/uploads\/2024\/11\/image-500x71.png 500w\" sizes=\"auto, (max-width: 808px) 100vw, 808px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>When loading data with LSMW, you can be stuck by incorrect date formating : Here is how to convert a field read in the file in DDMY (no matter what date separator the loading file provide) to SAP Date format &hellip; <a href=\"http:\/\/www.pierre-vincent.com\/memosap\/2024\/11\/26\/lsmw-data-manipulation\/\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,8,9],"tags":[],"class_list":["post-496","post","type-post","status-publish","format-standard","hentry","category-dev-tech-interface","category-mm","category-prod-planning"],"_links":{"self":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/comments?post=496"}],"version-history":[{"count":1,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/496\/revisions"}],"predecessor-version":[{"id":498,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/496\/revisions\/498"}],"wp:attachment":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/media?parent=496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/categories?post=496"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/tags?post=496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}