Skip to Content
0
Sep 01, 2023 at 12:01 PM

CDS - Copy one Line item data to another line item

100 Views Last edit Sep 01, 2023 at 12:06 PM 3 rev

Hello Experts,

Following is the data available in a table, only Line Item 1 is having data in Cleared On , Cleared Doc fields.

The remaining line items have blanks values in Cleared On , Cleared Doc fields.

I need to create a CDS VIew such that it should use / copy the same values of Cleared On , Cleared Doc fields of Line item 1 to Line item 2 , Line item 3 , Line item 4.

image.png

i.e.

For Line item 2, Line item 3, Line item 4

All the Blank fields in Cleared on column should be filled / copied from Line Item 1 with 01-Sep-23,

All the Blank fields in Cleared Doc column should be filled / copied from Line Item 1 with 2001,

Expected outcome of CDS view should be as shown.

image.png

Thanks,

Vijay

Attachments

image.png (11.8 kB)
image.png (12.5 kB)