C_PubSecCmtmtActlAnalyses

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 C_PubSecCmtmtActlAnalyses.
-- 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: CPSMCMTMTACTLS

CREATE VIEW C_PubSecCmtmtActlAnalyses AS
SELECT
  Act.FinancialManagementArea AS FinancialManagementArea,
  Act.Ledger AS Ledger,
  Act.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Act.FiscalYear AS FiscalYear,
  Act.FiscalPeriod AS FiscalPeriod,
  Act.Fund AS Fund,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  Act.BudgetPeriod AS BudgetPeriod,
  _BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  Act.FunctionalArea AS FunctionalArea,
  _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  Act.GrantID AS GrantID,
  _Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  Act._Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  Act.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Act.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementExternalIDText.WBSDescription AS WBSDescription,
  Act._PubSecBudgetAccount.PubSecBudgetAccount AS PubSecBudgetAccount,
  Act._PubSecBudgetAccount.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  Act.CostCenter AS CostCenter,
  Act.GLAccount AS GLAccount,
  Act.ChartOfAccounts AS ChartOfAccounts,
  Act._ChartOfAccountsText AS _ChartOfAccountsText,
  Act.ProfitCenter AS ProfitCenter,
  Act.Segment AS Segment,
  Act.TransactionCurrency AS TransactionCurrency,
  Act.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Act.CompanyCodeCurrency AS CompanyCodeCurrency,
  Act.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Act.GlobalCurrency AS GlobalCurrency,
  Act.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Act.PubSecExpnCmtmtAmtInTransCrcy AS PubSecExpnCmtmtAmtInTransCrcy,
  Act.PubSecExpnActlAmtInTransCrcy AS PubSecExpnActlAmtInTransCrcy,
  Act.PubSecRevnCmtmtAmtInTransCrcy AS PubSecRevnCmtmtAmtInTransCrcy,
  Act.PubSecRevnActlAmtInTransCrcy AS PubSecRevnActlAmtInTransCrcy,
  Act.PubSecExpnCmtmtAmtInCoCodeCrcy AS PubSecExpnCmtmtAmtInCoCodeCrcy,
  Act.PubSecExpnActlAmtInCoCodeCrcy AS PubSecExpnActlAmtInCoCodeCrcy,
  Act.PubSecRevnCmtmtAmtInCoCodeCrcy AS PubSecRevnCmtmtAmtInCoCodeCrcy,
  Act.PubSecRevnActlAmtInCoCodeCrcy AS PubSecRevnActlAmtInCoCodeCrcy,
  Act.PubSecExpnCmtmtAmtInGlobalCrcy AS PubSecExpnCmtmtAmtInGlobalCrcy,
  Act.PubSecExpnActlAmtInGlobalCrcy AS PubSecExpnActlAmtInGlobalCrcy,
  Act.PubSecRevnCmtmtAmtInGlobalCrcy AS PubSecRevnCmtmtAmtInGlobalCrcy,
  Act.PubSecRevnActlAmtInGlobalCrcy AS PubSecRevnActlAmtInGlobalCrcy,
  Act.AccountingDocument AS AccountingDocument,
  Act.AccountingDocumentType AS AccountingDocumentType,
  Act.ReferenceDocument AS ReferenceDocument,
  Act.ReferenceDocumentContext AS ReferenceDocumentContext,
  Act.ReferenceDocumentType AS ReferenceDocumentType,
  Act._ReferenceDocumentType._Text[1:Language = $session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  Act.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  _PubSecBdgtCnsmpnAmtType._Text[1:Language = $session.system_language].PubSecBdgtCnsmpnAmtTypeText AS PubSecBdgtCnsmpnAmtTypeText,
  Act.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  Act._PubSecBdgtCnsmpnType._Text[1:Language = $session.system_language]. PubSecBudgetCnsmpnTypeText AS PubSecBudgetCnsmpnTypeText,
  Act.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  Act.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  Act.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  Act.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  Act.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  Act.FiscalYearVariant AS FiscalYearVariant,
  Act.LedgerFiscalYear AS LedgerFiscalYear,
  Act.PurchasingDocument AS PurchasingDocument,
  Act.PurchaseOrder AS PurchaseOrder,
  Act.PurchaseRequisition AS PurchaseRequisition,
  Act.PurchasingDocumentItem AS PurchasingDocumentItem,
  Act.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  Act.PartnerFunctionalArea AS PartnerFunctionalArea,
  Act._PartnerFunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS PartnerFuncAreaText,
  Act.PartnerFund AS PartnerFund,
  Act._PartnerFund._Text[1:Language = $session.system_language].FundDescription AS PartnerFundText,
  Act.PartnerGrant AS PartnerGrant,
  Act.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  Act._PartnerBudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName AS PartnerBudgetPeriodText,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  Act._Fund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  Act._Grant.GrantLfcycStatusForAuthzn AS GrantLfcycStatusForAuthzn
FROM I_PubSecCmtmtActlItemCube AS Act
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType ON PubSecBudgetCnsmpnType = _PubSecBdgtCnsmpnType.PubSecBudgetCnsmpnType  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON pubsecbudgetaccount = _PubSecBudgetAccount.PubSecBudgetAccount AND pubsecbudgetaccountcocode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode  -- association [0..1]
;