@AbapCatalog.sqlViewName: 'PRTMOPSTKPI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Event-based Order KPI'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true
define view P_RealTimeMfgOrderPostedKPI
with parameters
P_FiscalPeriodStartDate : budat,
P_FiscalPeriodEndDate : budat
as select from P_RealTimeMfgOrder(P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate) as _Ord
inner join I_LedgerCompanyCodeCrcyRoles as _CrcyRoles on _Ord.CompanyCode = _CrcyRoles.CompanyCode
inner join I_Ledger as _Ledger on _CrcyRoles.Ledger = _Ledger.Ledger
and _Ledger.LedgerType = '' //standard ledger only
left outer to one join P_RealTimeMfgOrdInspPostedWIP(P_FiscalPeriodStartDate : $parameters.P_FiscalPeriodStartDate,
P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate) as _postedWIP on _postedWIP.OrderID = _Ord.OrderID
and _postedWIP.Ledger = _Ledger.Ledger
left outer to one join P_RealTimeMfgOrdInspPostedRsrv(P_FiscalPeriodStartDate : $parameters.P_FiscalPeriodStartDate,
P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate) as _postedRsrv on _postedRsrv.OrderID = _Ord.OrderID
and _postedRsrv.Ledger = _Ledger.Ledger
left outer to one join P_RealTimeMfgOrdInspPostedVarc(P_FiscalPeriodStartDate : $parameters.P_FiscalPeriodStartDate,
P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate
) as _postedVarc on _postedVarc.OriginOrder = _Ord.OrderID
and _postedVarc.Ledger = _Ledger.Ledger
left outer to one join P_RealTimeMFGOrdInspPostdDistr(P_FiscalPeriodStartDate : $parameters.P_FiscalPeriodStartDate,
P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate
) as _postedDistr on _postedDistr.OrderID = _Ord.OrderID
and _postedDistr.Ledger = _Ledger.Ledger
// left outer to one join P_COOutputQuantitiesByObject(
// P_FromFiscalYearPeriod : '0000000',
// P_ToFiscalYearPeriod : $parameters.P_ToFiscalYearPeriod) as _OutputQty on _Ord.ControllingObject = _OutputQty.ControllingObject
{
key _Ord.OrderID,
key _Ledger.Ledger,
_Ledger._Text[1: Language = $session.system_language].LedgerName,
_Ord.OrderDescription,
_Ord.ControllingObject,
_Ord.OrderType,
_Ord.OrderCategory,
_Ord.ControllingArea,
_Ord.CompanyCode,
_Ord.Material,
_Ord.Plant,
ProfitCenter,
ResultsAnalysisKey,
EventBasedProcessingKey,
//ProductionUnit,
StatusCode,
//LogNumber,
//LogHandle,
// LogMessageText,
//Severity,
//To get the last posting date for EBWI, compare max posting date for WIP, reserve and variance
case
when _postedWIP.PostingDate>=coalesce(_postedRsrv.PostingDate,'00000000') and _postedWIP.PostingDate>=coalesce(_postedVarc.PostingDate,'00000000') then _postedWIP.PostingDate
when _postedRsrv.PostingDate>=coalesce(_postedWIP.PostingDate,'00000000') and _postedRsrv.PostingDate>=coalesce(_postedVarc.PostingDate ,'00000000') then _postedRsrv.PostingDate
else _postedVarc.PostingDate end as PostingDate,
// @Semantics.unitOfMeasure:true
// cast(CostCtrActivityTypeQtyUnit as fis_meinh) as BaseUnit,
//
// @DefaultAggregation: #SUM
// @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
// COALESCE(PlanOutputQuantity, 0) as PlanOutputQuantity,
// @DefaultAggregation: #SUM
// @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
// COALESCE(ActualOutputQuantity, 0) as ActualOutputQuantity,
//Cumulative WIP
//CE2308 WIP = WIP + RESERVE
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast ( (coalesce(_postedWIP.AmountInCompanyCodeCurrency, 0) + coalesce(_postedRsrv.AmountInCompanyCodeCurrency, 0) ) as fis_hsl ) as WIPCumltvAmtInCoCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast ( (coalesce(_postedWIP.AmountInGlobalCurrency, 0) + coalesce(_postedRsrv.AmountInGlobalCurrency, 0) )as fis_ksl ) as WIPCumltvAmtInGlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency1, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency1, 0) ) as fis_osl ) as WIPCumltvAmtInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency2, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency2, 0) ) as fis_vsl ) as WIPCumltvAmtInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency3, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency3, 0) ) as fis_bsl ) as WIPCumltvAmtInFreeDfndCrcy3, //BSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency4, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency4, 0) ) as fis_csl ) as WIPCumltvAmtInFreeDfndCrcy4, //CSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency5, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency5, 0) ) as fis_dsl ) as WIPCumltvAmtInFreeDfndCrcy5, //DSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency6, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency6, 0) ) as fis_esl ) as WIPCumltvAmtInFreeDfndCrcy6, // ESL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency7, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency7, 0) ) as fis_fsl) as WIPCumltvAmtInFreeDfndCrcy7, //FSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency8, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency8, 0) ) as fis_gsl ) as WIPCumltvAmtInFreeDfndCrcy8, //GSL,
// //Cumulative Reserves
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
// cast ( coalesce(_postedRsrv.AmountInCompanyCodeCurrency, 0) as fis_hsl ) as RsrvCumltvAmtInCoCodeCurrency,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
// cast ( coalesce(_postedRsrv.AmountInGlobalCurrency, 0) as fis_ksl ) as RsrvCumltvAmtInGlobalCurrency,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
// cast ( coalesce(_postedRsrv.AmountInFreeDefinedCurrency1, 0) as fis_osl ) as RsrvCumltvAmtInFreeDfndCrcy1,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
// cast ( coalesce(_postedRsrv.AmountInFreeDefinedCurrency2, 0) as fis_vsl ) as RsrvCumltvAmtInFreeDfndCrcy2,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
// cast ( coalesce(_postedRsrv.AmountInFreeDefinedCurrency3, 0) as fis_bsl ) as RsrvCumltvAmtInFreeDfndCrcy3, //BSL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
// cast ( coalesce(_postedRsrv.AmountInFreeDefinedCurrency4, 0) as fis_csl ) as RsrvCumltvAmtInFreeDfndCrcy4, //CSL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
// cast ( coalesce(_postedRsrv.AmountInFreeDefinedCurrency5, 0) as fis_dsl ) as RsrvCumltvAmtInFreeDfndCrcy5, //DSL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
// cast ( coalesce(_postedRsrv.AmountInFreeDefinedCurrency6, 0) as fis_esl ) as RsrvCumltvAmtInFreeDfndCrcy6, // ESL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
// cast ( coalesce(_postedRsrv.AmountInFreeDefinedCurrency7, 0) as fis_fsl) as RsrvCumltvAmtInFreeDfndCrcy7, //FSL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
// cast ( coalesce(_postedRsrv.AmountInFreeDefinedCurrency8, 0) as fis_gsl ) as RsrvCumltvAmtInFreeDfndCrcy8, //GSL,
//Cumulative Variance
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast ( coalesce(_postedVarc.AmountInCompanyCodeCurrency, 0) - coalesce(_postedDistr.AmountInCompanyCodeCurrency, 0) as fis_hsl ) as VarcCumltvAmtInCoCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast (coalesce(_postedVarc.AmountInGlobalCurrency, 0) - coalesce(_postedDistr.AmountInGlobalCurrency, 0)as fis_ksl ) as VarcCumltvAmtInGlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency1, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency1, 0) as fis_osl ) as VarcCumltvAmtInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency2, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency2, 0) as fis_vsl ) as VarcCumltvAmtInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency3, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency3, 0) as fis_bsl ) as VarcCumltvAmtInFreeDfndCrcy3, //BSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency4, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency4, 0) as fis_csl ) as VarcCumltvAmtInFreeDfndCrcy4, //CSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency5, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency5, 0) as fis_dsl ) as VarcCumltvAmtInFreeDfndCrcy5, //DSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency6, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency6, 0) as fis_esl ) as VarcCumltvAmtInFreeDfndCrcy6, // ESL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency7, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency7, 0) as fis_fsl) as VarcCumltvAmtInFreeDfndCrcy7, //FSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency8, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency8, 0) as fis_gsl ) as VarcCumltvAmtInFreeDfndCrcy8, //GSL,
//Current period posted WIP
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast ( coalesce(_postedWIP.PeriodAmountInCompanyCodeCrcy, 0) as fis_hsl ) as WIPPerdAmtInCoCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast ( coalesce(_postedWIP.PeriodAmountInGlobalCurrency, 0) as fis_ksl ) as WIPPerdAmtInGlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy1, 0) as fis_osl ) as WIPPerdAmtInFreeDefinedCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy2, 0) as fis_vsl ) as WIPPerdAmtInFreeDefinedCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy3, 0) as fis_bsl ) as WIPPerdAmtInFreeDefinedCrcy3, //BSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy4, 0) as fis_csl ) as WIPPerdAmtInFreeDefinedCrcy4, //CSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy5, 0) as fis_dsl ) as WIPPerdAmtInFreeDefinedCrcy5, //DSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy6, 0) as fis_esl ) as WIPPerdAmtInFreeDefinedCrcy6, // ESL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy7, 0) as fis_fsl) as WIPPerdAmtInFreeDefinedCrcy7, //FSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy8, 0) as fis_gsl ) as WIPPerdAmtInFreeDefinedCrcy8, //GSL,
// //Current period posted Reserves
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInCompanyCodeCrcy, 0) as fis_hsl ) as RsrvPerdAmtInCoCodeCurrency,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInGlobalCurrency, 0) as fis_ksl ) as RsrvPerdAmtInGlobalCurrency,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInFreeDfndCrcy1, 0) as fis_osl ) as RsrvPerdAmtInFreeDefinedCrcy1,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInFreeDfndCrcy2, 0) as fis_vsl ) as RsrvPerdAmtInFreeDefinedCrcy2,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInFreeDfndCrcy3, 0) as fis_bsl ) as RsrvPerdAmtInFreeDefinedCrcy3, //BSL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInFreeDfndCrcy4, 0) as fis_csl ) as RsrvPerdAmtInFreeDefinedCrcy4, //CSL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInFreeDfndCrcy5, 0) as fis_dsl ) as RsrvPerdAmtInFreeDefinedCrcy5, //DSL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInFreeDfndCrcy6, 0) as fis_esl ) as RsrvPerdAmtInFreeDefinedCrcy6, // ESL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInFreeDfndCrcy7, 0) as fis_fsl) as RsrvPerdAmtInFreeDefinedCrcy7, //FSL,
//
// @DefaultAggregation: #SUM
// @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
// cast ( coalesce(_postedRsrv.PeriodAmountInFreeDfndCrcy8, 0) as fis_gsl ) as RsrvPerdAmtInFreeDefinedCrcy8, //GSL,
//Current period posted Variance
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast ( coalesce(_postedVarc.PeriodAmountInCompanyCodeCrcy, 0) - coalesce(_postedDistr.PeriodAmountInCompanyCodeCrcy, 0) as fis_hsl ) as VarcPerdAmtInCoCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast ( coalesce(_postedVarc.PeriodAmountInGlobalCurrency, 0) - coalesce(_postedDistr.PeriodAmountInGlobalCurrency, 0) as fis_ksl ) as VarcPerdAmtInGlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy1, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy1, 0) as fis_osl ) as VarcPerdAmtInFreeDefinedCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy2, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy2, 0) as fis_vsl ) as VarcPerdAmtInFreeDefinedCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy3, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy3, 0) as fis_bsl ) as VarcPerdAmtInFreeDefinedCrcy3, //BSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy4, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy4, 0) as fis_csl ) as VarcPerdAmtInFreeDefinedCrcy4, //CSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy5, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy5, 0) as fis_dsl ) as VarcPerdAmtInFreeDefinedCrcy5, //DSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy6, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy6, 0) as fis_esl ) as VarcPerdAmtInFreeDefinedCrcy6, // ESL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy7, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy7, 0) as fis_fsl) as VarcPerdAmtInFreeDefinedCrcy7, //FSL,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy8, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy8, 0) as fis_gsl ) as VarcPerdAmtInFreeDefinedCrcy8, //GSL,
_CrcyRoles._CoCodeCurrencyRoleCurrency.Currency as CompanyCodeCurrency,
_CrcyRoles._GlobalCurrencyRoleCurrency.Currency as GlobalCurrency,
_CrcyRoles._FreeDfndCrcyRole1Currency.Currency as FreeDefinedCurrency1,
_CrcyRoles._FreeDfndCrcyRole2Currency.Currency as FreeDefinedCurrency2,
_CrcyRoles._FreeDfndCrcyRole3Currency.Currency as FreeDefinedCurrency3,
_CrcyRoles._FreeDfndCrcyRole4Currency.Currency as FreeDefinedCurrency4,
_CrcyRoles._FreeDfndCrcyRole5Currency.Currency as FreeDefinedCurrency5,
_CrcyRoles._FreeDfndCrcyRole6Currency.Currency as FreeDefinedCurrency6,
_CrcyRoles._FreeDfndCrcyRole7Currency.Currency as FreeDefinedCurrency7,
_CrcyRoles._FreeDfndCrcyRole8Currency.Currency as FreeDefinedCurrency8
}
where
_postedWIP.OrderID is not null
or _postedRsrv.OrderID is not null
or _postedVarc.OriginOrder is not null
or _postedDistr.OrderID is not null