I_AssetTP

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 I_AssetTP.
-- 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: IASSETTP

CREATE VIEW I_AssetTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  FixedAssetExternalID,
  MasterFixedAsset AS MasterFixedAssetForEdit,
  FixedAsset AS FixedAssetForEdit,
  (concat(concat( rpad( CompanyCode, 4, ' ' ), MasterFixedAsset),FixedAsset)) AS ChangeDocumentUUID,
  AssetCompletenessStatus,
  AssetLifecycleStatus,
  AssetUnderConstructionStatus,
  IsMainAsset,
  HasHistory,
  AccountIsBlockedForPosting,
  AssetIsForPostCapitalization,
  CreatedByUser,
  CreationDate,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeDateTime,
  AssetCreationValidityDate,
  AssetClass,
  AssetScreenLayout,
  AssetAccountDetermination,
  FixedAssetOrderDate,
  FixedAssetDescription,
  AssetAdditionalDescription,
  AssetSerialNumber,
  Inventory,
  Supplier,
  AssetCountryOfOrigin,
  AssetManufacturerName,
  OriginalMasterFixedAsset,
  OriginalFixedAsset,
  OriginalFixedAssetValueDate,
  OriginalAcquisitionFiscalYear,
  InHouseProdnPercent,
  AssetTypeName,
  PartnerCompany,
  OriginalAcquisitionCurrency,
  OriginalAcquisitionAmount,
  LastInventoryDate,
  InventoryNote,
  InvestmentOrder,
  InvestmentProjectWBSElement,
  InventoryIsCounted,
  InvestmentReason,
  EnvrnmtlInvestmentReason,
  FixedAssetGroup,
  PropertyClass,
  FixedAssetPropertyType,
  LocalTaxOffice,
  NoticeOfAssessmentTaxID,
  LastAssessmentNoticeDate,
  Municipality,
  LandRegisterDate,
  LandRegisterEntrySequence,
  LandRegisterEntryDate,
  LandRegisterVolume,
  LandRegisterPage,
  LandRegisterMap,
  LandPlot,
  ConveyanceDate,
  AreaSize,
  AreaSizeUnit,
  LeaseSupplier,
  LeaseAgreement,
  LeaseAgreementDate,
  LeaseTermEndDate,
  LeaseTermStartDate,
  LeaseDurationInFiscalYears,
  LeaseDurationInFiscalPeriods,
  LeaseType,
  LeasedAssetNote,
  AssetIsRealEstate,
  LastReorganizationDate,
  LegacyAsset,
  LegacyMasterFixedAsset,
  LegacyFixedAsset,
  LegacyFixedAssetCompanyCode,
  LegacyDataTransferDate,
  LegacyDataTransferSequence,
  AssetIsAcquiredUsed,
  BaseUnit,
  cast (cast('' as abap.char(2)) as faa_md_caller_code preserving type ) AS FixedAssetCallerCode,
  ObjectInternalID,
  AssetAuthorizationContext,
  cast(cast('' as abap.char(1)) as faa_md_multi_creation_status preserving type ) AS AssetMultipleCreationStatus,
  _GlobAssetTP.Country AS Country,
  _GlobAssetTP.NationalClassification AS NationalClassification,
  _GlobAssetTP._FixedAssetNatlClfnText AS _FixedAssetNatlClfnText,
  _GlobAssetTP.NationalClassificationDesc AS NationalClassificationDesc,
  _GlobAssetTP.TaxDepreciationGroup AS TaxDepreciationGroup,
  _GlobAssetTP._TaxDepreciationGroupText AS _TaxDepreciationGroupText,
  _GlobAssetTP.TaxDepreciationGroupDesc AS TaxDepreciationGroupDesc,
  _GlobAssetTP.RU_LongSerialNumber AS RU_LongSerialNumber,
  _GlobAssetTP.RU_WorkwearMaterial AS RU_WorkwearMaterial,
  _GlobAssetTP.RU_RetiredMasterFixedAsset AS RU_RetiredMasterFixedAsset,
  _GlobAssetTP.RU_RetiredFixedAsset AS RU_RetiredFixedAsset,
  _GlobAssetTP.RU_AssetTransportType AS RU_AssetTransportType,
  _GlobAssetTP.RU_VehicleIdNumber AS RU_VehicleIdNumber,
  _GlobAssetTP.RU_ManufacturingDate AS RU_ManufacturingDate,
  _GlobAssetTP.RU_VehicleEcologicalClass AS RU_VehicleEcologicalClass,
  _GlobAssetTP.RU_PropertyAddress AS RU_PropertyAddress,
  _GlobAssetTP.RU_PropertyOwnershipRegnDate AS RU_PropertyOwnershipRegnDate,
  _GlobAssetTP.RU_PropertyOwnershipTermnDate AS RU_PropertyOwnershipTermnDate,
  _GlobAssetTP.RU_ProdTraceabilityStartDate AS RU_ProdTraceabilityStartDate,
  _GlobAssetTP.RU_ProdTraceabilityEndDate AS RU_ProdTraceabilityEndDate,
  _GlobAssetTP.RU_AssetTNVED AS RU_AssetTNVED,
  _GlobAssetTP.ChartOfAccounts AS ChartOfAccounts,
  _GlobAssetTP.ChartOfAccountsText AS ChartOfAccountsText,
  _GlobAssetTP.GLAccount AS GLAccount,
  _GlobAssetTP.GLAccountText AS GLAccountText,
  _GlobAssetTP.JP_Annex16AssetStructure AS JP_Annex16AssetStructure,
  _GlobAssetTP._JP_Annex16AssetStruc AS _JP_Annex16AssetStruc,
  _GlobAssetTP.JP_Annex16AssetStructureDesc AS JP_Annex16AssetStructureDesc,
  _GlobAssetTP._JP_Annex16AssetItem AS _JP_Annex16AssetItem,
  _GlobAssetTP.JP_Annex16AssetItem AS JP_Annex16AssetItem,
  _GlobAssetTP.JP_Annex16AssetItemDesc AS JP_Annex16AssetItemDesc,
  _GlobAssetTP.JP_Annex16LeasingAgrmtDate AS JP_Annex16LeasingAgrmtDate,
  _GlobAssetTP.JP_PrptyTxRptCity AS JP_PrptyTxRptCity,
  _GlobAssetTP.JP_PrptyTxRptClassfctnKey AS JP_PrptyTxRptClassfctnKey,
  _GlobAssetTP.JP_PrptyTxRptSpclDepr AS JP_PrptyTxRptSpclDepr,
  _GlobAssetTP.JP_PrptyTxRptAddlDepr AS JP_PrptyTxRptAddlDepr,
  _GlobAssetTP.IN_AssetBlock AS IN_AssetBlock,
  _GlobAssetTP.IN_AssetPutToUseDate AS IN_AssetPutToUseDate,
  _GlobAssetTP.IN_AdditionalAssetBlock AS IN_AdditionalAssetBlock,
  _GlobAssetTP.IN_AssetIsResearchAndDev AS IN_AssetIsResearchAndDev,
  _GlobAssetTP.IN_AssetIsPriorYear AS IN_AssetIsPriorYear,
  _GlobAssetTP.PT_VehicleTypeByEnergy AS PT_VehicleTypeByEnergy,
  _GlobAssetTP.PT_VehicleIsWithoutLimit AS PT_VehicleIsWithoutLimit,
  _GlobAssetTP.PT_BigRepairAssetLink AS PT_BigRepairAssetLink,
  _GlobAssetTP.PT_LandAssetLink AS PT_LandAssetLink,
  _GlobAssetTP.PT_AssetReportFormCategory AS PT_AssetReportFormCategory,
  _GlobAssetTP.PT_AmortizedAssetIsReevaluated AS PT_AmortizedAssetIsReevaluated,
  _GlobAssetTP.RS_GroupDeprExclusionYear AS RS_GroupDeprExclusionYear,
  _GlobAssetTP.RS_AssetLastInvoiceDate AS RS_AssetLastInvoiceDate
FROM I_FixedAsset AS FixedAsset
LEFT OUTER JOIN I_AssetAssignmentTP AS _AssetAssignmentTP ON CompanyCode = _AssetAssignmentTP.CompanyCode AND MasterFixedAsset = _AssetAssignmentTP.MasterFixedAsset AND FixedAsset = _AssetAssignmentTP.FixedAsset  -- association [1..*]
LEFT OUTER JOIN I_AssetLedgerTP AS _AssetLedgerTP ON CompanyCode = _AssetLedgerTP.CompanyCode AND MasterFixedAsset = _AssetLedgerTP.MasterFixedAsset AND FixedAsset = _AssetLedgerTP.FixedAsset  -- association [1..*]
LEFT OUTER JOIN I_AssetValuationTP AS _AssetValuationTP ON CompanyCode = _AssetValuationTP.CompanyCode AND MasterFixedAsset = _AssetValuationTP.MasterFixedAsset AND FixedAsset = _AssetValuationTP.FixedAsset  -- association [1..*]
LEFT OUTER JOIN I_GlobAssetTP AS _GlobAssetTP ON CompanyCode = _GlobAssetTP.CompanyCode AND MasterFixedAsset = _GlobAssetTP.MasterFixedAsset AND FixedAsset = _GlobAssetTP.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_GlobAssetAssignmentTP AS _GlobAssetAssignmentTP ON CompanyCode = _GlobAssetAssignmentTP.CompanyCode AND MasterFixedAsset = _GlobAssetAssignmentTP.MasterFixedAsset AND FixedAsset = _GlobAssetAssignmentTP.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_GlobAssetPreciousMaterialsTP AS _GlobAssetPreciousMaterialsTP ON CompanyCode = _GlobAssetPreciousMaterialsTP.CompanyCode AND MasterFixedAsset = _GlobAssetPreciousMaterialsTP.MasterFixedAsset AND FixedAsset = _GlobAssetPreciousMaterialsTP.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvestmentProjectWBSElement ON InvestmentProjectWBSElement = _InvestmentProjectWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_AssetMultipleCreationTP AS _AssetMultipleCreationTP ON CompanyCode = _AssetMultipleCreationTP.CompanyCode AND MasterFixedAsset = _AssetMultipleCreationTP.MasterFixedAsset AND FixedAsset = _AssetMultipleCreationTP.FixedAsset  -- association [0..*]
LEFT OUTER JOIN E_FixedAsset AS _Extension ON CompanyCode = _Extension.CompanyCode AND MasterFixedAsset = _Extension.MasterFixedAsset AND FixedAsset = _Extension.FixedAsset  -- association [1..1]
;