Code With Sauru💻 [ALL]

 Report : Price Realization Tool - EVOQUA >> Field mapping Validation 19 Fails >> Join Validation All Pass >> Filter Validation  All Pass >> Derived Field Validation 5 Fails >> Data Quality Checks All pass >> Action items

 Report: Profitability_Actuals_Tableau >> Field Mapping Validation 4 Field Fails >> Join validation No fails >> Filter Validation no fails Derived Field validation no fails >> Data Quality Checks 2 Fails >> Action items

 Report name:  Purchase info Record >> Field Mapping: # Fix: Find in BW  table # LOC: # Code:  '' AS `Last Price Update`, --A017.Datab         CAST(NULL AS STRING) AS `Last Close PO Delivery Date`,--EKET EINDT         CAST(NULL AS STRING) AS `Last Close PO Price` --EKPO NETPR # Comment: Three Fields=> Last Price Update  [ Z017 - DATAB ] Last Close PO Delivery Date [ EKET - EINDT ] Last Close PO Price [ EKPO - NETPR ] |_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_| Rough=> Planned Delivery Time (in Days) :  Fix: (Hardcoded precision may not match SAP Verify SAP EINE-APLFZ field type) Net Price: Fix: Hardcoded precision/scale Verify SAP EINE-NETPR field type Price Unit:  Fix: Hardcoded precision may not match SAP Verify SAP EINE-PEINH field type goods_invoice_receipt: Fix:  Last Price Update Fix: Last Close...

 Report name:  Price list with release status Issue 1:   Field Mapping validation #Fields under A006 Table=> 1 ]PL_SALES_ORG_ID  2] PL_DISTRIBTN_CHANNEL_ID 3] PL_PRICE_LIST_ID 4] PL_CnTy 5] PL_MATERIAL 6] PL_VALID_START_DATE 7] PL_VALID_END_DATE # Extra Field: 1] load_date 2] RELEASE_STATUS Issue 2:  Join validation join name: A006 Pricing Master Fix: Implement explicit JOIN to A006 table on appropriate keys join name: KONP Pricing Conditions Fix: No Fix Required join name: TCURR Currency Conversion Validation Review of Your Comment: NOT JOINED; FDD documents detailed conversion logic In your code: No TCURR table is used No exchange rate logic exists Amount is directly taken from salesorders Why this Fails code: CAST (so.Rate AS decimal ( 17 , 2 )) AS `PL_List Price Amount` so.rate_unit AS `PL_Unit_CURRENCY` This means: Amount is in original transaction currency No conversion to reporting currency If your dataset contains: Curren...