C_AccrEngineAccrSubobjItemTP

DDL: C_ACCRENGINEACCRSUBOBJITEMTP SQL: CACESOITEMTP Type: view_entity CONSUMPTION
71 Fields 1 Data Sources

Accrual Subobject Item

C_AccrEngineAccrSubobjItemTP is a Consumption CDS View that provides data about "Accrual Subobject Item" in SAP S/4HANA. It reads from 1 data source (R_AccrEngineAccrSubobjItemTP) and exposes 71 fields with key fields AccrualEngineAccrualObjectType, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject.

Data Sources (1)

SourceAliasJoin Type
R_AccrEngineAccrSubobjItemTP R_AccrEngineAccrSubobjItemTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accrual Subobject Item view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (71)

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
AccrualItemTypeForEdit AccrualItemTypeForEdit Accr Item Type
LedgerGroup LedgerGroup Ledger Group
AccrPerdcPostingFrequency AccrPerdcPostingFrequency Posting Freqncy
AccrPerdcPostingFrequencyName AccrPerdcPostingFrequencyName Frequency Text
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 PlanAccrualMethod Plnd Accr. Method
ActualAccrualItemType ActualAccrualItemType Actl Costs Item Type
ActualAccrualMethod ActualAccrualMethod Actl Accr. Method
DeferralItemType DeferralItemType Deferral Item Type
DeferralMethod DeferralMethod Deferral Method
TotalAccrualQuantity TotalAccrualQuantity Total Qty to Accrue
TotalAccrualQuantityUnit TotalAccrualQuantityUnit Unit of Measure
TotalAccrAmountInTransCrcy TotalAccrAmountInTransCrcy Total A/D Amt (TC)
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
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
AccrualItemTypeNamelocalized
_AccrCompanyCode _AccrCompanyCode
_AccrItemType _AccrItemType
_AccrLogicalSystem _AccrLogicalSystem
_AccrMethod _AccrMethod
_AccrObj _AccrObj
_AccrObjectType _AccrObjectType
_AccrSubobj _AccrSubobj
_ActualAccrItemType _ActualAccrItemType
_PerdcPostgFrqcy _PerdcPostgFrqcy
_ActualAccrMethod _ActualAccrMethod
_ActualItem _ActualItem
_BaseUnit _BaseUnit
_ClsgPostgAccrAccount _ClsgPostgAccrAccount
_ClsgPostgDocumentType _ClsgPostgDocumentType
_ClsgPostgOffstgAccount _ClsgPostgOffstgAccount
_CompanyCodeCurrency _CompanyCodeCurrency
_DeferralItem _DeferralItem
_DeferralItemType _DeferralItemType
_DeferralMethod _DeferralMethod
_GlobalCurrency _GlobalCurrency
_Ledger _Ledger
_OpngPostgAccrAccount _OpngPostgAccrAccount
_OpngPostgDocumentType _OpngPostgDocumentType
_OpngPostgOffstgAccount _OpngPostgOffstgAccount
_PerdcPostgAccrAccount _PerdcPostgAccrAccount
_PerdcPostgDocumentType _PerdcPostgDocumentType
_PerdcPostgOffstgAccount _PerdcPostgOffstgAccount
_PlanAccrItemType _PlanAccrItemType
_PlanAccrMethod _PlanAccrMethod
_PlanItem _PlanItem
_TransactionCurrency _TransactionCurrency

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_AccrEngineAccrSubobjItemTP.
-- 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: CACESOITEMTP

CREATE VIEW C_AccrEngineAccrSubobjItemTP AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrSubobjectItmValdtyEndDte,
  AccrualItemTypeForEdit,
  LedgerGroup,
  AccrPerdcPostingFrequency,
  AccrPerdcPostingFrequencyName,
  AccrSubobjectItmValdtyStrtDte,
  AccrualMethod,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  AccrualItemIsObsolete,
  PlanAccrualItemType,
  PlanAccrualMethod,
  ActualAccrualItemType,
  ActualAccrualMethod,
  DeferralItemType,
  DeferralMethod,
  TotalAccrualQuantity,
  TotalAccrualQuantityUnit,
  TotalAccrAmountInTransCrcy,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  AccrOpngPostgDocumentType,
  AccrPerdcPostgDocumentType,
  AccrClsgPostgDocumentType,
  AccrOpngPostgAccrAccount,
  AccrOpngPostgOffstgAccount,
  AccrPerdcPostgAccrAccount,
  AccrPerdcPostgOffstgAcct,
  AccrClsgPostgAccrAccount,
  AccrClsgPostgOffstgAccount,
  AccrualItemLastChangeDateTime,
  _AccrItemType._Text.AccrualItemTypeName : localized AS AccrualItemTypeNamelocalized
FROM R_AccrEngineAccrSubobjItemTP
;

Learn More