I_TH_AssetDisposalLog

DDL: I_TH_ASSETDISPOSALLOG SQL: ITHASTDISPLOG Type: view COMPOSITE

Thailand Asset： Disposal List Log

I_TH_AssetDisposalLog is a Composite CDS View that provides data about "Thailand Asset： Disposal List Log" in SAP S/4HANA. It reads from 1 data source (I_FixedAssetTransaction) and exposes 19 fields with key fields CompanyCode, AssetDepreciationArea, MasterFixedAsset, FixedAsset, Ledger.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_FixedAssetTransaction I_FixedAssetTransaction from

Parameters (7)

NameTypeDefault
P_KeyDate fagl_keydate
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_FiscalYear fis_gjahr
P_FiscalPeriod fis_poper
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITHASTDISPLOG view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Thailand Asset： Disposal List Log view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode FixedAssetTransaction CompanyCode
KEY AssetDepreciationArea FixedAssetTransaction AssetDepreciationArea
KEY MasterFixedAsset FixedAssetTransaction MasterFixedAsset
KEY FixedAsset FixedAssetTransaction FixedAsset
KEY Ledger FixedAssetTransaction Ledger
KEY FiscalYear FixedAssetTransaction FiscalYear
KEY FiscalPeriod FiscalPeriod
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet
KEY AccountingDocument FixedAssetTransaction AccountingDocument
KEY TransactionSubitem TransactionSubitem
KEY DebitCreditCode DebitCreditCode
KEY CurrencyRole CurrencyRole
AssetClass AssetClass
StatryRptgEntity
StatryRptCategory
StatryRptRunID 
@AbapCatalog.sqlViewName: 'ITHASTDISPLOG'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Thailand Asset： Disposal List Log'
define view I_TH_AssetDisposalLog
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate                     : fagl_keydate,
    P_AssetAccountingKeyFigureSet : faa_key_figure_set,
    P_FiscalYear                  : fis_gjahr,
    P_FiscalPeriod                : fis_poper,
    P_StatryRptgEntity            : srf_reporting_entity,
    P_StatryRptCategory           : srf_rep_cat_id,
    P_StatryRptRunID              : srf_report_run_id

  as select from I_FixedAssetTransaction (P_KeyDate: :P_KeyDate, P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet) as FixedAssetTransaction
{
  key     FixedAssetTransaction.CompanyCode,
  key     FixedAssetTransaction.AssetDepreciationArea,
  key     FixedAssetTransaction.MasterFixedAsset,
  key     FixedAssetTransaction.FixedAsset,
  key     FixedAssetTransaction.Ledger,
  key     FixedAssetTransaction.FiscalYear,
  key     FiscalPeriod,
  key     SubLedgerAcctLineItemType,
  key     AssetAcctTransClassfctn,
  key     AssetAccountingKeyFigure,
  key     AssetAccountingKeyFigureSet,
  key     FixedAssetTransaction.AccountingDocument,
  key     TransactionSubitem,
  key     DebitCreditCode,
  key     CurrencyRole,
          AssetClass,
          $parameters.P_StatryRptgEntity  as StatryRptgEntity,
          $parameters.P_StatryRptCategory as StatryRptCategory,
          $parameters.P_StatryRptRunID    as StatryRptRunID


}
where
      FixedAssetTransaction.FiscalYear   =  :P_FiscalYear
  and FixedAssetTransaction.FiscalPeriod <= :P_FiscalPeriod
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FIXEDASSETTRANSACTION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More