Data load

fiori/test/data/sap.capire.orders-Orders.csv

@@ -1,3 +1,3 @@
-ID;createdAt;createdBy;buyer;OrderNo;currency_code
-7e2f2640-6866-4dcf-8f4d-3027aa831cad;2019-01-31;john.doe@test.com;john.doe@test.com;1;EUR
-64e718c9-ff99-47f1-8ca3-950c850777d4;2019-01-30;jane.doe@test.com;jane.doe@test.com;2;EUR
+ID;createdAt;createdBy;buyer;OrderNo;currency_code;status_code
+7e2f2640-6866-4dcf-8f4d-3027aa831cad;2019-01-31;john.doe@test.com;john.doe@test.com;1;EUR;O
+64e718c9-ff99-47f1-8ca3-950c850777d4;2019-01-30;jane.doe@test.com;jane.doe@test.com;2;EUR;C

orders/app/orders/fiori-service.cds

@@ -45,7 +45,8 @@ annotate OrdersService.Orders with @(
 		],
 		FieldGroup#Details: {
 			Data: [
-				{Value: currency.code, Label:'Currency'}
+				{Value: currency.code, Label:'Currency'},
+				{Value: status.code, Label:'Status'},
 			]
 		},
 		FieldGroup#Created: {
@@ -66,6 +67,9 @@ annotate OrdersService.Orders with @(
 	createdBy @UI.HiddenFilter:false;
 };
 
+annotate OrdersService.OrderStatus with {
+	code @Common: { Text: name,  TextArrangement: #TextOnly };
+}
 
 
 annotate OrdersService.Orders_Items with @(

orders/db/data/sap.capire.orders-OrderStatus.csv

@@ -0,0 +1,4 @@
+code;name;descr
+O;Open;Order is open
+P;In Process;Order is about to be processed
+C;Closed;Order is closed

orders/db/schema.cds

@@ -1,4 +1,4 @@
-using { Currency, User, managed, cuid } from '@sap/cds/common';
+using { Currency, User, managed, cuid, sap.common.CodeList } from '@sap/cds/common';
 namespace sap.capire.orders;
 
 entity Orders : cuid, managed {
@@ -6,8 +6,12 @@ entity Orders : cuid, managed {
   Items    : Composition of many Orders_Items on Items.up_ = $self;
   buyer    : User;
   currency : Currency;
+  status   : Association to OrderStatus;
 }
 
+@cds.persistence.data.kind: 'config'
+entity OrderStatus : CodeList { key code: String(1) }
+
 entity Orders_Items {
   key ID    : UUID;
   up_       : Association to Orders;