{"id":137,"date":"2023-12-04T04:33:37","date_gmt":"2023-12-04T04:33:37","guid":{"rendered":"https:\/\/sapabap.dwimansolution.com\/?p=137"},"modified":"2023-12-04T04:33:37","modified_gmt":"2023-12-04T04:33:37","slug":"sap-abap-generate-demo-data","status":"publish","type":"post","link":"https:\/\/sapabap.dwimansolution.com\/index.php\/2023\/12\/04\/sap-abap-generate-demo-data\/","title":{"rendered":"SAP ABAP &#8211; Generate DEMO Data"},"content":{"rendered":"\n<p>In development golden client server, there should be no data. But when we have to testing some syntax sometime we need dummy data to proceed. SAP provides dummy data that we can use to learning or testing some syntax.<\/p>\n\n\n\n<p>Here I share to you the objects of that dummy data and how we generate or reset that.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"658\" src=\"https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-1024x658.png\" alt=\"\" class=\"wp-image-138\" srcset=\"https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-1024x658.png 1024w, https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-300x193.png 300w, https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-768x493.png 768w, https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-1536x987.png 1536w, https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-850x546.png 850w, https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image.png 1684w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>image from : https:\/\/blog.sap-press.com\/what-is-sflight-and-the-flight-and-booking-data-model-for-abap<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Here I sort the <strong>transaction data<\/strong> by their level <strong>(header to detail)<\/strong>:<\/p>\n\n\n\n<ol>\n<li>SPFLI: the flight schedules for each airline<\/li>\n\n\n\n<li>SFLIGHT: the actual flights for a flight schedule<\/li>\n\n\n\n<li>SBOOK : bookings for single flights.<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<p>These is the <strong>master data<\/strong> tables:<\/p>\n\n\n\n<ol>\n<li>SCARR: all the carriers (airlines).<\/li>\n\n\n\n<li>SCUSTOM: information about the customers.<\/li>\n\n\n\n<li>SAIRPORT: the airport IDs and information about the airports.<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<p>If you guys found the tables has an empty row, then go to SE38 and run program <strong>SAPBC_DATA_GENERATOR<\/strong> . It will generate and reset your data in the demo tables above. (If you have changes in your data this action will reset the data into the beginning state.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"867\" height=\"641\" src=\"https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-1.png\" alt=\"\" class=\"wp-image-139\" srcset=\"https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-1.png 867w, https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-1-300x222.png 300w, https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-1-768x568.png 768w, https:\/\/sapabap.dwimansolution.com\/wp-content\/uploads\/2023\/12\/image-1-850x628.png 850w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><\/figure>\n\n\n\n<p>just execute it and check again in your demo tables.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Enjoy \ud83d\ude42<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>References: <\/p>\n\n\n\n<p><a href=\"https:\/\/blog.sap-press.com\/what-is-sflight-and-the-flight-and-booking-data-model-for-abap\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/blog.sap-press.com\/what-is-sflight-and-the-flight-and-booking-data-model-for-abap<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In development golden client server, there should be no data. But when we have to testing some syntax sometime we need dummy data to proceed. SAP provides dummy data that we can use to learning or testing some syntax. Here I share to you the objects of that dummy data and how we generate or&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/137"}],"collection":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/comments?post=137"}],"version-history":[{"count":1,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/137\/revisions"}],"predecessor-version":[{"id":140,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/137\/revisions\/140"}],"wp:attachment":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/media?parent=137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/categories?post=137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/tags?post=137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}