FAA_PFixedAssetValueHelp

DDL: FAA_PFIXEDASSETVALUEHELP Type: view Package: FINS_FIS_AA_MD
12 Fields 2 Data Sources

Fixed Asset

FAA_PFixedAssetValueHelp is a CDS View that provides data about "Fixed Asset" in SAP S/4HANA. It reads from 2 data sources (I_FixedAsset, I_FixedAssetAssgmt) and exposes 12 fields with key fields bukrs, anln1, anln2, bdatu. Part of development package FINS_FIS_AA_MD.

Data Sources (2)

SourceAliasJoin Type
I_FixedAsset I_FixedAsset from
I_FixedAssetAssgmt I_FixedAssetAssgmt left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAADVPFXAVH view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY bukrs I_FixedAsset CompanyCode Receiver Company Code
KEY anln1 I_FixedAsset MasterFixedAsset Fixed Asset
KEY anln2 I_FixedAsset FixedAsset Sub-number
KEY bdatu I_FixedAssetAssgmt ValidityEndDate ValidTo
adatu I_FixedAssetAssgmt ValidityStartDate Validity Start Date
anlkl AssetClass Asset Class
mcoa1 FixedAssetDescription Description
kostl I_FixedAssetAssgmt CostCenter Cost Center
werks I_FixedAssetAssgmt Plant Valuation Area
prctr I_FixedAssetAssgmt ProfitCenter Profit Center
gsber I_FixedAssetAssgmt BusinessArea Business Area
AssetAuthorizationContext I_FixedAsset AssetAuthorizationContext

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_PFixedAssetValueHelp.
-- 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 FAA_PFixedAssetValueHelp AS
SELECT
  I_FixedAsset.CompanyCode AS bukrs,
  I_FixedAsset.MasterFixedAsset AS anln1,
  I_FixedAsset.FixedAsset AS anln2,
  I_FixedAssetAssgmt.ValidityEndDate AS bdatu,
  I_FixedAssetAssgmt.ValidityStartDate AS adatu,
  AssetClass AS anlkl,
  FixedAssetDescription AS mcoa1,
  I_FixedAssetAssgmt.CostCenter AS kostl,
  I_FixedAssetAssgmt.Plant AS werks,
  I_FixedAssetAssgmt.ProfitCenter AS prctr,
  I_FixedAssetAssgmt.BusinessArea AS gsber,
  I_FixedAsset.AssetAuthorizationContext AS AssetAuthorizationContext
FROM I_FixedAsset
LEFT OUTER JOIN I_FixedAssetAssgmt ON /* join condition not captured in parsed metadata */
;

Learn More