db={"external_S_P_FLAT_main_api":[{"_id":{"$oid":"654c6a594d0867aef588674d"},"data.pricing.material":"TG11","data.pricing.controlling_area":"AJ00","data.pricing.cost_center":"DE0000012"},{"_id":{"$oid":"654c6a594d0867aef588674e"},"data.pricing.material":"TG12","data.pricing.controlling_area":"AJ00","data.pricing.cost_center":"DE000002"},{"_id":{"$oid":"654c6a594d0867aef588674f"},"data.pricing.material":"TG14","data.pricing.controlling_area":"AJ00","data.pricing.cost_center":"DE000003"},{"_id":{"$oid":"654c6a594d0867aef5886750"},"data.pricing.material":"TG2341","data.pricing.controlling_area":"AJ00","data.pricing.cost_center":"DE000004"}],"external_S_C_FLAT_main_api":[{"_id":{"$oid":"654c6a594d0867aef5886751"},"data.costcenter.controlling_area":"AJ00","data.costcenter.cost_center":"DE000001","data.costcenter.valid_from_date":"2023-09-12","data.costcenter.long_description":"CC DE000001 - 3rd"},{"_id":{"$oid":"654c6a594d0867aef5886752"},"data.costcenter.controlling_area":"AJ00","data.costcenter.cost_center":"DE000002","data.costcenter.valid_from_date":"2022-03-02","data.costcenter.long_description":"CC DE000002 - 1st"},{"_id":{"$oid":"654c6a594d0867aef5886753"},"data.costcenter.controlling_area":"AJ00","data.costcenter.cost_center":"DE000003","data.costcenter.valid_from_date":"2023-10-25","data.costcenter.long_description":"CC DE000003 - 1st"},{"_id":{"$oid":"654c6a594d0867aef5886754"},"data.costcenter.controlling_area":"AJ00","data.costcenter.cost_center":"DE000004","data.costcenter.valid_from_date":"2023-10-25","data.costcenter.long_description":"CC DE000004 - 2nd"}]}

db.external_S_P_FLAT_main_api.aggregate([{"$addFields":{"external_S_P_FLAT_main_api_data.pricing.controlling_area":"$data.pricing.controlling_area"}},{"$addFields":{"external_S_P_FLAT_main_api_data.pricing.cost_center":"$data.pricing.cost_center"}},{"$addFields":{"external_S_P_FLAT_main_api_data.pricing.cost_center":"$data.pricing.cost_center"}},{"$lookup":{from:"external_S_C_FLAT_main_api",let:{let_data__pricing__cost_center:{$getField:"data.pricing.cost_center"}},pipeline:[{"$match":{"$expr":{"$and":[{"$eq":[{$getField:"data.costcenter.cost_center"},"$$let_data__pricing__cost_center"]}]}}}],/** localField: "external_S_P_FLAT_main_api_data.pricing.cost_center",* foreignField: "data.costcenter.cost_center",*/as:"from_external_S_C_FLAT_main_api"}},/**{* "$lookup": {* from: "external_S_C_FLAT_main_api",* localField: "external_S_P_FLAT_main_api_data.pricing.cost_center",* foreignField: {* "$getField": {* "field": "data.costcenter.cost_center"* }* },* as: "from_external_S_C_FLAT_main_api"* }*},*/{"$unwind":{path:"$from_external_S_C_FLAT_main_api",preserveNullAndEmptyArrays:true,/** includeArrayIndex: ""*/}},{"$replaceRoot":{newRoot:{"$mergeObjects":["$from_external_S_C_FLAT_main_api","$$ROOT"]}}},{"$project":{_id:0,"external_S_P_FLAT_main_api_data.pricing.controlling_area":0,"external_S_P_FLAT_main_api_data.pricing.cost_center":0,/** from_external_S_C_FLAT_main_api: 0*/}}])