Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view P_RealTimeMfgOrderPostedKPI.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PRTMOPSTKPI
-- Parameters: P_FiscalPeriodStartDate : budat, P_FiscalPeriodEndDate : budat
CREATE VIEW P_RealTimeMfgOrderPostedKPI AS
SELECT
_Ord.OrderID AS OrderID,
_Ledger.Ledger AS Ledger,
_Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
_Ord.OrderDescription AS OrderDescription,
_Ord.ControllingObject AS ControllingObject,
_Ord.OrderType AS OrderType,
_Ord.OrderCategory AS OrderCategory,
_Ord.ControllingArea AS ControllingArea,
_Ord.CompanyCode AS CompanyCode,
_Ord.Material AS Material,
_Ord.Plant AS Plant,
ProfitCenter,
ResultsAnalysisKey,
StatusCode,
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 AS PostingDateendasPostingDate,
cast ( (coalesce(_postedWIP.AmountInCompanyCodeCurrency, 0) + coalesce(_postedRsrv.AmountInCompanyCodeCurrency, 0) ) as fis_hsl ) AS WIPCumltvAmtInCoCodeCurrency,
cast ( (coalesce(_postedWIP.AmountInGlobalCurrency, 0) + coalesce(_postedRsrv.AmountInGlobalCurrency, 0) )as fis_ksl ) AS WIPCumltvAmtInGlobalCurrency,
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency1, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency1, 0) ) as fis_osl ) AS WIPCumltvAmtInFreeDfndCrcy1,
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency2, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency2, 0) ) as fis_vsl ) AS WIPCumltvAmtInFreeDfndCrcy2,
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency3, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency3, 0) ) as fis_bsl ) AS WIPCumltvAmtInFreeDfndCrcy3,
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency4, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency4, 0) ) as fis_csl ) AS WIPCumltvAmtInFreeDfndCrcy4,
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency5, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency5, 0) ) as fis_dsl ) AS WIPCumltvAmtInFreeDfndCrcy5,
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency6, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency6, 0) ) as fis_esl ) AS WIPCumltvAmtInFreeDfndCrcy6,
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency7, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency7, 0) ) as fis_fsl) AS WIPCumltvAmtInFreeDfndCrcy7,
cast ( (coalesce(_postedWIP.AmountInFreeDefinedCurrency8, 0) + coalesce(_postedRsrv.AmountInFreeDefinedCurrency8, 0) ) as fis_gsl ) AS WIPCumltvAmtInFreeDfndCrcy8,
cast ( coalesce(_postedVarc.AmountInCompanyCodeCurrency, 0) - coalesce(_postedDistr.AmountInCompanyCodeCurrency, 0) as fis_hsl ) AS VarcCumltvAmtInCoCodeCurrency,
cast (coalesce(_postedVarc.AmountInGlobalCurrency, 0) - coalesce(_postedDistr.AmountInGlobalCurrency, 0)as fis_ksl ) AS VarcCumltvAmtInGlobalCurrency,
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency1, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency1, 0) as fis_osl ) AS VarcCumltvAmtInFreeDfndCrcy1,
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency2, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency2, 0) as fis_vsl ) AS VarcCumltvAmtInFreeDfndCrcy2,
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency3, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency3, 0) as fis_bsl ) AS VarcCumltvAmtInFreeDfndCrcy3,
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency4, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency4, 0) as fis_csl ) AS VarcCumltvAmtInFreeDfndCrcy4,
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency5, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency5, 0) as fis_dsl ) AS VarcCumltvAmtInFreeDfndCrcy5,
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency6, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency6, 0) as fis_esl ) AS VarcCumltvAmtInFreeDfndCrcy6,
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency7, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency7, 0) as fis_fsl) AS VarcCumltvAmtInFreeDfndCrcy7,
cast ( coalesce(_postedVarc.AmountInFreeDefinedCurrency8, 0) - coalesce(_postedDistr.AmountInFreeDefinedCurrency8, 0) as fis_gsl ) AS VarcCumltvAmtInFreeDfndCrcy8,
cast ( coalesce(_postedWIP.PeriodAmountInCompanyCodeCrcy, 0) as fis_hsl ) AS WIPPerdAmtInCoCodeCurrency,
cast ( coalesce(_postedWIP.PeriodAmountInGlobalCurrency, 0) as fis_ksl ) AS WIPPerdAmtInGlobalCurrency,
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy1, 0) as fis_osl ) AS WIPPerdAmtInFreeDefinedCrcy1,
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy2, 0) as fis_vsl ) AS WIPPerdAmtInFreeDefinedCrcy2,
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy3, 0) as fis_bsl ) AS WIPPerdAmtInFreeDefinedCrcy3,
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy4, 0) as fis_csl ) AS WIPPerdAmtInFreeDefinedCrcy4,
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy5, 0) as fis_dsl ) AS WIPPerdAmtInFreeDefinedCrcy5,
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy6, 0) as fis_esl ) AS WIPPerdAmtInFreeDefinedCrcy6,
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy7, 0) as fis_fsl) AS WIPPerdAmtInFreeDefinedCrcy7,
cast ( coalesce(_postedWIP.PeriodAmountInFreeDfndCrcy8, 0) as fis_gsl ) AS WIPPerdAmtInFreeDefinedCrcy8,
cast ( coalesce(_postedVarc.PeriodAmountInCompanyCodeCrcy, 0) - coalesce(_postedDistr.PeriodAmountInCompanyCodeCrcy, 0) as fis_hsl ) AS VarcPerdAmtInCoCodeCurrency,
cast ( coalesce(_postedVarc.PeriodAmountInGlobalCurrency, 0) - coalesce(_postedDistr.PeriodAmountInGlobalCurrency, 0) as fis_ksl ) AS VarcPerdAmtInGlobalCurrency,
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy1, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy1, 0) as fis_osl ) AS VarcPerdAmtInFreeDefinedCrcy1,
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy2, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy2, 0) as fis_vsl ) AS VarcPerdAmtInFreeDefinedCrcy2,
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy3, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy3, 0) as fis_bsl ) AS VarcPerdAmtInFreeDefinedCrcy3,
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy4, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy4, 0) as fis_csl ) AS VarcPerdAmtInFreeDefinedCrcy4,
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy5, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy5, 0) as fis_dsl ) AS VarcPerdAmtInFreeDefinedCrcy5,
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy6, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy6, 0) as fis_esl ) AS VarcPerdAmtInFreeDefinedCrcy6,
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy7, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy7, 0) as fis_fsl) AS VarcPerdAmtInFreeDefinedCrcy7,
cast ( coalesce(_postedVarc.PeriodAmountInFreeDfndCrcy8, 0) - coalesce(_postedDistr.PeriodAmountInFreeDfndCrcy8, 0) as fis_gsl ) AS VarcPerdAmtInFreeDefinedCrcy8,
_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
FROM P_RealTimeMfgOrder
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS _CrcyRoles ON /* join condition not captured in parsed metadata */
INNER JOIN I_Ledger AS _Ledger ON /* join condition not captured in parsed metadata */
;