I_TH_AssetDisposalCube

DDL: I_TH_ASSETDISPOSALCUBE SQL: ITHASSTDSPSLCUBE Type: view COMPOSITE Package: GLO_FIN_IS_AA_TH
31 Fields 3 Data Sources

Thailand: Disposal List Cube

I_TH_AssetDisposalCube is a Composite CDS View (Cube) that provides data about "Thailand: Disposal List Cube" in SAP S/4HANA. It reads from 3 data sources (I_FixedAssetForLedger, I_FixedAssetTransaction, I_StRpJournalEntryLog) and exposes 31 fields with key fields CompanyCode, AssetDepreciationArea, MasterFixedAsset, FixedAsset, Ledger. Part of development package GLO_FIN_IS_AA_TH.

Data Sources (3)

SourceAliasJoin Type
I_FixedAssetForLedger FixedAssetForLedger left_outer
I_FixedAssetTransaction I_FixedAssetTransaction from
I_StRpJournalEntryLog ReportedItemsLog left_outer

Parameters (4)

NameTypeDefault
P_KeyDate fagl_keydate
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_FiscalYear fis_gjahr
P_FiscalPeriod fis_poper

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ITHASSTDSPSLCUBE view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Thailand: Disposal List Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode FixedAssetTransaction CompanyCode Receiver Company Code
KEY AssetDepreciationArea FixedAssetTransaction AssetDepreciationArea Deprec. Area
KEY MasterFixedAsset FixedAssetTransaction MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAssetTransaction FixedAsset Sub-number
KEY Ledger FixedAssetTransaction Ledger Ledger
KEY FiscalYear FixedAssetTransaction FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet
KEY AccountingDocument FixedAssetTransaction AccountingDocument Journal Entry
KEY TransactionSubitem TransactionSubitem Sub Transaction
KEY DebitCreditCode DebitCreditCode Single-Character Flag
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
DisplayCurrency DisplayCurrency Display Currency
AssetAccountDetermination FixedAssetTransaction AssetAccountDetermination Account Determ.
AssetClass AssetClass Asset Class
AssetCapitalizationDate FixedAssetTransaction AssetCapitalizationDate Asset Capitalization
FixedAssetDescription FixedAssetDescription Description
AssetDeactivationDate I_FixedAssetForLedger AssetDeactivationDate Deact.Date
RetirementAmountInDspCrcy RetirementAmountInDspCrcy
RetirementRevenueAmtInDspCrcy RetirementRevenueAmtInDspCrcy
RtrmtNetBookValueAmtInDspCrcy RtrmtNetBookValueAmtInDspCrcy
RetirementCostsAmtInDspCrcy RetirementCostsAmtInDspCrcy
RetirementGainAmtInDspCrcy RetirementGainAmtInDspCrcy
RetirementLossAmtInDspCrcy RetirementLossAmtInDspCrcy
AssetAuthorizationContext AssetAuthorizationContext

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_TH_AssetDisposalCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ITHASSTDSPSLCUBE
-- Parameters: P_KeyDate : fagl_keydate, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper

CREATE VIEW I_TH_AssetDisposalCube AS
SELECT
  FixedAssetTransaction.CompanyCode AS CompanyCode,
  FixedAssetTransaction.AssetDepreciationArea AS AssetDepreciationArea,
  FixedAssetTransaction.MasterFixedAsset AS MasterFixedAsset,
  FixedAssetTransaction.FixedAsset AS FixedAsset,
  FixedAssetTransaction.Ledger AS Ledger,
  FixedAssetTransaction.FiscalYear AS FiscalYear,
  FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetAcctTransClassfctn,
  AssetAccountingKeyFigure,
  AssetAccountingKeyFigureSet,
  FixedAssetTransaction.AccountingDocument AS AccountingDocument,
  TransactionSubitem,
  DebitCreditCode,
  CurrencyRole,
  ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  DisplayCurrency,
  FixedAssetTransaction.AssetAccountDetermination AS AssetAccountDetermination,
  AssetClass,
  FixedAssetTransaction.AssetCapitalizationDate AS AssetCapitalizationDate,
  FixedAssetDescription,
  FixedAssetForLedger.AssetDeactivationDate AS AssetDeactivationDate,
  RetirementAmountInDspCrcy,
  RetirementRevenueAmtInDspCrcy,
  RtrmtNetBookValueAmtInDspCrcy,
  RetirementCostsAmtInDspCrcy,
  RetirementGainAmtInDspCrcy,
  RetirementLossAmtInDspCrcy,
  AssetAuthorizationContext
FROM I_FixedAssetTransaction
LEFT OUTER JOIN I_FixedAssetForLedger AS FixedAssetForLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StRpJournalEntryLog AS ReportedItemsLog ON /* join condition not captured in parsed metadata */
;

Learn More