P_PL_SAFTFixedAssetFields10

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_PL_SAFTFixedAssetFields10.
-- 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_ConfigurationKeyDate : fipl_sa_confign_key_date, P_BookDepreciationAreaLedger : saft_aa_pl_book_area_ledger, P_ReportingEndDate : srf_rpg_period_end_date

CREATE VIEW P_PL_SAFTFixedAssetFields10 AS
SELECT
  FixedAssetForLedger.CompanyCode AS CompanyCode,
  FixedAssetForLedger.MasterFixedAsset AS MasterFixedAsset,
  FixedAssetForLedger.FixedAsset AS FixedAsset,
  FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  FixedAsset.AssetClass AS AssetClass,
  FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  FixedAssetForLedger.AssetDeactivationDate AS AssetDeactivationDate,
  FixedAssetForLedger.AcquisitionValueDate AS AcquisitionValueDate,
  cast('00000000' as fipl_sa_acqn_prodn_date ) AS PL_AcquisitionProductionDate,
  cast('' as fipl_sa_acqn_form_nmbr ) AS PL_AcquisitionFormNumber,
  cast('' as fipl_sa_acqn_doc_type) AS PL_AcquisitionDocumentType,
  FixedAsset._FixedAssetCountryData.NationalClassification AS IntAssetClassificationSymbol,
  cast('' as fipl_sa_ast_tax_grp ) AS PL_AssetTaxGroup,
  cast( '' as fipl_sa_def_key_content) AS IS_FAG_T10_Content,
  cast( '' as fipl_sa_def_key_content) AS IS_FAG_T20_Content,
  cast( '' as fipl_sa_def_key_content) AS IS_FAG_T30_Content,
  cast( '' as fipl_sa_def_key_content) AS IS_FAG_T80_Content,
  MainAreas.BookPlannedUsefulLifeInYears AS BookPlannedUsefulLifeInYears,
  MainAreas.BookPlannedUsefulLifeInPeriods AS BookPlannedUsefulLifeInPeriods,
  MainAreas.BookDeprKeyChangeoverYear AS BookDeprKeyChangeoverYear,
  MainAreas.BookDepreciationKey AS BookDepreciationKey,
  MainAreas.BookDepreciationMethod AS BookDepreciationMethod,
  MainAreas.BookDeprKeyPercentageRateValue AS BookDeprKeyPercentageRateValue,
  MainAreas.TaxPlannedUsefulLifeInYears AS TaxPlannedUsefulLifeInYears,
  MainAreas.TaxPlannedUsefulLifeInPeriods AS TaxPlannedUsefulLifeInPeriods,
  MainAreas.TaxDeprKeyChangeoverYear AS TaxDeprKeyChangeoverYear,
  MainAreas.TaxDepreciationKey AS TaxDepreciationKey,
  MainAreas.TaxDepreciationMethod AS TaxDepreciationMethod,
  MainAreas.TaxDepreciationFrequency AS TaxDepreciationFrequency,
  MainAreas.TaxDeprKeyPercentageRateValue AS TaxDeprKeyPercentageRateValue,
  FixedAssetForLedger._CompanyCode AS _CompanyCode,
  FixedAssetForLedger._MasterFixedAsset AS _MasterFixedAsset,
  FixedAssetForLedger._FixedAsset AS _FixedAsset,
  FixedAsset._AssetClass AS P_ConfigurationKeyDate,
  FixedAsset._AssetClass AS _AssetClass
FROM I_FixedAsset AS FixedAsset
INNER JOIN P_PL_SAFTMainAreasFields20 ON /* join condition not captured in parsed metadata */
INNER JOIN I_FixedAssetForLedger AS FixedAssetForLedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetRedesignSwitchStatus ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_FixedAsset
;