I_ManualAccrualObject

DDL: I_MANUALACCRUALOBJECT SQL: IMNLACCROBJ Type: view BASIC
9 Fields 2 Data Sources

Manual Accrual Object Interface View

I_ManualAccrualObject is a Basic CDS View that provides data about "Manual Accrual Object Interface View" in SAP S/4HANA. It reads from 2 data sources (acesobj, acac_objects) and exposes 9 fields with key fields CompanyCode, AccrualObject, AccrualSubobject.

Data Sources (2)

SourceAliasJoin Type
acesobj _Accrual inner
acac_objects _ManualAccrual from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMNLACCROBJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Manual Accrual Object Interface View view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode acac_objects bukrs Value
KEY AccrualObject acac_objects ref_key Source Reference Key
KEY AccrualSubobject acac_objects ref_subkey Ext Ref of Subobject
ManualAccrualsAccrObjectType acac_objtype Accr Object Cat
ManualAccrualsAccrSubobjType acac_subobjtype Accr. Object Subcat.
ManualAccrualsAccrObject acac_objnumber AObject Number
AccrualObjectDescription text User Group
PersonResponsibleName acac_resperson Employee
AccrSubobjectLifeCycleStatus

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_ManualAccrualObject.
-- 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: IMNLACCROBJ

CREATE VIEW I_ManualAccrualObject AS
SELECT
  _ManualAccrual.bukrs AS CompanyCode,
  _ManualAccrual.ref_key AS AccrualObject,
  _ManualAccrual.ref_subkey AS AccrualSubobject,
  acac_objtype AS ManualAccrualsAccrObjectType,
  acac_subobjtype AS ManualAccrualsAccrSubobjType,
  acac_objnumber AS ManualAccrualsAccrObject,
  text AS AccrualObjectDescription,
  acac_resperson AS PersonResponsibleName,
  cast(case _Accrual.xarchived when 'X' then 'A' else status end as ace_subobject_lifecycle_status preserving type) AS AccrSubobjectLifeCycleStatus
FROM acac_objects AS _ManualAccrual
INNER JOIN acesobj AS _Accrual ON /* join condition not captured in parsed metadata */
;

Learn More