I_FixedAssetTransactionLineItm

DDL: I_FIXEDASSETTRANSACTIONLINEITM SQL: ILINEITEM Type: view_entity BASIC Package: ODATA_AA_ASSET_TRANS_LIST

Line Item History

I_FixedAssetTransactionLineItm is a Basic CDS View that provides data about "Line Item History" in SAP S/4HANA. It reads from 2 data sources (acdoca, faat_md) and exposes 14 fields with key fields CompanyCode, AccountingDocument, Ledger, AssetDepreciationArea, LedgerGLLineItem. It has 1 association to related views. Part of development package ODATA_AA_ASSET_TRANS_LIST.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
acdoca acdoca from
faat_md faat_md inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WBSElementBasicData WBS_Element faat_md.investment_wbs_origin = WBS_Element.WBSElementInternalID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Line Item History view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode acdoca rbukrs
KEY AccountingDocument acdoca belnr
KEY Ledger acdoca rldnr
KEY AssetDepreciationArea acdoca afabe
KEY LedgerGLLineItem acdoca docln
CompanyCodeCurrency acdoca rhcur
PartnerMasterFixedAsset acdoca panl1
PartnerFixedAsset acdoca panl2
PredecessorJournalEntry acdoca prec_awref
PredecessorReferenceDocCntxt acdoca prec_aworg
PredecessorReferenceSystem acdoca prec_awsys
PredecessorReferenceDocType acdoca prec_awtyp
WBSElementExternalID WBS_Element WBSElementExternalID
AmountInCompanyCodeCurrency acdoca hsl 
//@AbapCatalog.sqlViewName: 'ILINEITEM'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Line Item History'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_FixedAssetTransactionLineItm
as select from acdoca
inner join faat_md on acdoca.rbukrs = faat_md.comp_code
                   and acdoca.panl1 = faat_md.asset_no
association [0..1] to I_WBSElementBasicData as WBS_Element 
                                                on faat_md.investment_wbs_origin = WBS_Element.WBSElementInternalID 
{
  key acdoca.rbukrs as CompanyCode,
  key acdoca.belnr as AccountingDocument,
  key acdoca.rldnr as Ledger,
  key acdoca.afabe as AssetDepreciationArea,
  key acdoca.docln as LedgerGLLineItem,
  acdoca.rhcur     as CompanyCodeCurrency,
  acdoca.panl1 as PartnerMasterFixedAsset,
  acdoca.panl2 as PartnerFixedAsset,
  acdoca.prec_awref as PredecessorJournalEntry,
  acdoca.prec_aworg as PredecessorReferenceDocCntxt,
  acdoca.prec_awsys as PredecessorReferenceSystem,
  acdoca.prec_awtyp as PredecessorReferenceDocType,
//  acdoca.bttype as Test,

  WBS_Element.WBSElementExternalID,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  acdoca.hsl as AmountInCompanyCodeCurrency
}
where
( acdoca.bttype = 'AUUA' or acdoca.bttype = 'AUUS' or acdoca.bttype = 'AUUZ' or acdoca.bttype = 'ZUCO' )
and acdoca.panl1 is not initial
and acdoca.docln is not initial
and acdoca.prec_awref is not initial 
//and acdoca.prec_aworg is not initial and acdoca.prec_awsys is not initial and acdoca.prec_awtyp is not initial )

Learn More