R_FixedAssetMultipleCreationTP

DDL: R_FIXEDASSETMULTIPLECREATIONTP Type: view_entity TRANSACTIONAL Package: FINS_FAA_MD_RAP_BO

Fixed Asset Multiple Creation

R_FixedAssetMultipleCreationTP is a Transactional CDS View that provides data about "Fixed Asset Multiple Creation" in SAP S/4HANA. It reads from 1 data source (I_FixedAsset) and exposes 7 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, RowIndex. Part of development package FINS_FAA_MD_RAP_BO.

Data Sources (1)

SourceAliasJoin Type
I_FixedAsset I_FixedAsset from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Fixed Asset Multiple Creation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode
KEY MasterFixedAsset
KEY FixedAsset
KEY RowIndex
FixedAssetDescription
AssetClass
_FixedAsset _FixedAsset
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Fixed Asset Multiple Creation'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
    semanticKey: ['CompanyCode','MasterFixedAsset','FixedAsset','RowIndex'],
    usageType: {
        serviceQuality: #C,
        sizeCategory: #S,
        dataClass: #MASTER
    }
}

define view entity R_FixedAssetMultipleCreationTP
  //  as select from I_AssetMultipleCreation

  as select from I_FixedAsset
  association to parent R_FixedAssetTP as _FixedAsset on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                      and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                      and $projection.FixedAsset       = _FixedAsset.FixedAsset
  //  association [0..1] to I_WBSElementBasicData as _WBSElement on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID


{
      // key CompanyCode,

  key cast( '0000' as bukrs )                    as CompanyCode,
      // key MasterFixedAsset,

  key cast( '000000000000' as anln1 )            as MasterFixedAsset,
      // key FixedAsset,

  key cast( '0000' as anln2 )                    as FixedAsset,
      // key RowIndex,

  key cast( 0 as int4 )                          as RowIndex,
      //Root fields

      // FixedAssetDescription, //S4CE_F011

      cast( '' as txa50_anlt )                   as FixedAssetDescription,
      //      AssetAdditionalDescription, //S4CE_F012

      //      BaseUnit, //S4CE_F013

      //      FixedAssetOrderDate, //S4CE_F014

      //      AssetSerialNumber, //S4CE_F015

      //      Inventory, //S4CE_F016

      //      legacymasterfixedasset, //S4CE_F017

      //      legacyfixedasset, //S4CE_F017

      //      legacyfixedassetcompanycode, //S4CE_F017

      //      InventoryIsCounted, //S4CE_F019

      //      LastInventoryDate, //S4CE_F020

      //      InventoryNote, //S4CE_F020

      //      AssetIsAcquiredUsed, //S4CE_F206

      //      Supplier, //S4CE_F206

      //      @Semantics.amount.currencyCode: 'OriginalAcquisitionCurrency'

      //      OriginalAcquisitionAmount, //S4CE_F208

      //      OriginalAcquisitionCurrency, //S4CE_F208

      //      OriginalAcquisitionFiscalYear, //S4CE_F208

      //      InHouseProdnPercent, //S4CE_F209

      //      AssetTypeName, //S4CE_F210

      //      AssetManufacturerName, //S4CE_F210

      //      AssetCountryOfOrigin, //S4CE_F210

      //      PartnerCompany, //S4CE_F211

      //

      //      //TDD fields

      //      TaxJurisdiction, //S4CE_F130

      //      CostCenter, //S4CE_F132

      //      WBSElementInternalID, //S4CE_F135

      //      _WBSElement.WBSElementExternalID,

      //      ProfitCenter, //S4CE_F138

      //      Segment, //S4CE_F139

      //      Plant, //S4CE_F146

      //      AssetLocation, //S4CE_F147

      //      Room, //S4CE_F148

      //      VehicleLicensePlateNumber, //S4CE_F149

      //

      //      //LD fields

      //      assetcapitalizationdate, //S4CE_F401

      //      assetdeactivationdate, //S4CE_F403


      //Technical

      @Consumption.hidden: true
      cast( '' as anlkl )                        as AssetClass, 

      //association

      _FixedAsset
      //      _WBSElement

}
where
  1 = 2