C_MnlAccrsAccrSubobjItem

DDL: C_MNLACCRSACCRSUBOBJITEM Type: view_entity CONSUMPTION
63 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Manual Accruals Accrual Subobject Items

C_MnlAccrsAccrSubobjItem is a Consumption CDS View that provides data about "Manual Accruals Accrual Subobject Items" in SAP S/4HANA. It reads from 1 data source (R_MnlAccrsAccrSubobjItem) and exposes 63 fields with key fields CompanyCode, AccrualObject, AccrualSubobject, AccrualItemType, Ledger. It has 1 association to related views. It is exposed through 1 OData service (UI_MANUALACCRS_MNG). It is used in 1 Fiori application: Manage Manual Accruals.

Data Sources (1)

SourceAliasJoin Type
R_MnlAccrsAccrSubobjItem R_MnlAccrsAccrSubobjItem projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_MngMnlAccrsPerdcAmount _PerdcAmounts _PerdcAmounts.AccrualEngineAccrualObjectType = $projection.AccrualEngineAccrualObjectType and _PerdcAmounts.AccrualObjectLogicalSystem = '' and _PerdcAmounts.CompanyCode = $projection.CompanyCode and _PerdcAmounts.AccrualObject = $projection.AccrualObject and _PerdcAmounts.AccrualSubobject = $projection.AccrualSubobject and _PerdcAmounts.AccrualItemType = $projection.AccrualItemType and _PerdcAmounts.Ledger = $projection.Ledger

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Manual Accruals Accrual Subobject Items 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

OData Services (1)

ServiceBindingVersionContractRelease
UI_MANUALACCRS_MNG UI_MANUALACCRS_MNG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5423 Manage Manual Accruals Transactional With this app, you can create, import, edit, and copy accrual objects as well as change their status. You can use this app to: - Display and edit accrual objects. - Create new accrual objects. - Copy accrual objects. - Import accrual objects from a spreadsheet file. - Change the status of an accrual object by pausing, suspending, or resuming its accrual subobjects. - Prematurely finish accrual subobjects by terminating them or undo premature termination. - View the parameters assigned to an accrual object. - View a detailed summary of changes made to the accrual object, comparing the old and new values of the accrual object fields.

Manage Manual Accruals

Business Role: General Ledger Accountant

With this app, you can create, import, edit, and copy accrual objects as well as change their status.

Fields (63)

KeyFieldSource TableSource FieldDescription
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
CompanyCodeForEdit CompanyCodeForEdit Company Code
AccrualItemTypeForEdit AccrualItemTypeForEdit Accr Item Type
ValidityEndDateForEdit ValidityEndDateForEdit Valid To
AccrualEngineAccrualObjectType AccrualEngineAccrualObjectType Component
AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
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
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
AccrualItemTypeCategory AccrualItemTypeCategory
PlanAccrualItemType PlanAccrualItemType Plnd Costs Itm Type
ActualAccrualItemType ActualAccrualItemType Actl Costs Item Type
_AccrCompanyCode _AccrCompanyCode
_AccrItemType _AccrItemType
_AccrItemTypeForEdit _AccrItemTypeForEdit
_AccrLogicalSystem _AccrLogicalSystem
_AccrMethod _AccrMethod
_AccrObj _AccrObj
_AccrObjectType _AccrObjectType
_AccrSubobj _AccrSubobj
_PerdcPostgFrqcy _PerdcPostgFrqcy
_BaseUnit _BaseUnit
_ClsgPostgAccrAccount _ClsgPostgAccrAccount
_ClsgPostgDocumentType _ClsgPostgDocumentType
_ClsgPostgOffstgAccount _ClsgPostgOffstgAccount
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_Ledger _Ledger
_OpngPostgAccrAccount _OpngPostgAccrAccount
_OpngPostgDocumentType _OpngPostgDocumentType
_OpngPostgOffstgAccount _OpngPostgOffstgAccount
_PerdcPostgAccrAccount _PerdcPostgAccrAccount
_PerdcPostgDocumentType _PerdcPostgDocumentType
_PerdcPostgOffstgAccount _PerdcPostgOffstgAccount
_TransactionCurrency _TransactionCurrency
_PerdcAmounts _PerdcAmounts

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_MnlAccrsAccrSubobjItem.
-- 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.

CREATE VIEW C_MnlAccrsAccrSubobjItem AS
SELECT
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrSubobjectItmValdtyEndDte,
  CompanyCodeForEdit,
  AccrualItemTypeForEdit,
  ValidityEndDateForEdit,
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  LedgerGroup,
  AccrPerdcPostingFrequency,
  AccrPerdcPostingFrequencyName,
  AccrSubobjectItmValdtyStrtDte,
  AccrualMethod,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  AccrualItemIsObsolete,
  TotalAccrualQuantity,
  TotalAccrualQuantityUnit,
  TotalAccrAmountInTransCrcy,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  AccrOpngPostgDocumentType,
  AccrPerdcPostgDocumentType,
  AccrClsgPostgDocumentType,
  AccrOpngPostgAccrAccount,
  AccrOpngPostgOffstgAccount,
  AccrPerdcPostgAccrAccount,
  AccrPerdcPostgOffstgAcct,
  AccrClsgPostgAccrAccount,
  AccrClsgPostgOffstgAccount,
  AccrualItemLastChangeDateTime,
  _AccrItemType._Text.AccrualItemTypeName : localized AS AccrualItemTypeNamelocalized,
  AccrualItemTypeCategory,
  PlanAccrualItemType,
  ActualAccrualItemType
FROM R_MnlAccrsAccrSubobjItem
LEFT OUTER JOIN C_MngMnlAccrsPerdcAmount AS _PerdcAmounts ON _PerdcAmounts.AccrualEngineAccrualObjectType = AccrualEngineAccrualObjectType AND _PerdcAmounts.AccrualObjectLogicalSystem = '' AND _PerdcAmounts.CompanyCode = CompanyCode AND _PerdcAmounts.AccrualObject = AccrualObject AND _PerdcAmounts.AccrualSubobject = AccrualSubobject AND _PerdcAmounts.AccrualItemType = AccrualItemType AND _PerdcAmounts.Ledger = Ledger  -- association [0..*]
;

Learn More