FAA_ES_ASSET_MD

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 FAA_ES_ASSET_MD.
-- 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: FAAESMD

CREATE VIEW FAA_ES_ASSET_MD AS
SELECT
  root.comp_code AS CompanyCode,
  root.asset_no AS MasterFixedAsset,
  root.asset_subno AS FixedAsset,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  main.description AS MasterFixedAssetDescription,
  main.description AS FixedAssetDescription,
  main.add_description AS AssetAdditionalDescription,
  main.asset_class AS AssetClass,
  _AssetClassText.description_short AS AssetClassName,
  main.creation_user AS CreatedByUser,
  _CreatedByUserName.UserDescription AS CreatedByUserName,
  main.creation_datetime AS CreationDateTime,
  main.lastchange_user AS LastChangedByUser,
  _LastChangedByUserName.UserDescription AS LastChangedByUserName,
  main.lastchange_datetime AS LastChangeDateTime,
  main.manufacturer AS AssetManufacturerName,
  main.investment_io_origin AS InvestmentOrder,
  main.asset_type_name AS AssetTypeName,
  main.inventory_note AS InventoryNote,
  main.inventory_number AS Inventory,
  main.serial_number AS AssetSerialNumber,
  _TO_FAAT_MD_TDD.ControllingArea AS ControllingArea,
  _TO_FAAT_MD_TDD.ValidityEndDate AS ValidityEndDate,
  _TO_FAAT_MD_TDD.CostCenter AS CostCenter,
  _TO_FAAT_MD_TDD._TO_CSKT[ 1: spras = $session.system_language ].ktext AS CostCenterName,
  _AssetAccountDeterminationText.description_short AS AssetAccountDeterminationDesc,
  _TO_FAAT_MD_TDD.AssetLocation AS AssetLocation,
  _TO_FAAT_MD_TDD._AssetLocation.LocationName AS AssetLocationName,
  _TO_FAAT_MD_TDD.BusinessArea AS BusinessArea,
  _TO_FAAT_MD_TDD._TO_TGSBT[ 1: spras = $session.system_language ].gtext AS BusinessAreaName,
  _TO_FAAT_MD_TDD.Plant AS Plant,
  _TO_FAAT_MD_TDD._TO_T001W.name1 AS PlantName,
  main.supplier_no AS supplier,
  _TO_FAAT_MD_TDD.PersonnelNumber AS PersonnelNumber,
  _TO_FAAT_MD_TDD.vehiclelicenseplatenumber AS VehicleLicensePlateNumber,
  _TO_FAAT_MD_TDD.budgetperiod AS BudgetPeriod,
  _TO_FAAT_MD_TDD.Fund AS Fund,
  _TO_FAAT_MD_TDD.functionalarea AS FunctionalArea,
  _TO_FAAT_MD_TDD.grantid AS GrantID,
  _TO_FAAT_MD_TDD.ProfitCenter AS ProfitCenter,
  _TO_FAAT_MD_TDD.internalorder AS InternalOrder,
  _TO_FAAT_MD_TDD.responsiblecostcenter AS ResponsibleCostCenter,
  _TO_FAAT_MD_TDD._CostCenter AS _CostCenter,
  _TO_FAAT_MD_TDD._ProfitCenter AS _ProfitCenter,
  _TO_FAAT_MD_TDD._BusinessArea AS _BusinessArea,
  _TO_FAAT_MD_TDD._Plant AS _Plant
FROM faat_md_root AS root
LEFT OUTER JOIN faat_md AS main ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN faac_acls0 AS _AssetClass ON AssetClass = _AssetClass.asset_class  -- association [0..1]
LEFT OUTER JOIN faac_acls0_t AS _AssetClassText ON AssetClass = _AssetClassText.asset_class AND _AssetClassText.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN FAA_ES_ASSET_MD_TDD AS _TO_FAAT_MD_TDD ON CompanyCode = _TO_FAAT_MD_TDD.CompanyCode AND MasterFixedAsset = _TO_FAAT_MD_TDD.MasterFixedAsset AND FixedAsset = _TO_FAAT_MD_TDD.FixedAsset  -- association [0..*]
LEFT OUTER JOIN faac_acctdet0 AS _AssetAccountDetermination ON assetaccountdetermination = _AssetAccountDetermination.gl_account_det  -- association [0..1]
LEFT OUTER JOIN faac_acctdet0_t AS _AssetAccountDeterminationText ON assetaccountdetermination = _AssetAccountDeterminationText.gl_account_det AND _AssetAccountDeterminationText.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUserName ON LastChangedByUser = _LastChangedByUserName.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUserName ON CreatedByUser = _CreatedByUserName.UserID  -- association [1..1]
LEFT OUTER JOIN E_FixedAsset AS _Extension ON MasterFixedAsset = _Extension.MasterFixedAsset AND FixedAsset = _Extension.FixedAsset AND CompanyCode = _Extension.CompanyCode  -- association [1..1]
;