🕖 TIMESTAMP field in SAP BW: How to insert into Transformation routine

Publicado porfelipelamounierPublicado emEN version, SAP BW

Welcome!
By Felipe Lamounier, state of Minas Gerais, Brazil – powered by 🙂My Easy B.I.

Let’s see how to put a TIMESTAMP field in a transformation in BW via ABAP routine.

Use the InfoObject 0H_TIMESTMP:

Screen in SAP BW showing the infoobject 0H_TIMESTMP

In the Transformation, create a routine for the TIMESTAMP field of InfoObject 0H_TIMESTMP, as per the ABAP code below:

* Variable
  data: lv_timestamp type tzonref-tstamps.

* Timestamp
  get time stamp field lv_timestamp.

* Timestamp InfoObjeto
  RESULT = lv_timestamp.

Code Explanation:

data: lv_timestamp type tzonref-tstamps.

This line declares a variable called lv_timestamp of type tzonref-tstamps. The type tzonref-tstamps is used to store timestamps with timezone information.

get time stamp field lv_timestamp.

This line gets the current timestamp from the system and stores it in the variable lv_timestamp.

RESULT = lv_timestamp

This line sets the field RESULT to the contents of the variable lv_timestamp. This means that the field RESULT will contain the current timestamp from the system, including timezone information

Anúncios
screen in SAP BW showing the rule in the transformation with abap code to get the timestamp

Feel free to leave any questions, suggestions, or comments in the comments section below, at the end of the page.

Keywords: Campo TIMESTAMP no SAP BW; TIMESTAMP in SAP BW routine; Implementing TIMESTAMP in SAP BW Transformations: A Step-by-Step Guide; How to Add TIMESTAMP Fields in SAP BW Using ABAP Routines; SAP BW TIMESTAMP; ABAP TIMESTAMP routine; how to insert TIMESTAMP in SAP BW transformation; using TIMESTAMP in SAP BW ABAP routines; step-by-step TIMESTAMP insertion in SAP BW

Did you like the content? Want to get more tips? Subscribe ↗ for free!

Junte-se a 970 outros assinantes

🔭See Also:

🔭 See also Pages:
🏠Home Page
💡Blog


🎓🚀Training&Education
🖼️Site Image Gallery

📚E-book: SAP BW and 2LIS Delta DataSource: How to Enhance without ECC PRD system downtime and Delta lost

🚀Go to↗ amazon.com

Want to learn more? Access our area 🎓🚀Training&Education↗

Follow on social media:

  • How to Find Deleted VTTK Transport in SAP ECC
    por felipelamounier
    Bem Vindo! | Welcome! By Felipe Lamounier, Minas Gerais, Brasil🇧🇷 – powered by 🙂My Easy B.I. 📑 Table of Contents: Introduction In this post, we will learn how to identify which transports were deleted in SAP ECC. We will also see how this data is removed from the VTTK table over a specific period. InContinuar lendo “How to Find Deleted VTTK Transport in SAP ECC”
  • How to identify SAP BW Process Chains with Recurring Errors
    por felipelamounier
    This post by Felipe Lamounier focuses on identifying recurring errors in Process Chains (RSPC) within SAP BW over a 65-day period. It provides a structured approach to filter and analyze execution logs, aimed at improving resource management and system efficiency by addressing improperly executed chains. The analysis concludes with recommendations for maintaining or removing chains based on error frequency.
  • How to Retrieve SAP Table Metadata Efficiently
    por felipelamounier
    This post by Felipe Lamounier provides a guide on efficiently retrieving metadata from SAP table fields using transaction SE16 and the DD03M view. Key elements include data element, data type, field length, and descriptions. Additionally, the post lists important SAP system tables, enhancing understanding of SAP metadata extraction.

Deixe um comentário