@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
Depth:
1
2
3
4
5
All
Reload
R_FixedAssetMultipleCreationTP view_entity