FAA_UPA_MIG_BAL_OLD01

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 FAA_UPA_MIG_BAL_OLD01.
-- 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 FAA_UPA_MIG_BAL_OLD01 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.ReferenceDocument AS ReferenceDocument,
  Values.LogicalSystem AS LogicalSystem,
  Values.ReferenceDocumentContext AS ReferenceDocumentContext,
  Values.ReferenceDocumentType AS ReferenceDocumentType,
  FixedAsset.anlkl AS AssetClass,
  Values.CompanyCodeCurrency AS CompanyCodeCurrency,
  Values.GlobalCurrency AS GlobalCurrency,
  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.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.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
FROM FAA_UPA_MIG_BAL_ODOC AS Values
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 anla AS FixedAsset ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): FAA_UPA_MIG_BAL_PLAN
;