I_AccrEngineAccrSubobjActlItem

DDL: I_ACCRENGINEACCRSUBOBJACTLITEM SQL: IACESOACTLITEM Type: view BASIC
76 Fields 2 Data Sources 1 Associations

Accrual Subobject Actual Item

I_AccrEngineAccrSubobjActlItem is a Basic CDS View that provides data about "Accrual Subobject Actual Item" in SAP S/4HANA. It reads from 2 data sources (I_AccrEngineAccrSubobjRawItem, I_AccrEngineActualAccrItemType) and exposes 76 fields with key fields AccrualEngineAccrualObjectType, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_AccrEngineAccrSubobjRawItem I_AccrEngineAccrSubobjRawItem from
I_AccrEngineActualAccrItemType I_AccrEngineActualAccrItemType inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_AccrEngineActualAccrItemType _ActualAccrItemType $projection.AccrualEngineAccrualObjectType = _ActualAccrItemType.AccrualEngineAccrualObjectType and $projection.AccrualItemType = _ActualAccrItemType.ActualAccrualItemType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACESOACTLITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accrual Subobject Actual 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 #BASIC view
AbapCatalog.preserveKey true view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType I_AccrEngineAccrSubobjRawItem 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 I_AccrEngineAccrSubobjRawItem 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
TotalAccrualQuantity TotalAccrualQuantity Total Qty to Accrue
TotalAccrualQuantityUnit TotalAccrualQuantityUnit Unit of Measure
TotalAccrAmountInTransCrcy TotalAccrAmountInTransCrcy Total A/D Amt (TC)
TotalAccrAmtInCompanyCodeCrcy TotalAccrAmtInCompanyCodeCrcy Total A/D Amt (CC)
TotalAccrAmountInGlobalCrcy TotalAccrAmountInGlobalCrcy Total A/D Amt (GC)
TotalAccrAmountInFreeDfndCrcy1 TotalAccrAmountInFreeDfndCrcy1 Total A/D Amt (FC1)
TotalAccrAmountInFreeDfndCrcy2 TotalAccrAmountInFreeDfndCrcy2 Total A/D Amt (FC2)
TotalAccrAmountInFreeDfndCrcy3 TotalAccrAmountInFreeDfndCrcy3 Total A/D Amt (FC3)
TotalAccrAmountInFreeDfndCrcy4 TotalAccrAmountInFreeDfndCrcy4 Total A/D Amt (FC4)
TotalAccrAmountInFreeDfndCrcy5 TotalAccrAmountInFreeDfndCrcy5 Total A/D Amt (FC5)
TotalAccrAmountInFreeDfndCrcy6 TotalAccrAmountInFreeDfndCrcy6 Total A/D Amt (FC6)
TotalAccrAmountInFreeDfndCrcy7 TotalAccrAmountInFreeDfndCrcy7 Total A/D Amt (FC7)
TotalAccrAmountInFreeDfndCrcy8 TotalAccrAmountInFreeDfndCrcy8 Total A/D Amt (FC8)
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
_ActualAccrItemType _ActualAccrItemType
_AccrMethod _AccrMethod
_OpngPostgDocumentType _OpngPostgDocumentType
_PerdcPostgDocumentType _PerdcPostgDocumentType
_ClsgPostgDocumentType _ClsgPostgDocumentType
_OpngPostgAccrAccount _OpngPostgAccrAccount
_OpngPostgOffstgAccount _OpngPostgOffstgAccount
_PerdcPostgAccrAccount _PerdcPostgAccrAccount
_PerdcPostgOffstgAccount _PerdcPostgOffstgAccount
_ClsgPostgAccrAccount _ClsgPostgAccrAccount
_ClsgPostgOffstgAccount _ClsgPostgOffstgAccount
_Ledger _Ledger
_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_AccrEngineAccrSubobjActlItem.
-- 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: IACESOACTLITEM

CREATE VIEW I_AccrEngineAccrSubobjActlItem AS
SELECT
  I_AccrEngineAccrSubobjRawItem.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  I_AccrEngineAccrSubobjRawItem.AccrualItemType AS AccrualItemType,
  Ledger,
  AccrSubobjectItmValdtyEndDte,
  AccrSubobjectItmValdtyStrtDte,
  AccrualMethod,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  AccrualItemIsObsolete,
  TotalAccrualQuantity,
  TotalAccrualQuantityUnit,
  TotalAccrAmountInTransCrcy,
  TotalAccrAmtInCompanyCodeCrcy,
  TotalAccrAmountInGlobalCrcy,
  TotalAccrAmountInFreeDfndCrcy1,
  TotalAccrAmountInFreeDfndCrcy2,
  TotalAccrAmountInFreeDfndCrcy3,
  TotalAccrAmountInFreeDfndCrcy4,
  TotalAccrAmountInFreeDfndCrcy5,
  TotalAccrAmountInFreeDfndCrcy6,
  TotalAccrAmountInFreeDfndCrcy7,
  TotalAccrAmountInFreeDfndCrcy8,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AccrOpngPostgDocumentType,
  AccrPerdcPostgDocumentType,
  AccrClsgPostgDocumentType,
  AccrOpngPostgAccrAccount,
  AccrOpngPostgOffstgAccount,
  AccrPerdcPostgAccrAccount,
  AccrPerdcPostgOffstgAcct,
  AccrClsgPostgAccrAccount,
  AccrClsgPostgOffstgAccount,
  AccrualItemLastChangeDateTime
FROM I_AccrEngineAccrSubobjRawItem
INNER JOIN I_AccrEngineActualAccrItemType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccrEngineActualAccrItemType AS _ActualAccrItemType ON AccrualEngineAccrualObjectType = _ActualAccrItemType.AccrualEngineAccrualObjectType AND AccrualItemType = _ActualAccrItemType.ActualAccrualItemType  -- association [0..1]
;

Learn More