I_FIXEDASSETFORMNUMBER

CDS View

Fixed Asset Form Numbers

I_FIXEDASSETFORMNUMBER is a CDS View in S/4HANA. Fixed Asset Form Numbers. It contains 4 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 4 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_StRpFxdAssetAcquisitionFormC view left_outer CONSUMPTION Fixed Asset Acquisition Form Cube
C_StRpFxdAssetLocTransferFormC view left_outer CONSUMPTION Fixed Asset Location Transfer Form Cube
C_StRpFxdAstRetirementFormCube view left_outer CONSUMPTION Fixed Asset Retirement Form Cube
P_PL_SAFTOldestAcqForm view_entity inner CONSUMPTION Acquisition form with minimum run ID
P_PL_SAFTOldestAcqFormRun view_entity from CONSUMPTION Run ID of the oldest Acquisition form
P_PL_SAFTRetirementForm view_entity from CONSUMPTION PL SAFT Asset Retirement Form per Doc.

Fields (4)

KeyField CDS FieldsUsed in Views
FixedAssetFormNumber FixedAssetFormNumber 3
StatryRptCategory StatryRptCategory 3
StatryRptgEntity StatryRptgEntity 3
StatryRptRunID StatryRptRunID 3 
@AbapCatalog.sqlViewName: 'IFAFORMNMBR'
@EndUserText.label: 'Fixed Asset Form Numbers'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #M,
                usageType.dataClass: #TRANSACTIONAL }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view I_FixedAssetFormNumber as select from fiaagend_frmnum 
{
  key frm_type           as FixedAssetFormType,
  key comp_code          as CompanyCode,
  key asset_no           as MasterFixedAsset,
  key asset_subno        as FixedAsset,
  key accountingdocument as AccountingDocument,
  key fiscalyear         as FiscalYear,
  key valid_to_date      as ValidityEndDate,
  key reporting_entity   as StatryRptgEntity,
  key rep_cat_id         as StatryRptCategory,
  key report_run_id      as StatryRptRunID,
  frm_number             as FixedAssetFormNumber,
  srf_db_key             as StatryRptRunUUID            
}

Learn More