P_AssetHistorySheetCube3

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_AssetHistorySheetCube3.
-- 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.
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper

CREATE VIEW P_AssetHistorySheetCube3 AS
SELECT
  Values.CompanyCode AS CompanyCode,
  Values.AssetDepreciationArea AS AssetDepreciationArea,
  Values.MasterFixedAsset AS MasterFixedAsset,
  Values.FixedAsset AS FixedAsset,
  Values.Ledger AS Ledger,
  Values.FiscalYear AS FiscalYear,
  Values.FiscalPeriod AS FiscalPeriod,
  Values.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  Values.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetKeyFigureSetSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Values.AccountingDocument AS AccountingDocument,
  Values.LedgerGLLineItem AS LedgerGLLineItem,
  Values.TransactionSubitem AS TransactionSubitem,
  Values.DebitCreditCode AS DebitCreditCode,
  Values.LedgerFiscalYear AS LedgerFiscalYear,
  Values.FiscalYearVariant AS FiscalYearVariant,
  Values.FiscalYearPeriod AS FiscalYearPeriod,
  Values.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  Values.PostingDate AS PostingDate,
  Values.ChartOfDepreciation AS ChartOfDepreciation,
  AssetKeyFigureSetSpec.AssetAccountingSortedKeyFigure AS AssetAccountingSortedKeyFigure,
  Values.ChartOfAccounts AS ChartOfAccounts,
  Values.ControllingArea AS ControllingArea,
  Values.Country AS Country,
  Values.CountryChartOfAccounts AS CountryChartOfAccounts,
  Values.FinancialManagementArea AS FinancialManagementArea,
  RealDepreciationAreaByCoCode.FinancialStatementVariant AS FinancialStatementVariant,
  Values.AccountingPrinciple AS AccountingPrinciple,
  Values.LedgerGroup AS LedgerGroup,
  Values.GLAccount AS GLAccount,
  Values.AlternativeGLAccount AS AlternativeGLAccount,
  Values.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  Values.GroupFixedAsset AS GroupFixedAsset,
  Values.FinancialAccountType AS FinancialAccountType,
  Values.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Values.CreationTime AS CreationTime,
  Values.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  Values.CostCenter AS CostCenter,
  Values.Plant AS Plant,
  Values.BusinessArea AS BusinessArea,
  Values.PersonnelNumber AS PersonnelNumber,
  Values.Fund AS Fund,
  Values.ProfitCenter AS ProfitCenter,
  Values.Segment AS Segment,
  Values.FunctionalArea AS FunctionalArea,
  Values.FundsCenter AS FundsCenter,
  Values.AssetTransactionType AS AssetTransactionType,
  Values.GrantID AS GrantID,
  Values.BudgetPeriod AS BudgetPeriod,
  Values.BusinessTransactionType AS BusinessTransactionType,
  Values.BusinessTransactionCategory AS BusinessTransactionCategory,
  Values.FinancialClosingStep AS FinancialClosingStep,
  Values.CompanyCodeCurrency AS CompanyCodeCurrency,
  Values.GlobalCurrency AS GlobalCurrency,
  Values.FunctionalCurrency AS FunctionalCurrency,
  Values.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  Values.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  Values.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  Values.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  Values.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  Values.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  Values.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  Values.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  Values.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Values.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Values.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  Values.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  Values.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  Values.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  Values.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  Values.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  Values.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  Values.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  Values.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  Values.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  Values.GlobalCurrencyRole AS GlobalCurrencyRole,
  Values.FunctionalCurrencyRole AS FunctionalCurrencyRole,
  Values.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  Values.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  Values.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  Values.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  Values.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  Values.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  Values.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  Values.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  Values.BaseUnit AS BaseUnit,
  cast (0 as quan1_12) AS Quantity
FROM P_AssetHistorySheetCube4
INNER JOIN I_AssetKeyFigureSetSpec AS AssetKeyFigureSetSpec ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetKeyFigureSpecification AS AssetKeyFigureSpec ON /* join condition not captured in parsed metadata */
INNER JOIN I_FixedAssetPlanValue AS Values ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_AssetHistorySheetCube4, I_LedgerCompanyCodeCrcyRoles
;