Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below code, I need to put a condition:
if INCO1 = DAP,CUP,UYP,UYT then [SSCP09 Overdue No of Days] = 10 Days otherwise 45 days
***********************************************************************************************************
Load [EBELN EBELP Key] as [SSCP09 EBELN EBELP Key],
[Target Quantity] as [SSCP09 Target Quantity],
[Target Date] as [SSCP09 Target Date],
[Target Date in System] as [SSCP09 Target Date in System],
INCO1 as [SSCP09 INCO1],
INCO2 as [SSCP09 INCO2],
[SSCPR05 Country Code] as [SSCP09 Country Code] ,
[SSCPR05 Vendor Name] as [SSCP09 Vendor Name],
EBELN as [SSCP09 EBELN],
EBELP as [SSCP09 EBELP],
BSART as [SSCP09 Document Type],
EKGRP as [SSCP09 EKGRP],
[Delivered Quantity] as [SSCP09 Delivered Quantity],
[Delivery Date] as [SSCP09 Delivery Date],
[SSCPR05 PO Status] as [SSCP09 PO Status],
[SSCP Date] as [SSCP09 SSCP Date],
[KPI Status] as [SSCP09 KPI Status],
[SSCPR05 Overdue No of Days] as [SSCP09 Overdue No of Days] ,
[SSCPR05 Pending Since Bucket] as [SSCP09 Pending since Bucket],
'XYZ' as [SSCP09 Company],
'XYZ' & Date([SSCP Date],'DD-MMM-YYYY') as %Link_SSCP09
from Test.qvd where wildmatch(HGPR,'800','801')<1;
Thanks in advance.