P_JP_FixedAsset

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_JP_FixedAsset.
-- 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.
-- SQL view name: PJPFIXASSET
-- Parameters: p_switchstatus : char03, p_ledger : fins_ledger, p_validfrom : bdatu, p_DepArea : afabe_d

CREATE VIEW P_JP_FixedAsset AS
SELECT
  MAIN.CompanyCode AS CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetClass,
  FixedAssetDescription,
  AssetAccountDetermination,
  AssetStatusAtPurchase,
  MAIN.IsLineItemSettled AS IsLineItemSettled,
  case :p_switchstatus when 'OFF' then Quantity else QTY.Quantity end as Quantity AS QuantityendasQuantity,
  BaseUnit,
  _FixedAssetAssgmt.BusinessArea AS BusinessArea,
  _FixedAssetAssgmt.CostCenter AS CostCenter,
  _FixedAssetAssgmt.Plant AS Plant,
  LDG.AssetCapitalizationDate AS AssetCapitalizationDate,
  LDG.AssetDeactivationDate AS AssetDeactivationDate,
  LDG.AcquisitionValueDate AS AcquisitionValueDate,
  AVL.ValidityStartDate AS ValidityStartDate,
  AVL.ValidityEndDate AS ValidityEndDate,
  AVL.DepreciationStartDate AS DepreciationStartDate,
  AVL.AssetRealDepreciationArea AS AssetRealDepreciationArea,
  AVL.DepreciationKey AS DepreciationKey,
  AVL.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  AVL.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods
LEFT OUTER JOIN I_AssetValuationForLedger AS AVL ON MAIN.CompanyCode = AVL.CompanyCode AND MAIN.MasterFixedAsset = AVL.MasterFixedAsset AND MAIN.FixedAsset = AVL.FixedAsset AND AVL.Ledger = :p_ledger AND AVL.AssetRealDepreciationArea = :p_DepArea AND AVL.ValidityEndDate >= :p_validfrom AND AVL.ValidityStartDate <= :p_validfrom  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetForLedger AS LDG ON MAIN.CompanyCode = LDG.CompanyCode AND MAIN.MasterFixedAsset = LDG.MasterFixedAsset AND MAIN.FixedAsset = LDG.FixedAsset AND LDG.Ledger = :p_ledger  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetCountryData AS CountryData ON MAIN.CompanyCode = CountryData.CompanyCode AND MAIN.MasterFixedAsset = CountryData.MasterFixedAsset AND MAIN.FixedAsset = CountryData.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_FixedAssetAssgmt AS _FixedAssetAssgmt ON MAIN.CompanyCode = _FixedAssetAssgmt.CompanyCode AND MAIN.MasterFixedAsset = _FixedAssetAssgmt.MasterFixedAsset AND MAIN.FixedAsset = _FixedAssetAssgmt.FixedAsset AND _FixedAssetAssgmt.ValidityStartDate <= :p_validfrom AND _FixedAssetAssgmt.ValidityEndDate >= :p_validfrom  -- association [0..1]
LEFT OUTER JOIN P_JP_AssetQuantity AS QTY ON MAIN.CompanyCode = QTY.CompanyCode AND MAIN.MasterFixedAsset = QTY.MasterFixedAsset AND MAIN.FixedAsset = QTY.FixedAsset AND QTY.Ledger = :p_ledger  -- association [0..1]
;