P_FixedAssetAssgmt

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 P_FixedAssetAssgmt.
-- 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 P_FixedAssetAssgmt AS
SELECT
  anlz.bukrs AS CompanyCode,
  anlz.anln1 AS MasterFixedAsset,
  anlz.anln2 AS FixedAsset,
  anlz.bdatu AS ValidityEndDate,
  tka02.kokrs AS ControllingArea,
  anlz.adatu AS ValidityStartDate,
  anlz.kfzkz AS VehicleLicensePlateNumber,
  anlz.kostl AS CostCenter,
  anlz.werks AS Plant,
  anlz.gsber AS BusinessArea,
  anlz.stort AS AssetLocation,
  anlz.raumn AS Room,
  anlz.lstar AS CostCtrActivityType,
  anlz.caufn AS InternalOrder,
  anlz.xstil AS IsShutDown,
  anlz.kostlv AS ResponsibleCostCenter,
  anlz.pernr AS PersonnelNumber,
  anlz.iaufn AS MaintenanceOrder,
  anlz.txjcd AS TaxJurisdiction,
  anlz.geber AS Fund,
  anlz.ps_psp_pnr2 AS WBSElementInternalID,
  cast(anlz.ps_psp_pnr2 as fis_wbsint_no_conv preserving type) AS WBSElementInternalID_2,
  cast(anlz.imkey as recaimkeyfi preserving type) AS REInternalFinNumber,
  cast(anlz.imkey as faa_deprecated_real_estate_obj preserving type) AS RealEstateObject,
  anlz.prctr AS ProfitCenter,
  anlz.segment AS Segment,
  anlz.fkber AS FunctionalArea,
  anlz.msfak AS ShiftOperationFactor,
  anlz.grant_nbr AS GrantID,
  anlz.budget_pd AS BudgetPeriod,
  anlz.fistl AS FundsCenter,
  anlz.tplnr AS FunctionalLocation,
  cast('' as bupla) AS BusinessPlace,
  cast('CLASSIC' as faa_authcntxt) AS AssetAuthorizationContext,
  cast('' as awtyp) AS ReferenceDocumentType,
  cast('' as awsys) AS LogicalSystem,
  cast('' as aworg) AS ReferenceDocumentContext,
  cast('' as awref) as ReferenceDocument AS comp_codeasCompanyCode,
  faat_md_tdd.awref AS ReferenceDocument
FROM anlz
INNER JOIN P_TF_AssetRedesignSwitchStatus ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): faat_md_tdd
;