P_MasterFixedAsset

DDL: P_MASTERFIXEDASSET Type: view BASIC

P_MasterFixedAsset is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (anlh, P_TF_AssetRedesignSwitchStatus, P_TF_AssetRedesignSwitchStatus, faat_md_root) and exposes 7 fields with key fields CompanyCode, MasterFixedAsset, MasterFixedAsset.

4 data source(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
anlh anlh from
P_TF_AssetRedesignSwitchStatus P_TF_AssetRedesignSwitchStatus inner
P_TF_AssetRedesignSwitchStatus P_TF_AssetRedesignSwitchStatus inner
faat_md_root root union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIMASTFIXASSET view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs
KEY MasterFixedAsset anln1
MasterFixedAssetDescription anlhtxt
comp_codeasCompanyCode
KEY MasterFixedAsset faat_md_root asset_no
MasterFixedAssetDescription main description
AssetAuthorizationContext 
@AbapCatalog: { sqlViewName: 'PFIMASTFIXASSET', preserveKey: true, compiler.compareFilter: true }
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_MasterFixedAsset
  as select from anlh
    inner join   P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = ''
{
  key bukrs                             as CompanyCode,
  key anln1                             as MasterFixedAsset,

      anlhtxt                           as MasterFixedAssetDescription,
      cast('CLASSIC' as  faa_authcntxt) as AssetAuthorizationContext
}

union all select from    faat_md_root as root
  left outer to one join faat_md      as main                                            on  main.comp_code   = root.comp_code
                                                                                         and main.asset_no    = root.asset_no
                                                                                         and main.asset_subno = root.asset_subno
  inner join             P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = 'X'
{
  key root.comp_code                as CompanyCode,
  key root.asset_no                 as MasterFixedAsset,
      main.description              as MasterFixedAssetDescription,
      cast('NEW' as  faa_authcntxt) as AssetAuthorizationContext
}
where
      root.is_main_asset    =  'X'
  and root.lifecycle_status <> '2'
  and root.lifecycle_status <> '8'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ANLH",
"FAAT_MD",
"FAAT_MD_ROOT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More