P_FixedAsset

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_FixedAsset.
-- 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_FixedAsset AS
SELECT
  anla.bukrs AS CompanyCode,
  anla.anln1 AS MasterFixedAsset,
  anla.anln2 AS FixedAsset,
  anla.anlkl AS AssetClass,
  anla.sernr AS AssetSerialNumber,
  anla.menge AS Quantity,
  anla.meins AS BaseUnit,
  anla.invnr AS Inventory,
  anla.txt50 AS FixedAssetDescription,
  anla.txa50 AS AssetAdditionalDescription,
  t001.waers AS Currency,
  anla.urwrt AS OriglAcqnAmtInCoCodeCrcy,
  anla.vbund AS PartnerCompany,
  anla.herst AS AssetManufacturerName,
  anla.antei AS InHouseProdnPercent,
  anla.liefe AS AssetSupplierName,
  anla.invzu AS InventoryNote,
  anla.ord41 AS Group1AssetEvaluationKey,
  anla.ord42 AS Group2AssetEvaluationKey,
  anla.ord43 AS Group3AssetEvaluationKey,
  anla.ord44 AS Group4AssetEvaluationKey,
  anla.gdlgrp AS Group5AssetEvaluationKey,
  anla.ktogr AS AssetAccountDetermination,
  anla.aneqk AS HasHistory,
  anla.aktiv AS AssetCapitalizationDate,
  anla.zujhr AS FirstAcquisitionFiscalYear,
  anla.zuper AS FirstAcquisitionFiscalPeriod,
  anla.deakt AS AssetDeactivationDate,
  anla.gplab AS PlannedRetirementDate,
  anla.bstdt AS FixedAssetOrderDate,
  anla.aibn1 AS OriginalMasterFixedAsset,
  anla.anlue AS FixedAssetGroup,
  anla.izwek AS InvestmentReason,
  anla.aimmo AS AssetIsRealEstate,
  anla.feins AS AreaSizeUnit,
  anla.eaufn AS InvestmentOrder,
  anla.posnr AS InvestmentProjectWBSElement,
  cast(anla.posnr as faa_inv_wbs_element_int preserving type) AS InvestmentProjectWBSElement_2,
  anla.inken AS InventoryIsCounted,
  anla.ivdat AS LastInventoryDate,
  anla.act_change_pm AS AssetSynchronizationRule,
  anla.urjhr AS OriginalAcquisitionFiscalYear,
  anla.typbz AS AssetTypeName,
  anla.lifnr AS Supplier,
  anla.land1 AS AssetCountryOfOrigin,
  anla.ehwnr AS NoticeOfAssessmentTaxID,
  anla.ehwzu AS LastAssessmentNoticeDate,
  anla.umwkz AS EnvrnmtlInvestmentReason,
  case when anla.aedat = '' then cast('00000000' as fis_aedat_anla) when anla.aedat <> '' then cast(anla.aedat as fis_aedat_anla) end as LastChangeDate AS aedatasfis_aedat_anlaendasLastChangeDate,
  anla.aneqs AS FixedAssetFinDataCmpltns,
  anla.xloev AS AccountIsMarkedForDeletion,
  anla.xspeb AS AccountIsBlockedForPosting,
  anla.zugdt AS AcquisitionValueDate,
  anla.aibdt AS OriginalFixedAssetValueDate,
  anla.xinvm AS AssetUnderConstIsInvmtMsr,
  anla.abgdt AS LastRetirementValueDate,
  anla.aenam AS LastChangedByUser,
  anla.eigkz AS FixedAssetPropertyType,
  anla.erdat AS CreationDate,
  anla.ernam AS CreatedByUser,
  anla.grund AS ManualDepreciationReason,
  anla.last_reorg_date AS LastReorganizationDate,
  anla.ldt_date AS LegacyDataTransferDate,
  anla.xanlgr AS IsGroupAsset,
  anla.xopvw AS IsLineItemSettled,
  anla.aibn2 AS OriginalFixedAsset,
  anla.mcoa1 AS MasterFixedAssetSearchTerm,
  anla.xafabch AS AssetStatusAtPurchase,
  cast('' as xafabch) AS AssetIsAcquiredUsed,
  cast('' as faa_md_xmain) AS IsMainAsset,
  cast('' as faa_md_lc_status) AS AssetLifecycleStatus,
  cast('' as faa_md_compl_status) AS AssetCompletenessStatus,
  cast('' as faa_md_auc_status) AS AssetUnderConstructionStatus,
  cast('00000000' as faa_md_validity_date) AS AssetCreationValidityDate,
  cast(0 as timestamp) AS CreationDateTime,
  cast(0 as timestamp) AS LastChangeDateTime,
  cast(anla.felei as faa_layout) AS AssetScreenLayout,
  cast(0 as urwrt) AS OriginalAcquisitionAmount,
  cast('' as faa_md_org_acq_curr) AS OriginalAcquisitionCurrency,
  anla.vmgli AS PropertyClass,
  anla.fiamt AS LocalTaxOffice,
  anla.stadt AS Municipality,
  anla.gruvo AS LandRegisterDate,
  anla.grlfd AS LandRegisterEntrySequence,
  anla.grein AS LandRegisterEntryDate,
  anla.grbnd AS LandRegisterVolume,
  anla.grblt AS LandRegisterPage,
  anla.flurk AS LandRegisterMap,
  anla.flurn AS LandPlot,
  anla.aufla AS ConveyanceDate,
  anla.grufl AS AreaSize,
  anla.leafi AS LeaseSupplier,
  anla.lvtnr AS LeaseAgreement,
  anla.lvdat AS LeaseAgreementDate,
  anla.lkdat AS LeaseTermEndDate,
  anla.leabg AS LeaseTermStartDate,
  anla.lejar AS LeaseDurationInFiscalYears,
  anla.leper AS LeaseDurationInFiscalPeriods,
  anla.leart AS LeaseType,
  anla.letxt AS LeasedAssetNote,
  cast('' as faa_legacyasset) AS LegacyAsset,
  cast('' as faa_md_ldt_comp_code) AS LegacyFixedAssetCompanyCode,
  cast('' as faa_md_ldt_asset_no) AS LegacyMasterFixedAsset,
  cast('' as faa_md_ldt_asset_subno) AS LegacyFixedAsset,
  anla.ldt_seqno AS LegacyDataTransferSequence,
  cast('' as faa_md_xpostcap) AS AssetIsForPostCapitalization,
  cast('CLASSIC' as faa_authcntxt) AS AssetAuthorizationContext,
  anla.objnr AS ObjectInternalID,
  P_TF_AssetRedesignSwitchStatus.IsActive as AssetRedesignSwitchIsActive AS comp_codeasCompanyCode,
  P_TF_AssetRedesignSwitchStatus.IsActive AS AssetRedesignSwitchIsActive
FROM anla
INNER JOIN P_TF_AssetRedesignSwitchStatus ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): faat_md_root
;