P_FixedAssetPlanValue

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_FixedAssetPlanValue.
-- 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_FixedAssetPlanValue AS
SELECT
  Plan.bukrs AS CompanyCode,
  Plan.anln1 AS MasterFixedAsset,
  Plan.anln2 AS FixedAsset,
  Plan.gjahr AS FiscalYear,
  Plan.afabe AS AssetDepreciationArea,
  Plan.poper AS FiscalPeriod,
  cast(Plan.slalittype as fis_slalittype preserving type) AS SubLedgerAcctLineItemType,
  Plan.gjahr AS LedgerFiscalYear,
  cast('2' as faa_use_val_ty) AS PlannedValueIsInclusive,
  Plan.rldnr AS Ledger,
  Plan.movcat AS AssetAcctTransClassfctn,
  Plan.anlgr AS GroupMasterFixedAsset,
  Plan.anlgr2 AS GroupFixedAsset,
  cast('A' as fis_koart) AS FinancialAccountType,
  Plan.recid AS JointVentureCostRecoveryCode,
  Plan.xpost AS DepreciationIsDue,
  Plan.rhcur AS CompanyCodeCurrency,
  Plan.hsl AS AmountInCompanyCodeCurrency,
  Plan.rkcur AS GlobalCurrency,
  Plan.ksl AS AmountInGlobalCurrency,
  Plan.rocur AS FreeDefinedCurrency1,
  Plan.osl AS AmountInFreeDefinedCurrency1,
  Plan.rvcur AS FreeDefinedCurrency2,
  Plan.vsl AS AmountInFreeDefinedCurrency2,
  Plan.rbcur AS FreeDefinedCurrency3,
  Plan.bsl AS AmountInFreeDefinedCurrency3,
  Plan.rccur AS FreeDefinedCurrency4,
  Plan.csl AS AmountInFreeDefinedCurrency4,
  Plan.rdcur AS FreeDefinedCurrency5,
  Plan.dsl AS AmountInFreeDefinedCurrency5,
  Plan.recur AS FreeDefinedCurrency6,
  Plan.esl AS AmountInFreeDefinedCurrency6,
  Plan.rfcur AS FreeDefinedCurrency7,
  Plan.fsl AS AmountInFreeDefinedCurrency7,
  Plan.rgcur AS FreeDefinedCurrency8,
  Plan.gsl as AmountInFreeDefinedCurrency8 AS bukrsasCompanyCode,
  Plan.gsl as AmountInFreeDefinedCurrency8 AS rbukrsasCompanyCode,
  Plan.gsl AS AmountInFreeDefinedCurrency8
FROM faat_plan_values AS Plan
INNER JOIN I_AssetRedesignSwitchStatus ON /* join condition not captured in parsed metadata */
INNER JOIN P_TF_AssetRedesignSwitchStatus ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): faat_plan_values, P_ACDOCP_COM
;