P_FixedAssetCountryData

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 P_FixedAssetCountryData.
-- 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 P_FixedAssetCountryData AS
SELECT
  anla.bukrs AS CompanyCode,
  anla.anln1 AS MasterFixedAsset,
  anla.anln2 AS FixedAsset,
  glofaaassetdata.glo_natl_clfn_code AS NationalClassification,
  glofaaassetdata.glo_tax_depr_grp AS TaxDepreciationGroup,
  t001.land1 AS Country,
  glofaaassetdata.glo_rus_sernr AS RU_LongSerialNumber,
  glofaaassetdata.glo_rus_matnr AS RU_WorkwearMaterial,
  cast('' as glo_ru_retired_asset_number) AS RU_RetiredMasterFixedAsset,
  cast('' as glo_ru_retired_asset_subnumber) AS RU_RetiredFixedAsset,
  glofaaassetdata.glo_rus_trc_begd AS RU_ProdTraceabilityStartDate,
  glofaaassetdata.glo_rus_trc_endd AS RU_ProdTraceabilityEndDate,
  glofaaassetdata.glo_rus_trc_tnved AS RU_AssetTNVED,
  glofaaassetdata.glo_rus_ttx_type AS RU_AssetTransportType,
  glofaaassetdata.glo_rus_ttx_vin AS RU_VehicleIdNumber,
  glofaaassetdata.glo_rus_ttx_mnfd AS RU_ManufacturingDate,
  glofaaassetdata.glo_rus_eco_cls AS RU_VehicleEcologicalClass,
  glofaaassetdata.glo_rus_prt_addr AS RU_PropertyAddress,
  glofaaassetdata.glo_rus_ltx_owrd AS RU_PropertyOwnershipRegnDate,
  glofaaassetdata.glo_rus_ltx_owtd AS RU_PropertyOwnershipTermnDate,
  glofaaassetdata.glo_jp_ax16_strc AS JP_Annex16AssetStructure,
  glofaaassetdata.glo_jp_ax16_item AS JP_Annex16AssetItem,
  cast(anla.lvdat as glo_anx16_lease_agreement_date) AS JP_Annex16LeasingAgrmtDate,
  cast(anla.gdlgrp as glo_jp_city_code) AS JP_PrptyTxRptCity,
  cast(anla.vmgli as glo_jp_ptx_classification_key) AS JP_PrptyTxRptClassfctnKey,
  cast(anla.grund as glo_jp_sdc) AS JP_PrptyTxRptSpclDepr,
  glofaaassetdata.glo_jp_ptx_prdcd AS JP_PrptyTxRptAddlDepr,
  glofaaassetdata.glo_in_blk_key AS IN_AssetBlock,
  glofaaassetdata.glo_in_ast_use AS IN_AssetPutToUseDate,
  glofaaassetdata.glo_in_adnlblk AS IN_AdditionalAssetBlock,
  glofaaassetdata.glo_in_r_d_asset AS IN_AssetIsResearchAndDev,
  glofaaassetdata.glo_in_prior_yr AS IN_AssetIsPriorYear,
  glofaaassetdata.glo_pt_vehicletype AS PT_VehicleTypeByEnergy,
  glofaaassetdata.glo_pt_isvehiclewolimit AS PT_VehicleIsWithoutLimit,
  glofaaassetdata.glo_pt_repairassetlink AS PT_BigRepairAssetLink,
  glofaaassetdata.glo_pt_landassetlink AS PT_LandAssetLink,
  glofaaassetdata.glo_pt_assetrepformcat AS PT_AssetReportFormCategory,
  glofaaassetdata.glo_pt_isamassetreval AS PT_AmortizedAssetIsReevaluated,
  cast(anla.internal_code as glo_il_internal_code) AS IL_InvmtCtrInternalCode,
  cast(anla.approval_number as glo_il_approval_number) AS IL_InvmtCtrApprovalDocNmbr,
  cast(anla.approval_version as glo_il_approval_version) AS IL_InvmtCtrApprovalVersion,
  cast(anla.bogus_anln1 as glo_il_bogus_anln1) AS IL_InvmtCtrBogusAssetNumber,
  cast(anla.asset_version as glo_il_asset_version) AS IL_InvmtCtrAssetVersion,
  cast('0000' as glo_rs_exclusion_year) AS RS_GroupDeprExclusionYear,
  cast('00000000' as glo_rs_last_invoice_date) as RS_AssetLastInvoiceDate AS comp_codeasCompanyCode,
  glo_faat_md.glo_rs_last_invoice_date AS RS_AssetLastInvoiceDate
FROM anla
INNER JOIN P_TF_AssetRedesignSwitchStatus ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): glo_faat_md
;