Which tables does I_GlobAssetTimeBasedValnTP use?

I_GlobAssetTimeBasedValnTP reads from 1 data source(s): I_GlobAssetTimeBasedValn.

How many fields does I_GlobAssetTimeBasedValnTP have?

I_GlobAssetTimeBasedValnTP has 33 fields. Key fields: CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea.

I_GlobAssetTimeBasedValnTP

DDL: I_GLOBASSETTIMEBASEDVALNTP SQL: IGASTTMBSDVALNTP Type: view TRANSACTIONAL

CSMD Time Based Valuation of Asset

I_GlobAssetTimeBasedValnTP is a Transactional CDS View that provides data about "CSMD Time Based Valuation of Asset" in SAP S/4HANA. It reads from 1 data source (I_GlobAssetTimeBasedValn) and exposes 33 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_GlobAssetTimeBasedValn	GlobAssetTimeBasedValuation	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_AssetTP	_AssetTP	`$projection.CompanyCode = _AssetTP.CompanyCode and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset and $projection.FixedAsset = _AssetTP.FixedAsset`
[1..1]	I_AssetValuationTP	_AssetValuationTP	`$projection.CompanyCode = _AssetValuationTP.CompanyCode and $projection.MasterFixedAsset = _AssetValuationTP.MasterFixedAsset and $projection.FixedAsset = _AssetValuationTP.FixedAsset and $projection.Ledger = _AssetValuationTP.Ledger and $projection.AssetDepreciationArea = _AssetValuationTP.AssetDepreciationArea`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	IGASTTMBSDVALNTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	CSMD Time Based Valuation of Asset	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#TRANSACTIONAL	view
Metadata.allowExtensions	false	view
ObjectModel.writeActivePersistence	GLO_FAAV_MD_VTDD	view
ObjectModel.writeDraftPersistence	GLO_FAAD_MD_VTDD	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (33)

Key	Field	Source Field
KEY	CompanyCode	CompanyCode
KEY	MasterFixedAsset	MasterFixedAsset
KEY	FixedAsset	FixedAsset
KEY	Ledger	Ledger
KEY	AssetDepreciationArea	AssetDepreciationArea
KEY	ValidityEndDate	ValidityEndDate
	ValidityStartDate	ValidityStartDate
	ValidityEndDateForEdit	ValidityEndDate
	JP_ImpairmentPostingDate	JP_ImpairmentPostingDate
	JP_ImpAcqnProdCostAmtInCCCrcy	JP_ImpAcqnProdCostAmtInCCCrcy
	JP_ImpAcqnProdCostAmtInGCrcy	JP_ImpAcqnProdCostAmtInGCrcy
	JP_ImpAcqnProdCostAmtInFDCrcy1	JP_ImpAcqnProdCostAmtInFDCrcy1
	JP_ImpAcqnProdCostAmtInFDCrcy2	JP_ImpAcqnProdCostAmtInFDCrcy2
	JP_ImpAcqnProdCostAmtInFDCrcy3	JP_ImpAcqnProdCostAmtInFDCrcy3
	JP_ImpAcqnProdCostAmtInFDCrcy4	JP_ImpAcqnProdCostAmtInFDCrcy4
	JP_ImpAcqnProdCostAmtInFDCrcy5	JP_ImpAcqnProdCostAmtInFDCrcy5
	JP_ImpAcqnProdCostAmtInFDCrcy6	JP_ImpAcqnProdCostAmtInFDCrcy6
	JP_ImpAcqnProdCostAmtInFDCrcy7	JP_ImpAcqnProdCostAmtInFDCrcy7
	JP_ImpAcqnProdCostAmtInFDCrcy8	JP_ImpAcqnProdCostAmtInFDCrcy8
	JP_AftImprmtBookAmtInCCCrcy	JP_AftImprmtBookAmtInCCCrcy
	JP_AftImprmtBookAmtInGlobCrcy	JP_AftImprmtBookAmtInGlobCrcy
	JP_AftImprmtBookAmtInFDCrcy1	JP_AftImprmtBookAmtInFDCrcy1
	JP_AftImprmtBookAmtInFDCrcy2	JP_AftImprmtBookAmtInFDCrcy2
	JP_AftImprmtBookAmtInFDCrcy3	JP_AftImprmtBookAmtInFDCrcy3
	JP_AftImprmtBookAmtInFDCrcy4	JP_AftImprmtBookAmtInFDCrcy4
	JP_AftImprmtBookAmtInFDCrcy5	JP_AftImprmtBookAmtInFDCrcy5
	JP_AftImprmtBookAmtInFDCrcy6	JP_AftImprmtBookAmtInFDCrcy6
	JP_AftImprmtBookAmtInFDCrcy7	JP_AftImprmtBookAmtInFDCrcy7
	JP_AftImprmtBookAmtInFDCrcy8	JP_AftImprmtBookAmtInFDCrcy8
	SK_CapitalImprovementYear	SK_CapitalImprovementYear
	_AssetTP	_AssetTP
	_FixedAsset	_FixedAsset
	_AssetValuationTP	_AssetValuationTP

@AbapCatalog.sqlViewName: 'IGASTTMBSDVALNTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CSMD Time Based Valuation of Asset'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@Metadata.allowExtensions: false
@ObjectModel: {
    writeActivePersistence: 'GLO_FAAV_MD_VTDD',
    writeDraftPersistence:  'GLO_FAAD_MD_VTDD',
    semanticKey: ['ValidityEndDateForEdit','CompanyCode','MasterFixedAsset','FixedAsset','AssetDepreciationArea'],
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    usageType: {
        serviceQuality: #A,
        sizeCategory: #XL,
        dataClass: #TRANSACTIONAL
    }
}

define view I_GlobAssetTimeBasedValnTP
  as select from I_GlobAssetTimeBasedValn as GlobAssetTimeBasedValuation

  association [1..1] to I_AssetTP          as _AssetTP          on  $projection.CompanyCode      = _AssetTP.CompanyCode
                                                                and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset
                                                                and $projection.FixedAsset       = _AssetTP.FixedAsset

  association [1..1] to I_AssetValuationTP as _AssetValuationTP on  $projection.CompanyCode               = _AssetValuationTP.CompanyCode
                                                                and $projection.MasterFixedAsset          = _AssetValuationTP.MasterFixedAsset
                                                                and $projection.FixedAsset                = _AssetValuationTP.FixedAsset
                                                                and $projection.Ledger                    = _AssetValuationTP.Ledger
                                                                and $projection.AssetDepreciationArea = _AssetValuationTP.AssetDepreciationArea

{
  key CompanyCode,
  key MasterFixedAsset,
  key FixedAsset,
  key Ledger,
  key AssetDepreciationArea,
  key ValidityEndDate,
              
      @ObjectModel:{ mandatory:true}
      ValidityStartDate,
      @Semantics.businessDate.to: true
      ValidityEndDate                                       as      ValidityEndDateForEdit,

      // JP Impairment

      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpairmentPostingDate,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInCCCrcy,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInGCrcy,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInFDCrcy1,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInFDCrcy2,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInFDCrcy3,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInFDCrcy4,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInFDCrcy5,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInFDCrcy6,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInFDCrcy7,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_ImpAcqnProdCostAmtInFDCrcy8,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInCCCrcy,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInGlobCrcy,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInFDCrcy1,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInFDCrcy2,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInFDCrcy3,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInFDCrcy4,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInFDCrcy5,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInFDCrcy6,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInFDCrcy7,
      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      JP_AftImprmtBookAmtInFDCrcy8,

      // SK Tax Depreciation

      @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
      SK_CapitalImprovementYear,

      // Associations

      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _AssetTP,

      _FixedAsset, // For inheritence use in access control


      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _AssetValuationTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLOBASSETTIMEBASEDVALN"
],
"ASSOCIATED":
[
"I_ASSETTP",
"I_ASSETVALUATIONTP",
"I_FIXEDASSET"
],
"BASE":
[
"I_GLOBASSETTIMEBASEDVALN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_GlobAssetTimeBasedValnTP view

I_GlobAssetTimeBasedValn view

C_GlobAssetTimeBasedValnTP view