== Physical Plan ==
AdaptiveSparkPlan (150)
+- == Current Plan ==
ResultQueryStage (148)
+- * Project (147)
+- TableCacheQueryStage (146), Statistics(sizeInBytes=28.0 KiB, rowCount=18)
+- 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=8.0 KiB, rowCount=18)
: : : : : : : : +- 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=18)
: : : : +- BroadcastExchange (47)
: : : : +- ShuffleQueryStage (46), Statistics(sizeInBytes=2.1 KiB, rowCount=18)
: : : : +- 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=12)
+- BroadcastExchange (79)
+- ShuffleQueryStage (78), Statistics(sizeInBytes=3.0 KiB, rowCount=12)
+- 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=8.0 KiB, rowCount=18)
: : : : : : : : +- 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=18)
: : : : +- BroadcastExchange (47)
: : : : +- ShuffleQueryStage (46), Statistics(sizeInBytes=2.1 KiB, rowCount=18)
: : : : +- 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=12)
+- BroadcastExchange (79)
+- ShuffleQueryStage (78), Statistics(sizeInBytes=3.0 KiB, rowCount=12)
+- 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#826154, clusterId#826165L, constraintIsActive#826354, constraintLabels#826320, constraintOperators#826321, constraintRanks#826323, constraintValues#826360, deliveryDateTime#826148, externalPlantId#826214, externalProductId#826212, isFallbackOrderOnly#826160, logisticUnits#826293, measurements#826469, minimumOrderQuantity#826372, mrpController#826156, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, nextAvailabilityDateTime#826155, optimizationGroups#826483, orderDateTime#826153, orderProposalHorizonGroupingId#826162L, orderProposalId#826161L, orderProposalItemGroupId#826168, orderProposalItemId#826169, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, originalReplenishmentRunId#826471L, plant#826147, previousOrderProposal#826164L, product#826152, productGroup#826151, purchasingGroup#826159, purchasingOrg#826158, sequenceId#826166, sourceOfSupplyUuid#826157, splitIndicator#826163L, subrange#826149, supplier#826146, supplierGroup#826145, supplyingPlant#826150, worklistShardItemId#826167L]
Arguments: [availabilityDateTime#826154, clusterId#826165L, constraintIsActive#826354, constraintLabels#826320, constraintOperators#826321, constraintRanks#826323, constraintValues#826360, deliveryDateTime#826148, externalPlantId#826214, externalProductId#826212, isFallbackOrderOnly#826160, logisticUnits#826293, measurements#826469, minimumOrderQuantity#826372, mrpController#826156, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, nextAvailabilityDateTime#826155, optimizationGroups#826483, orderDateTime#826153, orderProposalHorizonGroupingId#826162L, orderProposalId#826161L, ... 19 more fields]
(2) InMemoryRelation
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 19 more fields], StorageLevel(disk, memory, 2 replicas)
(3) Scan parquet
Output [25]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169]
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/10000002109/shardId=0_1_10000002109]
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#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169]
(5) Exchange
Input [25]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169]
Arguments: hashpartitioning(product#826152, plant#826147, 25), REPARTITION_BY_NUM, [plan_id=326011]
(6) ShuffleQueryStage
Output [25]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169]
Arguments: 0
(7) Scan parquet
Output [24]: [internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194, systemId#826171]
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#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194, systemId#826171]
(9) Project [codegen id : 2]
Output [24]: [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
Input [24]: [internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194, systemId#826171]
(10) Exchange
Input [24]: [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=326030]
(11) ShuffleQueryStage
Output [24]: [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
Arguments: 1
(12) BroadcastExchange
Input [24]: [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[1, string, true], ), isnull(input[1, string, true])),false), [plan_id=326658]
(13) BroadcastQueryStage
Output [24]: [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
Arguments: 20
(14) BroadcastHashJoin [codegen id : 12]
Left keys [2]: [coalesce(sourceOfSupplyUuid#826157, ), isnull(sourceOfSupplyUuid#826157)]
Right keys [2]: [coalesce(internalUUID#826172, ), isnull(internalUUID#826172)]
Join type: LeftOuter
Join condition: None
(15) Project [codegen id : 12]
Output [26]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, struct(systemId, systemId#826171, internalUUID, internalUUID#826172, supplier, supplier#826173, receiver, receiver#826174, product, product#826175, receivingPlant, receivingPlant#826176, sourceOfSupplyType, sourceOfSupplyType#826177, purchasingGroup, purchasingGroup#826178, purchasingOrganization, purchasingOrganization#826179, productGroup, productGroup#826180, validFrom, validFrom#826181, validTo, validTo#826182, priority, ... 23 more fields) AS sos#826195]
Input [49]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
(16) Scan parquet
Output [8]: [internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206, systemId#826199]
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#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206, systemId#826199]
(18) Filter [codegen id : 3]
Input [8]: [internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206, systemId#826199]
Condition : plant#826201.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(19) Project [codegen id : 3]
Output [8]: [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
Input [8]: [internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206, systemId#826199]
(20) Exchange
Input [8]: [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=326057]
(21) ShuffleQueryStage
Output [8]: [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
Arguments: 2
(22) BroadcastExchange
Input [8]: [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
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=326662]
(23) BroadcastQueryStage
Output [8]: [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
Arguments: 21
(24) BroadcastHashJoin [codegen id : 12]
Left keys [4]: [coalesce(product#826152, ), isnull(product#826152), coalesce(plant#826147, ), isnull(plant#826147)]
Right keys [4]: [coalesce(product#826202.internalRefUUID, ), isnull(product#826202.internalRefUUID), coalesce(plant#826201.internalRefUUID, ), isnull(plant#826201.internalRefUUID)]
Join type: LeftOuter
Join condition: None
(25) Project [codegen id : 12]
Output [29]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, CASE WHEN isnotnull(productionAspect#826204) THEN struct(systemId, systemId#826199, internalUUID, internalUUID#826200, plant, plant#826201, product, product#826202, blockedForReplenishmentStartingFrom, blockedForReplenishmentStartingFrom#826203, productionAspect, productionAspect#826204, salesPlant, salesPlant#826205, listing, listing#826206) END AS productPlant#826211, product#826202.id AS externalProductId#826212, plant#826201.id AS externalPlantId#826214]
Input [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
(26) Scan parquet
Output [12]: [internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227, systemId#826216]
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#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227, systemId#826216]
(28) Filter [codegen id : 4]
Input [12]: [internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227, systemId#826216]
Condition : isnotnull(internalUUID#826217)
(29) Project [codegen id : 4]
Output [12]: [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
Input [12]: [internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227, systemId#826216]
(30) Exchange
Input [12]: [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=326086]
(31) ShuffleQueryStage
Output [12]: [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
Arguments: 3
(32) BroadcastExchange
Input [12]: [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
Arguments: HashedRelationBroadcastMode(List(input[1, string, true]),false), [plan_id=326666]
(33) BroadcastQueryStage
Output [12]: [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
Arguments: 16
(34) BroadcastHashJoin
Left keys [1]: [product#826152]
Right keys [1]: [internalUUID#826217]
Join type: LeftOuter
Join condition: None
(35) Project
Output [30]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, CASE WHEN isnotnull(internalUUID#826217) THEN struct(systemId, systemId#826216, internalUUID, internalUUID#826217, id, id#826218, displayId, displayId#826219, name, name#826220, baseUnitOfMeasure, baseUnitOfMeasure#826221, unitOfMeasures, unitOfMeasures#826222, unitOfMeasureConversions, unitOfMeasureConversions#826223, productionAspect, productionAspect#826224, salesAspect, salesAspect#826225, procurementAspect, procurementAspect#826226, productGroup, productGroup#826227) END AS productInformation#826228]
Input [41]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
(36) Project
Output [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, transform(coalesce(transform(filter(productInformation#826228.unitOfMeasureConversions, lambdafunction((array_contains(transform(productInformation#826228.unitOfMeasures, lambdafunction(lambda x_2146#826240.measurementUnit.internalRefUUID, lambda x_2146#826240, false)), lambda x_2145#826237.measurementUnit1.internalRefUUID) AND (lambda x_2145#826237.measurementUnit2.internalRefUUID = productInformation#826228.baseUnitOfMeasure.internalRefUUID)), lambda x_2145#826237, false)), lambdafunction(struct(uom, lambda x_2147#826241.measurementUnit1.code, uomUuid, lambda x_2147#826241.measurementUnit1.internalRefUUID, numerator, lambda x_2147#826241.quantityNumerator, denominator, lambda x_2147#826241.quantityDenominator, isOrderUnit, false, isPreferred, false), lambda x_2147#826241, false)), []), lambdafunction(named_struct(uom, lambda x_2148#826247.uom, uomUuid, lambda x_2148#826247.uomUuid, numerator, lambda x_2148#826247.numerator, denominator, lambda x_2148#826247.denominator, isOrderUnit, ((lambda x_2148#826247.uomUuid = coalesce(sos#826195.orderQuantityUnit.internalRefUUID, productInformation#826228.procurementAspect.orderUnit.internalRefUUID, productInformation#826228.baseUnitOfMeasure.internalRefUUID)) <=> true), isPreferred, lambda x_2148#826247.isPreferred), lambda x_2148#826247, false)) AS logisticUnits#826246, productInformation#826228.baseUnitOfMeasure.code AS orderQuantityBaseUom#826242, productInformation#826228.baseUnitOfMeasure.internalRefUUID AS orderQuantityBaseUomUuid#826244, CASE WHEN isnull(supplyingPlant#826150) THEN 4 ELSE 1 END AS preferredUomSourceCode#826251]
Input [30]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228]
(37) Project
Output [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, CASE WHEN (preferredUomSourceCode#826251 = 2) THEN productPlant#826211.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile WHEN (preferredUomSourceCode#826251 = 3) THEN sos#826195.logisticalRoundingProfile.logisticalRoundingProfile WHEN (preferredUomSourceCode#826251 = 4) THEN coalesce(productPlant#826211.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile, sos#826195.logisticalRoundingProfile.logisticalRoundingProfile) WHEN (preferredUomSourceCode#826251 = 5) THEN coalesce(sos#826195.logisticalRoundingProfile.logisticalRoundingProfile, productPlant#826211.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile) END AS preferredRoundingProfile#826252]
Input [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredUomSourceCode#826251]
(38) Project
Output [36]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252, cast(null as string) AS logisticalRoundingProfile#826259, cast(null as string) AS _extract_internalRefUUID#826548]
Input [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252]
(39) Project
Output [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252]
Input [36]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252, logisticalRoundingProfile#826259, _extract_internalRefUUID#826548]
(40) Project
Output [35]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252, cast(null as string) AS logisticalRoundingProfile#826286]
Input [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252]
(41) Project
Output [33]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, transform(transform(logisticUnits#826246, lambdafunction(named_struct(uom, lambda x_2149#826294.uom, uomUuid, lambda x_2149#826294.uomUuid, numerator, lambda x_2149#826294.numerator, denominator, lambda x_2149#826294.denominator, isOrderUnit, lambda x_2149#826294.isOrderUnit, isPreferred, CASE WHEN array_contains([], lambda x_2149#826294.uomUuid) THEN true ELSE lambda x_2149#826294.isPreferred END), lambda x_2149#826294, false)), lambdafunction(named_struct(uom, lambda x_2151#826295.uom, uomUuid, lambda x_2151#826295.uomUuid, numerator, lambda x_2151#826295.numerator, denominator, lambda x_2151#826295.denominator, isOrderUnit, lambda x_2151#826295.isOrderUnit, isPreferred, CASE WHEN array_contains(transform(transform(logisticUnits#826246, lambdafunction(named_struct(uom, lambda x_2149#826296.uom, uomUuid, lambda x_2149#826296.uomUuid, numerator, lambda x_2149#826296.numerator, denominator, lambda x_2149#826296.denominator, isOrderUnit, lambda x_2149#826296.isOrderUnit, isPreferred, CASE WHEN array_contains([], lambda x_2149#826296.uomUuid) THEN true ELSE lambda x_2149#826296.isPreferred END), lambda x_2149#826296, false)), lambdafunction(lambda x_2150#826297.isPreferred, lambda x_2150#826297, false)), true) THEN lambda x_2151#826295.isPreferred ELSE lambda x_2151#826295.isOrderUnit END), lambda x_2151#826295, false)) AS logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244]
Input [35]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252, logisticalRoundingProfile#826286]
(42) Project
Output [33]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, CASE WHEN isnotnull(supplyingPlant#826150) THEN productPlant#826211.productionAspect.productPlanningPlants.minimumLotSize ELSE ((sos#826195.minimumOrderQuantity * cast(filter(logisticUnits#826293, lambdafunction(lambda x#826301.isOrderUnit, lambda x#826301, false))[0].numerator as double)) / cast(filter(logisticUnits#826293, lambdafunction(lambda x#826302.isOrderUnit, lambda x#826302, false))[0].denominator as double)) END AS minimumOrderQuantity#826298]
Input [33]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244]
(43) Scan parquet
Output [4]: [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
Batched: true
Location: InMemoryFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-param-determination-service/out/10000002109/0_1_10000002109/constraintprofile]
ReadSchema: struct<product:string,plant:string,orderDateTime:timestamp,constraintprofile:string>
(44) ColumnarToRow [codegen id : 5]
Input [4]: [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
(45) Exchange
Input [4]: [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=326131]
(46) ShuffleQueryStage
Output [4]: [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
Arguments: 6
(47) BroadcastExchange
Input [4]: [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
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=326677]
(48) BroadcastQueryStage
Output [4]: [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
Arguments: 19
(49) BroadcastHashJoin
Left keys [6]: [coalesce(product#826152, ), isnull(product#826152), coalesce(plant#826147, ), isnull(plant#826147), coalesce(orderDateTime#826153, 1970-01-01 00:00:00), isnull(orderDateTime#826153)]
Right keys [6]: [coalesce(product#826303, ), isnull(product#826303), coalesce(plant#826304, ), isnull(plant#826304), coalesce(orderDateTime#826305, 1970-01-01 00:00:00), isnull(orderDateTime#826305)]
Join type: LeftOuter
Join condition: None
(50) Project
Output [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826298, constraintProfile#826306]
Input [37]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826298, product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
(51) Scan parquet
Output [5]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, maxRangeCoverage#826312, minOrderQuantity#826313]
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#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, maxRangeCoverage#826312, minOrderQuantity#826313]
(53) Project [codegen id : 6]
Output [7]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, maxRangeCoverage#826312.isActive AS _extract_isActive#826571, maxRangeCoverage#826312.range AS _extract_range#826572, maxRangeCoverage#826312.rank AS _extract_rank#826573, minOrderQuantity#826313]
Input [5]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, maxRangeCoverage#826312, minOrderQuantity#826313]
(54) Exchange
Input [7]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, _extract_isActive#826571, _extract_range#826572, _extract_rank#826573, minOrderQuantity#826313]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=326152]
(55) ShuffleQueryStage
Output [7]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, _extract_isActive#826571, _extract_range#826572, _extract_rank#826573, minOrderQuantity#826313]
Arguments: 7
(56) BroadcastExchange
Input [7]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, _extract_isActive#826571, _extract_range#826572, _extract_rank#826573, minOrderQuantity#826313]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=326681]
(57) BroadcastQueryStage
Output [7]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, _extract_isActive#826571, _extract_range#826572, _extract_rank#826573, minOrderQuantity#826313]
Arguments: 18
(58) BroadcastHashJoin
Left keys [2]: [coalesce(constraintProfile#826306, ), isnull(constraintProfile#826306)]
Right keys [2]: [coalesce(constraintProfile#826307, ), isnull(constraintProfile#826307)]
Join type: LeftOuter
Join condition: None
(59) Project
Output [35]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, array(CASE WHEN (minServiceLevel#826309.isActive <=> true) THEN minServiceLevel#826309.level END, CASE WHEN (_extract_isActive#826571 <=> true) THEN cast(_extract_range#826572 as double) END, coalesce(minimumOrderQuantity#826298, 0.0), CASE WHEN (maxServiceLevelEndListing#826311.isActive <=> true) THEN maxServiceLevelEndListing#826311.level END, null) AS constraintValues#826322, array(CASE WHEN (minServiceLevel#826309.isActive <=> true) THEN minServiceLevel#826309.rank ELSE 0 END, CASE WHEN (_extract_isActive#826571 <=> true) THEN _extract_rank#826573 ELSE 0 END, CASE WHEN (minOrderQuantity#826313.isActive <=> true) THEN minOrderQuantity#826313.rank ELSE 0 END, CASE WHEN (maxServiceLevelEndListing#826311.isActive <=> true) THEN maxServiceLevelEndListing#826311.rank ELSE 0 END, 0) AS constraintRanks#826323, array((minServiceLevel#826309.isActive <=> true), (_extract_isActive#826571 <=> true), (minOrderQuantity#826313.isActive <=> true), (maxServiceLevelEndListing#826311.isActive <=> true), false) AS constraintIsActive#826324]
Input [41]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826298, constraintProfile#826306, constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, _extract_isActive#826571, _extract_range#826572, _extract_rank#826573, minOrderQuantity#826313]
(60) Project
Output [35]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, array(CASE WHEN isnull(filter(null, lambdafunction((lambda x_2159#826361.label = minServiceLevel), lambda x_2159#826361, false))[0]) THEN element_at(constraintValues#826322, 1, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2159#826362.label = minServiceLevel), lambda x_2159#826362, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2159#826363.label = minServiceLevel), lambda x_2159#826363, false))[0].value END END, CASE WHEN isnull(filter(null, lambdafunction((lambda x_2160#826364.label = maxRangeCoverage), lambda x_2160#826364, false))[0]) THEN element_at(constraintValues#826322, 2, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2160#826365.label = maxRangeCoverage), lambda x_2160#826365, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2160#826366.label = maxRangeCoverage), lambda x_2160#826366, false))[0].value END END, element_at(constraintValues#826322, 3, None, false), CASE WHEN isnull(filter(null, lambdafunction((lambda x_2161#826367.label = maxServiceLevelEndListing), lambda x_2161#826367, false))[0]) THEN element_at(constraintValues#826322, 4, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2161#826368.label = maxServiceLevelEndListing), lambda x_2161#826368, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2161#826369.label = maxServiceLevelEndListing), lambda x_2161#826369, false))[0].value END END, CASE WHEN filter(null, lambdafunction((lambda x_2162#826370.label = lockedOrderQuantity), lambda x_2162#826370, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2162#826371.label = lockedOrderQuantity), lambda x_2162#826371, false))[0].value END) AS constraintValues#826360, constraintRanks#826323, array(coalesce(filter(null, lambdafunction((lambda x_2154#826355.label = minServiceLevel), lambda x_2154#826355, false))[0].isActive, element_at(constraintIsActive#826324, 1, None, false)), coalesce(filter(null, lambdafunction((lambda x_2155#826356.label = maxRangeCoverage), lambda x_2155#826356, false))[0].isActive, element_at(constraintIsActive#826324, 2, None, false)), coalesce(filter(null, lambdafunction((lambda x_2156#826357.label = minOrderQuantity), lambda x_2156#826357, false))[0].isActive, element_at(constraintIsActive#826324, 3, None, false)), coalesce(filter(null, lambdafunction((lambda x_2157#826358.label = maxServiceLevelEndListing), lambda x_2157#826358, false))[0].isActive, element_at(constraintIsActive#826324, 4, None, false)), coalesce(filter(null, lambdafunction((lambda x_2158#826359.label = lockedOrderQuantity), lambda x_2158#826359, false))[0].isActive, false)) AS constraintIsActive#826354]
Input [35]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, constraintValues#826322, constraintRanks#826323, constraintIsActive#826324]
(61) Project
Output [42]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, productInformation#826228.unitOfMeasures AS _extract_unitOfMeasures#826569, productInformation#826228.baseUnitOfMeasure.internalRefUUID AS _extract_internalRefUUID#826570, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, CASE WHEN element_at(constraintIsActive#826354, 3, None, false) THEN element_at(constraintValues#826360, 3, None, false) ELSE -1.0 END AS minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, sos#826195.purchasingPriceAspect.netPrice.amount AS netPriceAmount#826373, sos#826195.purchasingPriceAspect.netPrice.currencyCode.code AS netPriceCurrencyCode#826375, sos#826195.purchasingPriceAspect.netPriceQuantity AS netPriceQuantity#826377, sos#826195.purchasingPriceAspect.netPriceUnit.code AS netPriceQuantityUom#826379, sos#826195.purchasingPriceAspect.netPriceUnit.internalRefUUID AS netPriceQuantityUomUuid#826381, struct(value, CASE WHEN (sos#826195.purchasingPriceAspect.netPriceUnit.internalRefUUID <=> orderQuantityBaseUomUuid#826244) THEN (sos#826195.purchasingPriceAspect.netPrice.amount / sos#826195.purchasingPriceAspect.netPriceQuantity) ELSE (((sos#826195.purchasingPriceAspect.netPrice.amount / sos#826195.purchasingPriceAspect.netPriceQuantity) * cast(filter(logisticUnits#826293, lambdafunction((lambda x_2163#826417.uomUuid = sos#826195.purchasingPriceAspect.netPriceUnit.internalRefUUID), lambda x_2163#826417, false))[0].denominator as double)) / cast(filter(logisticUnits#826293, lambdafunction((lambda x_2163#826418.uomUuid = sos#826195.purchasingPriceAspect.netPriceUnit.internalRefUUID), lambda x_2163#826418, false))[0].numerator as double)) END, dimensionType, 0, dimensionCode, sos#826195.purchasingPriceAspect.netPrice.currencyCode.code, dimensionCodeUuid, null, isoCode, null) AS CURRENCY#826416]
Input [35]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354]
(62) Scan parquet
Output [3]: [internalUUID#826406, isoCode#826410, systemId#826405]
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#826406, isoCode#826410, systemId#826405]
(64) Project [codegen id : 7]
Output [2]: [internalUUID#826406, isoCode#826410.code AS _extract_code#826547]
Input [3]: [internalUUID#826406, isoCode#826410, systemId#826405]
(65) Exchange
Input [2]: [internalUUID#826406, _extract_code#826547]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=326177]
(66) ShuffleQueryStage
Output [2]: [internalUUID#826406, _extract_code#826547]
Arguments: 8
(67) BroadcastExchange
Input [2]: [internalUUID#826406, _extract_code#826547]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=326687]
(68) BroadcastQueryStage
Output [2]: [internalUUID#826406, _extract_code#826547]
Arguments: 14
(69) BroadcastHashJoin
Left keys [2]: [coalesce(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID, ), isnull(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID)]
Right keys [2]: [coalesce(internalUUID#826406, ), isnull(internalUUID#826406)]
Join type: LeftOuter
Join condition: None
(70) Project
Output [43]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, _extract_unitOfMeasures#826569, _extract_internalRefUUID#826570, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, CURRENCY#826416, struct(value, cast(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826432.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826432, false))[0].productDimensions, lambdafunction((lambda x_2165#826438.dimensionName.code = VOLUME), lambda x_2165#826438, false))[0].dimensionValue as double), dimensionType, 1, dimensionCode, filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826433.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826433, false))[0].productDimensions, lambdafunction((lambda x_2165#826439.dimensionName.code = VOLUME), lambda x_2165#826439, false))[0].measurementUnit.code, dimensionCodeUuid, filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826434.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826434, false))[0].productDimensions, lambdafunction((lambda x_2165#826440.dimensionName.code = VOLUME), lambda x_2165#826440, false))[0].measurementUnit.internalRefUUID, isoCode, _extract_code#826547) AS VOLUME#826428]
Input [44]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, _extract_unitOfMeasures#826569, _extract_internalRefUUID#826570, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, CURRENCY#826416, internalUUID#826406, _extract_code#826547]
(71) ReusedExchange [Reuses operator id: 67]
Output [2]: [internalUUID#826442, _extract_code#826544]
(72) BroadcastQueryStage
Output [2]: [internalUUID#826442, _extract_code#826544]
Arguments: 15
(73) BroadcastHashJoin
Left keys [2]: [coalesce(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID, ), isnull(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID)]
Right keys [2]: [coalesce(internalUUID#826442, ), isnull(internalUUID#826442)]
Join type: LeftOuter
Join condition: None
(74) Project
Output [40]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, filter(array(CURRENCY#826416, VOLUME#826428, struct(value, cast(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826460.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826460, false))[0].productDimensions, lambdafunction((lambda x_2167#826466.dimensionName.code = GROSS_WT), lambda x_2167#826466, false))[0].dimensionValue as double), dimensionType, 3, dimensionCode, filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826461.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826461, false))[0].productDimensions, lambdafunction((lambda x_2167#826467.dimensionName.code = GROSS_WT), lambda x_2167#826467, false))[0].measurementUnit.code, dimensionCodeUuid, filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826462.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826462, false))[0].productDimensions, lambdafunction((lambda x_2167#826468.dimensionName.code = GROSS_WT), lambda x_2167#826468, false))[0].measurementUnit.internalRefUUID, isoCode, _extract_code#826544)), lambdafunction(isnotnull(lambda x_2168#826470.value), lambda x_2168#826470, false)) AS measurements#826469]
Input [45]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, _extract_unitOfMeasures#826569, _extract_internalRefUUID#826570, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, CURRENCY#826416, VOLUME#826428, internalUUID#826442, _extract_code#826544]
(75) Scan parquet
Output [6]: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
Batched: true
Location: InMemoryFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-param-determination-service/out/10000002109/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#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
(77) Exchange
Input [6]: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=326221]
(78) ShuffleQueryStage
Output [6]: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
Arguments: 11
(79) BroadcastExchange
Input [6]: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
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=326695]
(80) BroadcastQueryStage
Output [6]: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
Arguments: 17
(81) BroadcastHashJoin [codegen id : 13]
Left keys [10]: [coalesce(supplierGroup#826145, ), isnull(supplierGroup#826145), coalesce(supplier#826146, ), isnull(supplier#826146), coalesce(subrange#826149, ), isnull(subrange#826149), coalesce(plant#826147, ), isnull(plant#826147), coalesce(deliveryDateTime#826148, 1970-01-01 00:00:00), isnull(deliveryDateTime#826148)]
Right keys [10]: [coalesce(supplierGroup#826477, ), isnull(supplierGroup#826477), coalesce(supplier#826472, ), isnull(supplier#826472), coalesce(subrange#826473, ), isnull(subrange#826473), coalesce(plant#826474, ), isnull(plant#826474), coalesce(deliveryDateTime#826475, 1970-01-01 00:00:00), isnull(deliveryDateTime#826475)]
Join type: LeftOuter
Join condition: (isnull(supplyingPlant#826150) AND isnull(productGroup#826151))
(82) Project [codegen id : 13]
Output [44]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, [ServiceLevel,RangeOfCoverage,Quantity,ServiceLevelAtStartOfDelisting,Quantity] AS constraintLabels#826320, [GE,LE,GE,LE,EQ] AS constraintOperators#826321, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, null AS originalReplenishmentRunId#826471L, coalesce(optimizationGroups#826479, []) AS optimizationGroups#826483]
Input [46]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
(83) ResultQueryStage
Output [44]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintLabels#826320, constraintOperators#826321, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, originalReplenishmentRunId#826471L, optimizationGroups#826483]
Arguments: 22
(84) Exchange
Input [25]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169]
Arguments: hashpartitioning(product#826152, plant#826147, 25), REPARTITION_BY_NUM, [plan_id=325557]
(85) Project
Output [24]: [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
Input [24]: [internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194, systemId#826171]
(86) Exchange
Input [24]: [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=325560]
(87) BroadcastExchange
Input [24]: [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[1, string, true], ), isnull(input[1, string, true])),false), [plan_id=325613]
(88) BroadcastHashJoin
Left keys [2]: [coalesce(sourceOfSupplyUuid#826157, ), isnull(sourceOfSupplyUuid#826157)]
Right keys [2]: [coalesce(internalUUID#826172, ), isnull(internalUUID#826172)]
Join type: LeftOuter
Join condition: None
(89) Project
Output [26]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, struct(systemId, systemId#826171, internalUUID, internalUUID#826172, supplier, supplier#826173, receiver, receiver#826174, product, product#826175, receivingPlant, receivingPlant#826176, sourceOfSupplyType, sourceOfSupplyType#826177, purchasingGroup, purchasingGroup#826178, purchasingOrganization, purchasingOrganization#826179, productGroup, productGroup#826180, validFrom, validFrom#826181, validTo, validTo#826182, priority, ... 23 more fields) AS sos#826195]
Input [49]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194]
(90) Filter
Input [8]: [internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206, systemId#826199]
Condition : plant#826201.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(91) Project
Output [8]: [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
Input [8]: [internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206, systemId#826199]
(92) Exchange
Input [8]: [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=325566]
(93) BroadcastExchange
Input [8]: [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
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=325617]
(94) BroadcastHashJoin
Left keys [4]: [coalesce(product#826152, ), isnull(product#826152), coalesce(plant#826147, ), isnull(plant#826147)]
Right keys [4]: [coalesce(product#826202.internalRefUUID, ), isnull(product#826202.internalRefUUID), coalesce(plant#826201.internalRefUUID, ), isnull(plant#826201.internalRefUUID)]
Join type: LeftOuter
Join condition: None
(95) Project
Output [29]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, CASE WHEN isnotnull(productionAspect#826204) THEN struct(systemId, systemId#826199, internalUUID, internalUUID#826200, plant, plant#826201, product, product#826202, blockedForReplenishmentStartingFrom, blockedForReplenishmentStartingFrom#826203, productionAspect, productionAspect#826204, salesPlant, salesPlant#826205, listing, listing#826206) END AS productPlant#826211, product#826202.id AS externalProductId#826212, plant#826201.id AS externalPlantId#826214]
Input [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206]
(96) Filter
Input [12]: [internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227, systemId#826216]
Condition : isnotnull(internalUUID#826217)
(97) Project
Output [12]: [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
Input [12]: [internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227, systemId#826216]
(98) Exchange
Input [12]: [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=325572]
(99) BroadcastExchange
Input [12]: [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
Arguments: HashedRelationBroadcastMode(List(input[1, string, true]),false), [plan_id=325621]
(100) BroadcastHashJoin
Left keys [1]: [product#826152]
Right keys [1]: [internalUUID#826217]
Join type: LeftOuter
Join condition: None
(101) Project
Output [30]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, CASE WHEN isnotnull(internalUUID#826217) THEN struct(systemId, systemId#826216, internalUUID, internalUUID#826217, id, id#826218, displayId, displayId#826219, name, name#826220, baseUnitOfMeasure, baseUnitOfMeasure#826221, unitOfMeasures, unitOfMeasures#826222, unitOfMeasureConversions, unitOfMeasureConversions#826223, productionAspect, productionAspect#826224, salesAspect, salesAspect#826225, procurementAspect, procurementAspect#826226, productGroup, productGroup#826227) END AS productInformation#826228]
Input [41]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227]
(102) Project
Output [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, transform(coalesce(transform(filter(productInformation#826228.unitOfMeasureConversions, lambdafunction((array_contains(transform(productInformation#826228.unitOfMeasures, lambdafunction(lambda x_2146#826240.measurementUnit.internalRefUUID, lambda x_2146#826240, false)), lambda x_2145#826237.measurementUnit1.internalRefUUID) AND (lambda x_2145#826237.measurementUnit2.internalRefUUID = productInformation#826228.baseUnitOfMeasure.internalRefUUID)), lambda x_2145#826237, false)), lambdafunction(struct(uom, lambda x_2147#826241.measurementUnit1.code, uomUuid, lambda x_2147#826241.measurementUnit1.internalRefUUID, numerator, lambda x_2147#826241.quantityNumerator, denominator, lambda x_2147#826241.quantityDenominator, isOrderUnit, false, isPreferred, false), lambda x_2147#826241, false)), []), lambdafunction(named_struct(uom, lambda x_2148#826247.uom, uomUuid, lambda x_2148#826247.uomUuid, numerator, lambda x_2148#826247.numerator, denominator, lambda x_2148#826247.denominator, isOrderUnit, ((lambda x_2148#826247.uomUuid = coalesce(sos#826195.orderQuantityUnit.internalRefUUID, productInformation#826228.procurementAspect.orderUnit.internalRefUUID, productInformation#826228.baseUnitOfMeasure.internalRefUUID)) <=> true), isPreferred, lambda x_2148#826247.isPreferred), lambda x_2148#826247, false)) AS logisticUnits#826246, productInformation#826228.baseUnitOfMeasure.code AS orderQuantityBaseUom#826242, productInformation#826228.baseUnitOfMeasure.internalRefUUID AS orderQuantityBaseUomUuid#826244, CASE WHEN isnull(supplyingPlant#826150) THEN 4 ELSE 1 END AS preferredUomSourceCode#826251]
Input [30]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228]
(103) Project
Output [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, CASE WHEN (preferredUomSourceCode#826251 = 2) THEN productPlant#826211.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile WHEN (preferredUomSourceCode#826251 = 3) THEN sos#826195.logisticalRoundingProfile.logisticalRoundingProfile WHEN (preferredUomSourceCode#826251 = 4) THEN coalesce(productPlant#826211.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile, sos#826195.logisticalRoundingProfile.logisticalRoundingProfile) WHEN (preferredUomSourceCode#826251 = 5) THEN coalesce(sos#826195.logisticalRoundingProfile.logisticalRoundingProfile, productPlant#826211.productionAspect.productPlanningPlants.logisticalRoundingProfile.logisticalRoundingProfile) END AS preferredRoundingProfile#826252]
Input [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredUomSourceCode#826251]
(104) InMemoryTableScan
Output [2]: [logisticalRoundingProfile#826259, plant#826260]
Arguments: [logisticalRoundingProfile#826259, plant#826260]
(105) InMemoryRelation
Arguments: [logisticalRoundingProfile#826259, plant#826260, logisticalRoundingRule#826261], StorageLevel(disk, memory, 2 replicas)
(106) LocalTableScan
Output [3]: [logisticalRoundingProfile#826259, plant#826260, logisticalRoundingRule#826261]
Arguments: <empty>, [logisticalRoundingProfile#826259, plant#826260, logisticalRoundingRule#826261]
(107) Project
Output [2]: [logisticalRoundingProfile#826259, plant#826260.internalRefUUID AS _extract_internalRefUUID#826548]
Input [2]: [logisticalRoundingProfile#826259, plant#826260]
(108) BroadcastExchange
Input [2]: [logisticalRoundingProfile#826259, _extract_internalRefUUID#826548]
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=325627]
(109) BroadcastHashJoin
Left keys [4]: [coalesce(preferredRoundingProfile#826252, ), isnull(preferredRoundingProfile#826252), coalesce(plant#826147, ), isnull(plant#826147)]
Right keys [4]: [coalesce(logisticalRoundingProfile#826259, ), isnull(logisticalRoundingProfile#826259), coalesce(_extract_internalRefUUID#826548, ), isnull(_extract_internalRefUUID#826548)]
Join type: LeftOuter
Join condition: None
(110) Project
Output [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252]
Input [36]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252, logisticalRoundingProfile#826259, _extract_internalRefUUID#826548]
(111) InMemoryTableScan
Output [2]: [logisticalRoundingProfile#826286, plant#826287]
Arguments: [logisticalRoundingProfile#826286, plant#826287], [isnull(plant#826287.internalRefUUID)]
(112) InMemoryRelation
Arguments: [logisticalRoundingProfile#826286, plant#826287, logisticalRoundingRule#826288], StorageLevel(disk, memory, 2 replicas)
(113) Filter
Input [2]: [logisticalRoundingProfile#826286, plant#826287]
Condition : isnull(plant#826287.internalRefUUID)
(114) Project
Output [1]: [logisticalRoundingProfile#826286]
Input [2]: [logisticalRoundingProfile#826286, plant#826287]
(115) BroadcastExchange
Input [1]: [logisticalRoundingProfile#826286]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, false], ), isnull(input[0, string, false])),false), [plan_id=325631]
(116) BroadcastHashJoin
Left keys [2]: [coalesce(preferredRoundingProfile#826252, ), isnull(preferredRoundingProfile#826252)]
Right keys [2]: [coalesce(logisticalRoundingProfile#826286, ), isnull(logisticalRoundingProfile#826286)]
Join type: LeftOuter
Join condition: None
(117) Project
Output [33]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, transform(transform(logisticUnits#826246, lambdafunction(named_struct(uom, lambda x_2149#826294.uom, uomUuid, lambda x_2149#826294.uomUuid, numerator, lambda x_2149#826294.numerator, denominator, lambda x_2149#826294.denominator, isOrderUnit, lambda x_2149#826294.isOrderUnit, isPreferred, CASE WHEN array_contains([], lambda x_2149#826294.uomUuid) THEN true ELSE lambda x_2149#826294.isPreferred END), lambda x_2149#826294, false)), lambdafunction(named_struct(uom, lambda x_2151#826295.uom, uomUuid, lambda x_2151#826295.uomUuid, numerator, lambda x_2151#826295.numerator, denominator, lambda x_2151#826295.denominator, isOrderUnit, lambda x_2151#826295.isOrderUnit, isPreferred, CASE WHEN array_contains(transform(transform(logisticUnits#826246, lambdafunction(named_struct(uom, lambda x_2149#826296.uom, uomUuid, lambda x_2149#826296.uomUuid, numerator, lambda x_2149#826296.numerator, denominator, lambda x_2149#826296.denominator, isOrderUnit, lambda x_2149#826296.isOrderUnit, isPreferred, CASE WHEN array_contains([], lambda x_2149#826296.uomUuid) THEN true ELSE lambda x_2149#826296.isPreferred END), lambda x_2149#826296, false)), lambdafunction(lambda x_2150#826297.isPreferred, lambda x_2150#826297, false)), true) THEN lambda x_2151#826295.isPreferred ELSE lambda x_2151#826295.isOrderUnit END), lambda x_2151#826295, false)) AS logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244]
Input [35]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826246, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, preferredRoundingProfile#826252, logisticalRoundingProfile#826286]
(118) Project
Output [33]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, CASE WHEN isnotnull(supplyingPlant#826150) THEN productPlant#826211.productionAspect.productPlanningPlants.minimumLotSize ELSE ((sos#826195.minimumOrderQuantity * cast(filter(logisticUnits#826293, lambdafunction(lambda x#826301.isOrderUnit, lambda x#826301, false))[0].numerator as double)) / cast(filter(logisticUnits#826293, lambdafunction(lambda x#826302.isOrderUnit, lambda x#826302, false))[0].denominator as double)) END AS minimumOrderQuantity#826298]
Input [33]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, productPlant#826211, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244]
(119) Exchange
Input [4]: [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=325588]
(120) BroadcastExchange
Input [4]: [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
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=325636]
(121) BroadcastHashJoin
Left keys [6]: [coalesce(product#826152, ), isnull(product#826152), coalesce(plant#826147, ), isnull(plant#826147), coalesce(orderDateTime#826153, 1970-01-01 00:00:00), isnull(orderDateTime#826153)]
Right keys [6]: [coalesce(product#826303, ), isnull(product#826303), coalesce(plant#826304, ), isnull(plant#826304), coalesce(orderDateTime#826305, 1970-01-01 00:00:00), isnull(orderDateTime#826305)]
Join type: LeftOuter
Join condition: None
(122) Project
Output [34]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826298, constraintProfile#826306]
Input [37]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826298, product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306]
(123) Project
Output [7]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, maxRangeCoverage#826312.isActive AS _extract_isActive#826571, maxRangeCoverage#826312.range AS _extract_range#826572, maxRangeCoverage#826312.rank AS _extract_rank#826573, minOrderQuantity#826313]
Input [5]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, maxRangeCoverage#826312, minOrderQuantity#826313]
(124) Exchange
Input [7]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, _extract_isActive#826571, _extract_range#826572, _extract_rank#826573, minOrderQuantity#826313]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=325593]
(125) BroadcastExchange
Input [7]: [constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, _extract_isActive#826571, _extract_range#826572, _extract_rank#826573, minOrderQuantity#826313]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=325640]
(126) BroadcastHashJoin
Left keys [2]: [coalesce(constraintProfile#826306, ), isnull(constraintProfile#826306)]
Right keys [2]: [coalesce(constraintProfile#826307, ), isnull(constraintProfile#826307)]
Join type: LeftOuter
Join condition: None
(127) Project
Output [35]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, array(CASE WHEN (minServiceLevel#826309.isActive <=> true) THEN minServiceLevel#826309.level END, CASE WHEN (_extract_isActive#826571 <=> true) THEN cast(_extract_range#826572 as double) END, coalesce(minimumOrderQuantity#826298, 0.0), CASE WHEN (maxServiceLevelEndListing#826311.isActive <=> true) THEN maxServiceLevelEndListing#826311.level END, null) AS constraintValues#826322, array(CASE WHEN (minServiceLevel#826309.isActive <=> true) THEN minServiceLevel#826309.rank ELSE 0 END, CASE WHEN (_extract_isActive#826571 <=> true) THEN _extract_rank#826573 ELSE 0 END, CASE WHEN (minOrderQuantity#826313.isActive <=> true) THEN minOrderQuantity#826313.rank ELSE 0 END, CASE WHEN (maxServiceLevelEndListing#826311.isActive <=> true) THEN maxServiceLevelEndListing#826311.rank ELSE 0 END, 0) AS constraintRanks#826323, array((minServiceLevel#826309.isActive <=> true), (_extract_isActive#826571 <=> true), (minOrderQuantity#826313.isActive <=> true), (maxServiceLevelEndListing#826311.isActive <=> true), false) AS constraintIsActive#826324]
Input [41]: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826298, constraintProfile#826306, constraintProfile#826307, minServiceLevel#826309, maxServiceLevelEndListing#826311, _extract_isActive#826571, _extract_range#826572, _extract_rank#826573, minOrderQuantity#826313]
(128) Project
Output [35]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, array(CASE WHEN isnull(filter(null, lambdafunction((lambda x_2159#826361.label = minServiceLevel), lambda x_2159#826361, false))[0]) THEN element_at(constraintValues#826322, 1, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2159#826362.label = minServiceLevel), lambda x_2159#826362, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2159#826363.label = minServiceLevel), lambda x_2159#826363, false))[0].value END END, CASE WHEN isnull(filter(null, lambdafunction((lambda x_2160#826364.label = maxRangeCoverage), lambda x_2160#826364, false))[0]) THEN element_at(constraintValues#826322, 2, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2160#826365.label = maxRangeCoverage), lambda x_2160#826365, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2160#826366.label = maxRangeCoverage), lambda x_2160#826366, false))[0].value END END, element_at(constraintValues#826322, 3, None, false), CASE WHEN isnull(filter(null, lambdafunction((lambda x_2161#826367.label = maxServiceLevelEndListing), lambda x_2161#826367, false))[0]) THEN element_at(constraintValues#826322, 4, None, false) ELSE CASE WHEN filter(null, lambdafunction((lambda x_2161#826368.label = maxServiceLevelEndListing), lambda x_2161#826368, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2161#826369.label = maxServiceLevelEndListing), lambda x_2161#826369, false))[0].value END END, CASE WHEN filter(null, lambdafunction((lambda x_2162#826370.label = lockedOrderQuantity), lambda x_2162#826370, false))[0].isActive THEN filter(null, lambdafunction((lambda x_2162#826371.label = lockedOrderQuantity), lambda x_2162#826371, false))[0].value END) AS constraintValues#826360, constraintRanks#826323, array(coalesce(filter(null, lambdafunction((lambda x_2154#826355.label = minServiceLevel), lambda x_2154#826355, false))[0].isActive, element_at(constraintIsActive#826324, 1, None, false)), coalesce(filter(null, lambdafunction((lambda x_2155#826356.label = maxRangeCoverage), lambda x_2155#826356, false))[0].isActive, element_at(constraintIsActive#826324, 2, None, false)), coalesce(filter(null, lambdafunction((lambda x_2156#826357.label = minOrderQuantity), lambda x_2156#826357, false))[0].isActive, element_at(constraintIsActive#826324, 3, None, false)), coalesce(filter(null, lambdafunction((lambda x_2157#826358.label = maxServiceLevelEndListing), lambda x_2157#826358, false))[0].isActive, element_at(constraintIsActive#826324, 4, None, false)), coalesce(filter(null, lambdafunction((lambda x_2158#826359.label = lockedOrderQuantity), lambda x_2158#826359, false))[0].isActive, false)) AS constraintIsActive#826354]
Input [35]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, constraintValues#826322, constraintRanks#826323, constraintIsActive#826324]
(129) Project
Output [42]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, productInformation#826228.unitOfMeasures AS _extract_unitOfMeasures#826569, productInformation#826228.baseUnitOfMeasure.internalRefUUID AS _extract_internalRefUUID#826570, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, CASE WHEN element_at(constraintIsActive#826354, 3, None, false) THEN element_at(constraintValues#826360, 3, None, false) ELSE -1.0 END AS minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, sos#826195.purchasingPriceAspect.netPrice.amount AS netPriceAmount#826373, sos#826195.purchasingPriceAspect.netPrice.currencyCode.code AS netPriceCurrencyCode#826375, sos#826195.purchasingPriceAspect.netPriceQuantity AS netPriceQuantity#826377, sos#826195.purchasingPriceAspect.netPriceUnit.code AS netPriceQuantityUom#826379, sos#826195.purchasingPriceAspect.netPriceUnit.internalRefUUID AS netPriceQuantityUomUuid#826381, struct(value, CASE WHEN (sos#826195.purchasingPriceAspect.netPriceUnit.internalRefUUID <=> orderQuantityBaseUomUuid#826244) THEN (sos#826195.purchasingPriceAspect.netPrice.amount / sos#826195.purchasingPriceAspect.netPriceQuantity) ELSE (((sos#826195.purchasingPriceAspect.netPrice.amount / sos#826195.purchasingPriceAspect.netPriceQuantity) * cast(filter(logisticUnits#826293, lambdafunction((lambda x_2163#826417.uomUuid = sos#826195.purchasingPriceAspect.netPriceUnit.internalRefUUID), lambda x_2163#826417, false))[0].denominator as double)) / cast(filter(logisticUnits#826293, lambdafunction((lambda x_2163#826418.uomUuid = sos#826195.purchasingPriceAspect.netPriceUnit.internalRefUUID), lambda x_2163#826418, false))[0].numerator as double)) END, dimensionType, 0, dimensionCode, sos#826195.purchasingPriceAspect.netPrice.currencyCode.code, dimensionCodeUuid, null, isoCode, null) AS CURRENCY#826416]
Input [35]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, sos#826195, externalProductId#826212, externalPlantId#826214, productInformation#826228, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354]
(130) Project
Output [2]: [internalUUID#826406, isoCode#826410.code AS _extract_code#826547]
Input [3]: [internalUUID#826406, isoCode#826410, systemId#826405]
(131) Exchange
Input [2]: [internalUUID#826406, _extract_code#826547]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=325600]
(132) BroadcastExchange
Input [2]: [internalUUID#826406, _extract_code#826547]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=325646]
(133) BroadcastHashJoin
Left keys [2]: [coalesce(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID, ), isnull(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID)]
Right keys [2]: [coalesce(internalUUID#826406, ), isnull(internalUUID#826406)]
Join type: LeftOuter
Join condition: None
(134) Project
Output [43]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, _extract_unitOfMeasures#826569, _extract_internalRefUUID#826570, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, CURRENCY#826416, struct(value, cast(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826432.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826432, false))[0].productDimensions, lambdafunction((lambda x_2165#826438.dimensionName.code = VOLUME), lambda x_2165#826438, false))[0].dimensionValue as double), dimensionType, 1, dimensionCode, filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826433.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826433, false))[0].productDimensions, lambdafunction((lambda x_2165#826439.dimensionName.code = VOLUME), lambda x_2165#826439, false))[0].measurementUnit.code, dimensionCodeUuid, filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2164#826434.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2164#826434, false))[0].productDimensions, lambdafunction((lambda x_2165#826440.dimensionName.code = VOLUME), lambda x_2165#826440, false))[0].measurementUnit.internalRefUUID, isoCode, _extract_code#826547) AS VOLUME#826428]
Input [44]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, _extract_unitOfMeasures#826569, _extract_internalRefUUID#826570, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, CURRENCY#826416, internalUUID#826406, _extract_code#826547]
(135) Scan parquet
Output [3]: [internalUUID#826442, isoCode#826446, systemId#826441]
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#826442, isoCode#826446.code AS _extract_code#826544]
Input [3]: [internalUUID#826442, isoCode#826446, systemId#826441]
(137) Exchange
Input [2]: [internalUUID#826442, _extract_code#826544]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=325605]
(138) BroadcastExchange
Input [2]: [internalUUID#826442, _extract_code#826544]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[0, string, true], ), isnull(input[0, string, true])),false), [plan_id=325650]
(139) BroadcastHashJoin
Left keys [2]: [coalesce(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID, ), isnull(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID)]
Right keys [2]: [coalesce(internalUUID#826442, ), isnull(internalUUID#826442)]
Join type: LeftOuter
Join condition: None
(140) Project
Output [40]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, filter(array(CURRENCY#826416, VOLUME#826428, struct(value, cast(filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826460.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826460, false))[0].productDimensions, lambdafunction((lambda x_2167#826466.dimensionName.code = GROSS_WT), lambda x_2167#826466, false))[0].dimensionValue as double), dimensionType, 3, dimensionCode, filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826461.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826461, false))[0].productDimensions, lambdafunction((lambda x_2167#826467.dimensionName.code = GROSS_WT), lambda x_2167#826467, false))[0].measurementUnit.code, dimensionCodeUuid, filter(filter(_extract_unitOfMeasures#826569, lambdafunction((lambda x_2166#826462.measurementUnit.internalRefUUID = _extract_internalRefUUID#826570), lambda x_2166#826462, false))[0].productDimensions, lambdafunction((lambda x_2167#826468.dimensionName.code = GROSS_WT), lambda x_2167#826468, false))[0].measurementUnit.internalRefUUID, isoCode, _extract_code#826544)), lambdafunction(isnotnull(lambda x_2168#826470.value), lambda x_2168#826470, false)) AS measurements#826469]
Input [45]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, _extract_unitOfMeasures#826569, _extract_internalRefUUID#826570, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, CURRENCY#826416, VOLUME#826428, internalUUID#826442, _extract_code#826544]
(141) Exchange
Input [6]: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=325609]
(142) BroadcastExchange
Input [6]: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
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=325654]
(143) BroadcastHashJoin
Left keys [10]: [coalesce(supplierGroup#826145, ), isnull(supplierGroup#826145), coalesce(supplier#826146, ), isnull(supplier#826146), coalesce(subrange#826149, ), isnull(subrange#826149), coalesce(plant#826147, ), isnull(plant#826147), coalesce(deliveryDateTime#826148, 1970-01-01 00:00:00), isnull(deliveryDateTime#826148)]
Right keys [10]: [coalesce(supplierGroup#826477, ), isnull(supplierGroup#826477), coalesce(supplier#826472, ), isnull(supplier#826472), coalesce(subrange#826473, ), isnull(subrange#826473), coalesce(plant#826474, ), isnull(plant#826474), coalesce(deliveryDateTime#826475, 1970-01-01 00:00:00), isnull(deliveryDateTime#826475)]
Join type: LeftOuter
Join condition: (isnull(supplyingPlant#826150) AND isnull(productGroup#826151))
(144) Project
Output [44]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, [ServiceLevel,RangeOfCoverage,Quantity,ServiceLevelAtStartOfDelisting,Quantity] AS constraintLabels#826320, [GE,LE,GE,LE,EQ] AS constraintOperators#826321, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, null AS originalReplenishmentRunId#826471L, coalesce(optimizationGroups#826479, []) AS optimizationGroups#826483]
Input [46]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, supplierGroup#826477, optimizationGroups#826479]
(145) AdaptiveSparkPlan
Output [44]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintLabels#826320, constraintOperators#826321, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, originalReplenishmentRunId#826471L, optimizationGroups#826483]
Arguments: isFinalPlan=true
(146) TableCacheQueryStage
Output [44]: [availabilityDateTime#826154, clusterId#826165L, constraintIsActive#826354, constraintLabels#826320, constraintOperators#826321, constraintRanks#826323, constraintValues#826360, deliveryDateTime#826148, externalPlantId#826214, externalProductId#826212, isFallbackOrderOnly#826160, logisticUnits#826293, measurements#826469, minimumOrderQuantity#826372, mrpController#826156, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, nextAvailabilityDateTime#826155, optimizationGroups#826483, orderDateTime#826153, orderProposalHorizonGroupingId#826162L, orderProposalId#826161L, orderProposalItemGroupId#826168, orderProposalItemId#826169, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, originalReplenishmentRunId#826471L, plant#826147, previousOrderProposal#826164L, product#826152, productGroup#826151, purchasingGroup#826159, purchasingOrg#826158, sequenceId#826166, sourceOfSupplyUuid#826157, splitIndicator#826163L, subrange#826149, supplier#826146, supplierGroup#826145, supplyingPlant#826150, worklistShardItemId#826167L]
Arguments: 0
(147) Project [codegen id : 1]
Output [45]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintLabels#826320, constraintOperators#826321, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, originalReplenishmentRunId#826471L, optimizationGroups#826483, 0_1_10000002109 AS shardId#831125]
Input [44]: [availabilityDateTime#826154, clusterId#826165L, constraintIsActive#826354, constraintLabels#826320, constraintOperators#826321, constraintRanks#826323, constraintValues#826360, deliveryDateTime#826148, externalPlantId#826214, externalProductId#826212, isFallbackOrderOnly#826160, logisticUnits#826293, measurements#826469, minimumOrderQuantity#826372, mrpController#826156, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, nextAvailabilityDateTime#826155, optimizationGroups#826483, orderDateTime#826153, orderProposalHorizonGroupingId#826162L, orderProposalId#826161L, orderProposalItemGroupId#826168, orderProposalItemId#826169, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, originalReplenishmentRunId#826471L, plant#826147, previousOrderProposal#826164L, product#826152, productGroup#826151, purchasingGroup#826159, purchasingOrg#826158, sequenceId#826166, sourceOfSupplyUuid#826157, splitIndicator#826163L, subrange#826149, supplier#826146, supplierGroup#826145, supplyingPlant#826150, worklistShardItemId#826167L]
(148) ResultQueryStage
Output [45]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintLabels#826320, constraintOperators#826321, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, originalReplenishmentRunId#826471L, optimizationGroups#826483, shardId#831125]
Arguments: 2
(149) Project
Output [45]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintLabels#826320, constraintOperators#826321, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, originalReplenishmentRunId#826471L, optimizationGroups#826483, 0_1_10000002109 AS shardId#831125]
Input [44]: [availabilityDateTime#826154, clusterId#826165L, constraintIsActive#826354, constraintLabels#826320, constraintOperators#826321, constraintRanks#826323, constraintValues#826360, deliveryDateTime#826148, externalPlantId#826214, externalProductId#826212, isFallbackOrderOnly#826160, logisticUnits#826293, measurements#826469, minimumOrderQuantity#826372, mrpController#826156, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, nextAvailabilityDateTime#826155, optimizationGroups#826483, orderDateTime#826153, orderProposalHorizonGroupingId#826162L, orderProposalId#826161L, orderProposalItemGroupId#826168, orderProposalItemId#826169, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, originalReplenishmentRunId#826471L, plant#826147, previousOrderProposal#826164L, product#826152, productGroup#826151, purchasingGroup#826159, purchasingOrg#826158, sequenceId#826166, sourceOfSupplyUuid#826157, splitIndicator#826163L, subrange#826149, supplier#826146, supplierGroup#826145, supplyingPlant#826150, worklistShardItemId#826167L]
(150) AdaptiveSparkPlan
Output [45]: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, externalProductId#826212, externalPlantId#826214, logisticUnits#826293, orderQuantityBaseUom#826242, orderQuantityBaseUomUuid#826244, minimumOrderQuantity#826372, constraintLabels#826320, constraintOperators#826321, constraintValues#826360, constraintRanks#826323, constraintIsActive#826354, netPriceAmount#826373, netPriceCurrencyCode#826375, netPriceQuantity#826377, netPriceQuantityUom#826379, netPriceQuantityUomUuid#826381, measurements#826469, originalReplenishmentRunId#826471L, optimizationGroups#826483, shardId#831125]
Arguments: isFinalPlan=false