I_FixedAssetAssgmtTP

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_FixedAssetAssgmtTP.
-- 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_FixedAssetAssgmtTP AS
SELECT
  I_FixedAssetAssgmt.CompanyCode AS CompanyCode,
  I_FixedAssetAssgmt.MasterFixedAsset AS MasterFixedAsset,
  I_FixedAssetAssgmt.FixedAsset AS FixedAsset,
  I_FixedAssetAssgmt.ValidityEndDate AS ValidityEndDate,
  I_FixedAssetAssgmt.ValidityStartDate AS ValidityStartDate,
  I_FixedAssetAssgmt.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  I_FixedAssetAssgmt.CostCenter AS CostCenter,
  _CostCenter[1:CostCenter = CostCenter and ControllingArea = ControllingArea and ValidityStartDate >= ValidityStartDate and ValidityEndDate <= ValidityEndDate]._Text[1: Language = $session.system_language].CostCenterName AS CostCenterName,
  I_FixedAssetAssgmt.Plant AS Plant,
  I_FixedAssetAssgmt.BusinessArea AS BusinessArea,
  I_FixedAssetAssgmt.AssetLocation AS AssetLocation,
  I_FixedAssetAssgmt.Room AS Room,
  I_FixedAssetAssgmt.CostCtrActivityType AS CostCtrActivityType,
  I_FixedAssetAssgmt.InternalOrder AS InternalOrder,
  I_FixedAssetAssgmt.IsShutDown AS IsShutDown,
  I_FixedAssetAssgmt.ResponsibleCostCenter AS ResponsibleCostCenter,
  I_FixedAssetAssgmt.PersonnelNumber AS PersonnelNumber,
  I_FixedAssetAssgmt.MaintenanceOrder AS MaintenanceOrder,
  I_FixedAssetAssgmt.TaxJurisdiction AS TaxJurisdiction,
  I_FixedAssetAssgmt.Fund AS Fund,
  I_FixedAssetAssgmt.WBSElementInternalID AS WBSElementInternalID,
  I_FixedAssetAssgmt.WBSElementInternalID_2 AS WBSElementInternalID_2,
  _WBSElement.WBSElementExternalID AS AssetWBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  cast(I_FixedAssetAssgmt.REInternalFinNumber as imkey) AS RealEstateObject,
  I_FixedAssetAssgmt.ProfitCenter AS ProfitCenter,
  I_FixedAssetAssgmt.Segment AS Segment,
  I_FixedAssetAssgmt.FunctionalArea AS FunctionalArea,
  I_FixedAssetAssgmt.ShiftOperationFactor AS ShiftOperationFactor,
  I_FixedAssetAssgmt.GrantID AS GrantID,
  I_FixedAssetAssgmt.BudgetPeriod AS BudgetPeriod,
  I_FixedAssetAssgmt.FundsCenter AS FundsCenter,
  I_FixedAssetAssgmt.ControllingArea AS ControllingArea,
  I_FixedAssetAssgmt._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure
FROM I_FixedAssetAssgmt
LEFT OUTER JOIN I_FixedAssetTP AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND ValidityStartDate <= _CostCenter.ValidityEndDate AND ValidityStartDate >= _CostCenter.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _ResponsibleCostCenter ON ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter AND ControllingArea = _ResponsibleCostCenter.ControllingArea AND ValidityStartDate <= _ResponsibleCostCenter.ValidityEndDate AND ValidityStartDate >= _ResponsibleCostCenter.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActivityType ON CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType AND ControllingArea = _CostCenterActivityType.ControllingArea AND ValidityStartDate <= _CostCenterActivityType.ValidityEndDate AND ValidityStartDate >= _CostCenterActivityType.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND ValidityStartDate <= _ProfitCenter.ValidityEndDate AND ValidityStartDate >= _ProfitCenter.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_TaxJurisCalcProcedure AS _TaxJurisdictionCalcProcedure ON taxcalculationprocedure = _TaxJurisdictionCalcProcedure.TaxJurisdictionCalcProcedure  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction AND taxcalculationprocedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID_2 = _WBSElement.WBSElementInternalID  -- association [0..1]
;