P_FixedAssetTmpPlanVal

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_FixedAssetTmpPlanVal.
-- 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.

CREATE VIEW P_FixedAssetTmpPlanVal AS
SELECT
  Header.timestamp AS CreationDateTime,
  Header.usera AS CreatedByUser,
  Values.afabe AS AssetDepreciationArea,
  Values.bukrs AS CompanyCode,
  Values.gjahr AS FiscalYear,
  Values.anln1 AS MasterFixedAsset,
  Values.anln2 AS FixedAsset,
  Values.slalittype AS SubLedgerAcctLineItemType,
  Values.poper AS FiscalPeriod,
  I_DepreciationAreaForLedger.Ledger AS Ledger,
  I_DepreciationAreaForLedger.IsRepresentativeLedger AS IsRepresentativeLedger,
  Values.ldgrp AS LedgerGroup,
  Values.anlgr AS GroupMasterFixedAsset,
  Values.anlgr2 AS GroupFixedAsset,
  Values.movcat AS AssetAcctTransClassfctn,
  cast('A' as fis_koart preserving type) AS FinancialAccountType,
  cast(Values.rhcur as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(Values.hsl as fis_hsl preserving type) AS AmountInCompanyCodeCurrency,
  cast(Values.rkcur as fis_rkcur preserving type) AS GlobalCurrency,
  cast(Values.ksl as fis_ksl preserving type) AS AmountInGlobalCurrency,
  cast(rocur as fis_rocur preserving type) AS FreeDefinedCurrency1,
  cast(osl as fis_osl preserving type) AS AmountInFreeDefinedCurrency1,
  cast(rvcur as fis_rvcur preserving type) AS FreeDefinedCurrency2,
  cast(vsl as fis_vsl preserving type) AS AmountInFreeDefinedCurrency2,
  rbcur AS FreeDefinedCurrency3,
  cast(bsl as fis_bsl preserving type) AS AmountInFreeDefinedCurrency3,
  rccur AS FreeDefinedCurrency4,
  cast(csl as fis_csl preserving type) AS AmountInFreeDefinedCurrency4,
  rdcur AS FreeDefinedCurrency5,
  cast(dsl as fis_dsl preserving type) AS AmountInFreeDefinedCurrency5,
  recur AS FreeDefinedCurrency6,
  cast(esl as fis_esl preserving type) AS AmountInFreeDefinedCurrency6,
  cast(rfcur as fis_rfcur preserving type) AS FreeDefinedCurrency7,
  cast(fsl as fis_fsl preserving type) AS AmountInFreeDefinedCurrency7,
  rgcur AS FreeDefinedCurrency8,
  cast(gsl as fis_gsl preserving type) AS AmountInFreeDefinedCurrency8,
  Values.anlkl AS AssetClass,
  Values.ktogr AS AssetAccountDetermination,
  Values.xanlgr AS IsGroupAsset,
  Values.recid AS JointVentureCostRecoveryCode
FROM faat_d_pv_hdr AS Header
INNER JOIN faat_d_pv_values AS Values ON /* join condition not captured in parsed metadata */
INNER JOIN I_DepreciationAreaForLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LedgerGroupAssignment AS _LedgerGroupAssignment ON LedgerGroup = _LedgerGroupAssignment.LedgerGroup  -- association [0..*]
;