Quick :4] Pricing POC_Prod - Purchase info Record

 Report name:  Purchase info Record

>> Field Mapping:

Planned Delivery Time (in Days) : 

Fix: (Hardcoded precision may not match SAP Verify SAP EINE-APLFZ field type)

Net Price:

Fiz: 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 PO Delivery Date

Fix:


Last Close PO Price

Fix: 



>> Join Validation 

only 2 with WAERM statement



>> Filter Validation

a) Date Range Filter

b) Validity Date Range


>> Derived Field Validation

a)Last Price Update

b)Last Close PO Delivery Date

c)Last Close PO Price


>> Data Quality Checks

a) NULL Value Validation on Key Fields

b) Referential Integrity (Join Success Rate)

c) Duplicate Record Detection

d) Data Completeness Check


>> Action Items



Comments

Popular posts from this blog

QUICK: 2]Material Valuation

[ STRUCTURED Databricks ]