Skip to Content
avatar image
Former Member

CDS Views: Can we split the data

Can we perform calculations on the data which is read to split them into more rows, before we output. Relations for the tables are for Header table PARENT_GUID is BP_GUID of the customer and chid table PARENT_GUID is the GUID of the header >>> that means CHILD-PARENT_GUID is HEADER-GUID and HEADER-PARENT_GUID is CUST-BP_GUID

The challenging part is splitting the start dates from these four tables >>> CDS vies should have one START_DATE and one END_DATE which should be consolidated from the four tables and the date should be respectively for those periods.

Let me explain that below with an example

ESTATE_ID

ESTATE_DTL

INCOME_ID

INCOME_DTL

Our view should have the below data

We have to consider all the start and end dates and split them and then data should be populated into those fields respectively for those periods. (I will explain when we have a call if you have any doubts)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers