C_AssetAssignmentTP

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_AssetAssignmentTP.
-- 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: CASSETASSGMTTP

CREATE VIEW C_AssetAssignmentTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityEndDate,
  ValidityEndDateForEdit,
  ValidityStartDate,
  _FixedAsset.AssetClass AS AssetClass,
  _FixedAsset._AssetClass AS _AssetClass,
  BusinessArea,
  CostCenter,
  CostCtrActivityType,
  InternalOrder,
  Fund,
  GrantID,
  FunctionalArea,
  FundsCenter,
  WBSElementInternalID,
  WBSElementExternalID,
  cast('' as abap.char(32)) AS ProjectSummaryTaskUUIDString,
  TaxJurisdiction,
  RealEstateObject,
  Segment,
  ProfitCenter,
  BudgetPeriod,
  ResponsibleCostCenter,
  Room,
  Plant,
  AssetLocation,
  VehicleLicensePlateNumber,
  PersonnelNumber,
  BusinessPlace,
  ControllingArea,
  FinancialManagementArea,
  LongText,
  cast (cast (''as abap.char(10))as belnr_d preserving type) AS AccountingDocument,
  cast (cast ('' as abap.numc(4))as gjahr preserving type) AS FiscalYear,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  AssetAuthorizationContext
FROM I_AssetAssignmentTP AS AssetAssignmentTP
LEFT OUTER JOIN C_AssetTP AS _AssetTP ON CompanyCode = _AssetTP.CompanyCode AND MasterFixedAsset = _AssetTP.MasterFixedAsset AND FixedAsset = _AssetTP.FixedAsset  -- association [1..1]
LEFT OUTER JOIN P_AssetInvestmentProject AS _Project ON WBSElementInternalID = _Project.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN C_AssetWBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _CostCenterHierarchyLeafNode ON CostCenter = _CostCenterHierarchyLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _CostCenterHierarchyLeafNode.HierarchyNodeClass AND _CostCenterHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _CostCenterHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _CostCenterHierarchyLeafNode.HierarchyType = '0101'  -- association [0..*]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _ProfitCenterHierLeafNode ON ProfitCenter = _ProfitCenterHierLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _ProfitCenterHierLeafNode.HierarchyNodeClass AND _ProfitCenterHierLeafNode.ValidityStartDate <= $session.system_date AND _ProfitCenterHierLeafNode.ValidityEndDate >= $session.system_date AND _ProfitCenterHierLeafNode.HierarchyType = '0106'  -- association [0..*]
;