I_FixedAssetWorklist

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_FixedAssetWorklist.
-- 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_FixedAssetWorklist AS
SELECT
  an.MasterFixedAsset AS MasterFixedAsset,
  an.FixedAsset AS FixedAsset,
  an.CompanyCode AS CompanyCode,
  az.ValidityEndDate AS ValidityEndDate,
  LastChangeDate,
  az.ControllingArea AS ControllingArea,
  an.FixedAssetExternalID AS FixedAssetExternalID,
  FixedAssetDescription,
  an.FixedAssetFinDataCmpltns AS FixedAssetFinDataCmpltns,
  InventoryNote,
  InvestmentReason,
  AccountIsMarkedForDeletion,
  an.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  AcquisitionValueDate,
  OriginalFixedAssetValueDate,
  InvestmentProjectWBSElement,
  OriginalAcquisitionFiscalYear,
  AssetUnderConstIsInvmtMsr,
  LastRetirementValueDate,
  LastChangedByUser,
  OriginalMasterFixedAsset,
  OriginalFixedAsset,
  AssetCapitalizationDate,
  an.AssetClass AS AssetClass,
  FixedAssetGroup,
  FixedAssetOrderDate,
  AssetDeactivationDate,
  InvestmentOrder,
  NoticeOfAssessmentTaxID,
  LastAssessmentNoticeDate,
  FixedAssetPropertyType,
  an.CreationDate AS CreationDate,
  an.CreatedByUser AS CreatedByUser,
  AreaSizeUnit,
  Group5AssetEvaluationKey,
  PlannedRetirementDate,
  ManualDepreciationReason,
  AssetManufacturerName,
  InventoryIsCounted,
  Inventory,
  LastInventoryDate,
  AssetAccountDetermination,
  AssetCountryOfOrigin,
  LastReorganizationDate,
  LegacyDataTransferDate,
  an.AssetSupplierName AS AssetSupplierName,
  an.Supplier AS Supplier,
  BaseUnit,
  Quantity,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  AssetSerialNumber,
  AssetTypeName,
  EnvrnmtlInvestmentReason,
  PartnerCompany,
  IsGroupAsset,
  IsLineItemSettled,
  FirstAcquisitionFiscalYear,
  FirstAcquisitionFiscalPeriod,
  az.GrantID AS GrantID,
  az.Room AS Room,
  az.BudgetPeriod AS BudgetPeriod,
  az.ValidityStartDate AS ValidityStartDate,
  az.InternalOrder AS InternalOrder,
  az.FundsCenter AS FundsCenter,
  az.FunctionalArea AS FunctionalArea,
  az.Fund AS Fund,
  az.BusinessArea AS BusinessArea,
  az.MaintenanceOrder AS MaintenanceOrder,
  az.REInternalFinNumber AS RealEstateObject,
  az.WBSElementInternalID_2 AS WBSElementInternalID,
  az.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  az.CostCenter AS CostCenter,
  az.ResponsibleCostCenter AS ResponsibleCostCenter,
  az.CostCtrActivityType AS CostCtrActivityType,
  az.PersonnelNumber AS PersonnelNumber,
  az.ProfitCenter AS ProfitCenter,
  az.Segment AS Segment,
  az.AssetLocation AS AssetLocation,
  az.FunctionalLocation AS FunctionalLocation,
  az.TaxJurisdiction AS TaxJurisdiction,
  an._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  az.Plant AS Plant,
  az.IsShutDown AS IsShutDown,
  az.ShiftOperationFactor AS ShiftOperationFactor,
  an._CompanyCode AS _CompanyCode,
  an._MasterFixedAsset AS _MasterFixedAsset,
  an._AssetClass AS _AssetClass
FROM I_FixedAsset AS an
INNER JOIN I_FixedAssetAssgmt AS az ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FixedAssetFinDataCmpltns AS _FixedAssetFinDataCmpltns ON an.FixedAssetFinDataCmpltns = _FixedAssetFinDataCmpltns.FixedAssetFinDataCmpltns  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetStatus AS _FixedAssetStatus ON Status = _FixedAssetStatus.Status  -- association [0..1]
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]
;