P_AssetAssignment

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_AssetAssignment.
-- 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: PASSETASSGMT

CREATE VIEW P_AssetAssignment 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.ControllingArea AS ControllingArea,
  I_FixedAssetAssgmt._CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  I_FixedAssetAssgmt.BusinessArea AS BusinessArea,
  cast (cast (''as abap.char(30))as farp_gtext preserving type) AS BusinessAreaName,
  I_FixedAssetAssgmt.CostCenter AS CostCenter,
  cast (cast (''as abap.char(20))as fis_kostl_name preserving type) AS CostCenterName,
  I_FixedAssetAssgmt.CostCtrActivityType AS CostCtrActivityType,
  cast (cast (''as abap.char(20))as ktext preserving type) AS CostCtrActivityTypeName,
  I_FixedAssetAssgmt.InternalOrder AS InternalOrder,
  cast (cast (''as abap.char(40))as fis_internalorder_text preserving type) AS InternalOrderDescription,
  I_FixedAssetAssgmt.Fund AS Fund,
  cast (cast (''as abap.char(20))as fmis_fund_name preserving type) AS FundName,
  I_FixedAssetAssgmt.GrantID AS GrantID,
  cast (cast (''as abap.char(20))as gm_short_description preserving type) AS GrantName,
  I_FixedAssetAssgmt.FunctionalArea AS FunctionalArea,
  cast (cast (''as abap.char(25))as fkbtx preserving type) AS FunctionalAreaName,
  I_FixedAssetAssgmt.FundsCenter AS FundsCenter,
  cast (cast (''as abap.char(20))as fmis_fc_name preserving type) AS FundsCenterName,
  cast (I_FixedAssetAssgmt.WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cast (cast('' as abap.char(24)) as ps_posid_edit preserving type) AS WBSElementExternalID,
  cast (cast (''as abap.char(40))as ps_s4_post1 preserving type) AS WBSElementDescription,
  I_FixedAssetAssgmt.TaxJurisdiction AS TaxJurisdiction,
  I_FixedAssetAssgmt.RealEstateObject AS RealEstateObject,
  I_FixedAssetAssgmt.Segment AS Segment,
  cast (cast (''as abap.char(50))as fis_segment_name preserving type) AS SegmentName,
  I_FixedAssetAssgmt.ProfitCenter AS ProfitCenter,
  cast (cast (''as abap.char(20))as fis_prctr_shorttext preserving type) AS ProfitCenterName,
  I_FixedAssetAssgmt.BudgetPeriod AS BudgetPeriod,
  I_FixedAssetAssgmt.ResponsibleCostCenter AS ResponsibleCostCenter,
  cast (cast (''as abap.char(20))as fis_kostl_name preserving type) AS ResponsibleCostCenterName,
  I_FixedAssetAssgmt.Room AS Room,
  I_FixedAssetAssgmt.Plant AS Plant,
  cast (cast (''as abap.char(30))as werks_name preserving type) AS PlantName,
  I_FixedAssetAssgmt.AssetLocation AS AssetLocation,
  cast (cast (''as abap.char(40))as locationname preserving type) AS AssetLocationName,
  I_FixedAssetAssgmt.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  I_FixedAssetAssgmt.PersonnelNumber AS PersonnelNumber,
  I_FixedAssetAssgmt.BusinessPlace AS BusinessPlace,
  I_FixedAssetAssgmt.ReferenceDocumentType AS ReferenceDocumentType,
  I_FixedAssetAssgmt.LogicalSystem AS LogicalSystem,
  I_FixedAssetAssgmt.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_FixedAssetAssgmt.ReferenceDocument AS ReferenceDocument,
  cast ('' as abap.char(512) ) AS LongText,
  I_FixedAssetAssgmt.AssetAuthorizationContext AS AssetAuthorizationContext,
  I_FixedAssetAssgmt._CompanyCode AS _CompanyCode,
  I_FixedAssetAssgmt._CostCenter AS _CostCenter,
  I_FixedAssetAssgmt._ResponsibleCostCenter AS _ResponsibleCostCenter,
  I_FixedAssetAssgmt._CostCenterActivityType AS _CostCenterActivityType,
  I_FixedAssetAssgmt._Plant AS _Plant,
  I_FixedAssetAssgmt._BusinessArea AS _BusinessArea,
  I_FixedAssetAssgmt._InternalOrder AS _InternalOrder,
  I_FixedAssetAssgmt._ProfitCenter AS _ProfitCenter,
  I_FixedAssetAssgmt._Segment AS _Segment,
  I_FixedAssetAssgmt._FunctionalArea AS _FunctionalArea,
  I_FixedAssetAssgmt._ControllingArea AS _ControllingArea,
  I_FixedAssetAssgmt._AssetLocation AS _AssetLocation,
  I_FixedAssetAssgmt._Employment AS _Employment
FROM I_FixedAssetAssgmt
LEFT OUTER JOIN I_AssetTP AS _AssetTP ON CompanyCode = _AssetTP.CompanyCode AND MasterFixedAsset = _AssetTP.MasterFixedAsset AND FixedAsset = _AssetTP.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _Fund ON Fund = _Fund.Fund AND FinancialManagementArea = _Fund.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FundsCenter = _FundsCenter.FundsCenter AND FinancialManagementArea = _FundsCenter.FinancialManagementArea AND ( ( ValidityEndDate > _FundsCenter.ValidityStartDate AND ValidityEndDate <= _FundsCenter.ValidityEndDate ) OR( ValidityStartDate <= _FundsCenter.ValidityEndDate AND ValidityStartDate >= _FundsCenter.ValidityStartDate ) OR( ValidityEndDate >= _FundsCenter.ValidityEndDate AND ValidityStartDate <= _FundsCenter.ValidityStartDate AND _FundsCenter.ValidityStartDate <= $session.system_date AND _FundsCenter.ValidityEndDate >= $session.system_date ) )  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
;