ODP

Introduction

Operational Data Provisioning provides a technical infrastructure that you can use to support two different application scenarios. 

- Operational analytics for decision making in operative business processes. 

- Data extraction and replication.

Here mostly we will talk only about Data Extraction and Replication ( and mostly to BW ).

The R.H.S shows Providers which supply data to ODQ which is read by Consumers ( Subscribers ).
Eg : Here, Datasource ( Extractors ) basically refers to BW Extractors ( eg: 0FI_AP_4 or 2LIS_02_ACC etc.).
Once the datasources are ODP enabled ( SAP Note 0002232584 ) , They act as ODP Providers.
When BW System is reading data from ODQ, it becomes the subscriber.

One Source can provide data to multiple subscribers.
0FI_AP_4 Data can be read by SAP BW, SAP Data Services etc.

Context
A context represents a source of ODPs.
( Providers - Like sources which can be used - like SAP Extractors, HANA Views ? ).
Context identifiers exist for all technologies whose analytical views can be exposed as ODPs.
Determination of available contexts in system is done
via CL_RODPS_DEFAULT_CONTEXT->GET_CONTEXT_LIST


The main advantage of ODP in BW is we need not use PSA anymore ( that also means, we cannot correct invalid records in PSA - May be we can use Error DTPs ? )

ODP FAQs       - Click HERE
ODP Overview - Click HERE

Creating a ODP Datasource
Creating and ODP datasource is same as regular datasources.
If you know the datasource already exists in your source system, you can either replicate the datasource or create a datasource by right clicking.
Make sure that the datasource is ODP enabled before creating.Running BS_ANLY_DS_RELEASE_ODP make a datasource available as an ODP.

You can use the same name as the regular datasource and rename it.
once the datasource / transformation / DTP is created, run the DTP and it will create an entry in ODQMON.

Points to Remember

• Check if a datasource is ODP enabled. If the right hand side icon is Green, it is released and can be used. If red, we need to implement below mentioned note and other steps to make them available.

• Implement SAP Note 0002232584 to release datasources to ODP. 
• This will install program BS_ANLY_DS_RELEASE_ODP when executed, This program add entry in table ROOSATTR and makes field EXPOSE_EXTERNAL = ‘X’.
• Run program RODPS_OS_EXPOSE to expose zdatasources to ODP.
• Not all datasources in the excel sheet are relaeased
• Not all datasources are released for ODP. Go to RSA5/6 and check the datasource. If the datasource is in red  , it means it is not released for ODP.
•   Eg: 0EQUIPMENT_ATTR
•   Check Note 2173041
• Initialization
• There is no separate initialization. DTP when run for the first time, does initialization along with data load. There is an option to do init with out data transfer ( Delta init with out data).
• When the DTP is run again, it will act as Delta DTP.
• Delta Functionality
• Everything remains same the jobs in the background. It's just that the collective job would now write to ODQMON. If the same data source is used for traditional approach as well then the delta would be written to both ODQMON and RSA7.

Change Mode Field : ODQ_CHANGEMODE
'C' The data record was created as new record in the source.
'U' The data record was changed in the source. Depending on the delta procedure, the delta can contain up to two data records for one changed record in the source.
'D' The data record was deleted from the source.

ODP Tables

Tables	Description	Extra Notes
ODQDATA	Data Store for Delta	Contains all compressed Delta request Data
ODQDATA_F	Data Storage for One-Off Extraction	Contains compressed Full request Data
ODQDATA_C	Data Storage for Delta Init.	Contains compressed Init request Data
ODQREQ	Operational DeltaQueue: General Request

ODP TCodes & Std.Programs

Name	Description	Extra Notes
ODQMON	ODP Delta monitor	Monitor for all delta queues : Notes
ODP_CLEANUP	Clean up program	Notes
RODPS_REPL_TEST	Check data in the delta - Like RSA3	Notes
BS_ANLY_DS_RELEASE_ODP	Releases datasources to ODP	SAP Notes 2232584
RODPS_OS_EXPOSE	Release Z Datasources to ODP

Errors and Solutions

Click HERE

DTP Failures

Subscription for DTP_ deleted in source system ODP...... See long text.

Online content
Data Acquisition with ODP and SLT (SAP) - Video
Reporting on Operational Data Providers     - Link
Data Loading to BW From ECC using ODP – SAP HANA Information Views - Link
Logistics(LO) Extraction with ODP Framework - Link

Core Data Services

Introduction

ABAP Core Data Services - Introduction ( ABAP CDS View ) - Click HERE 

Points to Remember

• CDS started with BW 7.4 but is more effective from BW 7.5
• CDS Views need to be transported from system to system
• Created using eclipse interface
• Used to create complex joins
• Can be read from IDT

Syntax

Tables	Description	Link/Notes
Remove Leading Zeroes	ltrim(matnr,'0') as Matnr_Test	link
Substring	substring(date,1,4) as begin_year,
Concatenation	concat('A','B') Nested concat concat(substring(date,1,4),concat(concat('-',substring(date,5,2)),concat('-',substring(date,7,2)))) as Start_date1,	concat only takes 2 parameters at a time. if you need more than one concatenation, you need to nested concat statements link

Useful Notes

Task	Notes
Renaming CDS View	CDS views cannot be renamed once they are transported to another system ( link )
Search for view	CTRL+SHIFT+A ( link )

ABAP Messages

If there is an output message coming in the below format
 message id sy-msgid type 'S' number sy-msgno
          with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

You can actually pas the whole message into a text variable using INTO
 message id sy-msgid type 'S' number sy-msgno  INTO DATA(lv_error_text)
          with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

Email Settings in SAP

SAPCONNECT is used to maintain and send emails within SAP and out of SAP.

Tcode :
SCOT - SAP Connet
This is the main screen for all email related stuff.

Create 'Send Jobs'
A job needs to be scheduled in the system to trigger the emails which are present in the queue. In Tcode SCOT -> Settings -> Send Jobs.
Create a job here and schedule it.


SOST - SAPCONNECT Send request Queue

Configuring Outgoing emails in SAP in Process Chain
Make sure SAPCONNECT is configured.
In the Process Chain --> Right Click on the step you want to add email --) Check Option - Create Message and follow the screens and you should be able to create an email for that step.


Emails not being sent
There can be various reasons for emails not being sent. below are some items to check.

Look in STMP settings if 'Node in Use' is checked. If not, check that.

This can be done as follows.
Settings -> SMTP Connection -> Outbound Messages -> SMTP nodes.

http://www.postalmethods.com/send-mail-from/sap-r3/how-to/configure-outgoing-email-in-sap


Errors
Cannot process message; no node determined for
https://www.stechies.com/error-xs826-cannot-process-message-node-determined-occurs-w/

CHARM

CHARM - Change Manager

Cannot create transport of copies Error [ Crude way of checking ]
Go to the application log on the top of the page and once that opens click on the "create transports" which has status RED.
check for the error message.
Take the transport of copy which failed and try releasing it. There will be a pop up mentioning errors. click on the error and you can find the details of the error.