What is R_MnlAccrsAccrSubobjItemTP in SAP S/4HANA?

R_MnlAccrsAccrSubobjItemTP is a transactional CDS view in SAP S/4HANA. Accrual Subobject Item It contains 51 fields.

Which tables does R_MnlAccrsAccrSubobjItemTP read from?

R_MnlAccrsAccrSubobjItemTP reads data from: I_AccrEngineAccrSubobjRawItem.

What VDM layer is R_MnlAccrsAccrSubobjItemTP?

R_MnlAccrsAccrSubobjItemTP is classified as a Transactional view that supports create, update, and delete operations.

R_MnlAccrsAccrSubobjItemTP

DDL: R_MNLACCRSACCRSUBOBJITEMTP SQL: RACACSOITEMTP Type: view_entity TRANSACTIONAL

51 Fields 1 Data Sources 2 Associations

Accrual Subobject Item

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

Data Sources (1)

Source	Alias	Join Type
I_AccrEngineAccrSubobjRawItem	_Item	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	R_MnlAccrsAccrPerdcAmountsTP	_AccrPerdcAmounts	$projection.AccrualEngineAccrualObjectType = _AccrPerdcAmounts.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _AccrPerdcAmounts.AccrualObjectLogicalSystem and $projection.CompanyCode = _AccrPerdcAmounts.CompanyCode and $projection.AccrualObject = _AccrPerdcAmounts.AccrualObject and $projection.AccrualSubobject = _AccrPerdcAmounts.AccrualSubobject and $projection.AccrualItemType = _AccrPerdcAmounts.AccrualItemType and $projection.Ledger = _AccrPerdcAmounts.Ledger and $projection.AccrSubobjectItmValdtyEndDte >= _AccrPerdcAmounts.AccrualPeriodEndDate and $projection.AccrSubobjectItmValdtyStrtDte <= _AccrPerdcAmounts.AccrualPeriodEndDate
[0..1]	I_AccrItemTypeForLedgerGroup	_AccrLedgerGroup	`$projection.AccrualEngineAccrualObjectType = _AccrLedgerGroup.AccrualEngineApplication and $projection.CompanyCode = _AccrLedgerGroup.CompanyCode and $projection.AccrualItemType = _AccrLedgerGroup.AccrualItemType and $projection.Ledger = _AccrLedgerGroup.Ledger`

Annotations (8)

Name	Value	Level
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Accrual Subobject Item	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view

Fields (51)

Key	Field	Source Table	Source Field	Description
KEY	AccrualEngineAccrualObjectType	I_AccrEngineAccrSubobjRawItem	AccrualEngineAccrualObjectType	Component
KEY	AccrualObjectLogicalSystem	I_AccrEngineAccrSubobjRawItem	AccrualObjectLogicalSystem	Logical System
KEY	CompanyCode	I_AccrEngineAccrSubobjRawItem	CompanyCode	Receiver Company Code
KEY	AccrualObject	I_AccrEngineAccrSubobjRawItem	AccrualObject	External Reference of Accrual Object
KEY	AccrualSubobject	I_AccrEngineAccrSubobjRawItem	AccrualSubobject	External Reference of Accrual Subobject
KEY	AccrualItemType	I_AccrEngineAccrSubobjRawItem	AccrualItemType	Accrual Item Type
KEY	Ledger	I_AccrEngineAccrSubobjRawItem	Ledger	Ledger
KEY	AccrSubobjectItmValdtyEndDte	I_AccrEngineAccrSubobjRawItem	AccrSubobjectItmValdtyEndDte	To
	AccrSubobjectItmValdtyStrtDte	I_AccrEngineAccrSubobjRawItem	AccrSubobjectItmValdtyStrtDte	From
	AccrualMethod	I_AccrEngineAccrSubobjRawItem	AccrualMethod	Accr/Defrl Method
	AccrSubobjHdrStartOfLifeDate	I_AccrEngineAccrSubobjRawItem	AccrSubobjHdrStartOfLifeDate	Start of Life
	AccrSubobjHdrEndOfLifeDate	I_AccrEngineAccrSubobjRawItem	AccrSubobjHdrEndOfLifeDate	End of Life
	AccrualItemIsObsolete	I_AccrEngineAccrSubobjRawItem	AccrualItemIsObsolete	Obsolete
	LedgerGroup	_AccrLedgerGroup	LedgerGroup	Ledger Group
	TotalAccrualQuantity	I_AccrEngineAccrSubobjRawItem	TotalAccrualQuantity	Total Qty to Accrue
	TotalAccrualQuantityUnit	I_AccrEngineAccrSubobjRawItem	TotalAccrualQuantityUnit	Unit of Measure
	TotalAccrAmountInTransCrcy	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInTransCrcy	Total A/D Amt (TC)
	TotalAccrAmtInCompanyCodeCrcy	I_AccrEngineAccrSubobjRawItem	TotalAccrAmtInCompanyCodeCrcy	Total A/D Amt (CC)
	TotalAccrAmountInGlobalCrcy	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInGlobalCrcy	Total A/D Amt (GC)
	TotalAccrAmountInFreeDfndCrcy1	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInFreeDfndCrcy1	Total A/D Amt (FC1)
	TotalAccrAmountInFreeDfndCrcy2	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInFreeDfndCrcy2	Total A/D Amt (FC2)
	TotalAccrAmountInFreeDfndCrcy3	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInFreeDfndCrcy3	Total A/D Amt (FC3)
	TotalAccrAmountInFreeDfndCrcy4	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInFreeDfndCrcy4	Total A/D Amt (FC4)
	TotalAccrAmountInFreeDfndCrcy5	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInFreeDfndCrcy5	Total A/D Amt (FC5)
	TotalAccrAmountInFreeDfndCrcy6	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInFreeDfndCrcy6	Total A/D Amt (FC6)
	TotalAccrAmountInFreeDfndCrcy7	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInFreeDfndCrcy7	Total A/D Amt (FC7)
	TotalAccrAmountInFreeDfndCrcy8	I_AccrEngineAccrSubobjRawItem	TotalAccrAmountInFreeDfndCrcy8	Total A/D Amt (FC8)
	TransactionCurrency	I_AccrEngineAccrSubobjRawItem	TransactionCurrency	Transaction Currency
	CompanyCodeCurrency	I_AccrEngineAccrSubobjRawItem	CompanyCodeCurrency	Local Currency
	GlobalCurrency	I_AccrEngineAccrSubobjRawItem	GlobalCurrency	GM Billing Element: Global Currency
	FreeDefinedCurrency1	I_AccrEngineAccrSubobjRawItem	FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2	I_AccrEngineAccrSubobjRawItem	FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3	I_AccrEngineAccrSubobjRawItem	FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4	I_AccrEngineAccrSubobjRawItem	FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5	I_AccrEngineAccrSubobjRawItem	FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6	I_AccrEngineAccrSubobjRawItem	FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7	I_AccrEngineAccrSubobjRawItem	FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8	I_AccrEngineAccrSubobjRawItem	FreeDefinedCurrency8	Freely Defined Currency 8
	AccrOpngPostgDocumentType	I_AccrEngineAccrSubobjRawItem	AccrOpngPostgDocumentType	Document Type
	AccrPerdcPostgDocumentType	I_AccrEngineAccrSubobjRawItem	AccrPerdcPostgDocumentType	Document Type
	AccrClsgPostgDocumentType	I_AccrEngineAccrSubobjRawItem	AccrClsgPostgDocumentType	Document Type
	AccrOpngPostgAccrAccount	I_AccrEngineAccrSubobjRawItem	AccrOpngPostgAccrAccount	Accr./Dfrl Acct
	AccrOpngPostgOffstgAccount	I_AccrEngineAccrSubobjRawItem	AccrOpngPostgOffstgAccount	Offsetting Account
	AccrPerdcPostgAccrAccount	I_AccrEngineAccrSubobjRawItem	AccrPerdcPostgAccrAccount	Accr./Dfrl. Account
	AccrPerdcPostgOffstgAcct	I_AccrEngineAccrSubobjRawItem	AccrPerdcPostgOffstgAcct	Offsetting Account
	AccrClsgPostgAccrAccount	I_AccrEngineAccrSubobjRawItem	AccrClsgPostgAccrAccount	Accr./Dfrl Acct
	AccrClsgPostgOffstgAccount	I_AccrEngineAccrSubobjRawItem	AccrClsgPostgOffstgAccount	Offsetting Account
	AccrSubobjLastChangeDateTime	_ManualAccrual	AccrSubobjLastChangeDateTime
	_AccrLedgerGroup		_AccrLedgerGroup
	_ManualAccrual		_ManualAccrual
	_AccrPerdcAmounts		_AccrPerdcAmounts

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 R_MnlAccrsAccrSubobjItemTP.
-- 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: RACACSOITEMTP

CREATE VIEW R_MnlAccrsAccrSubobjItemTP AS
SELECT
  _Item.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  _Item.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  _Item.CompanyCode AS CompanyCode,
  _Item.AccrualObject AS AccrualObject,
  _Item.AccrualSubobject AS AccrualSubobject,
  _Item.AccrualItemType AS AccrualItemType,
  _Item.Ledger AS Ledger,
  _Item.AccrSubobjectItmValdtyEndDte AS AccrSubobjectItmValdtyEndDte,
  _Item.AccrSubobjectItmValdtyStrtDte AS AccrSubobjectItmValdtyStrtDte,
  _Item.AccrualMethod AS AccrualMethod,
  _Item.AccrSubobjHdrStartOfLifeDate AS AccrSubobjHdrStartOfLifeDate,
  _Item.AccrSubobjHdrEndOfLifeDate AS AccrSubobjHdrEndOfLifeDate,
  _Item.AccrualItemIsObsolete AS AccrualItemIsObsolete,
  _AccrLedgerGroup.LedgerGroup AS LedgerGroup,
  _Item.TotalAccrualQuantity AS TotalAccrualQuantity,
  _Item.TotalAccrualQuantityUnit AS TotalAccrualQuantityUnit,
  _Item.TotalAccrAmountInTransCrcy AS TotalAccrAmountInTransCrcy,
  _Item.TotalAccrAmtInCompanyCodeCrcy AS TotalAccrAmtInCompanyCodeCrcy,
  _Item.TotalAccrAmountInGlobalCrcy AS TotalAccrAmountInGlobalCrcy,
  _Item.TotalAccrAmountInFreeDfndCrcy1 AS TotalAccrAmountInFreeDfndCrcy1,
  _Item.TotalAccrAmountInFreeDfndCrcy2 AS TotalAccrAmountInFreeDfndCrcy2,
  _Item.TotalAccrAmountInFreeDfndCrcy3 AS TotalAccrAmountInFreeDfndCrcy3,
  _Item.TotalAccrAmountInFreeDfndCrcy4 AS TotalAccrAmountInFreeDfndCrcy4,
  _Item.TotalAccrAmountInFreeDfndCrcy5 AS TotalAccrAmountInFreeDfndCrcy5,
  _Item.TotalAccrAmountInFreeDfndCrcy6 AS TotalAccrAmountInFreeDfndCrcy6,
  _Item.TotalAccrAmountInFreeDfndCrcy7 AS TotalAccrAmountInFreeDfndCrcy7,
  _Item.TotalAccrAmountInFreeDfndCrcy8 AS TotalAccrAmountInFreeDfndCrcy8,
  _Item.TransactionCurrency AS TransactionCurrency,
  _Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Item.GlobalCurrency AS GlobalCurrency,
  _Item.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _Item.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _Item.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _Item.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _Item.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _Item.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _Item.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _Item.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _Item.AccrOpngPostgDocumentType AS AccrOpngPostgDocumentType,
  _Item.AccrPerdcPostgDocumentType AS AccrPerdcPostgDocumentType,
  _Item.AccrClsgPostgDocumentType AS AccrClsgPostgDocumentType,
  _Item.AccrOpngPostgAccrAccount AS AccrOpngPostgAccrAccount,
  _Item.AccrOpngPostgOffstgAccount AS AccrOpngPostgOffstgAccount,
  _Item.AccrPerdcPostgAccrAccount AS AccrPerdcPostgAccrAccount,
  _Item.AccrPerdcPostgOffstgAcct AS AccrPerdcPostgOffstgAcct,
  _Item.AccrClsgPostgAccrAccount AS AccrClsgPostgAccrAccount,
  _Item.AccrClsgPostgOffstgAccount AS AccrClsgPostgOffstgAccount,
  _ManualAccrual.AccrSubobjLastChangeDateTime AS AccrSubobjLastChangeDateTime
FROM I_AccrEngineAccrSubobjRawItem AS _Item
LEFT OUTER JOIN R_MnlAccrsAccrPerdcAmountsTP AS _AccrPerdcAmounts ON AccrualEngineAccrualObjectType = _AccrPerdcAmounts.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrPerdcAmounts.AccrualObjectLogicalSystem AND CompanyCode = _AccrPerdcAmounts.CompanyCode AND AccrualObject = _AccrPerdcAmounts.AccrualObject AND AccrualSubobject = _AccrPerdcAmounts.AccrualSubobject AND AccrualItemType = _AccrPerdcAmounts.AccrualItemType AND Ledger = _AccrPerdcAmounts.Ledger AND AccrSubobjectItmValdtyEndDte >= _AccrPerdcAmounts.AccrualPeriodEndDate AND AccrSubobjectItmValdtyStrtDte <= _AccrPerdcAmounts.AccrualPeriodEndDate  -- association [0..*]
LEFT OUTER JOIN I_AccrItemTypeForLedgerGroup AS _AccrLedgerGroup ON AccrualEngineAccrualObjectType = _AccrLedgerGroup.AccrualEngineApplication AND CompanyCode = _AccrLedgerGroup.CompanyCode AND AccrualItemType = _AccrLedgerGroup.AccrualItemType AND Ledger = _AccrLedgerGroup.Ledger  -- association [0..1]
;

Depth:

R_MnlAccrsAccrSubobjItemTP view_entity

I_AccrEngineAccrSubobjRawItem view

A_MnlAccrsAccrSubobjItem view_entity