C_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 C_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.
-- Parameters: P_KeyDate : faa_keydate

CREATE VIEW C_FixedAssetWorklist AS
SELECT
  core.ValidityEndDate AS ValidityEndDate,
  MasterFixedAsset,
  FixedAsset,
  core.CompanyCode AS CompanyCode,
  FixedAssetExternalID,
  FixedAssetDescription,
  core._CompanyCode.CompanyCodeName AS CompanyCodeName,
  $parameters.P_KeyDate AS KeyDate,
  core.ControllingArea AS ControllingArea,
  Status,
  _FixedAssetStatus._Text[1: Language = $session.system_language].StatusName AS StatusName,
  core.FixedAssetFinDataCmpltns AS FixedAssetFinDataCmpltns,
  _FixedAssetFinDataCmpltns._Text[1: Language = $session.system_language].FixedAssetFinDataCmpltnsName AS FixedAssetFinDataCmpltnsName,
  AssetCapitalizationDate,
  Inventory,
  core.CostCenter AS AssetCostCenter,
  AssetClass,
  _AssetClass._Text[1: Language = $session.system_language].AssetClassName AS AssetClassName,
  _AssetClass._Text[1: Language = $session.system_language].AssetClassDescription AS AssetClassDescription,
  LastChangeDate,
  IsCapitalized,
  OriginalFixedAsset,
  LastRetirementValueDate,
  LastChangedByUser,
  OriginalFixedAssetValueDate,
  OriginalMasterFixedAsset,
  FixedAssetGroup,
  FixedAssetOrderDate,
  AssetDeactivationDate,
  InvestmentOrder,
  NoticeOfAssessmentTaxID,
  LastAssessmentNoticeDate,
  FixedAssetPropertyType,
  _FixedAssetPropertyType._Text[1: Language = $session.system_language].FixedAssetPropertyTypeName AS FixedAssetPropertyTypeName,
  CreationDate,
  CreatedByUser,
  AreaSizeUnit,
  PlannedRetirementDate,
  ManualDepreciationReason,
  _ManualDepreciationReason._Text[1: Language = $session.system_language].ManualDepreciationReasonName AS ManualDepreciationReasonName,
  AssetManufacturerName,
  InventoryIsCounted,
  InventoryNote,
  LastInventoryDate,
  InvestmentReason,
  _InvestmentReason._Text[1: Language = $session.system_language].InvestmentReasonName AS InvestmentReasonName,
  AssetAccountDetermination,
  core._AssetAccountDetermination._Text[1: Language = $session.system_language].AssetAccountDeterminationDesc AS AssetAccountDeterminationDesc,
  AssetCountryOfOrigin,
  LastReorganizationDate,
  LegacyDataTransferDate,
  Supplier,
  case Supplier when '' then AssetSupplierName else _Supplier.SupplierName end as AssetSupplierName AS SupplierNameendasAssetSupplierName,
  _Supplier.SupplierName AS SupplierName,
  BaseUnit,
  Quantity,
  Group1AssetEvaluationKey,
  cast (_Group1AssetEvaluationKey._Text[1: Language = $session.system_language].AssetEvaluationKeyName as faa_ordtx1) AS Group1AssetEvaluationKeyName,
  Group2AssetEvaluationKey,
  cast (_Group2AssetEvaluationKey._Text[1: Language = $session.system_language].AssetEvaluationKeyName as faa_ordtx2) AS Group2AssetEvaluationKeyName,
  Group3AssetEvaluationKey,
  cast (_Group3AssetEvaluationKey._Text[1: Language = $session.system_language].AssetEvaluationKeyName as faa_ordtx3) AS Group3AssetEvaluationKeyName,
  Group4AssetEvaluationKey,
  cast (_Group4AssetEvaluationKey._Text[1: Language = $session.system_language].AssetEvaluationKeyName as faa_ordtx4) AS Group4AssetEvaluationKeyName,
  Group5AssetEvaluationKey,
  _Group5AssetEvaluationKey._Text[1: Language = $session.system_language].Group5AssetEvaluationKeyName AS Group5AssetEvaluationKeyName,
  InvestmentProjectWBSElement AS WBSElementInternalID,
  '' AS InvestmentProjectWBSElement,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  AssetSerialNumber,
  AssetTypeName,
  EnvrnmtlInvestmentReason,
  _EnvrnmtlInvestmentReason._Text[1: Language = $session.system_language].EnvironmentInvestmntReasonName AS EnvironmentInvestmntReasonName,
  OriginalAcquisitionFiscalYear,
  PartnerCompany,
  IsGroupAsset,
  AssetUnderConstIsInvmtMsr,
  AccountIsMarkedForDeletion,
  IsLineItemSettled,
  AccountIsBlockedForPosting,
  AcquisitionValueDate,
  FirstAcquisitionFiscalYear,
  FirstAcquisitionFiscalPeriod,
  core.ValidityStartDate AS ValidityStartDate,
  BudgetPeriod AS AssetBudgetPeriod,
  InternalOrder,
  FundsCenter,
  FunctionalArea,
  Fund AS AssetFund,
  GrantID AS AssetGrant,
  core.BusinessArea AS AssetBusinessArea,
  MaintenanceOrder,
  RealEstateObject,
  VehicleLicensePlateNumber,
  ResponsibleCostCenter,
  CostCtrActivityType,
  PersonnelNumber,
  core.ProfitCenter AS AssetProfitCenter,
  Room,
  Segment AS AssetSegment,
  AssetLocation,
  FunctionalLocation,
  _FunctionalLocation._FunctionalLocationText[1: Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  TaxJurisdiction,
  TaxCalculationProcedure,
  cast (_TaxJurisdiction._Text[1: Language = $session.system_language].TaxJurisdictionName as faa_taxjutxt) AS TaxJurisdictionName,
  Plant,
  IsShutDown,
  I_CompanyCodeAsset.ChartOfDepreciation AS ChartOfDepreciation,
  core._CompanyCode AS _CompanyCode,
  core._ControllingArea AS _ControllingArea,
  core._CostCenter AS _CostCenter,
  core._ProfitCenter AS _ProfitCenter,
  core._BusinessArea AS _BusinessArea,
  I_CompanyCodeAsset._ChartOfDepreciation AS _ChartOfDepreciation
FROM I_FixedAssetWorklist AS core
INNER JOIN I_CompanyCodeAsset ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN E_FixedAssetWorklist AS _Extension ON MasterFixedAsset = _Extension.MasterFixedAsset AND FixedAsset = _Extension.FixedAsset AND CompanyCode = _Extension.CompanyCode  -- association [1..1]
LEFT OUTER JOIN E_FixedAsset AS _ExtensionNew ON MasterFixedAsset = _ExtensionNew.MasterFixedAsset AND FixedAsset = _ExtensionNew.FixedAsset AND CompanyCode = _ExtensionNew.CompanyCode  -- association [1..1]
;