I_IN_FixedAssetTransaction

DDL: I_IN_FIXEDASSETTRANSACTION SQL: IINFASSETTRANS Type: view COMPOSITE Package: ID-FIAA-IN

CDS view for Fixed Asset Transaction (India)

I_IN_FixedAssetTransaction is a Composite CDS View that provides data about "CDS view for Fixed Asset Transaction (India)" in SAP S/4HANA. It reads from 2 data sources (I_FixedAssetValue, I_IN_TransactionType) and exposes 21 fields. Part of development package ID-FIAA-IN.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
I_FixedAssetValue I_FixedAssetValue from
I_IN_TransactionType ttype inner

Parameters (1)

NameTypeDefault
P_AssetAccountingKeyFigureSet faa_key_figure_set

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IINFASSETTRANS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS view for Fixed Asset Transaction (India) view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
CompanyCode fav CompanyCode
AssetDepreciationArea fav AssetDepreciationArea
MasterFixedAsset fav MasterFixedAsset
FixedAsset fav FixedAsset
AccountingDocument fav AccountingDocument
Ledger fav Ledger
FiscalYear fav FiscalYear
SubLedgerAcctLineItemType fav SubLedgerAcctLineItemType
AssetAcctTransClassfctn fav AssetAcctTransClassfctn
AssetAccountingKeyFigure fav AssetAccountingKeyFigure
ChartOfDepreciation fav ChartOfDepreciation
DocumentDate fav DocumentDate
PostingDate fav PostingDate
AssetValueDate fav AssetValueDate
AmountInCompanyCodeCurrency fav AmountInCompanyCodeCurrency
CompanyCodeCurrency fav CompanyCodeCurrency
AssetCapitalizationDate fav AssetCapitalizationDate
AssetDeactivationDate fav AssetDeactivationDate
PartnerMasterFixedAsset fav PartnerMasterFixedAsset
PartnerFixedAsset fav PartnerFixedAsset
AssetTransactionTypeGroup I_IN_TransactionType AssetTransactionTypeGroup 
@AbapCatalog.sqlViewName: 'IINFASSETTRANS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS view for Fixed Asset Transaction (India)'
@ObjectModel: { usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
        
define view I_IN_FixedAssetTransaction 
  with parameters 
    P_AssetAccountingKeyFigureSet : faa_key_figure_set
    
    as select from I_FixedAssetValue(P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet) as fav
       inner join I_IN_TransactionType as ttype
      on fav.AssetTransactionType = ttype.AssetTransactionType
      and fav.AssetAccountingKeyFigureSet = $parameters.P_AssetAccountingKeyFigureSet
      {
         fav.CompanyCode,
         fav.AssetDepreciationArea,
         fav.MasterFixedAsset,
         fav.FixedAsset,
         fav.AccountingDocument,
         fav.Ledger,
         fav.FiscalYear,
         fav.SubLedgerAcctLineItemType,
         fav.AssetAcctTransClassfctn,
         fav.AssetAccountingKeyFigure,
         fav.ChartOfDepreciation,
         fav.DocumentDate,
         fav.PostingDate,
         fav.AssetValueDate,
         @Semantics.amount.currencyCode:'CompanyCodeCurrency'
         fav.AmountInCompanyCodeCurrency,
         fav.CompanyCodeCurrency,
         fav.AssetCapitalizationDate,
         fav.AssetDeactivationDate,
         fav.PartnerMasterFixedAsset,
         fav.PartnerFixedAsset,
         ttype.AssetTransactionTypeGroup
      }

Learn More