{"id":7747,"date":"2021-10-11T08:00:31","date_gmt":"2021-10-11T06:00:31","guid":{"rendered":"http:\/\/192.168.20.3\/?p=7747"},"modified":"2024-12-11T09:24:52","modified_gmt":"2024-12-11T08:24:52","slug":"creacion-alvs-dinamicos","status":"publish","type":"post","link":"https:\/\/orekait.com\/es\/creacion-alvs-dinamicos\/","title":{"rendered":"Creaci\u00f3n de ALVs din\u00e1micos<br><span class=\"font-300\"><\/span>"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_row admin_label=&#8221;Imagen principal&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_image src=&#8221;https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/alvs-dina.png&#8221; alt=&#8221;cloud-public&#8221; title_text=&#8221;alvs-dina&#8221; admin_label=&#8221;Imagen principal&#8221; module_class=&#8221;post-img&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;Cuerpo&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text admin_label=&#8221;Texto&#8221; _builder_version=&#8221;4.25.2&#8243; header_2_font_size=&#8221;24px&#8221; header_3_font_size=&#8221;20px&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; content__hover_enabled=&#8221;off|desktop&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p>En este art\u00edculo, vamos a entrar a hablar de la<strong>\u00a0t\u00e9cnica para crear ALVs din\u00e1micos<\/strong>\u00a0mediante un ejemplo pr\u00e1ctico.<\/p>\n<p>Al realizar un\u00a0<strong>programa Z<\/strong>, podemos mostrar el resultado a trav\u00e9s de un\u00a0<strong>ALV ajustado a las necesidades<\/strong>\u00a0que se requieran. Usando dicha herramienta, existe la opci\u00f3n de crear un ALV din\u00e1mico. \u00a0Un\u00a0<strong>ALV<\/strong>\u00a0din\u00e1mico nos da la opci\u00f3n de ir generando tantas columnas como datos recupere durante la ejecuci\u00f3n.<\/p>\n<p>En este caso, se mostrar\u00e1n un<strong>\u00a0n\u00famero m\u00e1ximo de columnas generadas din\u00e1micamente<\/strong>\u00a0en base por ejemplo a el documento que tenga m\u00e1s posiciones. Es decir, si encuentra 5 documentos y cada documento tiene varias posiciones, y uno de ellos tiene 4 posiciones y el resto menos, se mostrar\u00e1n 4 columnas generadas din\u00e1micamente.<\/p>\n<p><strong>Se puede aplicar a otras l\u00f3gicas y no s\u00f3lo a documentos y posiciones.<\/strong><\/p>\n<p>Para este\u00a0<strong>ejemplo\u00a0<\/strong>se han usado las tablas<strong>\u00a0SCARR y SFLIGHT<\/strong>. Se mostrar\u00e1n por compa\u00f1\u00eda los n\u00fameros de vuelos totales por columna, siendo el n\u00famero de vuelos totales que tenga una compa\u00f1\u00eda el n\u00famero m\u00e1ximo de las columnas que se generar\u00e1n.<\/p>\n<p>La<strong>\u00a0clave<\/strong>\u00a0a usar ser\u00eda:<\/p>\n<p><strong>cl_alv_table_create<\/strong><\/p>\n<p>Las columnas a mostrar ser\u00e1n, id de la compa\u00f1\u00eda, nombre de la compa\u00f1\u00eda y la moneda de la tabla SCARR y los campos n\u00famero de vuelo y fecha de vuelo ser\u00e1n los que se crear\u00e1n din\u00e1micamente.<\/p>\n<p>En el programa que hemos creado para realizar el ejemplo, en la pantalla de selecci\u00f3n<strong>\u00a0insertamos el id de la compa\u00f1\u00eda<\/strong>:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7756 \" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-1-1.png\" alt=\"\" width=\"404\" height=\"231\" \/><\/figure>\n<\/div>\n<p>El<strong>\u00a0resultado\u00a0<\/strong>de la ejecuci\u00f3n ser\u00eda este:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7760 size-full\" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-2.png\" alt=\"\" width=\"1751\" height=\"135\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-2.png 1751w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-2-1280x99.png 1280w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-2-980x76.png 980w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-2-480x37.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) and (max-width: 1280px) 1280px, (min-width: 1281px) 1751px, 100vw\" \/><\/figure>\n<\/div>\n<p>De la compa\u00f1\u00eda DL hay 3 vuelos y AA tiene 2, mostrando as\u00ed el m\u00e1ximo n\u00famero de vuelos.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7764 \" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-3-1.png\" alt=\"\" width=\"515\" height=\"283\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-3-1.png 515w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-3-1-480x264.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 515px, 100vw\" \/><\/figure>\n<\/div>\n<p>De la compa\u00f1\u00eda AA, hay varios vuelos en distintas fechas. Nos quedamos con el vuelo m\u00e1s reciente, teniendo as\u00ed un \u00fanico vuelo.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7768 \" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-4.png\" alt=\"\" width=\"521\" height=\"494\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-4.png 521w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-4-480x455.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 521px, 100vw\" \/><\/figure>\n<\/div>\n<p>Para la compa\u00f1\u00eda DL hacemos lo mismo.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7772 \" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-5-1.png\" alt=\"\" width=\"523\" height=\"463\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-5-1.png 523w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-5-1-480x425.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 523px, 100vw\" \/><\/figure>\n<\/div>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7776 \" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-6-1.jpg\" alt=\"\" width=\"514\" height=\"515\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-6-1.jpg 514w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-6-1-480x481.jpg 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 514px, 100vw\" \/><\/figure>\n<\/div>\n<p>Otro ejemplo m\u00e1s para ver que se est\u00e1 haciendo el\u00a0<strong>ALV din\u00e1mico<\/strong>:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7780 size-full\" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-7.jpg\" alt=\"\" width=\"676\" height=\"42\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-7.jpg 676w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-7-480x30.jpg 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 676px, 100vw\" \/><\/figure>\n<\/div>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7784 \" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-8.png\" alt=\"\" width=\"570\" height=\"86\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-8.png 570w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/10\/ALV-8-480x72.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 570px, 100vw\" \/><\/figure>\n<\/div>\n<p>En esta ocasi\u00f3n se muestran los cinco vuelos que tiene la compa\u00f1\u00eda LH.<\/p>\n<p>Esperamos que estos ejemplos te hayan sido de utilidad para entender\u00a0<strong>qu\u00e9 posibilidades nos da un ALV din\u00e1mico y en qu\u00e9 casos de uso tiene sentido utilizarlos<\/strong>. No dudes en exponer tus dudas en comentarios o contactar con nosotros.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;M\u00e1s informaci\u00f3n&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"morado\">M\u00e1s informaci\u00f3n:<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/orekait.com\/es\/area-finanzas&#8221; button_text=&#8221;M\u00e1s informaci\u00f3n&#8221; module_class=&#8221;entrada-btn&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#8156EA&#8221; button_bg_color=&#8221;RGBA(255,255,255,0)&#8221; button_border_color=&#8221;#8156EA&#8221; button_border_radius=&#8221;30px&#8221; button_font=&#8221;Plus Jakarta Sans|600|||||||&#8221; button_icon=&#8221;&#x24;||divi||400&#8243; button_icon_color=&#8221;#8156EA&#8221; button_on_hover=&#8221;off&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; button_text_color__hover_enabled=&#8221;on|desktop&#8221; button_text_color__hover=&#8221;#8156EA&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;#8156EA&#8221; button_bg_enable_color__hover=&#8221;on&#8221; button_icon_color__hover_enabled=&#8221;on|hover&#8221; button_icon_color__hover=&#8221;#ffffff&#8221; url_new_window=&#8221;on&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||40px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row use_custom_gutter=&#8221;on&#8221; admin_label=&#8221;Noticias relacionadas titulo&#8221; module_id=&#8221;fondo-articulos&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f7f7f7&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; custom_margin=&#8221;||40px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_heading title=&#8221;Quizas te pueda interesar&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; title_level=&#8221;h2&#8243; title_text_align=&#8221;center&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_heading][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||30px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;Noticias relacionadas&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;-150px||||false|false&#8221; custom_margin_tablet=&#8221;0px||||false|false&#8221; custom_margin_phone=&#8221;0px||||false|false&#8221; custom_margin_last_edited=&#8221;on|desktop&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_blog fullwidth=&#8221;off&#8221; posts_number=&#8221;3&#8243; include_categories=&#8221;current&#8221; show_author=&#8221;off&#8221; show_date=&#8221;off&#8221; show_pagination=&#8221;off&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_blog][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En este art\u00edculo, vamos a entrar a hablar de la\u00a0t\u00e9cnica para crear ALVs din\u00e1micos\u00a0mediante un ejemplo pr\u00e1ctico. Al realizar un\u00a0programa Z, podemos mostrar el resultado a trav\u00e9s de un\u00a0ALV ajustado a las necesidades\u00a0que se requieran. Usando dicha herramienta, existe la opci\u00f3n de crear un ALV din\u00e1mico. \u00a0Un\u00a0ALV\u00a0din\u00e1mico nos da la opci\u00f3n de ir generando tantas [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":7750,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"Lorem ipsum dolor sit amet consectetur adipiscing elit congue montes, imperdiet taciti erat elementum fermentum sem ante ultrices ridiculus, sagittis sociis egestas quisque ac semper quis odio. Aenean hendrerit ac metus dis nascetur aliquet mollis integer, rutrum vel laoreet posuere proin sagittis luctus est, tempus duis nisl ultrices parturient tempor praesent. Dignissim curabitur nascetur pellentesque augue fringilla pulvinar eros, tempus fames vehicula maecenas cubilia id, rutrum euismod integer ut scelerisque mus.\r\n\r\nVivamus auctor odio aenean rhoncus natoque dictum purus, volutpat pellentesque laoreet ridiculus consequat nisi varius euismod, augue platea convallis curae magnis taciti. Imperdiet nibh curabitur quisque orci consequat aenean pellentesque, cubilia duis senectus felis sed posuere tortor, magnis enim diam a odio sociis. Enim tellus nisl nec molestie augue luctus tempor habitant, nunc dictumst phasellus volutpat sem facilisis taciti, habitasse laoreet at turpis vel fermentum vulputate.","_et_gb_content_width":"","footnotes":""},"categories":[39,40],"tags":[],"class_list":["post-7747","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finanzas","category-sap-fi"],"_links":{"self":[{"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/posts\/7747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/comments?post=7747"}],"version-history":[{"count":6,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/posts\/7747\/revisions"}],"predecessor-version":[{"id":21386,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/posts\/7747\/revisions\/21386"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/media\/7750"}],"wp:attachment":[{"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/media?parent=7747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/categories?post=7747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/tags?post=7747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}