Tip:
Highlight text to annotate it
X
Welcome to exercise two of CD162 in this exercise will look at Core Data Services
will begin by creating the new HDBDD development artifact
will go back to our project
that will create a new folder
is just so we can help of the organizer develop artifacts we will put all of our data definitions and and
table related content
so choose to create a DDL source file and will create a developer artifact with the file extension HDBDD
and type in the name
of artifact purchase order
and that we can type extension or the wizard would have added it automatically force
and we open in a special editor for HDBDD which knows the CDS
Syntax will get proper syntax highlighting
and the eventually and future revisions will enhances with the graphical
design tools as well at first we just need to input are schema that we want all of the objects
generated into so we'll put in the schema that we created in the previous exercise
next will begin to define our reusable types and structures
so we'll go to the exercise template web site and the code for the types / structures and and everything the
we create reusable types that they can be based on
simple the data types like
string and in a second we also create
a more complex types
like this history type
and it'll create our database tables will see how we're reuse these types
inside the definition of our table so that to the we have nice for usability and have all structures like this history structure that can be repeated
and we don't have to keep redefined the individual columns
that created the header table
and that will create a purchase order item table
and from this one development artifact will we activated it will generate
all the catalog artifacts and generate two tables and will generate a table type and then we'll see this and just go ahead and activate
that is now created all the catalog artifacts we can go to the catalog
and look inside are schema
and we'll see that the types are here under procedures table types
will see this history type that has been created
and then we'll see the two tables are purchase order and item
definition of a double click on it shows is our definition you see how the type
has been expanded in place with a history created by created at that and so forth
and now we have a little test tool
that will allow us to populate some records into our table
and bring up his cool and solutions
the UI exercise to just type in the name were schema and it is to do a couple things can validate table success that they have
the right number of columns the right types that you made any mistakes in the previous part of exercise and you'll
and the school will tell you up but if routing successful that will go ahead and create a couple test records
in both the purchase order header and I'm able that allows is now go back to the HANA Studio and we can look of the content
in the tables
and we see that the records are her here as well
so that we have our tables created with a little bit of data in them in case you want to do anything with the state