== Physical Plan ==
Execute SaveIntoDataSourceCommand (1)
+- SaveIntoDataSourceCommand (2)
+- Project (100)
+- Project (99)
+- Project (98)
+- Project (97)
+- Project (96)
+- Project (95)
+- Join (94)
:- Project (89)
: +- Project (88)
: +- Project (87)
: +- Join (86)
: :- Project (82)
: : +- Join (81)
: : :- Project (77)
: : : +- Project (76)
: : : +- Project (75)
: : : +- Project (74)
: : : +- Project (73)
: : : +- Project (72)
: : : +- Project (71)
: : : +- Project (70)
: : : +- Project (69)
: : : +- Project (68)
: : : +- Project (67)
: : : +- Join (66)
: : : :- Project (62)
: : : : +- Project (61)
: : : : +- Project (60)
: : : : +- Project (59)
: : : : +- Project (58)
: : : : +- Project (57)
: : : : +- Join (56)
: : : : :- Project (53)
: : : : : +- Join (52)
: : : : : :- Project (49)
: : : : : : +- Project (48)
: : : : : : +- Project (47)
: : : : : : +- Project (46)
: : : : : : +- Project (45)
: : : : : : +- Join (44)
: : : : : : :- Project (41)
: : : : : : : +- Project (40)
: : : : : : : +- Join (39)
: : : : : : : :- Join (35)
: : : : : : : : :- SubqueryAlias (32)
: : : : : : : : : +- Project (31)
: : : : : : : : : +- Project (30)
: : : : : : : : : +- Project (29)
: : : : : : : : : +- Project (28)
: : : : : : : : : +- Project (27)
: : : : : : : : : +- Project (26)
: : : : : : : : : +- Project (25)
: : : : : : : : : +- Project (24)
: : : : : : : : : +- Join (23)
: : : : : : : : : :- Project (19)
: : : : : : : : : : +- Project (18)
: : : : : : : : : : +- Project (17)
: : : : : : : : : : +- Project (16)
: : : : : : : : : : +- Join (15)
: : : : : : : : : : :- Project (10)
: : : : : : : : : : : +- Project (9)
: : : : : : : : : : : +- Join (8)
: : : : : : : : : : : :- RepartitionByExpression (4)
: : : : : : : : : : : : +- LogicalRelation (3)
: : : : : : : : : : : +- SubqueryAlias (7)
: : : : : : : : : : : +- Repartition (6)
: : : : : : : : : : : +- LogicalRelation (5)
: : : : : : : : : : +- SubqueryAlias (14)
: : : : : : : : : : +- Filter (13)
: : : : : : : : : : +- Repartition (12)
: : : : : : : : : : +- LogicalRelation (11)
: : : : : : : : : +- SubqueryAlias (22)
: : : : : : : : : +- Repartition (21)
: : : : : : : : : +- LogicalRelation (20)
: : : : : : : : +- SubqueryAlias (34)
: : : : : : : : +- LocalRelation (33)
: : : : : : : +- SubqueryAlias (38)
: : : : : : : +- Filter (37)
: : : : : : : +- LocalRelation (36)
: : : : : : +- Aggregate (43)
: : : : : : +- LocalRelation (42)
: : : : : +- Repartition (51)
: : : : : +- LogicalRelation (50)
: : : : +- Repartition (55)
: : : : +- LogicalRelation (54)
: : : +- Project (65)
: : : +- Project (64)
: : : +- LocalRelation (63)
: : +- SubqueryAlias (80)
: : +- Repartition (79)
: : +- LogicalRelation (78)
: +- SubqueryAlias (85)
: +- Repartition (84)
: +- LogicalRelation (83)
+- Project (93)
+- Project (92)
+- Repartition (91)
+- LogicalRelation (90)
(1) Execute SaveIntoDataSourceCommand
Output: []
(2) SaveIntoDataSourceCommand
Arguments: org.apache.spark.sql.delta.sources.DeltaDataSource@26c081c1, [__partition_columns=["shardId","sequenceId"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/prod-plant-snapshot/10000002108], Overwrite
(3) LogicalRelation
Arguments: parquet, [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299], false
(4) RepartitionByExpression
Arguments: [product#732282, plant#732277], 25
(5) LogicalRelation
Arguments: parquet, [systemId#732301, internalUUID#732302, supplier#732303, receiver#732304, product#732305, receivingPlant#732306, sourceOfSupplyType#732307, purchasingGroup#732308, purchasingOrganization#732309, productGroup#732310, validFrom#732311, validTo#732312, priority#732313, isPurchasingBlocked#732314, isConsignment#732315, isDeleted#732316, supplierSubrange#732317, plannedDeliveryTimeDays#732318, orderQuantityUnit#732319, purchasingPriceAspect#732320, orderCurrency#732321, minimumOrderQuantity#732322, logisticalRoundingProfile#732323, supplyingPlant#732324], false
(6) Repartition
Arguments: 25, true
(7) SubqueryAlias
Arguments: sos
(8) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#732287 <=> internalUUID#732302)
(9) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 25 more fields]
(10) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 1 more fields]
(11) LogicalRelation
Arguments: parquet, [systemId#732329, internalUUID#732330, plant#732331, product#732332, blockedForReplenishmentStartingFrom#732333, productionAspect#732334, salesPlant#732335, listing#732336], false
(12) Repartition
Arguments: 25, true
(13) Filter
Arguments: plant#732331.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(14) SubqueryAlias
Arguments: pp
(15) Join
Arguments: LeftOuter, ((product#732282 <=> product#732332.internalRefUUID) AND (plant#732277 <=> plant#732331.internalRefUUID))
(16) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(17) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(18) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 12 more fields]
(19) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 4 more fields]
(20) LogicalRelation
Arguments: parquet, [systemId#732346, internalUUID#732347, id#732348, displayId#732349, name#732350, baseUnitOfMeasure#732351, unitOfMeasures#732352, unitOfMeasureConversions#732353, productionAspect#732354, salesAspect#732355, procurementAspect#732356, productGroup#732357], false
(21) Repartition
Arguments: 25, true
(22) SubqueryAlias
Arguments: tmp
(23) Join
Arguments: LeftOuter, (product#732282 = internalUUID#732347)
(24) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 17 more fields]
(25) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 5 more fields]
(26) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 6 more fields]
(27) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 7 more fields]
(28) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 8 more fields]
(29) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 8 more fields]
(30) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 9 more fields]
(31) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(32) SubqueryAlias
Arguments: worklist
(33) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#732389, plant#732390, logisticalRoundingRule#732391]
(34) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(35) Join
Arguments: LeftOuter, ((preferredRoundingProfile#732382 <=> logisticalRoundingProfile#732389) AND (plant#732277 <=> plant#732390.internalRefUUID))
(36) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#732416, plant#732417, logisticalRoundingRule#732418]
(37) Filter
Arguments: isnull(plant#732417.internalRefUUID)
(38) SubqueryAlias
Arguments: allPlantRoundingProfiles
(39) Join
Arguments: LeftOuter, (preferredRoundingProfile#732382 <=> logisticalRoundingProfile#732416)
(40) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 17 more fields]
(41) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(42) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#732407, unitOfMeasure#732408]
(43) Aggregate
Arguments: [logisticalRoundingRule#732407], [logisticalRoundingRule#732407, collect_list(unitOfMeasure#732408.internalRefUUID, 0, 0) AS preferredUOMs#732409]
(44) Join
Arguments: LeftOuter, (logisticalRoundingRule#732420.logisticalRoundingRule = logisticalRoundingRule#732407)
(45) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(46) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(47) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(48) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 8 more fields]
(49) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 9 more fields]
(50) LogicalRelation
Arguments: parquet, [product#732433, plant#732434, orderDateTime#732435, constraintprofile#732436], false
(51) Repartition
Arguments: 25, true
(52) Join
Arguments: LeftOuter, (((product#732282 <=> product#732433) AND (plant#732277 <=> plant#732434)) AND (orderDateTime#732283 <=> orderDateTime#732435))
(53) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(54) LogicalRelation
Arguments: parquet, [constraintProfile#732437, descriptions#732438, minServiceLevel#732439, minServiceLevelMinStock#732440, maxServiceLevelEndListing#732441, maxRangeCoverage#732442, minOrderQuantity#732443, profileType#732444, eventtype#732445], false
(55) Repartition
Arguments: 25, true
(56) Join
Arguments: LeftOuter, (constraintProfile#732436 <=> constraintProfile#732437)
(57) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 20 more fields]
(58) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(59) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(60) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 15 more fields]
(61) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 15 more fields]
(62) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 14 more fields]
(63) LocalRelation
Arguments: <empty>, [orderProposalId#732474, orderProposalItemId#732475, constraintOverwrites#732476]
(64) Project
Arguments: [orderProposalId#732474, orderProposalItemId#732475, filter(constraintOverwrites#732476, lambdafunction(((isnotnull(lambda x_1925#732478.label) AND isnotnull(lambda x_1925#732478.isActive)) AND (((lambda x_1925#732478.isActive = false) OR isnotnull(lambda x_1925#732478.value)) OR (lambda x_1925#732478.label <=> minOrderQuantity))), lambda x_1925#732478, false)) AS constraintOverwrites#732477]
(65) Project
Arguments: [orderProposalId#732474, orderProposalItemId#732475, transform(constraintOverwrites#732477, lambdafunction(struct(label, lambda x_1926#732483.label, value, CASE WHEN ((lambda x_1926#732483.label = minOrderQuantity) OR (lambda x_1926#732483.label = lockedOrderQuantity)) THEN round(lambda x_1926#732483.value, 0) ELSE lambda x_1926#732483.value END, isActive, lambda x_1926#732483.isActive), lambda x_1926#732483, false)) AS constraintOverwrites#732482]
(66) Join
Arguments: LeftOuter, ((orderProposalId#732291L = cast(orderProposalId#732474 as bigint)) AND (orderProposalItemId#732299 = orderProposalItemId#732475))
(67) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(68) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(69) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(70) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(71) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 14 more fields]
(72) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(73) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 16 more fields]
(74) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 17 more fields]
(75) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 18 more fields]
(76) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 19 more fields]
(77) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 20 more fields]
(78) LogicalRelation
Arguments: parquet, [systemId#732513, internalUUID#732514, code#732515, name#732516, commercialCode#732517, isoCode#732518], false
(79) Repartition
Arguments: 25, true
(80) SubqueryAlias
Arguments: unitOfMeasure
(81) Join
Arguments: LeftOuter, (filter(filter(productInformation#732358.unitOfMeasures, lambdafunction((lambda x_1937#732528.measurementUnit.internalRefUUID = productInformation#732358.baseUnitOfMeasure.internalRefUUID), lambda x_1937#732528, false))[0].productDimensions, lambdafunction((lambda x_1938#732530.dimensionName.code = VOLUME), lambda x_1938#732530, false))[0].measurementUnit.internalRefUUID <=> internalUUID#732514)
(82) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 21 more fields]
(83) LogicalRelation
Arguments: parquet, [systemId#732549, internalUUID#732550, code#732551, name#732552, commercialCode#732553, isoCode#732554], false
(84) Repartition
Arguments: 25, true
(85) SubqueryAlias
Arguments: unitOfMeasure
(86) Join
Arguments: LeftOuter, (filter(filter(productInformation#732358.unitOfMeasures, lambdafunction((lambda x_1939#732556.measurementUnit.internalRefUUID = productInformation#732358.baseUnitOfMeasure.internalRefUUID), lambda x_1939#732556, false))[0].productDimensions, lambdafunction((lambda x_1940#732558.dimensionName.code = GROSS_WT), lambda x_1940#732558, false))[0].measurementUnit.internalRefUUID <=> internalUUID#732550)
(87) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 22 more fields]
(88) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 20 more fields]
(89) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 21 more fields]
(90) LogicalRelation
Arguments: parquet, [supplier#732580, subrange#732581, plant#732582, deliverydatetime#732583, ordergroupingprofile#732584, supplierGroup#732585, locationGroup#732586, optimizationGroups#732587], false
(91) Repartition
Arguments: 25, true
(92) Project
Arguments: [supplier#732580, subrange#732581, plant#732582, deliverydatetime#732583, ordergroupingprofile#732584, supplierGroup#732585, locationGroup#732586, optimizationGroups#732587, cast(null as string) AS supplyingPlant#732589]
(93) Project
Arguments: [supplier#732580, subrange#732581, plant#732582, deliverydatetime#732583, ordergroupingprofile#732584, supplierGroup#732585, locationGroup#732586, optimizationGroups#732587, supplyingPlant#732589, cast(null as string) AS productGroup#732590]
(94) Join
Arguments: LeftOuter, (((((((supplierGroup#732275 <=> supplierGroup#732585) AND (supplier#732276 <=> supplier#732580)) AND (subrange#732279 <=> subrange#732581)) AND (plant#732277 <=> plant#732582)) AND (deliveryDateTime#732278 <=> deliveryDateTime#732583)) AND (supplyingPlant#732280 <=> supplyingPlant#732589)) AND (productGroup#732281 <=> productGroup#732590))
(95) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 22 more fields]
(96) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 22 more fields]
(97) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 21 more fields]
(98) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 20 more fields]
(99) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 19 more fields]
(100) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 20 more fields]