I_FixedAssetTP

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_FixedAssetTP.
-- 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_FixedAssetTP AS
SELECT
  I_FixedAsset.CompanyCode AS CompanyCode,
  I_FixedAsset.MasterFixedAsset AS MasterFixedAsset,
  I_FixedAsset.FixedAsset AS FixedAsset,
  I_FixedAsset.CompanyCode AS CompanyCodeForEdit,
  I_FixedAsset.MasterFixedAsset AS MasterFixedAssetForEdit,
  I_FixedAsset.FixedAsset AS FixedAssetForEdit,
  I_FixedAsset.FixedAssetExternalID AS FixedAssetExternalID,
  I_FixedAsset.AssetClass AS AssetClass,
  I_FixedAsset.AssetSerialNumber AS AssetSerialNumber,
  I_FixedAsset.Quantity AS Quantity,
  I_FixedAsset.BaseUnit AS BaseUnit,
  I_FixedAsset.Inventory AS Inventory,
  I_FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  I_FixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  _CompanyCode.Currency AS Currency,
  I_FixedAsset.OriglAcqnAmtInCoCodeCrcy AS OriglAcqnAmtInCoCodeCrcy,
  I_FixedAsset.PartnerCompany AS PartnerCompany,
  I_FixedAsset.AssetManufacturerName AS AssetManufacturerName,
  I_FixedAsset.InHouseProdnPercent AS InHouseProdnPercent,
  I_FixedAsset.AssetSupplierName AS AssetSupplierName,
  I_FixedAsset.InventoryNote AS InventoryNote,
  I_FixedAsset.Group1AssetEvaluationKey AS Group1AssetEvaluationKey,
  I_FixedAsset.Group2AssetEvaluationKey AS Group2AssetEvaluationKey,
  I_FixedAsset.Group3AssetEvaluationKey AS Group3AssetEvaluationKey,
  I_FixedAsset.Group4AssetEvaluationKey AS Group4AssetEvaluationKey,
  I_FixedAsset.Group5AssetEvaluationKey AS Group5AssetEvaluationKey,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  I_FixedAsset.AssetAccountDetermination AS AssetAccountDetermination,
  I_FixedAsset.HasHistory AS HasHistory,
  I_FixedAsset.AssetCapitalizationDate AS AssetCapitalizationDate,
  I_FixedAsset.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  I_FixedAsset.FirstAcquisitionFiscalPeriod AS FirstAcquisitionFiscalPeriod,
  I_FixedAsset.AssetDeactivationDate AS AssetDeactivationDate,
  I_FixedAsset.PlannedRetirementDate AS PlannedRetirementDate,
  I_FixedAsset.FixedAssetOrderDate AS FixedAssetOrderDate,
  I_FixedAsset.OriginalMasterFixedAsset AS OriginalMasterFixedAsset,
  I_FixedAsset.OriginalFixedAsset AS OriginalFixedAsset,
  I_FixedAsset.OriginalFixedAssetValueDate AS OriginalFixedAssetValueDate,
  I_FixedAsset.FixedAssetGroup AS FixedAssetGroup,
  I_FixedAsset.InvestmentReason AS InvestmentReason,
  I_FixedAsset.AssetIsRealEstate AS AssetIsRealEstate,
  I_FixedAsset.AreaSizeUnit AS AreaSizeUnit,
  I_FixedAsset.InvestmentOrder AS InvestmentOrder,
  I_FixedAsset.InvestmentProjectWBSElement_2 AS InvestmentProjectWBSElement_2,
  I_FixedAsset.InvestmentProjectWBSElement AS InvestmentProjectWBSElement,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  I_FixedAsset.InventoryIsCounted AS InventoryIsCounted,
  I_FixedAsset.LastInventoryDate AS LastInventoryDate,
  I_FixedAsset.AssetSynchronizationRule AS AssetSynchronizationRule,
  I_FixedAsset.OriginalAcquisitionFiscalYear AS OriginalAcquisitionFiscalYear,
  I_FixedAsset.AssetTypeName AS AssetTypeName,
  I_FixedAsset.Supplier AS Supplier,
  I_FixedAsset.AssetCountryOfOrigin AS AssetCountryOfOrigin,
  I_FixedAsset.NoticeOfAssessmentTaxID AS NoticeOfAssessmentTaxID,
  I_FixedAsset.LastAssessmentNoticeDate AS LastAssessmentNoticeDate,
  I_FixedAsset.EnvrnmtlInvestmentReason AS EnvrnmtlInvestmentReason,
  I_FixedAsset.AcquisitionValueDate AS AcquisitionValueDate,
  I_FixedAsset.CreationDate AS CreationDate,
  I_FixedAsset.CreatedByUser AS CreatedByUser,
  case when I_FixedAsset.LastChangeDate = '' then cast('00000000' as fis_aedat_anla) else I_FixedAsset.LastChangeDate end as LastChangeDate AS LastChangeDateendasLastChangeDate,
  I_FixedAsset.LastChangedByUser AS LastChangedByUser,
  I_FixedAsset.AssetStatusAtPurchase AS AssetStatusAtPurchase
FROM I_FixedAsset
LEFT OUTER JOIN I_FixedAssetAssgmtTP AS _FixedAssetAssgmt ON CompanyCode = _FixedAssetAssgmt.CompanyCode AND MasterFixedAsset = _FixedAssetAssgmt.MasterFixedAsset AND FixedAsset = _FixedAssetAssgmt.FixedAsset  -- association [1..*]
LEFT OUTER JOIN I_FixedAssetDeprAreaTP AS _FixedAssetDeprArea ON CompanyCode = _FixedAssetDeprArea.CompanyCode AND MasterFixedAsset = _FixedAssetDeprArea.MasterFixedAsset AND FixedAsset = _FixedAssetDeprArea.FixedAsset  -- association [1..*]
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_CompanyCode AS _CompanyCodeForEdit ON CompanyCodeForEdit = _CompanyCodeForEdit.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAssetForEdit ON CompanyCodeForEdit = _MasterFixedAssetForEdit.CompanyCode AND MasterFixedAssetForEdit = _MasterFixedAssetForEdit.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_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 _WBSElement ON InvestmentProjectWBSElement_2 = _WBSElement.WBSElementInternalID  -- 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]
;