R_GlobFxdAstTmeBsdValuationTP

DDL: R_GLOBFXDASTTMEBSDVALUATIONTP Type: view_entity TRANSACTIONAL Package: GLO_FIN_FAA_RAP_BO
43 Fields 1 Data Sources 2 Associations

Globalization Fixed Asset Time-based Valuation

R_GlobFxdAstTmeBsdValuationTP is a Transactional CDS View that provides data about "Globalization Fixed Asset Time-based Valuation" in SAP S/4HANA. It reads from 1 data source (I_GlobAssetTimeBasedValn) and exposes 43 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea. It has 2 associations to related views. Part of development package GLO_FIN_FAA_RAP_BO.

Data Sources (1)

SourceAliasJoin Type
I_GlobAssetTimeBasedValn I_GlobAssetTimeBasedValn from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_FixedAssetTP _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset
[1..1] I_LedgerCompanyCodeCrcyRoles _CurrencyRoles $projection.CompanyCode = _CurrencyRoles.CompanyCode and $projection.Ledger = _CurrencyRoles.Ledger

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Globalization Fixed Asset Time-based Valuation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (43)

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
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
CompanyCodeCurrency
GlobalCurrency
FreeDefinedCurrency1
FreeDefinedCurrency2
FreeDefinedCurrency3
FreeDefinedCurrency4
FreeDefinedCurrency5
FreeDefinedCurrency6
FreeDefinedCurrency7
FreeDefinedCurrency8
FunctionalCurrency
_FixedAsset _FixedAsset
_FixedAssetValuation _FixedAssetValuation
_CurrencyRoles _CurrencyRoles

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 R_GlobFxdAstTmeBsdValuationTP.
-- 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.

CREATE VIEW R_GlobFxdAstTmeBsdValuationTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  AssetDepreciationArea,
  ValidityEndDate,
  ValidityStartDate,
  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,
  _CurrencyRoles._CoCodeCurrencyRoleCurrency.Currency AS CompanyCodeCurrency,
  _CurrencyRoles._GlobalCurrencyRoleCurrency.Currency AS GlobalCurrency,
  _CurrencyRoles._FreeDfndCrcyRole1Currency.Currency AS FreeDefinedCurrency1,
  _CurrencyRoles._FreeDfndCrcyRole2Currency.Currency AS FreeDefinedCurrency2,
  _CurrencyRoles._FreeDfndCrcyRole3Currency.Currency AS FreeDefinedCurrency3,
  _CurrencyRoles._FreeDfndCrcyRole4Currency.Currency AS FreeDefinedCurrency4,
  _CurrencyRoles._FreeDfndCrcyRole5Currency.Currency AS FreeDefinedCurrency5,
  _CurrencyRoles._FreeDfndCrcyRole6Currency.Currency AS FreeDefinedCurrency6,
  _CurrencyRoles._FreeDfndCrcyRole7Currency.Currency AS FreeDefinedCurrency7,
  _CurrencyRoles._FreeDfndCrcyRole8Currency.Currency AS FreeDefinedCurrency8,
  _CurrencyRoles._FunctionalCrcyRoleCurrency.Currency AS FunctionalCurrency
FROM I_GlobAssetTimeBasedValn
LEFT OUTER JOIN R_FixedAssetTP AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _CurrencyRoles ON CompanyCode = _CurrencyRoles.CompanyCode AND Ledger = _CurrencyRoles.Ledger  -- association [1..1]
;

Learn More