I_AssetMultipleCreationTP

DDL: I_ASSETMULTIPLECREATIONTP SQL: IASTMULTICRTETP Type: view TRANSACTIONAL Package: FINS_FAA_MD_BOPF

Asset Multiple Creation - TP

I_AssetMultipleCreationTP is a Transactional CDS View that provides data about "Asset Multiple Creation - TP" in SAP S/4HANA. It reads from 1 data source (I_AssetMultipleCreation) and exposes 106 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, RowIndex. It has 1 association to related views. Part of development package FINS_FAA_MD_BOPF.

Data Sources (1)

SourceAliasJoin Type
I_AssetMultipleCreation Multi from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AssetTP _AssetTP $projection.CompanyCode = _AssetTP.CompanyCode and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset and $projection.FixedAsset = _AssetTP.FixedAsset

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IASTMULTICRTETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Asset Multiple Creation - TP view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
Metadata.allowExtensions false view
ObjectModel.writeActivePersistence IASTMULTICRTETP view
ObjectModel.writeDraftPersistence FAAD_MD_MULTI view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (106)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY RowIndex RowIndex
AssetClass AssetClass
AssetAccountDetermination AssetAccountDetermination
FixedAssetDescription FixedAssetDescription
AssetAdditionalDescription AssetAdditionalDescription
AssetSerialNumber AssetSerialNumber
Inventory Inventory
Supplier Supplier
AssetCountryOfOrigin AssetCountryOfOrigin
AssetManufacturerName AssetManufacturerName
OriginalMasterFixedAsset OriginalMasterFixedAsset
OriginalFixedAsset OriginalFixedAsset
OriginalFixedAssetValueDate OriginalFixedAssetValueDate
OriginalAcquisitionFiscalYear OriginalAcquisitionFiscalYear
OriginalAcquisitionAmount OriginalAcquisitionAmount
OriginalAcquisitionCurrency OriginalAcquisitionCurrency
InHouseProdnPercent InHouseProdnPercent
AssetTypeName AssetTypeName
PartnerCompany PartnerCompany
AssetIsAcquiredUsed AssetIsAcquiredUsed
InvestmentProjectWBSElement InvestmentProjectWBSElement
InvestmentOrder InvestmentOrder
LastInventoryDate LastInventoryDate
InventoryNote InventoryNote
InventoryIsCounted InventoryIsCounted
InvestmentReason InvestmentReason
EnvrnmtlInvestmentReason EnvrnmtlInvestmentReason
FixedAssetGroup FixedAssetGroup
PropertyClass PropertyClass
FixedAssetPropertyType FixedAssetPropertyType
LocalTaxOffice LocalTaxOffice
NoticeOfAssessmentTaxID NoticeOfAssessmentTaxID
LastAssessmentNoticeDate LastAssessmentNoticeDate
Municipality Municipality
LandRegisterDate LandRegisterDate
LandRegisterEntrySequence LandRegisterEntrySequence
LandRegisterEntryDate LandRegisterEntryDate
LandRegisterVolume LandRegisterVolume
LandRegisterPage LandRegisterPage
LandRegisterMap LandRegisterMap
LandPlot LandPlot
ConveyanceDate ConveyanceDate
AreaSize AreaSize
AreaSizeUnit AreaSizeUnit
AssetIsRealEstate AssetIsRealEstate
LeaseSupplier LeaseSupplier
LeaseAgreement LeaseAgreement
LeaseAgreementDate LeaseAgreementDate
LeaseTermEndDate LeaseTermEndDate
LeaseTermStartDate LeaseTermStartDate
LeaseDurationInFiscalYears LeaseDurationInFiscalYears
LeaseDurationInFiscalPeriods LeaseDurationInFiscalPeriods
LeaseType LeaseType
LeasedAssetNote LeasedAssetNote
BaseUnit BaseUnit
FixedAssetOrderDate FixedAssetOrderDate
LastReorganizationDate LastReorganizationDate
ObjectInternalID ObjectInternalID
BusinessArea BusinessArea
CostCenter CostCenter
CostCtrActivityType CostCtrActivityType
InternalOrder InternalOrder
Fund Fund
GrantID GrantID
FunctionalArea FunctionalArea
FundsCenter FundsCenter
WBSElementInternalID WBSElementInternalID
WBSElementExternalID
TaxJurisdiction TaxJurisdiction
RealEstateObject RealEstateObject
Segment Segment
ProfitCenter ProfitCenter
BudgetPeriod BudgetPeriod
ResponsibleCostCenter ResponsibleCostCenter
Room Room
Plant Plant
AssetLocation AssetLocation
VehicleLicensePlateNumber VehicleLicensePlateNumber
PersonnelNumber PersonnelNumber
BusinessPlace BusinessPlace
_AssetTP _AssetTP
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_AssetClass _AssetClass
_AssetAccountDetermination _AssetAccountDetermination
_Supplier _Supplier
_AssetCountryOfOrigin _AssetCountryOfOrigin
_OriginalAcquisitionCurrency _OriginalAcquisitionCurrency
_PartnerCompany _PartnerCompany
_InvestmentOrder _InvestmentOrder
_InvestmentReason _InvestmentReason
_EnvrnmtlInvestmentReason _EnvrnmtlInvestmentReason
_FixedAssetGroup _FixedAssetGroup
_FixedAssetPropertyType _FixedAssetPropertyType
_UnitOfMeasure _UnitOfMeasure
_BusinessArea _BusinessArea
_InternalOrder _InternalOrder
_FunctionalArea _FunctionalArea
_Segment _Segment
_Plant _Plant
_AssetLocation _AssetLocation
_Employment _Employment
@AbapCatalog.sqlViewName: 'IASTMULTICRTETP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Asset Multiple Creation - TP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@Metadata.allowExtensions: false
@ObjectModel: {
    writeActivePersistence: 'IASTMULTICRTETP',
    writeDraftPersistence:  'FAAD_MD_MULTI',
    semanticKey: ['CompanyCode','MasterFixedAsset','FixedAsset','RowIndex'],
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    usageType: {
        serviceQuality: #A,
        sizeCategory: #XXL,
        dataClass: #MASTER
    }
}


define view I_AssetMultipleCreationTP
  as select from I_AssetMultipleCreation as Multi
  association [1..1] to I_AssetTP as _AssetTP on  $projection.CompanyCode      = _AssetTP.CompanyCode
                                              and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset
                                              and $projection.FixedAsset       = _AssetTP.FixedAsset
{
      @ObjectModel.readOnly: true
  key CompanyCode,
      @ObjectModel.readOnly: true
  key MasterFixedAsset,
      @ObjectModel.readOnly: true
  key FixedAsset,

  key RowIndex,

      //Root fields


      AssetClass,
      //AssetScreenLayout,

      AssetAccountDetermination,

      FixedAssetDescription,

      AssetAdditionalDescription,

      AssetSerialNumber,
      Inventory,
      Supplier,
      AssetCountryOfOrigin,
      AssetManufacturerName,
      OriginalMasterFixedAsset,
      OriginalFixedAsset,
      OriginalFixedAssetValueDate,

      OriginalAcquisitionFiscalYear,
      OriginalAcquisitionAmount,
      OriginalAcquisitionCurrency,
      InHouseProdnPercent,
      AssetTypeName,
      PartnerCompany,
      AssetIsAcquiredUsed,
      InvestmentProjectWBSElement,
      InvestmentOrder,
      LastInventoryDate,
      InventoryNote,
      InventoryIsCounted,
      InvestmentReason,
      EnvrnmtlInvestmentReason,
      FixedAssetGroup,
      PropertyClass,
      FixedAssetPropertyType,
      LocalTaxOffice,
      NoticeOfAssessmentTaxID,
      LastAssessmentNoticeDate,
      Municipality,
      LandRegisterDate,
      LandRegisterEntrySequence,
      LandRegisterEntryDate,
      LandRegisterVolume,
      LandRegisterPage,
      LandRegisterMap,
      LandPlot,
      ConveyanceDate,
      AreaSize,
      AreaSizeUnit,
      AssetIsRealEstate,
      LeaseSupplier,
      LeaseAgreement,
      LeaseAgreementDate,
      LeaseTermEndDate,
      LeaseTermStartDate,
      LeaseDurationInFiscalYears,
      LeaseDurationInFiscalPeriods,
      LeaseType,
      LeasedAssetNote,
      BaseUnit,
      FixedAssetOrderDate,
      LastReorganizationDate,
      ObjectInternalID,

      //TDD fields

      BusinessArea,
      CostCenter,
      CostCtrActivityType,
      InternalOrder,
      Fund,
      GrantID,
      FunctionalArea,
      FundsCenter,
      WBSElementInternalID,
      cast (cast('' as abap.char(24)) as ps_posid_edit preserving type)         as WBSElementExternalID,
      TaxJurisdiction,
      RealEstateObject,
      Segment,
      ProfitCenter,
      BudgetPeriod,
      ResponsibleCostCenter,
      Room,
      Plant,
      AssetLocation,
      VehicleLicensePlateNumber,
      PersonnelNumber,
      BusinessPlace,

      // Association

      @ObjectModel.association.type:  [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _AssetTP,


      _CompanyCode,
      _MasterFixedAsset,
      _FixedAsset,
      _AssetClass,
      _AssetAccountDetermination,
      _Supplier,
      _AssetCountryOfOrigin,
      _OriginalAcquisitionCurrency,
      _PartnerCompany,
      _InvestmentOrder,
      _InvestmentReason,
      _EnvrnmtlInvestmentReason,
      _FixedAssetGroup,
      _FixedAssetPropertyType,
      _UnitOfMeasure,

      _BusinessArea,
      _InternalOrder,
      _FunctionalArea,
      _Segment,
      _Plant,
      _AssetLocation,
      _Employment
}