== Physical Plan ==
AdaptiveSparkPlan (150)
+- == Current Plan ==
ResultQueryStage (148)
+- * Project (147)
+- TableCacheQueryStage (146), Statistics(sizeInBytes=36.4 KiB, rowCount=24)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- AdaptiveSparkPlan (145)
+- == Final Plan ==
ResultQueryStage (83)
+- * Project (82)
+- * BroadcastHashJoin LeftOuter BuildRight (81)
:- Project (74)
: +- BroadcastHashJoin LeftOuter BuildRight (73)
: :- Project (70)
: : +- BroadcastHashJoin LeftOuter BuildRight (69)
: : :- Project (61)
: : : +- Project (60)
: : : +- Project (59)
: : : +- BroadcastHashJoin LeftOuter BuildRight (58)
: : : :- Project (50)
: : : : +- BroadcastHashJoin LeftOuter BuildRight (49)
: : : : :- Project (42)
: : : : : +- Project (41)
: : : : : +- Project (40)
: : : : : +- Project (39)
: : : : : +- Project (38)
: : : : : +- Project (37)
: : : : : +- Project (36)
: : : : : +- Project (35)
: : : : : +- BroadcastHashJoin LeftOuter BuildRight (34)
: : : : : :- * Project (25)
: : : : : : +- * BroadcastHashJoin LeftOuter BuildRight (24)
: : : : : : :- * Project (15)
: : : : : : : +- * BroadcastHashJoin LeftOuter BuildRight (14)
: : : : : : : :- ShuffleQueryStage (6), Statistics(sizeInBytes=10.4 KiB, rowCount=24)
: : : : : : : : +- Exchange (5)
: : : : : : : : +- * ColumnarToRow (4)
: : : : : : : : +- Scan parquet (3)
: : : : : : : +- BroadcastQueryStage (13), Statistics(sizeInBytes=6.3 MiB, rowCount=4.34E+3)
: : : : : : : +- BroadcastExchange (12)
: : : : : : : +- ShuffleQueryStage (11), Statistics(sizeInBytes=4.1 MiB, rowCount=4.34E+3)
: : : : : : : +- Exchange (10)
: : : : : : : +- * Project (9)
: : : : : : : +- * ColumnarToRow (8)
: : : : : : : +- Scan parquet (7)
: : : : : : +- BroadcastQueryStage (23), Statistics(sizeInBytes=2.0 MiB, rowCount=288)
: : : : : : +- BroadcastExchange (22)
: : : : : : +- ShuffleQueryStage (21), Statistics(sizeInBytes=235.3 KiB, rowCount=288)
: : : : : : +- Exchange (20)
: : : : : : +- * Project (19)
: : : : : : +- * Filter (18)
: : : : : : +- * ColumnarToRow (17)
: : : : : : +- Scan parquet (16)
: : : : : +- BroadcastQueryStage (33), Statistics(sizeInBytes=2.0 MiB, rowCount=159)
: : : : : +- BroadcastExchange (32)
: : : : : +- ShuffleQueryStage (31), Statistics(sizeInBytes=269.2 KiB, rowCount=159)
: : : : : +- Exchange (30)
: : : : : +- * Project (29)
: : : : : +- * Filter (28)
: : : : : +- * ColumnarToRow (27)
: : : : : +- Scan parquet (26)
: : : : +- BroadcastQueryStage (48), Statistics(sizeInBytes=2.0 MiB, rowCount=24)
: : : : +- BroadcastExchange (47)
: : : : +- ShuffleQueryStage (46), Statistics(sizeInBytes=2.8 KiB, rowCount=24)
: : : : +- Exchange (45)
: : : : +- * ColumnarToRow (44)
: : : : +- Scan parquet (43)
: : : +- BroadcastQueryStage (57), Statistics(sizeInBytes=2.0 MiB, rowCount=5)
: : : +- BroadcastExchange (56)
: : : +- ShuffleQueryStage (55), Statistics(sizeInBytes=832.0 B, rowCount=5)
: : : +- Exchange (54)
: : : +- * Project (53)
: : : +- * ColumnarToRow (52)
: : : +- Scan parquet (51)
: : +- BroadcastQueryStage (68), Statistics(sizeInBytes=2.0 MiB, rowCount=572)
: : +- BroadcastExchange (67)
: : +- ShuffleQueryStage (66), Statistics(sizeInBytes=33.3 KiB, rowCount=572)
: : +- Exchange (65)
: : +- * Project (64)
: : +- * ColumnarToRow (63)
: : +- Scan parquet (62)
: +- BroadcastQueryStage (72), Statistics(sizeInBytes=2.0 MiB, rowCount=572)
: +- ReusedExchange (71)
+- BroadcastQueryStage (80), Statistics(sizeInBytes=2.0 MiB, rowCount=18)
+- BroadcastExchange (79)
+- ShuffleQueryStage (78), Statistics(sizeInBytes=4.7 KiB, rowCount=18)
+- Exchange (77)
+- * ColumnarToRow (76)
+- Scan parquet (75)
+- == Initial Plan ==
Project (144)
+- BroadcastHashJoin LeftOuter BuildRight (143)
:- Project (140)
: +- BroadcastHashJoin LeftOuter BuildRight (139)
: :- Project (134)
: : +- BroadcastHashJoin LeftOuter BuildRight (133)
: : :- Project (129)
: : : +- Project (128)
: : : +- Project (127)
: : : +- BroadcastHashJoin LeftOuter BuildRight (126)
: : : :- Project (122)
: : : : +- BroadcastHashJoin LeftOuter BuildRight (121)
: : : : :- Project (118)
: : : : : +- Project (117)
: : : : : +- BroadcastHashJoin LeftOuter BuildRight (116)
: : : : : :- Project (110)
: : : : : : +- BroadcastHashJoin LeftOuter BuildRight (109)
: : : : : : :- Project (103)
: : : : : : : +- Project (102)
: : : : : : : +- Project (101)
: : : : : : : +- BroadcastHashJoin LeftOuter BuildRight (100)
: : : : : : : :- Project (95)
: : : : : : : : +- BroadcastHashJoin LeftOuter BuildRight (94)
: : : : : : : : :- Project (89)
: : : : : : : : : +- BroadcastHashJoin LeftOuter BuildRight (88)
: : : : : : : : : :- Exchange (84)
: : : : : : : : : : +- Scan parquet (3)
: : : : : : : : : +- BroadcastExchange (87)
: : : : : : : : : +- Exchange (86)
: : : : : : : : : +- Project (85)
: : : : : : : : : +- Scan parquet (7)
: : : : : : : : +- BroadcastExchange (93)
: : : : : : : : +- Exchange (92)
: : : : : : : : +- Project (91)
: : : : : : : : +- Filter (90)
: : : : : : : : +- Scan parquet (16)
: : : : : : : +- BroadcastExchange (99)
: : : : : : : +- Exchange (98)
: : : : : : : +- Project (97)
: : : : : : : +- Filter (96)
: : : : : : : +- Scan parquet (26)
: : : : : : +- BroadcastExchange (108)
: : : : : : +- Project (107)
: : : : : : +- InMemoryTableScan (104)
: : : : : : +- InMemoryRelation (105)
: : : : : : +- LocalTableScan (106)
: : : : : +- BroadcastExchange (115)
: : : : : +- Project (114)
: : : : : +- Filter (113)
: : : : : +- InMemoryTableScan (111)
: : : : : +- InMemoryRelation (112)
: : : : : +- LocalTableScan (106)
: : : : +- BroadcastExchange (120)
: : : : +- Exchange (119)
: : : : +- Scan parquet (43)
: : : +- BroadcastExchange (125)
: : : +- Exchange (124)
: : : +- Project (123)
: : : +- Scan parquet (51)
: : +- BroadcastExchange (132)
: : +- Exchange (131)
: : +- Project (130)
: : +- Scan parquet (62)
: +- BroadcastExchange (138)
: +- Exchange (137)
: +- Project (136)
: +- Scan parquet (135)
+- BroadcastExchange (142)
+- Exchange (141)
+- Scan parquet (75)
+- == Initial Plan ==
Project (149)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- AdaptiveSparkPlan (145)
+- == Final Plan ==
ResultQueryStage (83)
+- * Project (82)
+- * BroadcastHashJoin LeftOuter BuildRight (81)
:- Project (74)
: +- BroadcastHashJoin LeftOuter BuildRight (73)
: :- Project (70)
: : +- BroadcastHashJoin LeftOuter BuildRight (69)
: : :- Project (61)
: : : +- Project (60)
: : : +- Project (59)
: : : +- BroadcastHashJoin LeftOuter BuildRight (58)
: : : :- Project (50)
: : : : +- BroadcastHashJoin LeftOuter BuildRight (49)
: : : : :- Project (42)
: : : : : +- Project (41)
: : : : : +- Project (40)
: : : : : +- Project (39)
: : : : : +- Project (38)
: : : : : +- Project (37)
: : : : : +- Project (36)
: : : : : +- Project (35)
: : : : : +- BroadcastHashJoin LeftOuter BuildRight (34)
: : : : : :- * Project (25)
: : : : : : +- * BroadcastHashJoin LeftOuter BuildRight (24)
: : : : : : :- * Project (15)
: : : : : : : +- * BroadcastHashJoin LeftOuter BuildRight (14)
: : : : : : : :- ShuffleQueryStage (6), Statistics(sizeInBytes=10.4 KiB, rowCount=24)
: : : : : : : : +- Exchange (5)
: : : : : : : : +- * ColumnarToRow (4)
: : : : : : : : +- Scan parquet (3)
: : : : : : : +- BroadcastQueryStage (13), Statistics(sizeInBytes=6.3 MiB, rowCount=4.34E+3)
: : : : : : : +- BroadcastExchange (12)
: : : : : : : +- ShuffleQueryStage (11), Statistics(sizeInBytes=4.1 MiB, rowCount=4.34E+3)
: : : : : : : +- Exchange (10)
: : : : : : : +- * Project (9)
: : : : : : : +- * ColumnarToRow (8)
: : : : : : : +- Scan parquet (7)
: : : : : : +- BroadcastQueryStage (23), Statistics(sizeInBytes=2.0 MiB, rowCount=288)
: : : : : : +- BroadcastExchange (22)
: : : : : : +- ShuffleQueryStage (21), Statistics(sizeInBytes=235.3 KiB, rowCount=288)
: : : : : : +- Exchange (20)
: : : : : : +- * Project (19)
: : : : : : +- * Filter (18)
: : : : : : +- * ColumnarToRow (17)
: : : : : : +- Scan parquet (16)
: : : : : +- BroadcastQueryStage (33), Statistics(sizeInBytes=2.0 MiB, rowCount=159)
: : : : : +- BroadcastExchange (32)
: : : : : +- ShuffleQueryStage (31), Statistics(sizeInBytes=269.2 KiB, rowCount=159)
: : : : : +- Exchange (30)
: : : : : +- * Project (29)
: : : : : +- * Filter (28)
: : : : : +- * ColumnarToRow (27)
: : : : : +- Scan parquet (26)
: : : : +- BroadcastQueryStage (48), Statistics(sizeInBytes=2.0 MiB, rowCount=24)
: : : : +- BroadcastExchange (47)
: : : : +- ShuffleQueryStage (46), Statistics(sizeInBytes=2.8 KiB, rowCount=24)
: : : : +- Exchange (45)
: : : : +- * ColumnarToRow (44)
: : : : +- Scan parquet (43)
: : : +- BroadcastQueryStage (57), Statistics(sizeInBytes=2.0 MiB, rowCount=5)
: : : +- BroadcastExchange (56)
: : : +- ShuffleQueryStage (55), Statistics(sizeInBytes=832.0 B, rowCount=5)
: : : +- Exchange (54)
: : : +- * Project (53)
: : : +- * ColumnarToRow (52)
: : : +- Scan parquet (51)
: : +- BroadcastQueryStage (68), Statistics(sizeInBytes=2.0 MiB, rowCount=572)
: : +- BroadcastExchange (67)
: : +- ShuffleQueryStage (66), Statistics(sizeInBytes=33.3 KiB, rowCount=572)
: : +- Exchange (65)
: : +- * Project (64)
: : +- * ColumnarToRow (63)
: : +- Scan parquet (62)
: +- BroadcastQueryStage (72), Statistics(sizeInBytes=2.0 MiB, rowCount=572)
: +- ReusedExchange (71)
+- BroadcastQueryStage (80), Statistics(sizeInBytes=2.0 MiB, rowCount=18)
+- BroadcastExchange (79)
+- ShuffleQueryStage (78), Statistics(sizeInBytes=4.7 KiB, rowCount=18)
+- Exchange (77)
+- * ColumnarToRow (76)
+- Scan parquet (75)
+- == Initial Plan ==
Project (144)
+- BroadcastHashJoin LeftOuter BuildRight (143)
:- Project (140)
: +- BroadcastHashJoin LeftOuter BuildRight (139)
: :- Project (134)
: : +- BroadcastHashJoin LeftOuter BuildRight (133)
: : :- Project (129)
: : : +- Project (128)
: : : +- Project (127)
: : : +- BroadcastHashJoin LeftOuter BuildRight (126)
: : : :- Project (122)
: : : : +- BroadcastHashJoin LeftOuter BuildRight (121)
: : : : :- Project (118)
: : : : : +- Project (117)
: : : : : +- BroadcastHashJoin LeftOuter BuildRight (116)
: : : : : :- Project (110)
: : : : : : +- BroadcastHashJoin LeftOuter BuildRight (109)
: : : : : : :- Project (103)
: : : : : : : +- Project (102)
: : : : : : : +- Project (101)
: : : : : : : +- BroadcastHashJoin LeftOuter BuildRight (100)
: : : : : : : :- Project (95)
: : : : : : : : +- BroadcastHashJoin LeftOuter BuildRight (94)
: : : : : : : : :- Project (89)
: : : : : : : : : +- BroadcastHashJoin LeftOuter BuildRight (88)
: : : : : : : : : :- Exchange (84)
: : : : : : : : : : +- Scan parquet (3)
: : : : : : : : : +- BroadcastExchange (87)
: : : : : : : : : +- Exchange (86)
: : : : : : : : : +- Project (85)
: : : : : : : : : +- Scan parquet (7)
: : : : : : : : +- BroadcastExchange (93)
: : : : : : : : +- Exchange (92)
: : : : : : : : +- Project (91)
: : : : : : : : +- Filter (90)
: : : : : : : : +- Scan parquet (16)
: : : : : : : +- BroadcastExchange (99)
: : : : : : : +- Exchange (98)
: : : : : : : +- Project (97)
: : : : : : : +- Filter (96)
: : : : : : : +- Scan parquet (26)
: : : : : : +- BroadcastExchange (108)
: : : : : : +- Project (107)
: : : : : : +- InMemoryTableScan (104)
: : : : : : +- InMemoryRelation (105)
: : : : : : +- LocalTableScan (106)
: : : : : +- BroadcastExchange (115)
: : : : : +- Project (114)
: : : : : +- Filter (113)
: : : : : +- InMemoryTableScan (111)
: : : : : +- InMemoryRelation (112)
: : : : : +- LocalTableScan (106)
: : : : +- BroadcastExchange (120)
: : : : +- Exchange (119)
: : : : +- Scan parquet (43)
: : : +- BroadcastExchange (125)
: : : +- Exchange (124)
: : : +- Project (123)
: : : +- Scan parquet (51)
: : +- BroadcastExchange (132)
: : +- Exchange (131)
: : +- Project (130)
: : +- Scan parquet (62)
: +- BroadcastExchange (138)
: +- Exchange (137)
: +- Project (136)
: +- Scan parquet (135)
+- BroadcastExchange (142)
+- Exchange (141)
+- Scan parquet (75)
(1) InMemoryTableScan
Output [44]: [availabilityDateTime#913888, clusterId#913899L, constraintIsActive#914088, constraintLabels#914054, constraintOperators#914055, constraintRanks#914057, constraintValues#914094, deliveryDateTime#913882, externalPlantId#913948, externalProductId#913946, isFallbackOrderOnly#913894, logisticUnits#914027, measurements#914181, minimumOrderQuantity#914106, mrpController#913890, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, nextAvailabilityDateTime#913889, optimizationGroups#914195, orderDateTime#913887, orderProposalHorizonGroupingId#913896L, orderProposalId#913895L, orderProposalItemGroupId#913902, orderProposalItemId#913903, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, originalReplenishmentRunId#914183L, plant#913881, previousOrderProposal#913898L, product#913886, productGroup#913885, purchasingGroup#913893, purchasingOrg#913892, sequenceId#913900, sourceOfSupplyUuid#913891, splitIndicator#913897L, subrange#913883, supplier#913880, supplierGroup#913879, supplyingPlant#913884, worklistShardItemId#913901L]
Arguments: [availabilityDateTime#913888, clusterId#913899L, constraintIsActive#914088, constraintLabels#914054, constraintOperators#914055, constraintRanks#914057, constraintValues#914094, deliveryDateTime#913882, externalPlantId#913948, externalProductId#913946, isFallbackOrderOnly#913894, logisticUnits#914027, measurements#914181, minimumOrderQuantity#914106, mrpController#913890, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, nextAvailabilityDateTime#913889, optimizationGroups#914195, orderDateTime#913887, orderProposalHorizonGroupingId#913896L, orderProposalId#913895L, ... 19 more fields]
(2) InMemoryRelation
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 19 more fields], StorageLevel(disk, memory, 2 replicas)
(3) Scan parquet
Output [25]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903]
Batched: true
Location: InMemoryFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/out/order-proposal-boundary-snapshot/10000002110/shardId=0_1_10000002110]
ReadSchema: struct<supplierGroup:string,supplier:string,plant:string,deliveryDateTime:timestamp,subrange:string,supplyingPlant:string,productGroup:string,product:string,orderDateTime:timestamp,availabilityDateTime:timestamp,nextAvailabilityDateTime:timestamp,mrpController:string,sourceOfSupplyUuid:string,purchasingOrg:string,purchasingGroup:string,isFallbackOrderOnly:boolean,orderProposalId:bigint,orderProposalHorizonGroupingId:bigint,splitIndicator:bigint,previousOrderProposal:bigint,clusterId:bigint,sequenceId:int,worklistShardItemId:bigint,orderProposalItemGroupId:string,orderProposalItemId:string>
(4) ColumnarToRow [codegen id : 1]
Input [25]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903]
(5) Exchange
Input [25]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903]
Arguments: hashpartitioning(product#913886, plant#913881, 25), REPARTITION_BY_NUM, [plan_id=358496]
(6) ShuffleQueryStage
Output [25]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903]
Arguments: 0
(7) Scan parquet
Output [24]: [internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928, systemId#913905]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-sourceofsupply-sourceofsupply]
ReadSchema: struct<internalUUID:string,supplier:struct<internalRefUUID:string,id:string>,receiver:struct<internalRefUUID:string,id:string>,product:struct<internalRefUUID:string,id:string>,receivingPlant:struct<internalRefUUID:string,id:string>,sourceOfSupplyType:struct<internalRefUUID:string,code:string>,purchasingGroup:struct<internalRefUUID:string,id:string>,purchasingOrganization:struct<internalRefUUID:string,id:string>,productGroup:struct<internalRefUUID:string,id:string>,validFrom:timestamp,validTo:timestamp,priority:int,isPurchasingBlocked:boolean,isConsignment:boolean,isDeleted:boolean,supplierSubrange:string,plannedDeliveryTimeDays:int,orderQuantityUnit:struct<internalRefUUID:string,code:string>,purchasingPriceAspect:struct<netPrice:struct<amount:double,currencyCode:struct<internalRefUUID:string,code:string>>,netPriceQuantity:double,netPriceUnit:struct<internalRefUUID:string,code:string>>,orderCurrency:struct<internalRefUUID:string,code:string>,minimumOrderQuantity:double,logisticalRoundingProfile:struct<logisticalRoundingProfile:string,internalRefUUID:string>,supplyingPlant:struct<internalRefUUID:string,id:string>>
(8) ColumnarToRow [codegen id : 2]
Input [24]: [internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928, systemId#913905]
(9) Project [codegen id : 2]
Output [24]: [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
Input [24]: [internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928, systemId#913905]
(10) Exchange
Input [24]: [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358515]
(11) ShuffleQueryStage
Output [24]: [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
Arguments: 1
(12) BroadcastExchange
Input [24]: [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[1, string, true], ), isnull(input[1, string, true])),false), [plan_id=359143]
(13) BroadcastQueryStage
Output [24]: [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
Arguments: 21
(14) BroadcastHashJoin [codegen id : 12]
Left keys [2]: [coalesce(sourceOfSupplyUuid#913891, ), isnull(sourceOfSupplyUuid#913891)]
Right keys [2]: [coalesce(internalUUID#913906, ), isnull(internalUUID#913906)]
Join type: LeftOuter
Join condition: None
(15) Project [codegen id : 12]
Output [26]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, struct(systemId, systemId#913905, internalUUID, internalUUID#913906, supplier, supplier#913907, receiver, receiver#913908, product, product#913909, receivingPlant, receivingPlant#913910, sourceOfSupplyType, sourceOfSupplyType#913911, purchasingGroup, purchasingGroup#913912, purchasingOrganization, purchasingOrganization#913913, productGroup, productGroup#913914, validFrom, validFrom#913915, validTo, validTo#913916, priority, ... 23 more fields) AS sos#913929]
Input [49]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
(16) Scan parquet
Output [8]: [internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940, systemId#913933]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-product-productplant]
PushedFilters: [In(plant.internalRefUUID, [25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97])]
ReadSchema: struct<internalUUID:string,plant:struct<internalRefUUID:string,id:string>,product:struct<internalRefUUID:string,id:string>,blockedForReplenishmentStartingFrom:date,productionAspect:struct<productMovementPlants:struct<unitOfIssue:struct<internalRefUUID:string,code:string>>,productPlanningPlants:struct<mrpType:struct<internalRefUUID:string,code:string>,abcIndicator:struct<internalRefUUID:string,code:string>,mrpController:struct<internalRefUUID:string,id:string>,minimumLotSize:double,minimumSafetyStock:double,logisticalRoundingProfile:struct<internalRefUUID:string,logisticalRoundingProfile:string>,sourceOfSupplyCategory:struct<internalRefUUID:string,code:string>>>,salesPlant:struct<loadingGroup:struct<internalRefUUID:string,code:string>>,listing:array<struct<validFrom:timestamp,validTo:timestamp,isListed:boolean>>>
(17) ColumnarToRow [codegen id : 3]
Input [8]: [internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940, systemId#913933]
(18) Filter [codegen id : 3]
Input [8]: [internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940, systemId#913933]
Condition : plant#913935.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(19) Project [codegen id : 3]
Output [8]: [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
Input [8]: [internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940, systemId#913933]
(20) Exchange
Input [8]: [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358542]
(21) ShuffleQueryStage
Output [8]: [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
Arguments: 2
(22) BroadcastExchange
Input [8]: [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[3, struct<internalRefUUID:string,id:string>, true].internalRefUUID, ), isnull(input[3, struct<internalRefUUID:string,id:string>, true].internalRefUUID), coalesce(input[2, struct<internalRefUUID:string,id:string>, true].internalRefUUID, ), isnull(input[2, struct<internalRefUUID:string,id:string>, true].internalRefUUID)),false), [plan_id=359147]
(23) BroadcastQueryStage
Output [8]: [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
Arguments: 16
(24) BroadcastHashJoin [codegen id : 12]
Left keys [4]: [coalesce(product#913886, ), isnull(product#913886), coalesce(plant#913881, ), isnull(plant#913881)]
Right keys [4]: [coalesce(product#913936.internalRefUUID, ), isnull(product#913936.internalRefUUID), coalesce(plant#913935.internalRefUUID, ), isnull(plant#913935.internalRefUUID)]
Join type: LeftOuter
Join condition: None
(25) Project [codegen id : 12]
Output [29]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, CASE WHEN isnotnull(productionAspect#913938) THEN struct(systemId, systemId#913933, internalUUID, internalUUID#913934, plant, plant#913935, product, product#913936, blockedForReplenishmentStartingFrom, blockedForReplenishmentStartingFrom#913937, productionAspect, productionAspect#913938, salesPlant, salesPlant#913939, listing, listing#913940) END AS productPlant#913945, product#913936.id AS externalProductId#913946, plant#913935.id AS externalPlantId#913948]
Input [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
(26) Scan parquet
Output [12]: [internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961, systemId#913950]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-product-product-v2]
PushedFilters: [IsNotNull(internalUUID)]
ReadSchema: struct<internalUUID:string,id:string,displayId:string,name:array<struct<lang:string,content:string>>,baseUnitOfMeasure:struct<internalRefUUID:string,code:string>,unitOfMeasures:array<struct<measurementUnit:struct<internalRefUUID:string,code:string>,productDimensions:array<struct<dimensionName:struct<internalRefUUID:string,code:string>,dimensionValue:string,measurementUnit:struct<internalRefUUID:string,code:string>>>>>,unitOfMeasureConversions:array<struct<measurementUnit1:struct<internalRefUUID:string,code:string>,measurementUnit2:struct<internalRefUUID:string,code:string>,quantityNumerator:int,quantityDenominator:int>>,productionAspect:struct<minimumRemainingShelfLife:double>,salesAspect:struct<transportationGroup:struct<internalRefUUID:string,code:string>>,procurementAspect:struct<orderUnit:struct<internalRefUUID:string,code:string>>,productGroup:struct<internalRefUUID:string,id:string>>
(27) ColumnarToRow [codegen id : 4]
Input [12]: [internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961, systemId#913950]
(28) Filter [codegen id : 4]
Input [12]: [internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961, systemId#913950]
Condition : isnotnull(internalUUID#913951)
(29) Project [codegen id : 4]
Output [12]: [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
Input [12]: [internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961, systemId#913950]
(30) Exchange
Input [12]: [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358571]
(31) ShuffleQueryStage
Output [12]: [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
Arguments: 3
(32) BroadcastExchange
Input [12]: [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
Arguments: HashedRelationBroadcastMode(List(input[1, string, true]),false), [plan_id=359151]
(33) BroadcastQueryStage
Output [12]: [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
Arguments: 20
(34) BroadcastHashJoin
Left keys [1]: [product#913886]
Right keys [1]: [internalUUID#913951]
Join type: LeftOuter
Join condition: None
(35) Project
Output [30]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, CASE WHEN isnotnull(internalUUID#913951) THEN struct(systemId, systemId#913950, internalUUID, internalUUID#913951, id, id#913952, displayId, displayId#913953, name, name#913954, baseUnitOfMeasure, baseUnitOfMeasure#913955, unitOfMeasures, unitOfMeasures#913956, unitOfMeasureConversions, unitOfMeasureConversions#913957, productionAspect, productionAspect#913958, salesAspect, salesAspect#913959, procurementAspect, procurementAspect#913960, productGroup, productGroup#913961) END AS productInformation#913962]
Input [41]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
(36) Project
Output [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, transform(coalesce(transform(filter(productInformation#913962.unitOfMeasureConversions, lambdafunction((array_contains(transform(productInformation#913962.unitOfMeasures, lambdafunction(lambda x_2373#913974.measurementUnit.internalRefUUID, lambda x_2373#913974, false)), lambda x_2372#913971.measurementUnit1.internalRefUUID) AND (lambda x_2372#913971.measurementUnit2.internalRefUUID = productInformation#913962.baseUnitOfMeasure.internalRefUUID)), lambda x_2372#913971, false)), lambdafunction(struct(uom, lambda x_2374#913975.measurementUnit1.code, uomUuid, lambda x_2374#913975.measurementUnit1.internalRefUUID, numerator, lambda x_2374#913975.quantityNumerator, denominator, lambda x_2374#913975.quantityDenominator, isOrderUnit, false, isPreferred, false), lambda x_2374#913975, false)), []), lambdafunction(named_struct(uom, lambda x_2375#913981.uom, uomUuid, lambda x_2375#913981.uomUuid, numerator, lambda x_2375#913981.numerator, denominator, lambda x_2375#913981.denominator, isOrderUnit, ((lambda x_2375#913981.uomUuid = coalesce(sos#913929.orderQuantityUnit.internalRefUUID, productInformation#913962.procurementAspect.orderUnit.internalRefUUID, productInformation#913962.baseUnitOfMeasure.internalRefUUID)) <=> true), isPreferred, lambda x_2375#913981.isPreferred), lambda x_2375#913981, false)) AS logisticUnits#913980, productInformation#913962.baseUnitOfMeasure.code AS orderQuantityBaseUom#913976, productInformation#913962.baseUnitOfMeasure.internalRefUUID AS orderQuantityBaseUomUuid#913978, CASE WHEN isnull(supplyingPlant#913884) THEN 4 ELSE 1 END AS preferredUomSourceCode#913985]
Input [30]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962]
(37) Project
Output [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, CASE WHEN (preferredUomSourceCode#913985 = 2) THEN productPlant#913945.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile WHEN (preferredUomSourceCode#913985 = 3) THEN sos#913929.logisticalRoundingProfile.logisticalRoundingProfile WHEN (preferredUomSourceCode#913985 = 4) THEN coalesce(productPlant#913945.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile, sos#913929.logisticalRoundingProfile.logisticalRoundingProfile) WHEN (preferredUomSourceCode#913985 = 5) THEN coalesce(sos#913929.logisticalRoundingProfile.logisticalRoundingProfile, productPlant#913945.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile) END AS preferredRoundingProfile#913986]
Input [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredUomSourceCode#913985]
(38) Project
Output [36]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986, cast(null as string) AS logisticalRoundingProfile#913993, cast(null as string) AS _extract_internalRefUUID#914260]
Input [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986]
(39) Project
Output [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986]
Input [36]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986, logisticalRoundingProfile#913993, _extract_internalRefUUID#914260]
(40) Project
Output [35]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986, cast(null as string) AS logisticalRoundingProfile#914020]
Input [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986]
(41) Project
Output [33]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, transform(transform(logisticUnits#913980, lambdafunction(named_struct(uom, lambda x_2376#914028.uom, uomUuid, lambda x_2376#914028.uomUuid, numerator, lambda x_2376#914028.numerator, denominator, lambda x_2376#914028.denominator, isOrderUnit, lambda x_2376#914028.isOrderUnit, isPreferred, CASE WHEN array_contains([], lambda x_2376#914028.uomUuid) THEN true ELSE lambda x_2376#914028.isPreferred END), lambda x_2376#914028, false)), lambdafunction(named_struct(uom, lambda x_2378#914029.uom, uomUuid, lambda x_2378#914029.uomUuid, numerator, lambda x_2378#914029.numerator, denominator, lambda x_2378#914029.denominator, isOrderUnit, lambda x_2378#914029.isOrderUnit, isPreferred, CASE WHEN array_contains(transform(transform(logisticUnits#913980, lambdafunction(named_struct(uom, lambda x_2376#914030.uom, uomUuid, lambda x_2376#914030.uomUuid, numerator, lambda x_2376#914030.numerator, denominator, lambda x_2376#914030.denominator, isOrderUnit, lambda x_2376#914030.isOrderUnit, isPreferred, CASE WHEN array_contains([], lambda x_2376#914030.uomUuid) THEN true ELSE lambda x_2376#914030.isPreferred END), lambda x_2376#914030, false)), lambdafunction(lambda x_2377#914031.isPreferred, lambda x_2377#914031, false)), true) THEN lambda x_2378#914029.isPreferred ELSE lambda x_2378#914029.isOrderUnit END), lambda x_2378#914029, false)) AS logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978]
Input [35]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986, logisticalRoundingProfile#914020]
(42) Project
Output [33]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, CASE WHEN isnotnull(supplyingPlant#913884) THEN productPlant#913945.productionAspect.productPlanningPlants.minimumLotSize ELSE ((sos#913929.minimumOrderQuantity * cast(filter(logisticUnits#914027, lambdafunction(lambda x#914035.isOrderUnit, lambda x#914035, false))[0].numerator as double)) / cast(filter(logisticUnits#914027, lambdafunction(lambda x#914036.isOrderUnit, lambda x#914036, false))[0].denominator as double)) END AS minimumOrderQuantity#914032]
Input [33]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978]
(43) Scan parquet
Output [4]: [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
Batched: true
Location: InMemoryFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-param-determination-service/out/10000002110/0_1_10000002110/constraintprofile]
ReadSchema: struct<product:string,plant:string,orderDateTime:timestamp,constraintprofile:string>
(44) ColumnarToRow [codegen id : 5]
Input [4]: [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
(45) Exchange
Input [4]: [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358616]
(46) ShuffleQueryStage
Output [4]: [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
Arguments: 6
(47) BroadcastExchange
Input [4]: [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true]), coalesce(input[1, string, true], ), isnull(input[1, string, true]), coalesce(input[2, timestamp, true], 1970-01-01 00:00:00), isnull(input[2, timestamp, true])),false), [plan_id=359162]
(48) BroadcastQueryStage
Output [4]: [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
Arguments: 14
(49) BroadcastHashJoin
Left keys [6]: [coalesce(product#913886, ), isnull(product#913886), coalesce(plant#913881, ), isnull(plant#913881), coalesce(orderDateTime#913887, 1970-01-01 00:00:00), isnull(orderDateTime#913887)]
Right keys [6]: [coalesce(product#914037, ), isnull(product#914037), coalesce(plant#914038, ), isnull(plant#914038), coalesce(orderDateTime#914039, 1970-01-01 00:00:00), isnull(orderDateTime#914039)]
Join type: LeftOuter
Join condition: None
(50) Project
Output [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914032, constraintProfile#914040]
Input [37]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914032, product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
(51) Scan parquet
Output [5]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, maxRangeCoverage#914046, minOrderQuantity#914047]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/constraint-profile]
ReadSchema: struct<constraintProfile:string,minServiceLevel:struct<level:double,rank:int,isActive:boolean>,maxServiceLevelEndListing:struct<level:double,rank:int,isActive:boolean>,maxRangeCoverage:struct<range:int,rank:int,isActive:boolean>,minOrderQuantity:struct<rank:int,isActive:boolean>>
(52) ColumnarToRow [codegen id : 6]
Input [5]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, maxRangeCoverage#914046, minOrderQuantity#914047]
(53) Project [codegen id : 6]
Output [7]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, maxRangeCoverage#914046.isActive AS _extract_isActive#914283, maxRangeCoverage#914046.range AS _extract_range#914284, maxRangeCoverage#914046.rank AS _extract_rank#914285, minOrderQuantity#914047]
Input [5]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, maxRangeCoverage#914046, minOrderQuantity#914047]
(54) Exchange
Input [7]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, _extract_isActive#914283, _extract_range#914284, _extract_rank#914285, minOrderQuantity#914047]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358637]
(55) ShuffleQueryStage
Output [7]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, _extract_isActive#914283, _extract_range#914284, _extract_rank#914285, minOrderQuantity#914047]
Arguments: 7
(56) BroadcastExchange
Input [7]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, _extract_isActive#914283, _extract_range#914284, _extract_rank#914285, minOrderQuantity#914047]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=359166]
(57) BroadcastQueryStage
Output [7]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, _extract_isActive#914283, _extract_range#914284, _extract_rank#914285, minOrderQuantity#914047]
Arguments: 17
(58) BroadcastHashJoin
Left keys [2]: [coalesce(constraintProfile#914040, ), isnull(constraintProfile#914040)]
Right keys [2]: [coalesce(constraintProfile#914041, ), isnull(constraintProfile#914041)]
Join type: LeftOuter
Join condition: None
(59) Project
Output [35]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, array(CASE WHEN (minServiceLevel#914043.isActive <=> true) THEN minServiceLevel#914043.level END, CASE WHEN (_extract_isActive#914283 <=> true) THEN cast(_extract_range#914284 as double) END, coalesce(minimumOrderQuantity#914032, 0.0), CASE WHEN (maxServiceLevelEndListing#914045.isActive <=> true) THEN maxServiceLevelEndListing#914045.level END, null) AS constraintValues#914056, array(CASE WHEN (minServiceLevel#914043.isActive <=> true) THEN minServiceLevel#914043.rank ELSE 0 END, CASE WHEN (_extract_isActive#914283 <=> true) THEN _extract_rank#914285 ELSE 0 END, CASE WHEN (minOrderQuantity#914047.isActive <=> true) THEN minOrderQuantity#914047.rank ELSE 0 END, CASE WHEN (maxServiceLevelEndListing#914045.isActive <=> true) THEN maxServiceLevelEndListing#914045.rank ELSE 0 END, 0) AS constraintRanks#914057, array((minServiceLevel#914043.isActive <=> true), (_extract_isActive#914283 <=> true), (minOrderQuantity#914047.isActive <=> true), (maxServiceLevelEndListing#914045.isActive <=> true), false) AS constraintIsActive#914058]
Input [41]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914032, constraintProfile#914040, constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, _extract_isActive#914283, _extract_range#914284, _extract_rank#914285, minOrderQuantity#914047]
(60) Project
Output [35]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, array(CASE WHEN isnull(filter(null, lambdafunction((lambda x_2386#914095.label = minServiceLevel), lambda x_2386#914095, false))[0]) THEN element_at(constraintValues#914056, 1, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2386#914096.label = minServiceLevel), lambda x_2386#914096, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2386#914097.label = minServiceLevel), lambda x_2386#914097, false))[0].value END END, CASE WHEN isnull(filter(null, lambdafunction((lambda x_2387#914098.label = maxRangeCoverage), lambda x_2387#914098, false))[0]) THEN element_at(constraintValues#914056, 2, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2387#914099.label = maxRangeCoverage), lambda x_2387#914099, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2387#914100.label = maxRangeCoverage), lambda x_2387#914100, false))[0].value END END, element_at(constraintValues#914056, 3, None, false), CASE WHEN isnull(filter(null, lambdafunction((lambda x_2388#914101.label = maxServiceLevelEndListing), lambda x_2388#914101, false))[0]) THEN element_at(constraintValues#914056, 4, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2388#914102.label = maxServiceLevelEndListing), lambda x_2388#914102, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2388#914103.label = maxServiceLevelEndListing), lambda x_2388#914103, false))[0].value END END, CASE WHEN filter(null, lambdafunction((lambda x_2389#914104.label = lockedOrderQuantity), lambda x_2389#914104, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2389#914105.label = lockedOrderQuantity), lambda x_2389#914105, false))[0].value END) AS constraintValues#914094, constraintRanks#914057, array(coalesce(filter(null, lambdafunction((lambda x_2381#914089.label = minServiceLevel), lambda x_2381#914089, false))[0].isActive, element_at(constraintIsActive#914058, 1, None, false)), coalesce(filter(null, lambdafunction((lambda x_2382#914090.label = maxRangeCoverage), lambda x_2382#914090, false))[0].isActive, element_at(constraintIsActive#914058, 2, None, false)), coalesce(filter(null, lambdafunction((lambda x_2383#914091.label = minOrderQuantity), lambda x_2383#914091, false))[0].isActive, element_at(constraintIsActive#914058, 3, None, false)), coalesce(filter(null, lambdafunction((lambda x_2384#914092.label = maxServiceLevelEndListing), lambda x_2384#914092, false))[0].isActive, element_at(constraintIsActive#914058, 4, None, false)), coalesce(filter(null, lambdafunction((lambda x_2385#914093.label = lockedOrderQuantity), lambda x_2385#914093, false))[0].isActive, false)) AS constraintIsActive#914088]
Input [35]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, constraintValues#914056, constraintRanks#914057, constraintIsActive#914058]
(61) Project
Output [42]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, productInformation#913962.unitOfMeasures AS _extract_unitOfMeasures#914281, productInformation#913962.baseUnitOfMeasure.internalRefUUID AS _extract_internalRefUUID#914282, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, CASE WHEN element_at(constraintIsActive#914088, 3, None, false) THEN element_at(constraintValues#914094, 3, None, false) ELSE -1.0 END AS minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, sos#913929.purchasingPriceAspect.netPrice.amount AS netPriceAmount#914107, sos#913929.purchasingPriceAspect.netPrice.currencyCode.code AS netPriceCurrencyCode#914109, sos#913929.purchasingPriceAspect.netPriceQuantity AS netPriceQuantity#914111, sos#913929.purchasingPriceAspect.netPriceUnit.code AS netPriceQuantityUom#914113, sos#913929.purchasingPriceAspect.netPriceUnit.internalRefUUID AS netPriceQuantityUomUuid#914115, struct(value, CASE WHEN (sos#913929.purchasingPriceAspect.netPriceUnit.internalRefUUID <=> orderQuantityBaseUomUuid#913978) THEN (sos#913929.purchasingPriceAspect.netPrice.amount / sos#913929.purchasingPriceAspect.netPriceQuantity) ELSE (((sos#913929.purchasingPriceAspect.netPrice.amount / sos#913929.purchasingPriceAspect.netPriceQuantity) * cast(filter(logisticUnits#914027, lambdafunction((lambda x_2390#914129.uomUuid = sos#913929.purchasingPriceAspect.netPriceUnit.internalRefUUID), lambda x_2390#914129, false))[0].denominator as double)) / cast(filter(logisticUnits#914027, lambdafunction((lambda x_2390#914130.uomUuid = sos#913929.purchasingPriceAspect.netPriceUnit.internalRefUUID), lambda x_2390#914130, false))[0].numerator as double)) END, dimensionType, 0, dimensionCode, sos#913929.purchasingPriceAspect.netPrice.currencyCode.code, dimensionCodeUuid, null, isoCode, null) AS CURRENCY#914128]
Input [35]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088]
(62) Scan parquet
Output [3]: [internalUUID#914118, isoCode#914122, systemId#914117]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-common-unitofmeasurecodes-v2]
ReadSchema: struct<internalUUID:string,isoCode:struct<code:string>>
(63) ColumnarToRow [codegen id : 7]
Input [3]: [internalUUID#914118, isoCode#914122, systemId#914117]
(64) Project [codegen id : 7]
Output [2]: [internalUUID#914118, isoCode#914122.code AS _extract_code#914259]
Input [3]: [internalUUID#914118, isoCode#914122, systemId#914117]
(65) Exchange
Input [2]: [internalUUID#914118, _extract_code#914259]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358662]
(66) ShuffleQueryStage
Output [2]: [internalUUID#914118, _extract_code#914259]
Arguments: 8
(67) BroadcastExchange
Input [2]: [internalUUID#914118, _extract_code#914259]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=359172]
(68) BroadcastQueryStage
Output [2]: [internalUUID#914118, _extract_code#914259]
Arguments: 18
(69) BroadcastHashJoin
Left keys [2]: [coalesce(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID, ), isnull(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID)]
Right keys [2]: [coalesce(internalUUID#914118, ), isnull(internalUUID#914118)]
Join type: LeftOuter
Join condition: None
(70) Project
Output [43]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, _extract_unitOfMeasures#914281, _extract_internalRefUUID#914282, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, CURRENCY#914128, struct(value, cast(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914144.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914144, false))[0].productDimensions, lambdafunction((lambda x_2392#914150.dimensionName.code = VOLUME), lambda x_2392#914150, false))[0].dimensionValue as double), dimensionType, 1, dimensionCode, filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914145.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914145, false))[0].productDimensions, lambdafunction((lambda x_2392#914151.dimensionName.code = VOLUME), lambda x_2392#914151, false))[0].measurementUnit.code, dimensionCodeUuid, filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914146.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914146, false))[0].productDimensions, lambdafunction((lambda x_2392#914152.dimensionName.code = VOLUME), lambda x_2392#914152, false))[0].measurementUnit.internalRefUUID, isoCode, _extract_code#914259) AS VOLUME#914140]
Input [44]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, _extract_unitOfMeasures#914281, _extract_internalRefUUID#914282, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, CURRENCY#914128, internalUUID#914118, _extract_code#914259]
(71) ReusedExchange [Reuses operator id: 67]
Output [2]: [internalUUID#914154, _extract_code#914256]
(72) BroadcastQueryStage
Output [2]: [internalUUID#914154, _extract_code#914256]
Arguments: 19
(73) BroadcastHashJoin
Left keys [2]: [coalesce(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID, ), isnull(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID)]
Right keys [2]: [coalesce(internalUUID#914154, ), isnull(internalUUID#914154)]
Join type: LeftOuter
Join condition: None
(74) Project
Output [40]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, filter(array(CURRENCY#914128, VOLUME#914140, struct(value, cast(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914172.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914172, false))[0].productDimensions, lambdafunction((lambda x_2394#914178.dimensionName.code = GROSS_WT), lambda x_2394#914178, false))[0].dimensionValue as double), dimensionType, 3, dimensionCode, filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914173.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914173, false))[0].productDimensions, lambdafunction((lambda x_2394#914179.dimensionName.code = GROSS_WT), lambda x_2394#914179, false))[0].measurementUnit.code, dimensionCodeUuid, filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914174.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914174, false))[0].productDimensions, lambdafunction((lambda x_2394#914180.dimensionName.code = GROSS_WT), lambda x_2394#914180, false))[0].measurementUnit.internalRefUUID, isoCode, _extract_code#914256)), lambdafunction(isnotnull(lambda x_2395#914182.value), lambda x_2395#914182, false)) AS measurements#914181]
Input [45]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, _extract_unitOfMeasures#914281, _extract_internalRefUUID#914282, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, CURRENCY#914128, VOLUME#914140, internalUUID#914154, _extract_code#914256]
(75) Scan parquet
Output [6]: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
Batched: true
Location: InMemoryFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-param-determination-service/out/10000002110/SupplyNetworkProfiles/assignments]
ReadSchema: struct<supplier:string,subrange:string,plant:string,deliverydatetime:timestamp,supplierGroup:string,optimizationGroups:array<string>>
(76) ColumnarToRow [codegen id : 9]
Input [6]: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
(77) Exchange
Input [6]: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358706]
(78) ShuffleQueryStage
Output [6]: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
Arguments: 11
(79) BroadcastExchange
Input [6]: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[4, string, true], ), isnull(input[4, string, true]), coalesce(input[0, string, true], ), isnull(input[0, string, true]), coalesce(input[1, string, true], ), isnull(input[1, string, true]), coalesce(input[2, string, true], ), isnull(input[2, string, true]), coalesce(input[3, timestamp, true], 1970-01-01 00:00:00), isnull(input[3, timestamp, true])),false), [plan_id=359180]
(80) BroadcastQueryStage
Output [6]: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
Arguments: 15
(81) BroadcastHashJoin [codegen id : 13]
Left keys [10]: [coalesce(supplierGroup#913879, ), isnull(supplierGroup#913879), coalesce(supplier#913880, ), isnull(supplier#913880), coalesce(subrange#913883, ), isnull(subrange#913883), coalesce(plant#913881, ), isnull(plant#913881), coalesce(deliveryDateTime#913882, 1970-01-01 00:00:00), isnull(deliveryDateTime#913882)]
Right keys [10]: [coalesce(supplierGroup#914189, ), isnull(supplierGroup#914189), coalesce(supplier#914184, ), isnull(supplier#914184), coalesce(subrange#914185, ), isnull(subrange#914185), coalesce(plant#914186, ), isnull(plant#914186), coalesce(deliveryDateTime#914187, 1970-01-01 00:00:00), isnull(deliveryDateTime#914187)]
Join type: LeftOuter
Join condition: (isnull(supplyingPlant#913884) AND isnull(productGroup#913885))
(82) Project [codegen id : 13]
Output [44]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, [ServiceLevel,RangeOfCoverage,Quantity,ServiceLevelAtStartOfDelisting,Quantity] AS constraintLabels#914054, [GE,LE,GE,LE,EQ] AS constraintOperators#914055, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, null AS originalReplenishmentRunId#914183L, coalesce(optimizationGroups#914191, []) AS optimizationGroups#914195]
Input [46]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
(83) ResultQueryStage
Output [44]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintLabels#914054, constraintOperators#914055, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, originalReplenishmentRunId#914183L, optimizationGroups#914195]
Arguments: 22
(84) Exchange
Input [25]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903]
Arguments: hashpartitioning(product#913886, plant#913881, 25), REPARTITION_BY_NUM, [plan_id=358042]
(85) Project
Output [24]: [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
Input [24]: [internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928, systemId#913905]
(86) Exchange
Input [24]: [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358045]
(87) BroadcastExchange
Input [24]: [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[1, string, true], ), isnull(input[1, string, true])),false), [plan_id=358098]
(88) BroadcastHashJoin
Left keys [2]: [coalesce(sourceOfSupplyUuid#913891, ), isnull(sourceOfSupplyUuid#913891)]
Right keys [2]: [coalesce(internalUUID#913906, ), isnull(internalUUID#913906)]
Join type: LeftOuter
Join condition: None
(89) Project
Output [26]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, struct(systemId, systemId#913905, internalUUID, internalUUID#913906, supplier, supplier#913907, receiver, receiver#913908, product, product#913909, receivingPlant, receivingPlant#913910, sourceOfSupplyType, sourceOfSupplyType#913911, purchasingGroup, purchasingGroup#913912, purchasingOrganization, purchasingOrganization#913913, productGroup, productGroup#913914, validFrom, validFrom#913915, validTo, validTo#913916, priority, ... 23 more fields) AS sos#913929]
Input [49]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928]
(90) Filter
Input [8]: [internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940, systemId#913933]
Condition : plant#913935.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(91) Project
Output [8]: [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
Input [8]: [internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940, systemId#913933]
(92) Exchange
Input [8]: [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358051]
(93) BroadcastExchange
Input [8]: [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[3, struct<internalRefUUID:string,id:string>, true].internalRefUUID, ), isnull(input[3, struct<internalRefUUID:string,id:string>, true].internalRefUUID), coalesce(input[2, struct<internalRefUUID:string,id:string>, true].internalRefUUID, ), isnull(input[2, struct<internalRefUUID:string,id:string>, true].internalRefUUID)),false), [plan_id=358102]
(94) BroadcastHashJoin
Left keys [4]: [coalesce(product#913886, ), isnull(product#913886), coalesce(plant#913881, ), isnull(plant#913881)]
Right keys [4]: [coalesce(product#913936.internalRefUUID, ), isnull(product#913936.internalRefUUID), coalesce(plant#913935.internalRefUUID, ), isnull(plant#913935.internalRefUUID)]
Join type: LeftOuter
Join condition: None
(95) Project
Output [29]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, CASE WHEN isnotnull(productionAspect#913938) THEN struct(systemId, systemId#913933, internalUUID, internalUUID#913934, plant, plant#913935, product, product#913936, blockedForReplenishmentStartingFrom, blockedForReplenishmentStartingFrom#913937, productionAspect, productionAspect#913938, salesPlant, salesPlant#913939, listing, listing#913940) END AS productPlant#913945, product#913936.id AS externalProductId#913946, plant#913935.id AS externalPlantId#913948]
Input [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940]
(96) Filter
Input [12]: [internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961, systemId#913950]
Condition : isnotnull(internalUUID#913951)
(97) Project
Output [12]: [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
Input [12]: [internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961, systemId#913950]
(98) Exchange
Input [12]: [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358057]
(99) BroadcastExchange
Input [12]: [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
Arguments: HashedRelationBroadcastMode(List(input[1, string, true]),false), [plan_id=358106]
(100) BroadcastHashJoin
Left keys [1]: [product#913886]
Right keys [1]: [internalUUID#913951]
Join type: LeftOuter
Join condition: None
(101) Project
Output [30]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, CASE WHEN isnotnull(internalUUID#913951) THEN struct(systemId, systemId#913950, internalUUID, internalUUID#913951, id, id#913952, displayId, displayId#913953, name, name#913954, baseUnitOfMeasure, baseUnitOfMeasure#913955, unitOfMeasures, unitOfMeasures#913956, unitOfMeasureConversions, unitOfMeasureConversions#913957, productionAspect, productionAspect#913958, salesAspect, salesAspect#913959, procurementAspect, procurementAspect#913960, productGroup, productGroup#913961) END AS productInformation#913962]
Input [41]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961]
(102) Project
Output [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, transform(coalesce(transform(filter(productInformation#913962.unitOfMeasureConversions, lambdafunction((array_contains(transform(productInformation#913962.unitOfMeasures, lambdafunction(lambda x_2373#913974.measurementUnit.internalRefUUID, lambda x_2373#913974, false)), lambda x_2372#913971.measurementUnit1.internalRefUUID) AND (lambda x_2372#913971.measurementUnit2.internalRefUUID = productInformation#913962.baseUnitOfMeasure.internalRefUUID)), lambda x_2372#913971, false)), lambdafunction(struct(uom, lambda x_2374#913975.measurementUnit1.code, uomUuid, lambda x_2374#913975.measurementUnit1.internalRefUUID, numerator, lambda x_2374#913975.quantityNumerator, denominator, lambda x_2374#913975.quantityDenominator, isOrderUnit, false, isPreferred, false), lambda x_2374#913975, false)), []), lambdafunction(named_struct(uom, lambda x_2375#913981.uom, uomUuid, lambda x_2375#913981.uomUuid, numerator, lambda x_2375#913981.numerator, denominator, lambda x_2375#913981.denominator, isOrderUnit, ((lambda x_2375#913981.uomUuid = coalesce(sos#913929.orderQuantityUnit.internalRefUUID, productInformation#913962.procurementAspect.orderUnit.internalRefUUID, productInformation#913962.baseUnitOfMeasure.internalRefUUID)) <=> true), isPreferred, lambda x_2375#913981.isPreferred), lambda x_2375#913981, false)) AS logisticUnits#913980, productInformation#913962.baseUnitOfMeasure.code AS orderQuantityBaseUom#913976, productInformation#913962.baseUnitOfMeasure.internalRefUUID AS orderQuantityBaseUomUuid#913978, CASE WHEN isnull(supplyingPlant#913884) THEN 4 ELSE 1 END AS preferredUomSourceCode#913985]
Input [30]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962]
(103) Project
Output [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, CASE WHEN (preferredUomSourceCode#913985 = 2) THEN productPlant#913945.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile WHEN (preferredUomSourceCode#913985 = 3) THEN sos#913929.logisticalRoundingProfile.logisticalRoundingProfile WHEN (preferredUomSourceCode#913985 = 4) THEN coalesce(productPlant#913945.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile, sos#913929.logisticalRoundingProfile.logisticalRoundingProfile) WHEN (preferredUomSourceCode#913985 = 5) THEN coalesce(sos#913929.logisticalRoundingProfile.logisticalRoundingProfile, productPlant#913945.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile) END AS preferredRoundingProfile#913986]
Input [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredUomSourceCode#913985]
(104) InMemoryTableScan
Output [2]: [logisticalRoundingProfile#913993, plant#913994]
Arguments: [logisticalRoundingProfile#913993, plant#913994]
(105) InMemoryRelation
Arguments: [logisticalRoundingProfile#913993, plant#913994, logisticalRoundingRule#913995], StorageLevel(disk, memory, 2 replicas)
(106) LocalTableScan
Output [3]: [logisticalRoundingProfile#913993, plant#913994, logisticalRoundingRule#913995]
Arguments: <empty>, [logisticalRoundingProfile#913993, plant#913994, logisticalRoundingRule#913995]
(107) Project
Output [2]: [logisticalRoundingProfile#913993, plant#913994.internalRefUUID AS _extract_internalRefUUID#914260]
Input [2]: [logisticalRoundingProfile#913993, plant#913994]
(108) BroadcastExchange
Input [2]: [logisticalRoundingProfile#913993, _extract_internalRefUUID#914260]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, false], ), isnull(input[0, string, false]), coalesce(input[1, string, true], ), isnull(input[1, string, true])),false), [plan_id=358112]
(109) BroadcastHashJoin
Left keys [4]: [coalesce(preferredRoundingProfile#913986, ), isnull(preferredRoundingProfile#913986), coalesce(plant#913881, ), isnull(plant#913881)]
Right keys [4]: [coalesce(logisticalRoundingProfile#913993, ), isnull(logisticalRoundingProfile#913993), coalesce(_extract_internalRefUUID#914260, ), isnull(_extract_internalRefUUID#914260)]
Join type: LeftOuter
Join condition: None
(110) Project
Output [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986]
Input [36]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986, logisticalRoundingProfile#913993, _extract_internalRefUUID#914260]
(111) InMemoryTableScan
Output [2]: [logisticalRoundingProfile#914020, plant#914021]
Arguments: [logisticalRoundingProfile#914020, plant#914021], [isnull(plant#914021.internalRefUUID)]
(112) InMemoryRelation
Arguments: [logisticalRoundingProfile#914020, plant#914021, logisticalRoundingRule#914022], StorageLevel(disk, memory, 2 replicas)
(113) Filter
Input [2]: [logisticalRoundingProfile#914020, plant#914021]
Condition : isnull(plant#914021.internalRefUUID)
(114) Project
Output [1]: [logisticalRoundingProfile#914020]
Input [2]: [logisticalRoundingProfile#914020, plant#914021]
(115) BroadcastExchange
Input [1]: [logisticalRoundingProfile#914020]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, false], ), isnull(input[0, string, false])),false), [plan_id=358116]
(116) BroadcastHashJoin
Left keys [2]: [coalesce(preferredRoundingProfile#913986, ), isnull(preferredRoundingProfile#913986)]
Right keys [2]: [coalesce(logisticalRoundingProfile#914020, ), isnull(logisticalRoundingProfile#914020)]
Join type: LeftOuter
Join condition: None
(117) Project
Output [33]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, transform(transform(logisticUnits#913980, lambdafunction(named_struct(uom, lambda x_2376#914028.uom, uomUuid, lambda x_2376#914028.uomUuid, numerator, lambda x_2376#914028.numerator, denominator, lambda x_2376#914028.denominator, isOrderUnit, lambda x_2376#914028.isOrderUnit, isPreferred, CASE WHEN array_contains([], lambda x_2376#914028.uomUuid) THEN true ELSE lambda x_2376#914028.isPreferred END), lambda x_2376#914028, false)), lambdafunction(named_struct(uom, lambda x_2378#914029.uom, uomUuid, lambda x_2378#914029.uomUuid, numerator, lambda x_2378#914029.numerator, denominator, lambda x_2378#914029.denominator, isOrderUnit, lambda x_2378#914029.isOrderUnit, isPreferred, CASE WHEN array_contains(transform(transform(logisticUnits#913980, lambdafunction(named_struct(uom, lambda x_2376#914030.uom, uomUuid, lambda x_2376#914030.uomUuid, numerator, lambda x_2376#914030.numerator, denominator, lambda x_2376#914030.denominator, isOrderUnit, lambda x_2376#914030.isOrderUnit, isPreferred, CASE WHEN array_contains([], lambda x_2376#914030.uomUuid) THEN true ELSE lambda x_2376#914030.isPreferred END), lambda x_2376#914030, false)), lambdafunction(lambda x_2377#914031.isPreferred, lambda x_2377#914031, false)), true) THEN lambda x_2378#914029.isPreferred ELSE lambda x_2378#914029.isOrderUnit END), lambda x_2378#914029, false)) AS logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978]
Input [35]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#913980, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, preferredRoundingProfile#913986, logisticalRoundingProfile#914020]
(118) Project
Output [33]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, CASE WHEN isnotnull(supplyingPlant#913884) THEN productPlant#913945.productionAspect.productPlanningPlants.minimumLotSize ELSE ((sos#913929.minimumOrderQuantity * cast(filter(logisticUnits#914027, lambdafunction(lambda x#914035.isOrderUnit, lambda x#914035, false))[0].numerator as double)) / cast(filter(logisticUnits#914027, lambdafunction(lambda x#914036.isOrderUnit, lambda x#914036, false))[0].denominator as double)) END AS minimumOrderQuantity#914032]
Input [33]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, productPlant#913945, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978]
(119) Exchange
Input [4]: [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358073]
(120) BroadcastExchange
Input [4]: [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true]), coalesce(input[1, string, true], ), isnull(input[1, string, true]), coalesce(input[2, timestamp, true], 1970-01-01 00:00:00), isnull(input[2, timestamp, true])),false), [plan_id=358121]
(121) BroadcastHashJoin
Left keys [6]: [coalesce(product#913886, ), isnull(product#913886), coalesce(plant#913881, ), isnull(plant#913881), coalesce(orderDateTime#913887, 1970-01-01 00:00:00), isnull(orderDateTime#913887)]
Right keys [6]: [coalesce(product#914037, ), isnull(product#914037), coalesce(plant#914038, ), isnull(plant#914038), coalesce(orderDateTime#914039, 1970-01-01 00:00:00), isnull(orderDateTime#914039)]
Join type: LeftOuter
Join condition: None
(122) Project
Output [34]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914032, constraintProfile#914040]
Input [37]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914032, product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040]
(123) Project
Output [7]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, maxRangeCoverage#914046.isActive AS _extract_isActive#914283, maxRangeCoverage#914046.range AS _extract_range#914284, maxRangeCoverage#914046.rank AS _extract_rank#914285, minOrderQuantity#914047]
Input [5]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, maxRangeCoverage#914046, minOrderQuantity#914047]
(124) Exchange
Input [7]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, _extract_isActive#914283, _extract_range#914284, _extract_rank#914285, minOrderQuantity#914047]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358078]
(125) BroadcastExchange
Input [7]: [constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, _extract_isActive#914283, _extract_range#914284, _extract_rank#914285, minOrderQuantity#914047]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=358125]
(126) BroadcastHashJoin
Left keys [2]: [coalesce(constraintProfile#914040, ), isnull(constraintProfile#914040)]
Right keys [2]: [coalesce(constraintProfile#914041, ), isnull(constraintProfile#914041)]
Join type: LeftOuter
Join condition: None
(127) Project
Output [35]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, array(CASE WHEN (minServiceLevel#914043.isActive <=> true) THEN minServiceLevel#914043.level END, CASE WHEN (_extract_isActive#914283 <=> true) THEN cast(_extract_range#914284 as double) END, coalesce(minimumOrderQuantity#914032, 0.0), CASE WHEN (maxServiceLevelEndListing#914045.isActive <=> true) THEN maxServiceLevelEndListing#914045.level END, null) AS constraintValues#914056, array(CASE WHEN (minServiceLevel#914043.isActive <=> true) THEN minServiceLevel#914043.rank ELSE 0 END, CASE WHEN (_extract_isActive#914283 <=> true) THEN _extract_rank#914285 ELSE 0 END, CASE WHEN (minOrderQuantity#914047.isActive <=> true) THEN minOrderQuantity#914047.rank ELSE 0 END, CASE WHEN (maxServiceLevelEndListing#914045.isActive <=> true) THEN maxServiceLevelEndListing#914045.rank ELSE 0 END, 0) AS constraintRanks#914057, array((minServiceLevel#914043.isActive <=> true), (_extract_isActive#914283 <=> true), (minOrderQuantity#914047.isActive <=> true), (maxServiceLevelEndListing#914045.isActive <=> true), false) AS constraintIsActive#914058]
Input [41]: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914032, constraintProfile#914040, constraintProfile#914041, minServiceLevel#914043, maxServiceLevelEndListing#914045, _extract_isActive#914283, _extract_range#914284, _extract_rank#914285, minOrderQuantity#914047]
(128) Project
Output [35]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, array(CASE WHEN isnull(filter(null, lambdafunction((lambda x_2386#914095.label = minServiceLevel), lambda x_2386#914095, false))[0]) THEN element_at(constraintValues#914056, 1, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2386#914096.label = minServiceLevel), lambda x_2386#914096, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2386#914097.label = minServiceLevel), lambda x_2386#914097, false))[0].value END END, CASE WHEN isnull(filter(null, lambdafunction((lambda x_2387#914098.label = maxRangeCoverage), lambda x_2387#914098, false))[0]) THEN element_at(constraintValues#914056, 2, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2387#914099.label = maxRangeCoverage), lambda x_2387#914099, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2387#914100.label = maxRangeCoverage), lambda x_2387#914100, false))[0].value END END, element_at(constraintValues#914056, 3, None, false), CASE WHEN isnull(filter(null, lambdafunction((lambda x_2388#914101.label = maxServiceLevelEndListing), lambda x_2388#914101, false))[0]) THEN element_at(constraintValues#914056, 4, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2388#914102.label = maxServiceLevelEndListing), lambda x_2388#914102, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2388#914103.label = maxServiceLevelEndListing), lambda x_2388#914103, false))[0].value END END, CASE WHEN filter(null, lambdafunction((lambda x_2389#914104.label = lockedOrderQuantity), lambda x_2389#914104, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2389#914105.label = lockedOrderQuantity), lambda x_2389#914105, false))[0].value END) AS constraintValues#914094, constraintRanks#914057, array(coalesce(filter(null, lambdafunction((lambda x_2381#914089.label = minServiceLevel), lambda x_2381#914089, false))[0].isActive, element_at(constraintIsActive#914058, 1, None, false)), coalesce(filter(null, lambdafunction((lambda x_2382#914090.label = maxRangeCoverage), lambda x_2382#914090, false))[0].isActive, element_at(constraintIsActive#914058, 2, None, false)), coalesce(filter(null, lambdafunction((lambda x_2383#914091.label = minOrderQuantity), lambda x_2383#914091, false))[0].isActive, element_at(constraintIsActive#914058, 3, None, false)), coalesce(filter(null, lambdafunction((lambda x_2384#914092.label = maxServiceLevelEndListing), lambda x_2384#914092, false))[0].isActive, element_at(constraintIsActive#914058, 4, None, false)), coalesce(filter(null, lambdafunction((lambda x_2385#914093.label = lockedOrderQuantity), lambda x_2385#914093, false))[0].isActive, false)) AS constraintIsActive#914088]
Input [35]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, constraintValues#914056, constraintRanks#914057, constraintIsActive#914058]
(129) Project
Output [42]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, productInformation#913962.unitOfMeasures AS _extract_unitOfMeasures#914281, productInformation#913962.baseUnitOfMeasure.internalRefUUID AS _extract_internalRefUUID#914282, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, CASE WHEN element_at(constraintIsActive#914088, 3, None, false) THEN element_at(constraintValues#914094, 3, None, false) ELSE -1.0 END AS minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, sos#913929.purchasingPriceAspect.netPrice.amount AS netPriceAmount#914107, sos#913929.purchasingPriceAspect.netPrice.currencyCode.code AS netPriceCurrencyCode#914109, sos#913929.purchasingPriceAspect.netPriceQuantity AS netPriceQuantity#914111, sos#913929.purchasingPriceAspect.netPriceUnit.code AS netPriceQuantityUom#914113, sos#913929.purchasingPriceAspect.netPriceUnit.internalRefUUID AS netPriceQuantityUomUuid#914115, struct(value, CASE WHEN (sos#913929.purchasingPriceAspect.netPriceUnit.internalRefUUID <=> orderQuantityBaseUomUuid#913978) THEN (sos#913929.purchasingPriceAspect.netPrice.amount / sos#913929.purchasingPriceAspect.netPriceQuantity) ELSE (((sos#913929.purchasingPriceAspect.netPrice.amount / sos#913929.purchasingPriceAspect.netPriceQuantity) * cast(filter(logisticUnits#914027, lambdafunction((lambda x_2390#914129.uomUuid = sos#913929.purchasingPriceAspect.netPriceUnit.internalRefUUID), lambda x_2390#914129, false))[0].denominator as double)) / cast(filter(logisticUnits#914027, lambdafunction((lambda x_2390#914130.uomUuid = sos#913929.purchasingPriceAspect.netPriceUnit.internalRefUUID), lambda x_2390#914130, false))[0].numerator as double)) END, dimensionType, 0, dimensionCode, sos#913929.purchasingPriceAspect.netPrice.currencyCode.code, dimensionCodeUuid, null, isoCode, null) AS CURRENCY#914128]
Input [35]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, sos#913929, externalProductId#913946, externalPlantId#913948, productInformation#913962, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088]
(130) Project
Output [2]: [internalUUID#914118, isoCode#914122.code AS _extract_code#914259]
Input [3]: [internalUUID#914118, isoCode#914122, systemId#914117]
(131) Exchange
Input [2]: [internalUUID#914118, _extract_code#914259]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358085]
(132) BroadcastExchange
Input [2]: [internalUUID#914118, _extract_code#914259]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=358131]
(133) BroadcastHashJoin
Left keys [2]: [coalesce(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID, ), isnull(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID)]
Right keys [2]: [coalesce(internalUUID#914118, ), isnull(internalUUID#914118)]
Join type: LeftOuter
Join condition: None
(134) Project
Output [43]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, _extract_unitOfMeasures#914281, _extract_internalRefUUID#914282, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, CURRENCY#914128, struct(value, cast(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914144.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914144, false))[0].productDimensions, lambdafunction((lambda x_2392#914150.dimensionName.code = VOLUME), lambda x_2392#914150, false))[0].dimensionValue as double), dimensionType, 1, dimensionCode, filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914145.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914145, false))[0].productDimensions, lambdafunction((lambda x_2392#914151.dimensionName.code = VOLUME), lambda x_2392#914151, false))[0].measurementUnit.code, dimensionCodeUuid, filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2391#914146.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2391#914146, false))[0].productDimensions, lambdafunction((lambda x_2392#914152.dimensionName.code = VOLUME), lambda x_2392#914152, false))[0].measurementUnit.internalRefUUID, isoCode, _extract_code#914259) AS VOLUME#914140]
Input [44]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, _extract_unitOfMeasures#914281, _extract_internalRefUUID#914282, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, CURRENCY#914128, internalUUID#914118, _extract_code#914259]
(135) Scan parquet
Output [3]: [internalUUID#914154, isoCode#914158, systemId#914153]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-common-unitofmeasurecodes-v2]
ReadSchema: struct<internalUUID:string,isoCode:struct<code:string>>
(136) Project
Output [2]: [internalUUID#914154, isoCode#914158.code AS _extract_code#914256]
Input [3]: [internalUUID#914154, isoCode#914158, systemId#914153]
(137) Exchange
Input [2]: [internalUUID#914154, _extract_code#914256]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358090]
(138) BroadcastExchange
Input [2]: [internalUUID#914154, _extract_code#914256]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=358135]
(139) BroadcastHashJoin
Left keys [2]: [coalesce(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID, ), isnull(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID)]
Right keys [2]: [coalesce(internalUUID#914154, ), isnull(internalUUID#914154)]
Join type: LeftOuter
Join condition: None
(140) Project
Output [40]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, filter(array(CURRENCY#914128, VOLUME#914140, struct(value, cast(filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914172.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914172, false))[0].productDimensions, lambdafunction((lambda x_2394#914178.dimensionName.code = GROSS_WT), lambda x_2394#914178, false))[0].dimensionValue as double), dimensionType, 3, dimensionCode, filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914173.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914173, false))[0].productDimensions, lambdafunction((lambda x_2394#914179.dimensionName.code = GROSS_WT), lambda x_2394#914179, false))[0].measurementUnit.code, dimensionCodeUuid, filter(filter(_extract_unitOfMeasures#914281, lambdafunction((lambda x_2393#914174.measurementUnit.internalRefUUID = _extract_internalRefUUID#914282), lambda x_2393#914174, false))[0].productDimensions, lambdafunction((lambda x_2394#914180.dimensionName.code = GROSS_WT), lambda x_2394#914180, false))[0].measurementUnit.internalRefUUID, isoCode, _extract_code#914256)), lambdafunction(isnotnull(lambda x_2395#914182.value), lambda x_2395#914182, false)) AS measurements#914181]
Input [45]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, _extract_unitOfMeasures#914281, _extract_internalRefUUID#914282, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, CURRENCY#914128, VOLUME#914140, internalUUID#914154, _extract_code#914256]
(141) Exchange
Input [6]: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=358094]
(142) BroadcastExchange
Input [6]: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[4, string, true], ), isnull(input[4, string, true]), coalesce(input[0, string, true], ), isnull(input[0, string, true]), coalesce(input[1, string, true], ), isnull(input[1, string, true]), coalesce(input[2, string, true], ), isnull(input[2, string, true]), coalesce(input[3, timestamp, true], 1970-01-01 00:00:00), isnull(input[3, timestamp, true])),false), [plan_id=358139]
(143) BroadcastHashJoin
Left keys [10]: [coalesce(supplierGroup#913879, ), isnull(supplierGroup#913879), coalesce(supplier#913880, ), isnull(supplier#913880), coalesce(subrange#913883, ), isnull(subrange#913883), coalesce(plant#913881, ), isnull(plant#913881), coalesce(deliveryDateTime#913882, 1970-01-01 00:00:00), isnull(deliveryDateTime#913882)]
Right keys [10]: [coalesce(supplierGroup#914189, ), isnull(supplierGroup#914189), coalesce(supplier#914184, ), isnull(supplier#914184), coalesce(subrange#914185, ), isnull(subrange#914185), coalesce(plant#914186, ), isnull(plant#914186), coalesce(deliveryDateTime#914187, 1970-01-01 00:00:00), isnull(deliveryDateTime#914187)]
Join type: LeftOuter
Join condition: (isnull(supplyingPlant#913884) AND isnull(productGroup#913885))
(144) Project
Output [44]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, [ServiceLevel,RangeOfCoverage,Quantity,ServiceLevelAtStartOfDelisting,Quantity] AS constraintLabels#914054, [GE,LE,GE,LE,EQ] AS constraintOperators#914055, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, null AS originalReplenishmentRunId#914183L, coalesce(optimizationGroups#914191, []) AS optimizationGroups#914195]
Input [46]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, supplierGroup#914189, optimizationGroups#914191]
(145) AdaptiveSparkPlan
Output [44]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintLabels#914054, constraintOperators#914055, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, originalReplenishmentRunId#914183L, optimizationGroups#914195]
Arguments: isFinalPlan=true
(146) TableCacheQueryStage
Output [44]: [availabilityDateTime#913888, clusterId#913899L, constraintIsActive#914088, constraintLabels#914054, constraintOperators#914055, constraintRanks#914057, constraintValues#914094, deliveryDateTime#913882, externalPlantId#913948, externalProductId#913946, isFallbackOrderOnly#913894, logisticUnits#914027, measurements#914181, minimumOrderQuantity#914106, mrpController#913890, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, nextAvailabilityDateTime#913889, optimizationGroups#914195, orderDateTime#913887, orderProposalHorizonGroupingId#913896L, orderProposalId#913895L, orderProposalItemGroupId#913902, orderProposalItemId#913903, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, originalReplenishmentRunId#914183L, plant#913881, previousOrderProposal#913898L, product#913886, productGroup#913885, purchasingGroup#913893, purchasingOrg#913892, sequenceId#913900, sourceOfSupplyUuid#913891, splitIndicator#913897L, subrange#913883, supplier#913880, supplierGroup#913879, supplyingPlant#913884, worklistShardItemId#913901L]
Arguments: 0
(147) Project [codegen id : 1]
Output [45]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintLabels#914054, constraintOperators#914055, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, originalReplenishmentRunId#914183L, optimizationGroups#914195, 0_1_10000002110 AS shardId#918597]
Input [44]: [availabilityDateTime#913888, clusterId#913899L, constraintIsActive#914088, constraintLabels#914054, constraintOperators#914055, constraintRanks#914057, constraintValues#914094, deliveryDateTime#913882, externalPlantId#913948, externalProductId#913946, isFallbackOrderOnly#913894, logisticUnits#914027, measurements#914181, minimumOrderQuantity#914106, mrpController#913890, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, nextAvailabilityDateTime#913889, optimizationGroups#914195, orderDateTime#913887, orderProposalHorizonGroupingId#913896L, orderProposalId#913895L, orderProposalItemGroupId#913902, orderProposalItemId#913903, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, originalReplenishmentRunId#914183L, plant#913881, previousOrderProposal#913898L, product#913886, productGroup#913885, purchasingGroup#913893, purchasingOrg#913892, sequenceId#913900, sourceOfSupplyUuid#913891, splitIndicator#913897L, subrange#913883, supplier#913880, supplierGroup#913879, supplyingPlant#913884, worklistShardItemId#913901L]
(148) ResultQueryStage
Output [45]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintLabels#914054, constraintOperators#914055, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, originalReplenishmentRunId#914183L, optimizationGroups#914195, shardId#918597]
Arguments: 2
(149) Project
Output [45]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintLabels#914054, constraintOperators#914055, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, originalReplenishmentRunId#914183L, optimizationGroups#914195, 0_1_10000002110 AS shardId#918597]
Input [44]: [availabilityDateTime#913888, clusterId#913899L, constraintIsActive#914088, constraintLabels#914054, constraintOperators#914055, constraintRanks#914057, constraintValues#914094, deliveryDateTime#913882, externalPlantId#913948, externalProductId#913946, isFallbackOrderOnly#913894, logisticUnits#914027, measurements#914181, minimumOrderQuantity#914106, mrpController#913890, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, nextAvailabilityDateTime#913889, optimizationGroups#914195, orderDateTime#913887, orderProposalHorizonGroupingId#913896L, orderProposalId#913895L, orderProposalItemGroupId#913902, orderProposalItemId#913903, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, originalReplenishmentRunId#914183L, plant#913881, previousOrderProposal#913898L, product#913886, productGroup#913885, purchasingGroup#913893, purchasingOrg#913892, sequenceId#913900, sourceOfSupplyUuid#913891, splitIndicator#913897L, subrange#913883, supplier#913880, supplierGroup#913879, supplyingPlant#913884, worklistShardItemId#913901L]
(150) AdaptiveSparkPlan
Output [45]: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, externalProductId#913946, externalPlantId#913948, logisticUnits#914027, orderQuantityBaseUom#913976, orderQuantityBaseUomUuid#913978, minimumOrderQuantity#914106, constraintLabels#914054, constraintOperators#914055, constraintValues#914094, constraintRanks#914057, constraintIsActive#914088, netPriceAmount#914107, netPriceCurrencyCode#914109, netPriceQuantity#914111, netPriceQuantityUom#914113, netPriceQuantityUomUuid#914115, measurements#914181, originalReplenishmentRunId#914183L, optimizationGroups#914195, shardId#918597]
Arguments: isFinalPlan=false