FAA_UPA_MIG_DA_KFC_ACDOCA01

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_DA_KFC_ACDOCA01.
-- 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_KeyFigureSet : faa_key_figure_set

CREATE VIEW FAA_UPA_MIG_DA_KFC_ACDOCA01 AS
SELECT
  acdoca.rbukrs AS CompanyCode,
  acdoca.anln1 AS MasterFixedAsset,
  acdoca.anln2 AS FixedAsset,
  acdoca.gjahr AS FiscalYear,
  cast(acdoca.awtyp as fis_awtyp preserving type) AS ReferenceDocumentType,
  acdoca.awref AS ReferenceDocument,
  acdoca.aworg AS ReferenceDocumentContext,
  acdoca.awsys AS LogicalSystem,
  acdoca.subta AS TransactionSubitem,
  acdoca.afabe AS AssetDepreciationArea,
  cast(acdoca.slalittype as fis_slalittype preserving type) AS SubLedgerAcctLineItemType,
  acdoca.movcat AS AssetAcctTransClassfctn,
  AssetKeyFigureSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  acdoca.rldnr AS Ledger,
  cast(acdoca.belnr as fis_belnr preserving type) AS AccountingDocument,
  cast(acdoca.docln as fis_docln preserving type) AS LedgerGLLineItem,
  acdoca.drcrk AS DebitCreditCode,
  acdoca.anlkl AS AssetClass,
  cast( '10' as fis_selected_currency_branch ) AS CompanyCodeCurrencyBranch,
  acdoca.rhcur AS CompanyCodeCurrency,
  acdoca.hsl AS AmountInCompanyCodeCurrency,
  cast( '30' as fis_selected_currency_branch ) AS GlobalCurrencyBranch,
  acdoca.rkcur AS GlobalCurrency,
  acdoca.ksl AS AmountInGlobalCurrency,
  cast( 'F1' as fis_selected_currency_branch preserving type ) AS FreeDefinedCurrency1Branch,
  acdoca.rocur AS FreeDefinedCurrency1,
  acdoca.osl AS AmountInFreeDefinedCurrency1,
  cast( 'F2' as fis_selected_currency_branch preserving type ) AS FreeDefinedCurrency2Branch,
  acdoca.rvcur AS FreeDefinedCurrency2,
  acdoca.vsl AS AmountInFreeDefinedCurrency2,
  cast( 'F3' as fis_selected_currency_branch preserving type ) AS FreeDefinedCurrency3Branch,
  acdoca.rbcur AS FreeDefinedCurrency3,
  acdoca.bsl AS AmountInFreeDefinedCurrency3,
  cast( 'F4' as fis_selected_currency_branch preserving type ) AS FreeDefinedCurrency4Branch,
  acdoca.rccur AS FreeDefinedCurrency4,
  acdoca.csl AS AmountInFreeDefinedCurrency4,
  cast( 'F5' as fis_selected_currency_branch preserving type ) AS FreeDefinedCurrency5Branch,
  acdoca.rdcur AS FreeDefinedCurrency5,
  acdoca.dsl AS AmountInFreeDefinedCurrency5,
  cast( 'F6' as fis_selected_currency_branch preserving type ) AS FreeDefinedCurrency6Branch,
  acdoca.recur AS FreeDefinedCurrency6,
  acdoca.esl AS AmountInFreeDefinedCurrency6,
  cast( 'F7' as fis_selected_currency_branch preserving type ) AS FreeDefinedCurrency7Branch,
  acdoca.rfcur AS FreeDefinedCurrency7,
  acdoca.fsl AS AmountInFreeDefinedCurrency7,
  cast( 'F8' as fis_selected_currency_branch preserving type ) AS FreeDefinedCurrency8Branch,
  acdoca.rgcur AS FreeDefinedCurrency8,
  acdoca.gsl AS AmountInFreeDefinedCurrency8
FROM acdoca
INNER JOIN I_TechnicalLedger AS TechnicalLedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_DepreciationAreaForLedger AS DeprAreaForLedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetValuationView AS AssetValuationView 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_AssetKeyFigureSetSpec AS AssetKeyFigureSetSpec ON /* join condition not captured in parsed metadata */
;