I_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 I_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 I_FixedAsset AS
SELECT
  root.comp_code AS CompanyCode,
  root.asset_no AS MasterFixedAsset,
  root.asset_subno AS FixedAsset,
  main.asset_class AS AssetClass,
  main.serial_number AS AssetSerialNumber,
  cast( 0 as am_menge ) AS Quantity,
  main.base_unit AS BaseUnit,
  main.inventory_number AS Inventory,
  main.description AS FixedAssetDescription,
  main.add_description AS AssetAdditionalDescription,
  t001.waers AS Currency,
  cast( 0 as urwrt ) AS OriglAcqnAmtInCoCodeCrcy,
  main.trade_id AS PartnerCompany,
  main.manufacturer AS AssetManufacturerName,
  main.inhouse_prod_percent AS InHouseProdnPercent,
  cast( '' as liefe ) AS AssetSupplierName,
  main.inventory_note AS InventoryNote,
  cast( '' as ord41 ) AS Group1AssetEvaluationKey,
  cast( '' as ord42 ) AS Group2AssetEvaluationKey,
  cast( '' as ord43 ) AS Group3AssetEvaluationKey,
  cast( '' as ord44 ) AS Group4AssetEvaluationKey,
  cast( '' as gdlgrp ) AS Group5AssetEvaluationKey,
  main.gl_account_det AS AssetAccountDetermination,
  cast( root.is_historical_managed as aneqk ) AS HasHistory,
  cast( '00000000' as aktivd ) AS AssetCapitalizationDate,
  cast( '0000' as dzujahr ) AS FirstAcquisitionFiscalYear,
  cast( '000' as dzuper ) AS FirstAcquisitionFiscalPeriod,
  cast( '00000000' as deakt ) AS AssetDeactivationDate,
  cast( '00000000' as gplab ) AS PlannedRetirementDate,
  main.purchase_order_date AS FixedAssetOrderDate,
  main.original_asset AS OriginalMasterFixedAsset,
  main.asset_super_no AS FixedAssetGroup,
  main.invest_reason AS InvestmentReason,
  main.real_estate_asset AS AssetIsRealEstate,
  main.surface_area_unit AS AreaSizeUnit,
  main.investment_io_origin AS InvestmentOrder,
  cast( main.investment_wbs_origin as faa_inv_wbs_element_int preserving type ) AS InvestmentProjectWBSElement_2,
  main.investment_wbs_origin AS InvestmentProjectWBSElement,
  main.inventory_indicator AS InventoryIsCounted,
  main.inventory_date AS LastInventoryDate,
  cast( '' as aapm_act_change_pm ) AS AssetSynchronizationRule,
  main.original_acq_year AS OriginalAcquisitionFiscalYear,
  main.asset_type_name AS AssetTypeName,
  main.supplier_no AS Supplier,
  main.origin_country AS AssetCountryOfOrigin,
  main.assessment_tax_number AS NoticeOfAssessmentTaxID,
  main.assessment_date AS LastAssessmentNoticeDate,
  main.environmental_investment AS EnvrnmtlInvestmentReason,
  cast(root.completeness_status as aneqs) AS FixedAssetFinDataCmpltns,
  cast( root.is_blocked as xspeb_anla ) AS AccountIsBlockedForPosting,
  cast( '00000000' as dzugdat ) AS AcquisitionValueDate,
  main.original_acq_date AS OriginalFixedAssetValueDate,
  cast( '00000000' as abgdat ) AS LastRetirementValueDate,
  main.lastchange_user AS LastChangedByUser,
  main.property_ind AS FixedAssetPropertyType,
  cast( substring( cast( main.creation_datetime as char17 ), 1, 8 ) as erdat ) AS CreationDate,
  main.creation_user AS CreatedByUser,
  cast( '' as grund ) AS ManualDepreciationReason,
  main.last_reorg_date AS LastReorganizationDate,
  main.legacy_transfer_date AS LegacyDataTransferDate,
  cast( '' as xanlgr_1 ) AS IsGroupAsset,
  main.original_subasset AS OriginalFixedAsset,
  cast( main.description as mcoa1 ) AS MasterFixedAssetSearchTerm,
  main.asset_acquired_used AS AssetIsAcquiredUsed,
  root.is_main_asset AS IsMainAsset,
  root.lifecycle_status AS AssetLifecycleStatus,
  root.completeness_status AS AssetCompletenessStatus,
  root.auc_status AS AssetUnderConstructionStatus,
  root.validity_date AS AssetCreationValidityDate,
  main.creation_datetime AS CreationDateTime,
  main.lastchange_datetime AS LastChangeDateTime,
  main.screen_layout AS AssetScreenLayout,
  main.original_acq_value AS OriginalAcquisitionAmount,
  main.original_acq_value_curr AS OriginalAcquisitionCurrency,
  main.property_key AS PropertyClass,
  main.land_tax_office AS LocalTaxOffice,
  main.land_municipality AS Municipality,
  main.land_register_of AS LandRegisterDate,
  main.land_register_entry_number AS LandRegisterEntrySequence,
  main.land_register_entry AS LandRegisterEntryDate,
  main.land_register_volume AS LandRegisterVolume,
  main.land_register_page AS LandRegisterPage,
  main.land_register_map_no AS LandRegisterMap,
  main.land_plot_number AS LandPlot,
  main.conveyance_date AS ConveyanceDate,
  main.surface_area AS AreaSize,
  main.lease_company AS LeaseSupplier,
  main.lease_agreement_no AS LeaseAgreement,
  main.lease_agreement_date AS LeaseAgreementDate,
  main.lease_notice_date AS LeaseTermEndDate,
  main.lease_start_date AS LeaseTermStartDate,
  main.lease_years AS LeaseDurationInFiscalYears,
  main.lease_periods AS LeaseDurationInFiscalPeriods,
  main.lease_type AS LeaseType,
  main.lease_data_text AS LeasedAssetNote,
  cast( main.legacy_asset_no as faa_legacyasset ) AS LegacyAsset,
  main.legacy_comp_code AS LegacyFixedAssetCompanyCode,
  main.legacy_asset_no AS LegacyMasterFixedAsset,
  main.legacy_asset_subno AS LegacyFixedAsset,
  main.legacy_transfer_seq_no AS LegacyDataTransferSequence,
  root.is_post_capitalization AS AssetIsForPostCapitalization,
  cast( 'NEW' as faa_authcntxt ) AS AssetAuthorizationContext,
  main.object_nr AS ObjectInternalID
FROM faat_md_root AS root
LEFT OUTER JOIN I_FixedAssetAssgmt AS _FixedAssetAssgmt ON CompanyCode = _FixedAssetAssgmt.CompanyCode AND MasterFixedAsset = _FixedAssetAssgmt.MasterFixedAsset AND FixedAsset = _FixedAssetAssgmt.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_FixedAssetDeprArea AS _FixedAssetDeprArea ON CompanyCode = _FixedAssetDeprArea.CompanyCode AND MasterFixedAsset = _FixedAssetDeprArea.MasterFixedAsset AND FixedAsset = _FixedAssetDeprArea.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_AssetValuationForLedger AS _AssetValuationForLedger ON CompanyCode = _AssetValuationForLedger.CompanyCode AND MasterFixedAsset = _AssetValuationForLedger.MasterFixedAsset AND FixedAsset = _AssetValuationForLedger.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_FixedAssetForLedger AS _FixedAssetForLedger ON CompanyCode = _FixedAssetForLedger.CompanyCode AND MasterFixedAsset = _FixedAssetForLedger.MasterFixedAsset AND FixedAsset = _FixedAssetForLedger.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass ON AssetClass = _AssetClass.AssetClass  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.Company  -- association [0..1]
LEFT OUTER JOIN I_AssetAcctDetermination AS _AssetAccountDetermination ON AssetAccountDetermination = _AssetAccountDetermination.AssetAccountDetermination  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Country AS _AssetCountryOfOrigin ON AssetCountryOfOrigin = _AssetCountryOfOrigin.Country  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Group1AssetEvaluationKey AS _Group1AssetEvaluationKey ON Group1AssetEvaluationKey = _Group1AssetEvaluationKey.Group1AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group2AssetEvaluationKey AS _Group2AssetEvaluationKey ON Group2AssetEvaluationKey = _Group2AssetEvaluationKey.Group2AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group3AssetEvaluationKey AS _Group3AssetEvaluationKey ON Group3AssetEvaluationKey = _Group3AssetEvaluationKey.Group3AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group4AssetEvaluationKey AS _Group4AssetEvaluationKey ON Group4AssetEvaluationKey = _Group4AssetEvaluationKey.Group4AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group5AssetEvaluationKey AS _Group5AssetEvaluationKey ON Group5AssetEvaluationKey = _Group5AssetEvaluationKey.Group5AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_InvestmentReason AS _InvestmentReason ON InvestmentReason = _InvestmentReason.InvestmentReason  -- association [0..1]
LEFT OUTER JOIN I_EnvrnmtlInvestmentReason AS _EnvrnmtlInvestmentReason ON EnvrnmtlInvestmentReason = _EnvrnmtlInvestmentReason.EnvrnmtlInvestmentReason  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetFinDataCmpltns AS _FixedAssetFinDataCmpltns ON FixedAssetFinDataCmpltns = _FixedAssetFinDataCmpltns.FixedAssetFinDataCmpltns  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetPropertyType AS _FixedAssetPropertyType ON FixedAssetPropertyType = _FixedAssetPropertyType.FixedAssetPropertyType  -- association [0..1]
LEFT OUTER JOIN I_ManualDepreciationReason AS _ManualDepreciationReason ON ManualDepreciationReason = _ManualDepreciationReason.ManualDepreciationReason  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetGroup AS _FixedAssetGroup ON FixedAssetGroup = _FixedAssetGroup.FixedAssetGroup  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InvestmentOrder ON InvestmentOrder = _InvestmentOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvestmentWBSElement ON InvestmentProjectWBSElement_2 = _InvestmentWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_AssetLifecycleStatus AS _AssetLifecycleStatus ON AssetLifecycleStatus = _AssetLifecycleStatus.AssetLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_AssetCompletenessStatus AS _AssetCompletenessStatus ON AssetCompletenessStatus = _AssetCompletenessStatus.AssetCompletenessStatus  -- association [0..1]
LEFT OUTER JOIN I_AssetUnderConstructionStatus AS _AssetUnderConstructionStatus ON AssetUnderConstructionStatus = _AssetUnderConstructionStatus.AssetUnderConstructionStatus  -- association [0..1]
LEFT OUTER JOIN I_AssetStatusAtPurchase AS _AssetStatusAtPurchase ON AssetStatusAtPurchase = _AssetStatusAtPurchase.AssetStatusAtPurchase  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetCountryData AS _FixedAssetCountryData ON CompanyCode = _FixedAssetCountryData.CompanyCode AND MasterFixedAsset = _FixedAssetCountryData.MasterFixedAsset AND FixedAsset = _FixedAssetCountryData.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_GlobAssetAssignment AS _GlobAssetAssignment ON CompanyCode = _GlobAssetAssignment.CompanyCode AND MasterFixedAsset = _GlobAssetAssignment.MasterFixedAsset AND FixedAsset = _GlobAssetAssignment.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _OriginalAcquisitionCurrency ON OriginalAcquisitionCurrency = _OriginalAcquisitionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN E_FixedAsset AS _Extension ON MasterFixedAsset = _Extension.MasterFixedAsset AND FixedAsset = _Extension.FixedAsset AND CompanyCode = _Extension.CompanyCode  -- association [1..1]
;