I_AccrEngineAccrSubobjLifeCyc

DDL: I_ACCRENGINEACCRSUBOBJLIFECYC SQL: IACESOLIFECYCLE Type: view BASIC Package: ACE_S4_COMMON
7 Fields 1 Data Sources

Accrual Subobject Life Cycle

I_AccrEngineAccrSubobjLifeCyc is a Basic CDS View that provides data about "Accrual Subobject Life Cycle" in SAP S/4HANA. It reads from 1 data source (acesobj_item) and exposes 7 fields with key fields AccrualEngineAccrualObjectType, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject. Part of development package ACE_S4_COMMON.

Data Sources (1)

SourceAliasJoin Type
acesobj_item acesobj_item from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACESOLIFECYCLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accrual Subobject Life Cycle view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType comp Legal competence
KEY AccrualObjectLogicalSystem logsys Source system
KEY CompanyCode bukrs Value
KEY AccrualObject ref_key Source Reference Key
KEY AccrualSubobject ref_subkey Ext Ref of Subobject
AccrSubobjHdrStartOfLifeDate
AccrSubobjHdrEndOfLifeDate

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_AccrEngineAccrSubobjLifeCyc.
-- 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: IACESOLIFECYCLE

CREATE VIEW I_AccrEngineAccrSubobjLifeCyc AS
SELECT
  comp AS AccrualEngineAccrualObjectType,
  logsys AS AccrualObjectLogicalSystem,
  bukrs AS CompanyCode,
  ref_key AS AccrualObject,
  ref_subkey AS AccrualSubobject,
  cast( min(life_start_date ) as ace_life_start_date preserving type ) AS AccrSubobjHdrStartOfLifeDate,
  cast( max(life_end_date ) as ace_life_end_date preserving type ) AS AccrSubobjHdrEndOfLifeDate
FROM acesobj_item
;

Learn More