R_FixedAssetTP

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 R_FixedAssetTP.
-- 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 R_FixedAssetTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  cast('FixedAsset' as abap.char( 30 )) AS SAPObjectNodeType,
  FixedAssetExternalID,
  AssetCompletenessStatus,
  AssetLifecycleStatus,
  AssetUnderConstructionStatus,
  IsMainAsset,
  HasHistory,
  AccountIsBlockedForPosting,
  AssetIsForPostCapitalization,
  AssetCreationValidityDate,
  AssetClass,
  AssetScreenLayout,
  AssetAccountDetermination,
  FixedAssetDescription,
  AssetAdditionalDescription,
  AssetSerialNumber,
  FixedAssetOrderDate,
  BaseUnit,
  Supplier,
  AssetIsAcquiredUsed,
  AssetCountryOfOrigin,
  AssetManufacturerName,
  OriginalMasterFixedAsset,
  OriginalFixedAsset,
  OriginalFixedAssetValueDate,
  OriginalAcquisitionFiscalYear,
  OriginalAcquisitionCurrency,
  OriginalAcquisitionAmount,
  InHouseProdnPercent,
  AssetTypeName,
  PartnerCompany,
  Inventory,
  LastInventoryDate,
  InventoryNote,
  InventoryIsCounted,
  InvestmentReason,
  EnvrnmtlInvestmentReason,
  FixedAssetGroup,
  LocalTaxOffice,
  NoticeOfAssessmentTaxID,
  LastAssessmentNoticeDate,
  Municipality,
  LandRegisterDate,
  LandRegisterEntrySequence,
  LandRegisterEntryDate,
  LandRegisterVolume,
  LandRegisterPage,
  LandRegisterMap,
  LandPlot,
  ConveyanceDate,
  AreaSize,
  AreaSizeUnit,
  AssetIsRealEstate,
  LeaseSupplier,
  LeaseAgreement,
  LeaseAgreementDate,
  LeaseTermEndDate,
  LeaseTermStartDate,
  LeaseDurationInFiscalYears,
  LeaseDurationInFiscalPeriods,
  LeaseType,
  LeasedAssetNote,
  PropertyClass,
  FixedAssetPropertyType,
  LastReorganizationDate,
  LegacyMasterFixedAsset,
  LegacyFixedAsset,
  LegacyFixedAssetCompanyCode,
  LegacyDataTransferDate,
  LegacyDataTransferSequence,
  ObjectInternalID,
  InvestmentProjectWBSElement_2 AS InvestmentProjectWBSElement,
  InvestmentOrder,
  CreatedByUser,
  CreationDate,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeDateTime,
  cast (cast('' as abap.char(2)) as faa_md_caller_code preserving type ) AS FixedAssetCallerCode,
  cast( '' as abap_boolean preserving type ) AS IsChanged,
  cast( '' as abap_boolean preserving type ) AS FxdAstIsRecalculateTriggered,
  cast( '' as abap_boolean preserving type ) AS FxdAstIsTimeRstrcnTriggered,
  cast( '' as faa_md_multi_creation_status preserving type ) AS AssetMultipleCreationStatus,
  cast('' as xafar) AS DepreciationErrorStatus
FROM I_FixedAsset AS FixedAsset
LEFT OUTER JOIN E_FixedAsset AS _Extension ON CompanyCode = _Extension.CompanyCode AND MasterFixedAsset = _Extension.MasterFixedAsset AND FixedAsset = _Extension.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_PPM_ProjectTask AS _InvestmentProject ON InvestmentProjectWBSElement = _InvestmentProject.WBSElementInternalID AND _InvestmentProject.WBSElementInternalID is not initial  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvestmentProjectWBSElement ON InvestmentProjectWBSElement = _InvestmentProjectWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocument_2 AS _ChangeDocument ON _ChangeDocument.ChangeDocObjectClass = 'FAA_MD' AND _ChangeDocument.ChangeDocObject = ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _UserCreatedBy ON CreatedByUser = _UserCreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserChangedBy ON LastChangedByUser = _UserChangedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_HDMRelationTP AS _HDMRelation ON ChangeDocObject = _HDMRelation.LinkedSAPObjectKey AND SAPObjectNodeType = _HDMRelation.SAPObjectNodeType  -- association [0..*]
LEFT OUTER JOIN R_FixedAssetAssignmentTP AS _FixedAssetAssgmt ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_FixedAssetLedgerTP AS _FixedAssetLedger ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_FixedAssetValuationTP AS _FixedAssetValuation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_FixedAssetMultipleCreationTP AS _FixedAssetMultipleCreation ON /* condition not available in parsed metadata */  -- association [0..*]
;