P_MASTERFIXEDASSET

CDS View

P_MASTERFIXEDASSET is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MasterFixedAsset view from BASIC Master Fixed Asset 
@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'

Learn More