order qty ,order date and stock report- Sap bw

[OzgurKlc]

Hi All,

I am already joined to the Power bi world and we have started to get data form SAP BW to combiner order and stock report.

Current data:

Component from Bom	Finished good	Stock Identifier	Warehouse code	Stock qty	Order Qty	Total order of the Fisnished good	Date of Order
151109-TA	151109-AI		1085	22
151109-TA	151109-AI		1328	23
151109-TA	151109-AI	O		634
151109-TA	K51109-AI	#	1085	22	225	6870	14.07.2023 00:00
151109-TA	K51109-AI	O	2000	634	300	6870	19.02.2025 00:00
151109-TA	K51109-AI	O	2000	634	45	6870	22.03.2025 00:00
151109-TA	Y51109-AI		1085	22	300	3394	27.10.2023 00:00
151109-TA	Y51109-AI		1085	22	300	3394	21.11.2023 00:00
151109-TA	Y51109-AI		1085	22	300	3394	22.01.2024 00:00
151109-TA	Y51109-AI		1085	22	300	3394	20.02.2024 00:00
151109-TA	Y51109-AI		1085	22	300	3394	22.03.2024 00:00
151109-TA	Y51109-AI		2000/1085	22	300	3394	22.05.2024 00:00
151109-TA	Y51109-AI		2000/1085	22	300	3394	22.08.2024 00:00
151109-TA	Y51109-AI		2000/1085	22	300	3394	21.09.2024 00:00
151109-TA	Y51109-AI		1040	22	300	3394	21.11.2024 00:00
151109-TA	Y51109-AI		1085	22	300	3394	22.12.2024 00:00
151109-TA	Y51109-AI		1085	22	300	3394	19.02.2025 00:00
151109-TA	Y51109-AI		1085	22	94	3394	22.03.2025 00:00
151109-TA	Y51109-AI		2000/1328	23	300	3394	27.10.2023 00:00
151109-TA	Y51109-AI		2000/1328	23	300	3394	21.11.2023 00:00
151109-TA	Y51109-AI		2000/1328	23	300	3394	22.01.2024 00:00
151109-TA	Y51109-AI		2000/1328	23	300	3394	20.02.2024 00:00
151109-TA	Y51109-AI		2000/1328	23	300	3394	22.03.2024 00:00
151109-TA	Y51109-AI		2000/1328	23	300	3394	22.05.2024 00:00
151109-TA	Y51109-AI		2000/1328	23	300	3394	22.08.2024 00:00

We sould like to convert to like below depends on the finished goods of the smilar components. So I mean 151109-TA is parts of the

K51109-AI and Y51109-AI finsihed goods. So we need to split each stock based on their order qty weight.

So we would like convert like below, can you help me?

Thx

Component from Bom

Component

Stock Identifier

Warehouse code

weight of order-rate of the order

1085-warehouse quantitiy

1328-warehouse quantitiy

1040-warehouse quantitiy

July

August

September

October

K51109-AI

151109-TA

O

1085

=3394/6870+3394

current stock qty in 1085 warehouse * rate of the order

current stock in warehouse * rate of the order

current stock in warehouse * rate of the order

300

1200

6000

7000

Y51109-AI

151109-TA

O

1328

=6870/6870+3394

current stock qty  in 1328 warehouse * rate of the order

current stock in warehouse * rate of the order

current stock in warehouse * rate of the order

300

6000

7000

[v-yanjiang-msft]

Hi @OzgurKlc ,

Sorry I'm not quite clear about the transform logic "convert depends on the finished goods of the smilar components." and "split each stock based on their order qty weight.". Could you please clarify it based on the sample data.

Best regards,

Community Support Team_yanjiang