C_EndOfUsefulLifeAsset

DDL: C_ENDOFUSEFULLIFEASSET SQL: CGRCFALIFE Type: view CONSUMPTION Package: FINS_FIS_GRC_APPS
28 Fields 1 Data Sources

Near End Of Asset Useful Life

C_EndOfUsefulLifeAsset is a Consumption CDS View that provides data about "Near End Of Asset Useful Life" in SAP S/4HANA. It reads from 1 data source (P_DepreciationEndDate) and exposes 28 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetRealDepreciationArea. Part of development package FINS_FIS_GRC_APPS.

Data Sources (1)

SourceAliasJoin Type
P_DepreciationEndDate P_DepreciationEndDate from

Parameters (2)

NameTypeDefault
P_StartDate afabg
P_DepreciationDateOffsetInDays far_number

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCFALIFE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Near End Of Asset Useful Life view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY Ledger Ledger Ledger
KEY AssetRealDepreciationArea AssetRealDepreciationArea
KEY ValidityEndDate ValidityEndDate ValidTo
DepreciationStartDate DepreciationStartDate
PlannedUsefulLifeInYears PlannedUsefulLifeInYears Planned Use Life Yr.
DepreciationCalcValidToDate DepreciationCalcValidToDate Depreciation End Date
DepreciationDateOffsetInDays DepreciationDateOffsetInDays Days between depreciation & current date
AssetClass AssetClass Asset Class
FixedAssetDescription FixedAssetDescription Description
AssetAdditionalDescription AssetAdditionalDescription
PartnerCompany PartnerCompany Trading Partner
CompanyName _PartnerCompany CompanyName Text
Supplier Supplier Supplier
SupplierFullName _Supplier SupplierFullName
AssetCountryOfOrigin AssetCountryOfOrigin
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
_FixedAsset _FixedAsset
_MasterFixedAsset _MasterFixedAsset
_CompanyCode _CompanyCode
_AssetClass _AssetClass
_PartnerCompany _PartnerCompany
_Supplier _Supplier

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 C_EndOfUsefulLifeAsset.
-- 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: CGRCFALIFE
-- Parameters: P_StartDate : afabg, P_DepreciationDateOffsetInDays : far_number

CREATE VIEW C_EndOfUsefulLifeAsset AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  AssetRealDepreciationArea,
  ValidityEndDate,
  DepreciationStartDate,
  PlannedUsefulLifeInYears,
  DepreciationCalcValidToDate,
  DepreciationDateOffsetInDays,
  AssetClass,
  FixedAssetDescription,
  AssetAdditionalDescription,
  PartnerCompany,
  _PartnerCompany.CompanyName AS CompanyName,
  Supplier,
  _Supplier.SupplierFullName AS SupplierFullName,
  AssetCountryOfOrigin,
  LastChangeDate,
  LastChangedByUser,
  CreationDate,
  CreatedByUser
FROM P_DepreciationEndDate
;

Learn More