SELECT
TOP 200
case when "S1"."CURRENCY" = '' then null
	else "S1"."CURRENCY" end as "CURRENCY"
, "F"."SID_0CALMONTH"
, "DP"."SID_0CHNGID"
, case when "S2"."DISTR_CHAN" = '' then null
	else "S2"."DISTR_CHAN" end as "DISTR_CHAN"
, case when "S3"."PLANT" = '' then null
	else "S3"."PLANT" end as "PLANT"
, "DP"."SID_0REQUID"
, case when "S4"."SALESORG" = '' then null
	else "S4"."SALESORG" end as "SALESORG"
, case when "S5"."/BIC/ZASS_CLST" = '' then null
	else "S5"."/BIC/ZASS_CLST" end as "ZASS_CLST"
, case when "S6"."/BIC/ZBPC_CFO" = '' then null
	else "S6"."/BIC/ZBPC_CFO" end as "ZBPC_CFO"
, case when "S7"."/BIC/ZBRANCH" = '' then null
	else "S7"."/BIC/ZBRANCH" end as "ZBRANCH"
, "F"."SID_ZCALWEEK3"
, case when "S8"."/BIC/ZCFO_BRCH" = '' then null
	else "S8"."/BIC/ZCFO_BRCH" end as "ZCFO_BRCH"
, case when "S9"."/BIC/ZCFO_FRMT" = '' then null
	else "S9"."/BIC/ZCFO_FRMT" end as "ZCFO_FRMT"
, case when "S10"."/BIC/ZFORMAT" = '' then null
	else "S10"."/BIC/ZFORMAT" end as "ZFORMAT"
, "S11"."/BIC/ZLFL_VRNT"
, case when "S12"."/BIC/ZMANCLSTP" = '' then null
	else "S12"."/BIC/ZMANCLSTP" end as "ZMANCLSTP"
, case when "S13"."/BIC/ZMAN_CLST" = '' then null
	else "S13"."/BIC/ZMAN_CLST" end as "ZMAN_CLST"
, case when "S14"."/BIC/ZPLLFLVIR" = '' then null
	else "S14"."/BIC/ZPLLFLVIR" end as "ZPLLFLVIR"
, case when "S15"."/BIC/ZPLLFLVM" = '' then null
	else "S15"."/BIC/ZPLLFLVM" end as "ZPLLFLVM"
, case when "S16"."/BIC/ZPRC_CLST" = '' then null
	else "S16"."/BIC/ZPRC_CLST" end as "ZPRC_CLST"
, case when "S17"."/BIC/ZPRIVL_FL" = '' then null
	else "S17"."/BIC/ZPRIVL_FL" end as "ZPRIVL_FL"
, case when "S18"."/BIC/ZPROMO_FL" = '' then null
	else "S18"."/BIC/ZPROMO_FL" end as "ZPROMO_FL"
, case when "S19"."/BIC/ZREGION" = '' then null
	else "S19"."/BIC/ZREGION" end as "ZREGION"
, case when "S20"."RT_ASSGRAD" = '' then null
	else "S20"."RT_ASSGRAD" end as "RT_ASSGRAD"
, case when "S21"."/BIC/ZSUPERVIS" = '' then null
	else "S21"."/BIC/ZSUPERVIS" end as "ZSUPERVIS"
, "F"."RPA_CNR"
, "F"."RPA_CST"
, "F"."RPA_SAT"
, "F"."/BIC/ZCST_N"
, "F"."/BIC/ZNUM_ROWS"
, "F"."/BIC/ZSAT_N"
, "F"."/BIC/Z_NUMDAYS"
, "F"."/BIC/Z_PROFIT"
, "F"."SID_0CALDAY"
FROM
"SAPBI2"."/BIC/F${TABLE}" "F"
JOIN
"SAPBI2"."/BI0/SCURRENCY" "S1"
ON
"F" . "SID_0DOC_CURRCY"
= "S1" . "SID"
JOIN
"SAPBI2"."/BIC/D${TABLE}P" "DP"
ON
"F" . "KEY_${TABLE}P"
= "DP" . "DIMID"
JOIN
"SAPBI2"."/BI0/SDISTR_CHAN" "S2"
ON
"F" . "SID_0DISTR_CHAN"
= "S2" . "SID"
JOIN
"SAPBI2"."/BI0/SPLANT" "S3"
ON
"F" . "SID_0PLANT"
= "S3" . "SID"
JOIN
"SAPBI2"."/BI0/SSALESORG" "S4"
ON
"F" . "SID_0SALESORG"
= "S4" . "SID"
JOIN
"SAPBI2"."/BIC/SZASS_CLST" "S5"
ON
"F" . "SID_ZASS_CLST"
= "S5" . "SID"
JOIN
"SAPBI2"."/BIC/SZBPC_CFO" "S6"
ON
"F" . "SID_ZBPC_CFO"
= "S6" . "SID"
JOIN
"SAPBI2"."/BIC/SZBRANCH" "S7"
ON
"F" . "SID_ZBRANCH"
= "S7" . "SID"
JOIN
"SAPBI2"."/BIC/SZCFO_BRCH" "S8"
ON
"F" . "SID_ZCFO_BRCH"
= "S8" . "SID"
JOIN
"SAPBI2"."/BIC/SZCFO_FRMT" "S9"
ON
"F" . "SID_ZCFO_FRMT"
= "S9" . "SID"
JOIN
"SAPBI2"."/BIC/SZFORMAT" "S10"
ON
"F" . "SID_ZFORMAT"
= "S10" . "SID"
JOIN
"SAPBI2"."/BIC/SZLFL_VRNT" "S11"
ON
"F" . "SID_ZLFL_VRNT"
= "S11" . "SID"
JOIN
"SAPBI2"."/BIC/SZMANCLSTP" "S12"
ON
"F" . "SID_ZMANCLSTP"
= "S12" . "SID"
JOIN
"SAPBI2"."/BIC/SZMAN_CLST" "S13"
ON
"F" . "SID_ZMAN_CLST"
= "S13" . "SID"
JOIN
"SAPBI2"."/BIC/SZPLLFLVIR" "S14"
ON
"F" . "SID_ZPLLFLVIR"
= "S14" . "SID"
JOIN
"SAPBI2"."/BIC/SZPLLFLVM" "S15"
ON
"F" . "SID_ZPLLFLVM"
= "S15" . "SID"
JOIN
"SAPBI2"."/BIC/SZPRC_CLST" "S16"
ON
"F" . "SID_ZPRC_CLST"
= "S16" . "SID"
JOIN
"SAPBI2"."/BIC/SZPRIVL_FL" "S17"
ON
"F" . "SID_ZPRIVL_FL"
= "S17" . "SID"
JOIN
"SAPBI2"."/BIC/SZPROMO_FL" "S18"
ON
"F" . "SID_ZPROMO_FL"
= "S18" . "SID"
JOIN
"SAPBI2"."/BIC/SZREGION" "S19"
ON
"F" . "SID_ZREGION"
= "S19" . "SID"
JOIN
"SAPBI2"."/BI0/SRT_ASSGRAD" "S20"
ON
"F" . "SID_ZRTASSGRD"
= "S20" . "SID"
JOIN
"SAPBI2"."/BIC/SZSUPERVIS" "S21"
ON
"F" . "SID_ZSUPERVIS"
= "S21" . "SID"
WHERE
"F"."SID_0CALDAY"
= $DATE
AND
"F"."SID_0PLANT" IN ($PLANT_IDS)