SAP BI: Making a selection by using ABAP, AMDP, CDS View or Python from new finance S4 table "ACDOCA"

Context: Comparative of using different techonologies to make a select from new "acdoca" table which contains all data related to FI posting documents. Also it will be provided a few examples to explore different ways to achieve this goal. 



1. ABAP:  using new abap code as it's displayed here, defining a table at very moment when we're using at a local table "result", that happens by using @.



2. ABAP Managed Database Procedures (AMDP):


2.1 Call AMDP in ABAP



3. CDS View:  abap perspective Eclipse or SAP Hana both work.


4. Python (with SAP HANA DB Connection)
    
    Connection has to be established first.
 

Btw this article was partially written by AI ChatGPT4.0

If you've finished the page you're brave! :) 

Thanks!!

Popular posts from this blog

Exploring SAP Analytics Cloud: Scripting Features

Image
Exploring SAP Analytics Cloud: Scripting Features to Enhance Dashboards SAP Analytics Cloud (SAC) is a powerful tool that allows users to build interactive dashboards and reports. Beyond the drag-and-drop interface, SAC also offers scripting capabilities through Analytic Application that allow for more dynamic interactions and customization. Let’s explore how you can use scripting in SAC to enhance your dashboard. 1. Adding a Measure to a Widget (Bar Chart) You can programmatically add or change measures in a chart widget, which allows for dynamic customization of the data being displayed. Here's how you can add a measure to a bar chart using a script. In this example: Chart_1 is the ID of your bar chart widget. The getDataSource() method retrieves the chart’s data model. The new measure, "Gross Margin" , is added to the list and applied to the chart. 2. Changing a Dimension Programmatically Similarly, you can modify a dimension in a chart or table through scripting. T...
Read more

SAP Business Technology Platform (BTP) offers tools such as...

Image
 SAP Business Technology Platform (BTP) offers a wide range of tools and services that can be classified into several categories: 1. Database & Data Management SAP HANA Cloud : A high-performance in-memory database that allows real-time data processing, analytics, and complex calculations. It's optimized for SAP applications but flexible enough for other use cases. SAP Data Intelligence : A tool to manage, integrate, and orchestrate data pipelines from various sources, supporting hybrid cloud and multi-cloud environments. SAP Master Data Governance : Ensures data consistency across different business units by providing a central framework for managing and distributing master data. 2. Analytics SAP Analytics Cloud (SAC) : A powerful, all-in-one platform for business intelligence (BI), augmented analytics, and financial planning, offering dashboards, reporting, and machine learning integration. SAP Data Warehouse Cloud : A data management and modeling service that provides a sing...
Read more