I_AssetMultipleCreation

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_AssetMultipleCreation.
-- 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: IASTMULTICREATE

CREATE VIEW I_AssetMultipleCreation AS
SELECT
  comp_code AS CompanyCode,
  asset_no AS MasterFixedAsset,
  asset_subno AS FixedAsset,
  row_index AS RowIndex,
  asset_class AS AssetClass,
  gl_account_det AS AssetAccountDetermination,
  description AS FixedAssetDescription,
  add_description AS AssetAdditionalDescription,
  serial_number AS AssetSerialNumber,
  inventory_number AS Inventory,
  supplier_no AS Supplier,
  origin_country AS AssetCountryOfOrigin,
  manufacturer AS AssetManufacturerName,
  original_asset AS OriginalMasterFixedAsset,
  original_subasset AS OriginalFixedAsset,
  original_acq_date AS OriginalFixedAssetValueDate,
  original_acq_year AS OriginalAcquisitionFiscalYear,
  original_acq_value AS OriginalAcquisitionAmount,
  original_acq_value_curr AS OriginalAcquisitionCurrency,
  inhouse_prod_percent AS InHouseProdnPercent,
  asset_type_name AS AssetTypeName,
  trade_id AS PartnerCompany,
  asset_acquired_used AS AssetIsAcquiredUsed,
  cast(investment_wbs_origin as ps_s4_pspnr) AS InvestmentProjectWBSElement,
  investment_io_origin AS InvestmentOrder,
  inventory_date AS LastInventoryDate,
  inventory_note AS InventoryNote,
  inventory_indicator AS InventoryIsCounted,
  invest_reason AS InvestmentReason,
  environmental_investment AS EnvrnmtlInvestmentReason,
  asset_super_no AS FixedAssetGroup,
  property_key AS PropertyClass,
  property_ind AS FixedAssetPropertyType,
  land_tax_office AS LocalTaxOffice,
  assessment_tax_number AS NoticeOfAssessmentTaxID,
  assessment_date AS LastAssessmentNoticeDate,
  land_municipality AS Municipality,
  land_register_of AS LandRegisterDate,
  land_register_entry_number AS LandRegisterEntrySequence,
  land_register_entry AS LandRegisterEntryDate,
  land_register_volume AS LandRegisterVolume,
  land_register_page AS LandRegisterPage,
  land_register_map_no AS LandRegisterMap,
  land_plot_number AS LandPlot,
  conveyance_date AS ConveyanceDate,
  surface_area AS AreaSize,
  surface_area_unit AS AreaSizeUnit,
  real_estate_asset AS AssetIsRealEstate,
  lease_company AS LeaseSupplier,
  lease_agreement_no AS LeaseAgreement,
  lease_agreement_date AS LeaseAgreementDate,
  lease_notice_date AS LeaseTermEndDate,
  lease_start_date AS LeaseTermStartDate,
  lease_years AS LeaseDurationInFiscalYears,
  lease_periods AS LeaseDurationInFiscalPeriods,
  lease_type AS LeaseType,
  lease_data_text AS LeasedAssetNote,
  base_unit AS BaseUnit,
  purchase_order_date AS FixedAssetOrderDate,
  last_reorg_date AS LastReorganizationDate,
  object_nr AS ObjectInternalID,
  business_area AS BusinessArea,
  cost_center AS CostCenter,
  activity_type AS CostCtrActivityType,
  internal_order AS InternalOrder,
  Fund,
  grant_id AS GrantID,
  functional_area AS FunctionalArea,
  funds_center AS FundsCenter,
  cast(wbs_element as ps_s4_pspnr) AS WBSElementInternalID,
  tax_jurisdiction AS TaxJurisdiction,
  cast(real_estate_key as recaimkeyfi ) AS RealEstateObject,
  Segment,
  profit_center AS ProfitCenter,
  budget_period AS BudgetPeriod,
  responsible_cost_center AS ResponsibleCostCenter,
  Room,
  Plant,
  location AS AssetLocation,
  car_license_plate AS VehicleLicensePlateNumber,
  personnel_number AS PersonnelNumber,
  business_place AS BusinessPlace
FROM faat_md_multi AS Multi
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [1..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass ON AssetClass = _AssetClass.AssetClass  -- association [0..1]
LEFT OUTER JOIN I_AssetAcctDetermination AS _AssetAccountDetermination ON AssetAccountDetermination = _AssetAccountDetermination.AssetAccountDetermination  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Country AS _AssetCountryOfOrigin ON AssetCountryOfOrigin = _AssetCountryOfOrigin.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _OriginalAcquisitionCurrency ON OriginalAcquisitionCurrency = _OriginalAcquisitionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.Company  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InvestmentOrder ON InvestmentOrder = _InvestmentOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_InvestmentReason AS _InvestmentReason ON InvestmentReason = _InvestmentReason.InvestmentReason  -- association [0..1]
LEFT OUTER JOIN I_EnvrnmtlInvestmentReason AS _EnvrnmtlInvestmentReason ON EnvrnmtlInvestmentReason = _EnvrnmtlInvestmentReason.EnvrnmtlInvestmentReason  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetGroup AS _FixedAssetGroup ON FixedAssetGroup = _FixedAssetGroup.FixedAssetGroup  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetPropertyType AS _FixedAssetPropertyType ON FixedAssetPropertyType = _FixedAssetPropertyType.FixedAssetPropertyType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON InternalOrder = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Location AS _AssetLocation ON AssetLocation = _AssetLocation.Location AND Plant = _AssetLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID  -- association [0..1]
;