C_FixedAssetMaintain

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_FixedAssetMaintain.
-- 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 C_FixedAssetMaintain AS
SELECT
  Asset_Bo.CompanyCode AS CompanyCode,
  Asset_Bo.MasterFixedAsset AS MasterFixedAsset,
  Asset_Bo.FixedAsset AS FixedAsset,
  Asset_Bo.AssetClass AS AssetClass,
  Asset_Bo.CompanyCodeForEdit AS CompanyCodeForEdit,
  Asset_Bo.AssetSerialNumber AS AssetSerialNumber,
  Asset_Bo.Quantity AS Quantity,
  Asset_Bo.BaseUnit AS BaseUnit,
  Asset_Bo.Inventory AS Inventory,
  Asset_Bo.FixedAssetDescription AS FixedAssetDescription,
  Asset_Bo.FixedAssetExternalID AS FixedAssetExternalID,
  Asset_Bo.AssetAdditionalDescription AS AssetAdditionalDescription,
  Asset_Bo.Currency AS Currency,
  Asset_Bo.OriglAcqnAmtInCoCodeCrcy AS OriglAcqnAmtInCoCodeCrcy,
  Asset_Bo.PartnerCompany AS PartnerCompany,
  Asset_Bo.AssetManufacturerName AS AssetManufacturerName,
  Asset_Bo.InHouseProdnPercent AS InHouseProdnPercent,
  Asset_Bo.InventoryNote AS InventoryNote,
  Asset_Bo.Group1AssetEvaluationKey AS Group1AssetEvaluationKey,
  Asset_Bo.Group2AssetEvaluationKey AS Group2AssetEvaluationKey,
  Asset_Bo.Group3AssetEvaluationKey AS Group3AssetEvaluationKey,
  Asset_Bo.Group4AssetEvaluationKey AS Group4AssetEvaluationKey,
  Asset_Bo.Group5AssetEvaluationKey AS Group5AssetEvaluationKey,
  Asset_Bo.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  Asset_Bo.AssetAccountDetermination AS AssetAccountDetermination,
  Asset_Bo.HasHistory AS HasHistory,
  Asset_Bo.AssetCapitalizationDate AS AssetCapitalizationDate,
  Asset_Bo.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  Asset_Bo.FirstAcquisitionFiscalPeriod AS FirstAcquisitionFiscalPeriod,
  Asset_Bo.AssetDeactivationDate AS AssetDeactivationDate,
  Asset_Bo.PlannedRetirementDate AS PlannedRetirementDate,
  Asset_Bo.FixedAssetOrderDate AS FixedAssetOrderDate,
  Asset_Bo.OriginalMasterFixedAsset AS OriginalMasterFixedAsset,
  Asset_Bo.OriginalFixedAsset AS OriginalFixedAsset,
  Asset_Bo.OriginalFixedAssetValueDate AS OriginalFixedAssetValueDate,
  Asset_Bo.FixedAssetGroup AS FixedAssetGroup,
  Asset_Bo.InvestmentReason AS InvestmentReason,
  Asset_Bo.AssetIsRealEstate AS AssetIsRealEstate,
  Asset_Bo.AreaSizeUnit AS AreaSizeUnit,
  Asset_Bo.InvestmentOrder AS InvestmentOrder,
  Asset_Bo.InvestmentProjectWBSElement AS InvestmentProjectWBSElement,
  Asset_Bo.InvestmentProjectWBSElement_2 AS InvestmentProjectWBSElement_2,
  Asset_Bo.WBSElementExternalID AS WBSElementExternalID,
  Asset_Bo.WBSDescription AS WBSDescription,
  Asset_Bo.InventoryIsCounted AS InventoryIsCounted,
  Asset_Bo.LastInventoryDate AS LastInventoryDate,
  Asset_Bo.AssetSynchronizationRule AS AssetSynchronizationRule,
  Asset_Bo.OriginalAcquisitionFiscalYear AS OriginalAcquisitionFiscalYear,
  Asset_Bo.AssetTypeName AS AssetTypeName,
  Asset_Bo.Supplier AS Supplier,
  Asset_Bo.AssetSupplierName AS AssetSupplierName,
  Asset_Bo.AssetCountryOfOrigin AS AssetCountryOfOrigin,
  Asset_Bo.NoticeOfAssessmentTaxID AS NoticeOfAssessmentTaxID,
  Asset_Bo.LastAssessmentNoticeDate AS LastAssessmentNoticeDate,
  Asset_Bo.EnvrnmtlInvestmentReason AS EnvrnmtlInvestmentReason,
  Asset_Bo.AcquisitionValueDate AS AcquisitionValueDate,
  Asset_Bo.AssetStatusAtPurchase AS AssetStatusAtPurchase,
  cast('' as boolean preserving type ) AS InvmtSupportMeasureIsVisible,
  cast('' as boolean preserving type ) AS EquipmentIsVisible,
  cast('' as boolean preserving type ) AS UserHasAssetChangeAuthzn,
  cast('' as boolean preserving type ) AS AllocationsIsVisible,
  _AssetStatusAtPurchaseText.AssetStatusAtPurchaseName AS AssetStatusAtPurchaseName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _AssetClassText.AssetClassName AS AssetClassName,
  _AssetAcctDeterminationText.AssetAccountDeterminationDesc AS AssetAccountDeterminationDesc,
  _AssetCountryOfOriginText.CountryName AS AssetCountryOfOriginName,
  _PartnerCompany.CompanyName AS PartnerCompanyName,
  _Group1AssetEvaluationKeyText.AssetEvaluationKeyName AS Group1AssetEvaluationKeyName,
  _Group2AssetEvaluationKeyText.AssetEvaluationKeyName AS Group2AssetEvaluationKeyName,
  _Group3AssetEvaluationKeyText.AssetEvaluationKeyName AS Group3AssetEvaluationKeyName,
  _Group4AssetEvaluationKeyText.AssetEvaluationKeyName AS Group4AssetEvaluationKeyName,
  _Group5AssetEvaluationKeyText.Group5AssetEvaluationKeyName AS Group5AssetEvaluationKeyName,
  _InvestmentReasonText.InvestmentReasonName AS InvestmentReasonName,
  _FixedAssetGroupText.FixedAssetGroupName AS FixedAssetGroupName,
  Asset_Bo.CreationDate AS CreationDate,
  Asset_Bo.CreatedByUser AS CreatedByUser,
  Asset_Bo.LastChangeDate AS LastChangeDate,
  Asset_Bo.LastChangedByUser AS LastChangedByUser
FROM I_FixedAssetTP AS Asset_Bo
LEFT OUTER JOIN C_FixedAssetAssgmtMaintain AS _FixedAssetAssgmt ON CompanyCode = _FixedAssetAssgmt.CompanyCode AND MasterFixedAsset = _FixedAssetAssgmt.MasterFixedAsset AND FixedAsset = _FixedAssetAssgmt.FixedAsset  -- association [1..*]
LEFT OUTER JOIN C_FxdAstAssgmtCurrentMntn AS _FixedAssetAssgmtCurrent ON CompanyCode = _FixedAssetAssgmtCurrent.CompanyCode AND MasterFixedAsset = _FixedAssetAssgmtCurrent.MasterFixedAsset AND FixedAsset = _FixedAssetAssgmtCurrent.FixedAsset  -- association [1..*]
LEFT OUTER JOIN C_FixedAssetDeprAreaMaintain AS _FixedAssetDeprArea ON CompanyCode = _FixedAssetDeprArea.CompanyCode AND MasterFixedAsset = _FixedAssetDeprArea.MasterFixedAsset AND FixedAsset = _FixedAssetDeprArea.FixedAsset  -- association [1..*]
LEFT OUTER JOIN C_FxdAstDeprAreaCurrentMntn AS _FixedAssetDeprAreaCurrent ON CompanyCode = _FixedAssetDeprAreaCurrent.CompanyCode AND MasterFixedAsset = _FixedAssetDeprAreaCurrent.MasterFixedAsset AND FixedAsset = _FixedAssetDeprAreaCurrent.FixedAsset  -- association [1..*]
LEFT OUTER JOIN C_FixedAssetInvmtSuppMsrMntn AS _FixedAssetInvmtSuppMsr ON CompanyCode = _FixedAssetInvmtSuppMsr.CompanyCode AND MasterFixedAsset = _FixedAssetInvmtSuppMsr.MasterFixedAsset AND FixedAsset = _FixedAssetInvmtSuppMsr.FixedAsset  -- association [0..*]
LEFT OUTER JOIN C_FixedAssetEquipmentMaintain AS _FixedAssetEquipment ON CompanyCode = _FixedAssetEquipment.CompanyCode AND MasterFixedAsset = _FixedAssetEquipment.MasterFixedAsset AND FixedAsset = _FixedAssetEquipment.FixedAsset  -- association [0..*]
LEFT OUTER JOIN C_FixedAssetNote AS _Note ON CompanyCode = _Note.CompanyCode AND MasterFixedAsset = _Note.MasterFixedAsset AND FixedAsset = _Note.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_AssetStatusAtPurchaseText AS _AssetStatusAtPurchaseText ON Asset_Bo.AssetStatusAtPurchase = _AssetStatusAtPurchaseText.AssetStatusAtPurchase AND _AssetStatusAtPurchaseText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AssetClassText AS _AssetClassText ON Asset_Bo.AssetClass = _AssetClassText.AssetClass AND _AssetClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AssetAcctDeterminationText AS _AssetAcctDeterminationText ON Asset_Bo.AssetAccountDetermination = _AssetAcctDeterminationText.AssetAccountDetermination AND _AssetAcctDeterminationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _AssetCountryOfOriginText ON AssetCountryOfOrigin = _AssetCountryOfOriginText.Country AND _AssetCountryOfOriginText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Group1AssetEvaluationKeyText AS _Group1AssetEvaluationKeyText ON Asset_Bo.Group1AssetEvaluationKey = _Group1AssetEvaluationKeyText.Group1AssetEvaluationKey AND _Group1AssetEvaluationKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Group2AssetEvaluationKeyText AS _Group2AssetEvaluationKeyText ON Asset_Bo.Group2AssetEvaluationKey = _Group2AssetEvaluationKeyText.Group2AssetEvaluationKey AND _Group2AssetEvaluationKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Group3AssetEvaluationKeyText AS _Group3AssetEvaluationKeyText ON Asset_Bo.Group3AssetEvaluationKey = _Group3AssetEvaluationKeyText.Group3AssetEvaluationKey AND _Group3AssetEvaluationKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Group4AssetEvaluationKeyText AS _Group4AssetEvaluationKeyText ON Asset_Bo.Group4AssetEvaluationKey = _Group4AssetEvaluationKeyText.Group4AssetEvaluationKey AND _Group4AssetEvaluationKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Group5AssetEvaluationKeyText AS _Group5AssetEvaluationKeyText ON Asset_Bo.Group5AssetEvaluationKey = _Group5AssetEvaluationKeyText.Group5AssetEvaluationKey AND _Group5AssetEvaluationKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InvestmentReasonText AS _InvestmentReasonText ON Asset_Bo.InvestmentReason = _InvestmentReasonText.InvestmentReason AND _InvestmentReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetGroupText AS _FixedAssetGroupText ON Asset_Bo.FixedAssetGroup = _FixedAssetGroupText.FixedAssetGroup AND _FixedAssetGroupText.Language = $session.system_language  -- association [0..1]
;