I_AccrEngineAccrSubobjItem

DDL: I_ACCRENGINEACCRSUBOBJITEM SQL: IACESOITEM Type: view COMPOSITE
79 Fields 1 Data Sources 6 Associations

Accrual Subobject Item

I_AccrEngineAccrSubobjItem is a Composite CDS View that provides data about "Accrual Subobject Item" in SAP S/4HANA. It reads from 1 data source (I_AccrEngineAccrSubobjAccrItem) and exposes 79 fields with key fields AccrualEngineAccrualObjectType, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AccrEngineAccrSubobjAccrItem I_AccrEngineAccrSubobjAccrItem from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_AccrEngineAccrualMethod _PlanAccrMethod $projection.AccrualEngineAccrualObjectType = _PlanAccrMethod.AccrualEngineAccrualObjectType and $projection.PlanAccrualMethod = _PlanAccrMethod.AccrualMethod
[0..1] I_AccrEngineAccrualMethod _ActualAccrMethod $projection.AccrualEngineAccrualObjectType = _ActualAccrMethod.AccrualEngineAccrualObjectType and $projection.ActualAccrualMethod = _ActualAccrMethod.AccrualMethod
[0..1] I_AccrEngineAccrualMethod _DeferralMethod $projection.AccrualEngineAccrualObjectType = _DeferralMethod.AccrualEngineAccrualObjectType and $projection.DeferralMethod = _DeferralMethod.AccrualMethod
[0..1] I_AccrEngineAccrSubobjPlanItem _PlanItem $projection.AccrualEngineAccrualObjectType = _PlanItem.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _PlanItem.AccrualObjectLogicalSystem and $projection.CompanyCode = _PlanItem.CompanyCode and $projection.AccrualObject = _PlanItem.AccrualObject and $projection.AccrualSubobject = _PlanItem.AccrualSubobject and $projection.PlanAccrualItemType = _PlanItem.AccrualItemType and $projection.Ledger = _PlanItem.Ledger and $projection.AccrSubobjectItmValdtyStrtDte >= _PlanItem.AccrSubobjectItmValdtyStrtDte and $projection.AccrSubobjectItmValdtyEndDte <= _PlanItem.AccrSubobjectItmValdtyEndDte
[0..1] I_AccrEngineAccrSubobjActlItem _ActualItem $projection.AccrualEngineAccrualObjectType = _ActualItem.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _ActualItem.AccrualObjectLogicalSystem and $projection.CompanyCode = _ActualItem.CompanyCode and $projection.AccrualObject = _ActualItem.AccrualObject and $projection.AccrualSubobject = _ActualItem.AccrualSubobject and $projection.ActualAccrualItemType = _ActualItem.AccrualItemType and $projection.Ledger = _ActualItem.Ledger and $projection.AccrSubobjectItmValdtyStrtDte >= _ActualItem.AccrSubobjectItmValdtyStrtDte and $projection.AccrSubobjectItmValdtyEndDte <= _ActualItem.AccrSubobjectItmValdtyEndDte
[0..1] I_AccrEngineAccrSubobjDefrlItm _DeferralItem $projection.AccrualEngineAccrualObjectType = _DeferralItem.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _DeferralItem.AccrualObjectLogicalSystem and $projection.CompanyCode = _DeferralItem.CompanyCode and $projection.AccrualObject = _DeferralItem.AccrualObject and $projection.AccrualSubobject = _DeferralItem.AccrualSubobject and $projection.DeferralItemType = _DeferralItem.AccrualItemType and $projection.Ledger = _DeferralItem.Ledger and $projection.AccrSubobjectItmValdtyStrtDte >= _DeferralItem.AccrSubobjectItmValdtyStrtDte and $projection.AccrSubobjectItmValdtyEndDte <= _DeferralItem.AccrSubobjectItmValdtyEndDte

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACESOITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accrual Subobject Item view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.entityChangeStateId AccrualItemLastChangeDateTime view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType AccrualEngineAccrualObjectType Component
KEY AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccrualObject AccrualObject External Reference of Accrual Object
KEY AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
KEY AccrualItemType AccrualItemType Accrual Item Type
KEY Ledger Ledger Ledger
KEY AccrSubobjectItmValdtyEndDte AccrSubobjectItmValdtyEndDte To
AccrSubobjectItmValdtyStrtDte AccrSubobjectItmValdtyStrtDte From
AccrualMethod AccrualMethod Accr/Defrl Method
AccrSubobjHdrStartOfLifeDate AccrSubobjHdrStartOfLifeDate Start of Life
AccrSubobjHdrEndOfLifeDate AccrSubobjHdrEndOfLifeDate End of Life
AccrualItemIsObsolete AccrualItemIsObsolete Obsolete
PlanAccrualItemType PlanAccrualItemType Plnd Costs Itm Type
PlanAccrualMethod
ActualAccrualItemType ActualAccrualItemType Actl Costs Item Type
ActualAccrualMethod
DeferralItemType DeferralItemType Deferral Item Type
DeferralMethod
TotalAccrualQuantityUnit TotalAccrualQuantityUnit Unit of Measure
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
AccrOpngPostgDocumentType AccrOpngPostgDocumentType Document Type
AccrPerdcPostgDocumentType AccrPerdcPostgDocumentType Document Type
AccrClsgPostgDocumentType AccrClsgPostgDocumentType Document Type
AccrOpngPostgAccrAccount AccrOpngPostgAccrAccount Accr./Dfrl Acct
AccrOpngPostgOffstgAccount AccrOpngPostgOffstgAccount Offsetting Account
AccrPerdcPostgAccrAccount AccrPerdcPostgAccrAccount Accr./Dfrl. Account
AccrPerdcPostgOffstgAcct AccrPerdcPostgOffstgAcct Offsetting Account
AccrClsgPostgAccrAccount AccrClsgPostgAccrAccount Accr./Dfrl Acct
AccrClsgPostgOffstgAccount AccrClsgPostgOffstgAccount Offsetting Account
AccrualItemLastChangeDateTime AccrualItemLastChangeDateTime Time Stamp
_AccrObjectType _AccrObjectType
_AccrLogicalSystem _AccrLogicalSystem
_AccrCompanyCode _AccrCompanyCode
_AccrObj _AccrObj
_AccrSubobj _AccrSubobj
_AccrItemType _AccrItemType
_PlanAccrItemType _PlanAccrItemType
_ActualAccrItemType _ActualAccrItemType
_DeferralItemType _DeferralItemType
_AccrMethod _AccrMethod
_Ledger _Ledger
_PlanAccrMethod _PlanAccrMethod
_ActualAccrMethod _ActualAccrMethod
_DeferralMethod _DeferralMethod
_PlanItem _PlanItem
_ActualItem _ActualItem
_DeferralItem _DeferralItem
_OpngPostgDocumentType _OpngPostgDocumentType
_PerdcPostgDocumentType _PerdcPostgDocumentType
_ClsgPostgDocumentType _ClsgPostgDocumentType
_OpngPostgAccrAccount _OpngPostgAccrAccount
_OpngPostgOffstgAccount _OpngPostgOffstgAccount
_PerdcPostgAccrAccount _PerdcPostgAccrAccount
_PerdcPostgOffstgAccount _PerdcPostgOffstgAccount
_ClsgPostgAccrAccount _ClsgPostgAccrAccount
_ClsgPostgOffstgAccount _ClsgPostgOffstgAccount
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_FreeDefinedCurrency1 _FreeDefinedCurrency1
_FreeDefinedCurrency2 _FreeDefinedCurrency2
_FreeDefinedCurrency3 _FreeDefinedCurrency3
_FreeDefinedCurrency4 _FreeDefinedCurrency4
_FreeDefinedCurrency5 _FreeDefinedCurrency5
_FreeDefinedCurrency6 _FreeDefinedCurrency6
_FreeDefinedCurrency7 _FreeDefinedCurrency7
_FreeDefinedCurrency8 _FreeDefinedCurrency8
_BaseUnit _BaseUnit

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_AccrEngineAccrSubobjItem.
-- 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: IACESOITEM

CREATE VIEW I_AccrEngineAccrSubobjItem AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrSubobjectItmValdtyEndDte,
  AccrSubobjectItmValdtyStrtDte,
  AccrualMethod,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  AccrualItemIsObsolete,
  PlanAccrualItemType,
  cast( _PlanItem.AccrualMethod as aceds_acrmethod_plnd preserving type ) AS PlanAccrualMethod,
  ActualAccrualItemType,
  cast( _ActualItem.AccrualMethod as aceds_acrmethod_actl preserving type ) AS ActualAccrualMethod,
  DeferralItemType,
  cast( _DeferralItem.DeferralMethod as ace_deferral_accr_meth preserving type ) AS DeferralMethod,
  TotalAccrualQuantityUnit,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AccrOpngPostgDocumentType,
  AccrPerdcPostgDocumentType,
  AccrClsgPostgDocumentType,
  AccrOpngPostgAccrAccount,
  AccrOpngPostgOffstgAccount,
  AccrPerdcPostgAccrAccount,
  AccrPerdcPostgOffstgAcct,
  AccrClsgPostgAccrAccount,
  AccrClsgPostgOffstgAccount,
  AccrualItemLastChangeDateTime
FROM I_AccrEngineAccrSubobjAccrItem
LEFT OUTER JOIN I_AccrEngineAccrualMethod AS _PlanAccrMethod ON AccrualEngineAccrualObjectType = _PlanAccrMethod.AccrualEngineAccrualObjectType AND PlanAccrualMethod = _PlanAccrMethod.AccrualMethod  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrualMethod AS _ActualAccrMethod ON AccrualEngineAccrualObjectType = _ActualAccrMethod.AccrualEngineAccrualObjectType AND ActualAccrualMethod = _ActualAccrMethod.AccrualMethod  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrualMethod AS _DeferralMethod ON AccrualEngineAccrualObjectType = _DeferralMethod.AccrualEngineAccrualObjectType AND DeferralMethod = _DeferralMethod.AccrualMethod  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrSubobjPlanItem AS _PlanItem ON AccrualEngineAccrualObjectType = _PlanItem.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _PlanItem.AccrualObjectLogicalSystem AND CompanyCode = _PlanItem.CompanyCode AND AccrualObject = _PlanItem.AccrualObject AND AccrualSubobject = _PlanItem.AccrualSubobject AND PlanAccrualItemType = _PlanItem.AccrualItemType AND Ledger = _PlanItem.Ledger AND AccrSubobjectItmValdtyStrtDte >= _PlanItem.AccrSubobjectItmValdtyStrtDte AND AccrSubobjectItmValdtyEndDte <= _PlanItem.AccrSubobjectItmValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrSubobjActlItem AS _ActualItem ON AccrualEngineAccrualObjectType = _ActualItem.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _ActualItem.AccrualObjectLogicalSystem AND CompanyCode = _ActualItem.CompanyCode AND AccrualObject = _ActualItem.AccrualObject AND AccrualSubobject = _ActualItem.AccrualSubobject AND ActualAccrualItemType = _ActualItem.AccrualItemType AND Ledger = _ActualItem.Ledger AND AccrSubobjectItmValdtyStrtDte >= _ActualItem.AccrSubobjectItmValdtyStrtDte AND AccrSubobjectItmValdtyEndDte <= _ActualItem.AccrSubobjectItmValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrSubobjDefrlItm AS _DeferralItem ON AccrualEngineAccrualObjectType = _DeferralItem.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _DeferralItem.AccrualObjectLogicalSystem AND CompanyCode = _DeferralItem.CompanyCode AND AccrualObject = _DeferralItem.AccrualObject AND AccrualSubobject = _DeferralItem.AccrualSubobject AND DeferralItemType = _DeferralItem.AccrualItemType AND Ledger = _DeferralItem.Ledger AND AccrSubobjectItmValdtyStrtDte >= _DeferralItem.AccrSubobjectItmValdtyStrtDte AND AccrSubobjectItmValdtyEndDte <= _DeferralItem.AccrSubobjectItmValdtyEndDte  -- association [0..1]
;

Learn More