Please enable JavaScript.
Coggle requires JavaScript to display documents.
ASSY AMD Consume matrix Automation (CCD is not null), PDM Automation -…
ASSY AMD Consume matrix Automation (CCD is not null)
Database: PDM_AUTOMATION
Table : assembly_sap
Daily Query today Setup
2A PN, ccd_gradeddie , assembly kit
skip for ccd_gradeddie = N/A
determine which group type (ccd_gradeddie count)
From Assembly kit and IDV
2 time 12PM, 6PM
Database: PDM_AUTOMATION
Table : assembly_bom
Query itxa1_c ="CCD" and posnr_c and menge_quan
Table Matrix: fix
SPEC and Qty *N ( menge_quan)
posnr_c = SPEC
ccd_graddedies
Group 1 ( 3 CCD count)- posnr_c/spec (0020-3998) , (0030-3999), (0040-4000)
Group 2 ( 2 CCD count)- posnr_c/spec (0020-3999) , (0030-4000)
Group 3 ( 1 CCD count)- posnr_c/spec (0020-4000)
Validation Info vs CAMSTAR
Detail: INSITEINT_PNG.V_CONSUMEMATRIXLIST
SPEC , PRODUCT= 2A PN
, MATPRODUCT = ccd_gradeddies,
FORMULA ( ccd_gradeddies_qty and ignore "*"
PDM Automation
Validate PDM databse vs CAMSTAR database
Email notification if mismatch
User Data