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 )