Warning
All
ByName
d:\Users\SaikatH\AFG\AF Work\Alteryx\Master data_Alteryx_availability.xlsx|||`Store Open PO$`
False
1
Master data_Alteryx_availability.xlsx
Table=`Store Open PO$`
Warning
All
ByName
Custom
=
True
fixed
2019-12-26 12:14:52
0
2019-12-26 12:14:52
2019-12-26 12:14:52
d:\Users\SaikatH\AFG\AF Work\Alteryx\Master data_Alteryx_availability.xlsx|||`WH Open PO$`
False
1
Master data_Alteryx_availability.xlsx
Table=`WH Open PO$`
Custom
=
True
fixed
2019-06-18 17:15:03
0
2019-06-18 17:15:03
2019-06-18 17:15:03
Warning
All
ByName
Stock Avail. @ ST(DP MDQ) W/O PO = IF ([Final Store SOH])>=[DP Min] THEN 'Avail'...
"Concat","Article","Site","Store Name","Region","Article Description","MS","S","PDT","PGr","MC ","MC Description","Dept Code","Dept Name","Category Code","Category Name","Sub Cat Code","Sub Cat Desc"," Class Code","Class Desc","Vendor Code","Vendor Description","Local/Import","Stock Cover","Article Count","Avail. fr.","Avail. to","Avail. To Year","RP Type","DP Min","Min","Max","Sales Qty","Net Sales (AED)","NM (AED)","ROS/Week","Total Sales Qty","Total Net Sales (AED)","Total NM (AED)","ROS/Month","CBM/UOM","Rank","Top 50","Top 100","Top 200","Top 300","Top 400","Top 500","Remarks","Weightage_Cat","Classification","Weightage_MC","Input_#2_Classification","Weightage_Subcat","Input_#3_Classification","Weightage_Class","Input_#4_Classification","MTyp","Store SOH (MB52)","Transit","Restricted-Use","Blocked","Value Unrestricted"," Value in Transit","Value BlockedStock"," Value Restricted","A/B/C","Right_Mdse Cat.","Right_MTyp","AFL SOH (MB52)","Right_Transit","Right_ Restricted-Use","Right_ Blocked","Right_Value Unrestricted","Right_ Value in Transit","Right_Value BlockedStock","Right_ Value Restricted","Store SOH (ATP)","BUn","BUn2","Time","MovAvgPrice","Left_Left_Right_Crcy","Date in Format YYYYMMDD","Left_Left_Right_S","Site2","Left_Left_Right_MS","AFL SOH (ATP)","Right_BUn","Right_BUn2","Right_Time","Right_MovAvgPrice","Right_Crcy","Right_Date in Format YYYYMMDD","Right_S","Right_Site2","Right_MS","Final Store SOH","Final AFL SOH","Right_Site","Left_Right_Article","Sum_Open PO Store","Left_Right_Crcy2","Left_Right_S2","Left_Right_MS2","Right_Article","Sum_Open PO AFL","Left_Right_Crcy","Left_Right_S","Left_Right_MS"
True
True
True
False
False
False
False
False
False
upper
Warning
All
ByName
d:\Users\SaikatH\AFG\AF Work\Alteryx\Master data_Alteryx_availability.xlsx|||`Store SOH (ATP)$`
False
1
Master data_Alteryx_availability.xlsx
Table=`Store SOH (ATP)$`
Warning
All
ByName
Warning
All
ByName
"Concat","Article","Site","Store Name","Region","Article Description","MS","S","PDT","PGr","MC ","MC Description","Dept Code","Dept Name","Category Code","Category Name","Sub Cat Code","Sub Cat Desc"," Class Code","Class Desc","Vendor Code","Vendor Description","Local/Import","Stock Cover","Article Count","Avail. fr.","Avail. to","Avail. To Year","RP Type","DP Min","Min","Max","Sales Qty","Net Sales (AED)","NM (AED)","ROS/Week","Total Sales Qty","Total Net Sales (AED)","Total NM (AED)","ROS/Month","CBM/UOM","Rank","Top 50","Top 100","Top 200","Top 300","Top 400","Top 500","Remarks","Weightage_Cat","Classification","Weightage_MC","Input_#2_Classification","Weightage_Subcat","Input_#3_Classification","Weightage_Class","Input_#4_Classification","MTyp","Store SOH (MB52)","Transit","Restricted-Use","Blocked","Value Unrestricted"," Value in Transit","Value BlockedStock"," Value Restricted","A/B/C","Right_Mdse Cat.","Right_MTyp","AFL SOH (MB52)","Right_Transit","Right_ Restricted-Use","Right_ Blocked","Right_Value Unrestricted","Right_ Value in Transit","Right_Value BlockedStock","Right_ Value Restricted","Store SOH (ATP)","BUn","BUn2","Time","MovAvgPrice","Left_Right_Crcy","Date in Format YYYYMMDD","Left_Right_S","Site2","Left_Right_MS","AFL SOH (ATP)","Right_BUn","Right_BUn2","Right_Time","Right_MovAvgPrice","Right_Crcy","Right_Date in Format YYYYMMDD","Right_S","Right_Site2","Right_MS"
True
True
True
False
False
False
False
False
False
upper
Final Store SOH = Max([Store SOH (MB52)],[Store SOH (ATP)])
Final AFL SOH = Min(...
d:\Users\SaikatH\AFG\AF Work\Alteryx\Master data_Alteryx_availability.xlsx|||`WH SOH (ATP)$`
False
1
Master data_Alteryx_availability.xlsx
Table=`WH SOH (ATP)$`
d:\Users\SaikatH\AFG\AF Work\Alteryx\SAP data\Top SKUs availability_28.10.2019_Upload file.xlsx|||`Top SKUs$`
False
1
Top SKUs availability_28.10.2019_Upload file.xlsx
Table=`Top SKUs$`
Warning
All
ByName
d:\Users\SaikatH\AppData\Local\Temp\Engine_91732_2148ccd4e82343bbb1e47b9147fca85f_\Engine_8892_10d22febf4ca4e8c82fded8e176cb10f_.yxdb
Single
Profile
d:\Users\SaikatH\AppData\Local\Temp\Engine_91732_2148ccd4e82343bbb1e47b9147fca85f_\Engine_8892_74c2337fa69744cba69072e3ba05bd9c_.yxdb
Single
Profile
d:\Users\SaikatH\AppData\Local\Temp\Engine_91732_2148ccd4e82343bbb1e47b9147fca85f_\Engine_8892_b4c683fee001455ea2cd0d63d09de739_.yxdb
Single
Profile
ABC_logic
d:\Users\SaikatH\AFG\AF Work\Alteryx\SAP data\Data for ABC.xlsx|||`Sheet1$`
False
1
Data for ABC.xlsx
Table=`Sheet1$`
Error
Error
Error
Weightage_MC = ([Sales Qty]/[Max_Sales Qty]*0.4)+
([Net Sales W/O TAX (AED)]/[Ma...
Weightage_Subcat = ([Sales Qty]/[Max_Sales Qty]*0.4)+
([Net Sales W/O TAX (AED)]...
Error
Weightage_Cat = ([Sales Qty]/[Max_Sales Qty]*0.4)+
([Net Sales W/O TAX (AED)]/[M...
Weightage_Class = ([Sales Qty]/[Max_Sales Qty]*0.4)+
([Net Sales W/O TAX (AED)]/...
Classification = IF [Weightage_Cat] < 0 THEN 'IGNORE'
ELSEIF
[Sales Qty]<0
OR...
Classification = IF [Weightage_MC] < 0 THEN 'IGNORE'
ELSEIF
[Sales Qty]<0
OR ...
Classification = IF [Weightage_Subcat] < 0 THEN 'IGNORE'
ELSEIF
[Sales Qty]<0 ...
Classification = IF [Weightage_Class] < 0 THEN 'IGNORE'
ELSEIF
[Sales Qty]<0
...
Error
Unique: Article, Site
!IsNull([Weightage_Cat])
Simple
IsNotNull
Weightage_Cat
True
fixed
2020-01-02 17:35:15
0
2020-01-02 17:35:15
2020-01-02 17:35:15
!IsNull([Weightage_Cat])
d:\Users\SaikatH\AppData\Local\Temp\Engine_91732_2148ccd4e82343bbb1e47b9147fca85f_\Engine_8892_ce3e9a95a33f41809462f560c6653d76_.yxdb
Single
Profile
Container_MB52
8
tabParameters
X
X
G/yG+tVUrFewTkh5xFTQRVrGupSJ954FUMu5DmPGM3x0FinFdxdD5p3hObbfj6OOSn7Nqnq3M1Zn9Ld1lGLNzRYxEpzgfcwDoG9vJkw1l+fRLMby0BUKfbPf1xN3cytjiqRDROvKPOV3mP0knZqAdOPE7TkbH7hAbfAoF2GCxENYy0rdxGk3RMcOGRCoheq5+Fnzg4abWWjeDcY++VQUQWZZonms0AGOTjAAcvYMVAFx0nDgR9E3CkUi33F7IYPjrPYvCk/V3Pjb9f4hy7lTInamogFyF32umqEmvj7YfetVDIybwLRzXTGqHCdwy4IIH/HM54a/Lg9OfDs9OU5cGGzLFnH+8CVzPBpPLYc4afuc775Tsk6C6YVC3lrVwd76hdgVn+d13yb+Q3qkrOzdvhCNB2fq7c6ZBNZJQDV/vW5Y/AMB6Ud1SRwGa5ZtxUIRRp4S/mgArvibodRZrfmmRRw==
X
SAP Logon
tabMapping
P03 PRT IS Retail ECC 6.0 PRODUCTION
NAME
P03 PRT IS Retail ECC 6.0 PRODUCTION
GROUP
PRODUCTION
MSHOST
aesapprt00
SYSID
PRT
ON_CCE
0
CFIT
0x0023
POOL_SIZE
10
MAX_POOL_SIZE
10
IDLE_TIMEOUT
600
IDLE_CHECK_TIME
600
MAX_POOL_WAIT_TIME
0
SYSTEMTYPE
ABAP
METHOD
STANDARD
CLIENT
100
X
X
PIPE
MB52
RM07MLBS
RM07MLBS
RM07MLBS
158348
5
MATNR
S
MATNR
MATNR
Article
C
WERKS
S
WERKS
WERKS
Site
C
LGORT
S
LGORT
LGORT
Storage Location
C
CHARG
S
CHARG
CHARG
Batch
C
MATART
S
MATART
MATART
Article Type
C
MATKLA
S
MATKLA
MATKLA
Merchandise Category
C
EKGRUP
S
EKGRUP
EKGRUP
Purchasing Group
C
PA_SOND
X
P
PA_SOND
PA_SOND
Also Select Special Stocks
C
SO_SOBKZ
S
SO_SOBKZ
SO_SOBKZ
Special Stock Indicator
C
NEGATIV
P
NEGATIV
NEGATIV
Display Negative Stocks Only
C
XMCHB
X
P
XMCHB
XMCHB
Display Batch Stocks
C
NOZERO
P
NOZERO
NOZERO
No zero stock lines
C
NOVALUES
P
NOVALUES
NOVALUES
Do Not Display Values
C
PA_HSQ
X
P
PA_HSQ
X
ALVV
PA_HSQ
PA_HSQ
C
PA_FLT
P
PA_FLT
X
ALVV
PA_FLT
PA_FLT
C
P_VARI
P
P_VARI
P_VARI
Layout
C
0
MATNR
EQ
I
1
WERKS
EQ
I
8600
2
LGORT
EQ
I
3
CHARG
EQ
I
4
MATART
EQ
I
5
MATKLA
EQ
I
6
EKGRUP
EQ
I
7
PA_SOND
EQ
I
NonSelectable
8
SO_SOBKZ
EQ
I
9
NEGATIV
EQ
I
NonSelectable
10
XMCHB
EQ
I
X
NonSelectable
11
NOZERO
EQ
I
X
NonSelectable
12
NOVALUES
EQ
I
NonSelectable
13
PA_HSQ
EQ
I
NonSelectable
14
PA_FLT
EQ
I
X
NonSelectable
15
P_VARI
EQ
I
/PRUDHVI
NonSelectable
16
WERKS
EQ
I
8610
17
WERKS
EQ
I
8611
18
WERKS
EQ
I
8612
19
WERKS
EQ
I
8613
20
WERKS
EQ
I
8615
21
WERKS
EQ
I
8627
22
WERKS
EQ
I
8628
23
WERKS
EQ
I
8636
24
WERKS
EQ
I
8651
25
WERKS
EQ
I
8652
26
WERKS
EQ
I
8671
27
WERKS
EQ
I
8676
28
WERKS
EQ
I
8677
29
WERKS
EQ
I
8697
30
WERKS
EQ
I
8698
31
WERKS
EQ
I
8680
32
WERKS
EQ
I
8681
33
WERKS
EQ
I
8682
34
WERKS
EQ
I
8683
35
WERKS
EQ
I
8608
X
SAP Report
Output
Last
Custom
=
True
fixed
2019-07-23 10:32:52
0
2019-07-23 10:32:52
2019-07-23 10:32:52
Warning
All
ByName
[SIte] = 8600
Simple
=
SIte
True
fixed
2019-12-29 12:57:34
0
8600
2019-12-29 12:57:34
2019-12-29 12:57:34
[SIte] = 8600
Horizontal
Stocks availability for Top 50 SKU's Store MDQ with SAP_MB52_working