Below is dummy Data and expected output
CREATE TABLE #Containerno(CID INT,Contno VARCHAR(50),ConWeight int,E_Date date,cont_value Decimal(10,4));
CREATE TABLE #tbl_ContD(D_ID INT,CID int);
Create table #tbl_Issuance_Rags (R_ID int,D_ID int,R_Weight int,R_Date date)
INSERT INTO #Containerno VALUES
(1,'A02120',100,'2021-01-04','0.2040')
, (2,'B1512',300,'2021-02-15','1.5425')
, (3,'C2121',100,'2021-03-26','4.0052')
INSERT INTO #tbl_ContD VALUES
(111,1),
(112,1),
(113,1),
(114,2),
(115,2),
(116,3)
INSERT INTO #tbl_Issuance_Rags VALUES
(101,111,20,'2021-04-06'),
(102,112,30,'2021-04-06'),
(103,113,15,'2021-04-06'),
(104,114,25,'2021-04-06'),
(105,115,25,'2021-04-06'),
(106,11,35,'2021-04-06')

Value=(R_Weight*Cont_Value)
Perc =R_Weight/sum(R_Weight) which is 150