P_RTPC_REM_OrderPostedKPI

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_RTPC_REM_OrderPostedKPI.
-- 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: PRTPCREMPSTKPI
-- Parameters: P_FiscalPeriodStartDate : budat, P_FiscalPeriodEndDate : budat

CREATE VIEW P_RTPC_REM_OrderPostedKPI AS
SELECT
  _Ord.OrderID AS OrderID,
  _Ledger.Ledger AS Ledger,
  _CrcyRoles._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,
  _Ord.ProfitCenter AS ProfitCenter,
  _Ord.ResultsAnalysisKey AS ResultsAnalysisKey,
  'I0002' AS StatusCode,
  _Ord.ProductionVersion AS ProductionVersion,
  case when _PostedWIP.PostingDate>=coalesce(_PostedVarc.PostingDate,'00000000') then _PostedWIP.PostingDate else _PostedVarc.PostingDate end as PostingDate AS PostingDateendasPostingDate,
  coalesce(_PostedWIP.PeriodAmountInCompanyCodeCrcy, 0) AS WIPPerdAmtInCoCodeCurrency,
  coalesce(_PostedWIP.PeriodAmountInGlobalCurrency, 0) AS WIPPerdAmtInGlobalCurrency,
  coalesce(_PostedWIP.PeriodAmountInFreeDfndCrcy1, 0) AS WIPPerdAmtInFreeDefinedCrcy1,
  coalesce(_PostedWIP.PeriodAmountInFreeDfndCrcy2, 0) AS WIPPerdAmtInFreeDefinedCrcy2,
  coalesce(_PostedWIP.PeriodAmountInFreeDfndCrcy3, 0) AS WIPPerdAmtInFreeDefinedCrcy3,
  coalesce(_PostedWIP.PeriodAmountInFreeDfndCrcy4, 0) AS WIPPerdAmtInFreeDefinedCrcy4,
  coalesce(_PostedWIP.PeriodAmountInFreeDfndCrcy5, 0) AS WIPPerdAmtInFreeDefinedCrcy5,
  coalesce(_PostedWIP.PeriodAmountInFreeDfndCrcy6, 0) AS WIPPerdAmtInFreeDefinedCrcy6,
  coalesce(_PostedWIP.PeriodAmountInFreeDfndCrcy7, 0) AS WIPPerdAmtInFreeDefinedCrcy7,
  coalesce(_PostedWIP.PeriodAmountInFreeDfndCrcy8, 0) AS WIPPerdAmtInFreeDefinedCrcy8,
  coalesce(_PostedVarc.PeriodAmountInCompanyCodeCrcy, 0) AS VarcPerdAmtInCoCodeCurrency,
  coalesce(_PostedVarc.PeriodAmountInGlobalCurrency, 0) AS VarcPerdAmtInGlobalCurrency,
  coalesce(_PostedVarc.PeriodAmountInFreeDfndCrcy1, 0) AS VarcPerdAmtInFreeDefinedCrcy1,
  coalesce(_PostedVarc.PeriodAmountInFreeDfndCrcy2, 0) AS VarcPerdAmtInFreeDefinedCrcy2,
  coalesce(_PostedVarc.PeriodAmountInFreeDfndCrcy3, 0) AS VarcPerdAmtInFreeDefinedCrcy3,
  coalesce(_PostedVarc.PeriodAmountInFreeDfndCrcy4, 0) AS VarcPerdAmtInFreeDefinedCrcy4,
  coalesce(_PostedVarc.PeriodAmountInFreeDfndCrcy5, 0) AS VarcPerdAmtInFreeDefinedCrcy5,
  coalesce(_PostedVarc.PeriodAmountInFreeDfndCrcy6, 0) AS VarcPerdAmtInFreeDefinedCrcy6,
  coalesce(_PostedVarc.PeriodAmountInFreeDfndCrcy7, 0) AS VarcPerdAmtInFreeDefinedCrcy7,
  coalesce(_PostedVarc.PeriodAmountInFreeDfndCrcy8, 0) 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_RTPC_REM_Order AS _Ord
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 */
;