C_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 C_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: CASSETTP

CREATE VIEW C_AssetTP AS
SELECT
  AssetTP.CompanyCode AS CompanyCode,
  AssetTP.MasterFixedAsset AS MasterFixedAsset,
  AssetTP.FixedAsset AS FixedAsset,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  MasterFixedAssetForEdit,
  FixedAssetForEdit,
  cast ( MasterFixedAsset as faa_md_asset_no_from_ldt preserving type) AS MasterFixedAssetFrmLegacySyst,
  cast (FixedAsset as faa_md_asset_subno_from_ldt preserving type ) AS FixedAssetFrmLegacySyst,
  FixedAssetExternalID,
  ChangeDocumentUUID,
  AssetCompletenessStatus,
  cast (cast ( '' as abap.char(60) ) as faa_md_compl_status_text preserving type) AS AssetCompletenessStatusName,
  AssetLifecycleStatus,
  cast (cast ( '' as abap.char(60) ) as faa_md_lc_status_text preserving type) AS AssetLifecycleStatusName,
  AssetUnderConstructionStatus,
  cast (cast ( '' as abap.char(60) ) as faa_md_auc_status_text preserving type) AS AssetUndrConstructionStsName,
  IsMainAsset,
  HasHistory,
  AccountIsBlockedForPosting,
  IsLegacyAsset,
  AssetIsForPostCapitalization,
  CreatedByUser,
  CreationDate,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeDateTime,
  AssetCreationValidityDate,
  AssetClass,
  _AssetClass._Text[1:Language=$session.system_language].AssetClassName AS AssetClassName,
  AssetScreenLayout,
  AssetAccountDetermination,
  cast ( cast ('' as abap.char(50))as ktgrtx preserving type) AS AssetAccountDeterminationDesc,
  FixedAssetOrderDate,
  FixedAssetDescription,
  AssetAdditionalDescription,
  AssetSerialNumber,
  Inventory,
  Supplier,
  cast ( cast ('' as abap.char(80))as md_supplier_name preserving type) AS SupplierName,
  AssetCountryOfOrigin,
  AssetManufacturerName,
  OriginalMasterFixedAsset,
  OriginalFixedAsset,
  OriginalFixedAssetValueDate,
  OriginalAcquisitionFiscalYear,
  OriginalAcquisitionAmount,
  OriginalAcquisitionCurrency,
  InHouseProdnPercent,
  AssetTypeName,
  PartnerCompany,
  cast ( cast ('' as abap.char(30))as name_1 preserving type) AS PartnerCompanyName,
  InvestmentOrder,
  InvestmentProjectWBSElement,
  cast('' as faa_md_invmt_proj_wbs_ext_id) AS InvmtProjWBSElementExternalID,
  cast('' as ps_s4_post1) AS WBSDescription,
  cast('' as abap.char(32)) AS ProjectSummaryTaskUUIDString,
  LastInventoryDate,
  InventoryNote,
  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,
  LegacyMasterFixedAsset,
  LegacyFixedAsset,
  LegacyFixedAssetCompanyCode,
  LegacyDataTransferDate,
  LegacyDataTransferSequence,
  AssetIsAcquiredUsed,
  BaseUnit,
  cast ( cast ('' as abap.char(10))as mseht preserving type) AS BaseUnitName,
  AssetTP.AssetAuthorizationContext AS AssetAuthorizationContext,
  cast('' as xafar) AS DepreciationErrorStatus,
  cast('' as kostl) AS CostCenter,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  cast('' as ps_posid_edit) AS WBSElementExternalID,
  cast('' as prctr) AS ProfitCenter,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  cast('' as fb_segment) AS Segment,
  AssetMultipleCreationStatus,
  Country,
  NationalClassification,
  cast ( cast ('' as abap.char(50))as glo_natl_clfn_code_text preserving type) AS NationalClassificationDesc,
  TaxDepreciationGroup,
  cast ( cast ('' as abap.char(30))as glo_tax_depr_grp_desc preserving type) AS TaxDepreciationGroupDesc,
  RU_LongSerialNumber,
  RU_WorkwearMaterial,
  RU_RetiredMasterFixedAsset,
  RU_RetiredFixedAsset,
  RU_AssetTransportType,
  RU_VehicleIdNumber,
  RU_ManufacturingDate,
  RU_VehicleEcologicalClass,
  RU_PropertyAddress,
  RU_PropertyOwnershipRegnDate,
  RU_PropertyOwnershipTermnDate,
  RU_ProdTraceabilityStartDate,
  RU_ProdTraceabilityEndDate,
  RU_AssetTNVED,
  ChartOfAccounts,
  ChartOfAccountsText,
  GLAccount,
  GLAccountText,
  JP_Annex16AssetStructure,
  cast ( cast ('' as abap.char(50))as glo_anx16_strc_text preserving type) AS JP_Annex16AssetStructureDesc,
  JP_Annex16AssetItem,
  cast ( cast ('' as abap.char(50))as glo_anx16_item_text preserving type) AS JP_Annex16AssetItemDesc,
  JP_Annex16LeasingAgrmtDate,
  JP_PrptyTxRptCity,
  JP_PrptyTxRptClassfctnKey,
  JP_PrptyTxRptSpclDepr,
  JP_PrptyTxRptAddlDepr,
  IN_AssetBlock,
  IN_AssetPutToUseDate,
  IN_AdditionalAssetBlock,
  IN_AssetIsResearchAndDev,
  IN_AssetIsPriorYear,
  PT_VehicleTypeByEnergy,
  PT_VehicleIsWithoutLimit,
  PT_BigRepairAssetLink,
  PT_LandAssetLink,
  PT_AssetReportFormCategory,
  PT_AmortizedAssetIsReevaluated,
  RS_GroupDeprExclusionYear,
  RS_AssetLastInvoiceDate
FROM I_AssetTP AS AssetTP
LEFT OUTER JOIN C_AssetAssignmentTP AS _AssetAssignmentTP ON CompanyCode = _AssetAssignmentTP.CompanyCode AND MasterFixedAsset = _AssetAssignmentTP.MasterFixedAsset AND FixedAsset = _AssetAssignmentTP.FixedAsset  -- association [1..*]
LEFT OUTER JOIN C_AssetLedgerTP AS _AssetLedgerTP ON CompanyCode = _AssetLedgerTP.CompanyCode AND MasterFixedAsset = _AssetLedgerTP.MasterFixedAsset AND FixedAsset = _AssetLedgerTP.FixedAsset  -- association [1..*]
LEFT OUTER JOIN C_AssetValuationTP AS _AssetValuationTP ON CompanyCode = _AssetValuationTP.CompanyCode AND MasterFixedAsset = _AssetValuationTP.MasterFixedAsset AND FixedAsset = _AssetValuationTP.FixedAsset  -- association [1..*]
LEFT OUTER JOIN C_GlobAssetAssignmentTP AS _GlobAssetAssignmentTP ON CompanyCode = _GlobAssetAssignmentTP.CompanyCode AND MasterFixedAsset = _GlobAssetAssignmentTP.MasterFixedAsset AND FixedAsset = _GlobAssetAssignmentTP.FixedAsset  -- association [0..*]
LEFT OUTER JOIN C_GlobAssetPreciousMaterialsTP AS _GlobAssetPreciousMaterialsTP ON CompanyCode = _GlobAssetPreciousMaterialsTP.CompanyCode AND MasterFixedAsset = _GlobAssetPreciousMaterialsTP.MasterFixedAsset AND FixedAsset = _GlobAssetPreciousMaterialsTP.FixedAsset  -- association [0..*]
LEFT OUTER JOIN C_AssetMultipleCreationTP AS _AssetMultipleCreationTP ON CompanyCode = _AssetMultipleCreationTP.CompanyCode AND MasterFixedAsset = _AssetMultipleCreationTP.MasterFixedAsset AND FixedAsset = _AssetMultipleCreationTP.FixedAsset  -- association [0..*]
LEFT OUTER JOIN C_AssetWBSElement AS _InvestmentProjectWBSElement ON InvestmentProjectWBSElement = _InvestmentProjectWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN P_AssetInvestmentProject AS _InvestmentProject ON InvestmentProjectWBSElement = _InvestmentProject.WBSElementInternalID  -- association [0..1]
;