I_GlobAssetTimeBasedValnTP

DDL: I_GLOBASSETTIMEBASEDVALNTP SQL: IGASTTMBSDVALNTP Type: view TRANSACTIONAL Package: GLO_FIN_FAA_GEN
33 Fields 1 Data Sources 2 Associations

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. Part of development package GLO_FIN_FAA_GEN.

Data Sources (1)

SourceAliasJoin Type
I_GlobAssetTimeBasedValn GlobAssetTimeBasedValuation from

Associations (2)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY Ledger Ledger Ledger
KEY AssetDepreciationArea AssetDepreciationArea Deprec. Area
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDateForEdit ValidityEndDate ValidTo
JP_ImpairmentPostingDate JP_ImpairmentPostingDate Impairment Post Date
JP_ImpAcqnProdCostAmtInCCCrcy JP_ImpAcqnProdCostAmtInCCCrcy APC in Co. Code Crcy
JP_ImpAcqnProdCostAmtInGCrcy JP_ImpAcqnProdCostAmtInGCrcy APC in Global Crcy
JP_ImpAcqnProdCostAmtInFDCrcy1 JP_ImpAcqnProdCostAmtInFDCrcy1 APC in Currency 1
JP_ImpAcqnProdCostAmtInFDCrcy2 JP_ImpAcqnProdCostAmtInFDCrcy2 APC in Currency 2
JP_ImpAcqnProdCostAmtInFDCrcy3 JP_ImpAcqnProdCostAmtInFDCrcy3 APC in Currency 3
JP_ImpAcqnProdCostAmtInFDCrcy4 JP_ImpAcqnProdCostAmtInFDCrcy4 APC in Currency 4
JP_ImpAcqnProdCostAmtInFDCrcy5 JP_ImpAcqnProdCostAmtInFDCrcy5 APC in Currency 5
JP_ImpAcqnProdCostAmtInFDCrcy6 JP_ImpAcqnProdCostAmtInFDCrcy6 APC in Currency 6
JP_ImpAcqnProdCostAmtInFDCrcy7 JP_ImpAcqnProdCostAmtInFDCrcy7 APC in Currency 7
JP_ImpAcqnProdCostAmtInFDCrcy8 JP_ImpAcqnProdCostAmtInFDCrcy8 APC in Currency 8
JP_AftImprmtBookAmtInCCCrcy JP_AftImprmtBookAmtInCCCrcy BAI in Co. Code Crcy
JP_AftImprmtBookAmtInGlobCrcy JP_AftImprmtBookAmtInGlobCrcy BAI in Global Crcy
JP_AftImprmtBookAmtInFDCrcy1 JP_AftImprmtBookAmtInFDCrcy1 BAI in Currency 1
JP_AftImprmtBookAmtInFDCrcy2 JP_AftImprmtBookAmtInFDCrcy2 BAI in Currency 2
JP_AftImprmtBookAmtInFDCrcy3 JP_AftImprmtBookAmtInFDCrcy3 BAI in Currency 3
JP_AftImprmtBookAmtInFDCrcy4 JP_AftImprmtBookAmtInFDCrcy4 BAI in Currency 4
JP_AftImprmtBookAmtInFDCrcy5 JP_AftImprmtBookAmtInFDCrcy5 BAI in Currency 5
JP_AftImprmtBookAmtInFDCrcy6 JP_AftImprmtBookAmtInFDCrcy6 BAI in Currency 6
JP_AftImprmtBookAmtInFDCrcy7 JP_AftImprmtBookAmtInFDCrcy7 BAI in Currency 7
JP_AftImprmtBookAmtInFDCrcy8 JP_AftImprmtBookAmtInFDCrcy8 BAI in Currency 8
SK_CapitalImprovementYear SK_CapitalImprovementYear Capital Impr.Year
_AssetTP _AssetTP
_FixedAsset _FixedAsset
_AssetValuationTP _AssetValuationTP

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_GlobAssetTimeBasedValnTP.
-- 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: IGASTTMBSDVALNTP

CREATE VIEW I_GlobAssetTimeBasedValnTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  AssetDepreciationArea,
  ValidityEndDate,
  ValidityStartDate,
  ValidityEndDate AS ValidityEndDateForEdit,
  JP_ImpairmentPostingDate,
  JP_ImpAcqnProdCostAmtInCCCrcy,
  JP_ImpAcqnProdCostAmtInGCrcy,
  JP_ImpAcqnProdCostAmtInFDCrcy1,
  JP_ImpAcqnProdCostAmtInFDCrcy2,
  JP_ImpAcqnProdCostAmtInFDCrcy3,
  JP_ImpAcqnProdCostAmtInFDCrcy4,
  JP_ImpAcqnProdCostAmtInFDCrcy5,
  JP_ImpAcqnProdCostAmtInFDCrcy6,
  JP_ImpAcqnProdCostAmtInFDCrcy7,
  JP_ImpAcqnProdCostAmtInFDCrcy8,
  JP_AftImprmtBookAmtInCCCrcy,
  JP_AftImprmtBookAmtInGlobCrcy,
  JP_AftImprmtBookAmtInFDCrcy1,
  JP_AftImprmtBookAmtInFDCrcy2,
  JP_AftImprmtBookAmtInFDCrcy3,
  JP_AftImprmtBookAmtInFDCrcy4,
  JP_AftImprmtBookAmtInFDCrcy5,
  JP_AftImprmtBookAmtInFDCrcy6,
  JP_AftImprmtBookAmtInFDCrcy7,
  JP_AftImprmtBookAmtInFDCrcy8,
  SK_CapitalImprovementYear
FROM I_GlobAssetTimeBasedValn AS GlobAssetTimeBasedValuation
LEFT OUTER JOIN I_AssetTP AS _AssetTP ON CompanyCode = _AssetTP.CompanyCode AND MasterFixedAsset = _AssetTP.MasterFixedAsset AND FixedAsset = _AssetTP.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_AssetValuationTP AS _AssetValuationTP ON CompanyCode = _AssetValuationTP.CompanyCode AND MasterFixedAsset = _AssetValuationTP.MasterFixedAsset AND FixedAsset = _AssetValuationTP.FixedAsset AND Ledger = _AssetValuationTP.Ledger AND AssetDepreciationArea = _AssetValuationTP.AssetDepreciationArea  -- association [1..1]
;

Learn More