Currency in SAP

When Korean / Japanese currency is being used 

In BW, 

Net price = 87.124

In BOBJ

Net Price = 871.24

It’s a factor based on the existence of an entry in TCURX for the corresponding CURRKEY.

Copying a Data Flow in Microsoft Power BI

Copying a Data Flow in Microsoft Power BI

Dataflows cannot be changed /copied directly. We need to download the .json file and import it in a new data flow.

Step 1

Select the dataflow you want to copy and click on the last icon, It should give you options like below. select the 'Export .json' and it will download the .json file on to your desktop.

Step 2

Go to new data flow and select the 'Import Model' option.

Step 3 

Once the file is selected, you get below pop up saying it is being imported and after successful import, you can see the dataflow in your list.

You are the owner of the newly uploaded dataflow and you can make any changes you want.

Error and Corrections

Error

"Invalid dataflow parameter. Exception details : The AllowNativeQueries attribute of the mashup is set to true for this dataflow definition. For security reason, AllowNativeQueries should be set to false, and try again."

Correction

Change the attribute '"allowNativeQueries":false' to true ( "allowNativeQueries":true) and try importing again. It should go through.

Please make sure that you have access to the underlying database.

Other Links to Refer

How to make a copy of Power BI dataflow

CRM Datasources

CRM Datasources

0CRM_SRV_CONTRACT_H
CRM Service Contract Header Data


0CRM_SALES_CONTR_I
CRM Sales Contracts: Item

FM Based Datasource

Points to Remember
------------------------

• When running the datasource in RSA3 for multiple packets, data will be repeated in different packets. 
• For say, Single packet call captured 500 entries, when you run for multiple packets (3), you might get first call with 500, 2nd call with 150 and 3rd call with 90 records. If you compare the data, you can see that, the first 500 are the right values and the other 150 and 90 are duplicates from the 500 set.

• Use STATICS during declaration if you want to retain the values in a table for all data packets.
• When using multiple packets, data gets refreshed in the internal table for each iteration. Declaring the tables.variable with STATICS will hold the values through out the execution for tables which need to be selected only once functionally.

CRM Tables

CRM Tables

Tables	Description
CRMD_ORDERADM_H	Business Transaction - Header
CRMD_ORDERADM_I	Business Transaction - Item
CRMD_SERVICE_H	Service Process
CRMD_SERVICE_I	Transaction Item - Service
CRMD_CUSTOMER_H	Transaction - Customer Extension
CRMD_CUSTOMER_I	Transaction Item - Customer Extension
CRM_JEST	Individual Object Status
CRM_JCDS	Change Documents for System/User Statuses (Table JEST)