R_MnlAccrsAccrSubobjAssgmtTP

DDL: R_MNLACCRSACCRSUBOBJASSGMTTP SQL: RACACSOASSGMTTP Type: view_entity TRANSACTIONAL
32 Fields 1 Data Sources 1 Associations

Accrual Subobject Account Assignment

R_MnlAccrsAccrSubobjAssgmtTP is a Transactional CDS View that provides data about "Accrual Subobject Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_AccrEngineAccrSubobjAssgmt) and exposes 32 fields with key fields AccrualEngineAccrualObjectType, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_AccrEngineAccrSubobjAssgmt _Assgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_AccrEngineAccrSubobjAssgmt _Extension $projection.AccrualEngineAccrualObjectType = _Extension.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _Extension.AccrualObjectLogicalSystem and $projection.CompanyCode = _Extension.CompanyCode and $projection.AccrualObject = _Extension.AccrualObject and $projection.AccrualSubobject = _Extension.AccrualSubobject and $projection.AccrAcctAssgmtValdtyEndDte = _Extension.AccrAcctAssgmtValdtyEndDte

Annotations (8)

NameValueLevelField
EndUserText.label Accrual Subobject Account Assignment view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK 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 #M view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType I_AccrEngineAccrSubobjAssgmt AccrualEngineAccrualObjectType Component
KEY AccrualObjectLogicalSystem I_AccrEngineAccrSubobjAssgmt AccrualObjectLogicalSystem Logical System
KEY CompanyCode I_AccrEngineAccrSubobjAssgmt CompanyCode Receiver Company Code
KEY AccrualObject I_AccrEngineAccrSubobjAssgmt AccrualObject External Reference of Accrual Object
KEY AccrualSubobject I_AccrEngineAccrSubobjAssgmt AccrualSubobject External Reference of Accrual Subobject
KEY AccrAcctAssgmtValdtyEndDte I_AccrEngineAccrSubobjAssgmt AccrAcctAssgmtValdtyEndDte Validity End Date
AccrAcctAssgmtValdtyStrtDte I_AccrEngineAccrSubobjAssgmt AccrAcctAssgmtValdtyStrtDte Validity Start Date
BusinessArea I_AccrEngineAccrSubobjAssgmt BusinessArea Business Area
ProfitCenter I_AccrEngineAccrSubobjAssgmt ProfitCenter Profit Center
Segment I_AccrEngineAccrSubobjAssgmt Segment Segment number
Fund I_AccrEngineAccrSubobjAssgmt Fund Sender Fund
FundsCenter I_AccrEngineAccrSubobjAssgmt FundsCenter Funds Center
CommitmentItemInternalId I_AccrEngineAccrSubobjAssgmt CommitmentItemInternalId
FunctionalArea I_AccrEngineAccrSubobjAssgmt FunctionalArea Sendr Fctl Area
GrantID I_AccrEngineAccrSubobjAssgmt GrantID Sender Grant
FundedProgram I_AccrEngineAccrSubobjAssgmt FundedProgram Funded Program
BudgetPeriod I_AccrEngineAccrSubobjAssgmt BudgetPeriod Budget Period
CostCenter I_AccrEngineAccrSubobjAssgmt CostCenter Cost Center
OrderID I_AccrEngineAccrSubobjAssgmt OrderID Order ID
WBSElementInternalID I_AccrEngineAccrSubobjAssgmt WBSElementInternalID WBS Internal ID
CostObject I_AccrEngineAccrSubobjAssgmt CostObject Cost Object
CostCtrActivityType I_AccrEngineAccrSubobjAssgmt CostCtrActivityType Activity Type
ProjectNetworkObject I_AccrEngineAccrSubobjAssgmt ProjectNetworkObject Network
ProjectNetworkInternalID I_AccrEngineAccrSubobjAssgmt ProjectNetworkInternalID Plan No.f.Oper.
BusinessProcess I_AccrEngineAccrSubobjAssgmt BusinessProcess Business Process
SalesOrder I_AccrEngineAccrSubobjAssgmt SalesOrder SD Document
SalesOrderItem I_AccrEngineAccrSubobjAssgmt SalesOrderItem Sales Order Item
ProfitabilitySegment I_AccrEngineAccrSubobjAssgmt ProfitabilitySegment Profitability Segment
ControllingArea I_AccrEngineAccrSubobjAssgmt ControllingArea Controlling Area
FinancialManagementArea I_AccrEngineAccrSubobjAssgmt FinancialManagementArea FM Area
AccrSubobjLastChangeDateTime _ManualAccrual AccrSubobjLastChangeDateTime
_ManualAccrual _ManualAccrual

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_MnlAccrsAccrSubobjAssgmtTP.
-- 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: RACACSOASSGMTTP

CREATE VIEW R_MnlAccrsAccrSubobjAssgmtTP AS
SELECT
  _Assgmt.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  _Assgmt.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  _Assgmt.CompanyCode AS CompanyCode,
  _Assgmt.AccrualObject AS AccrualObject,
  _Assgmt.AccrualSubobject AS AccrualSubobject,
  _Assgmt.AccrAcctAssgmtValdtyEndDte AS AccrAcctAssgmtValdtyEndDte,
  _Assgmt.AccrAcctAssgmtValdtyStrtDte AS AccrAcctAssgmtValdtyStrtDte,
  _Assgmt.BusinessArea AS BusinessArea,
  _Assgmt.ProfitCenter AS ProfitCenter,
  _Assgmt.Segment AS Segment,
  _Assgmt.Fund AS Fund,
  _Assgmt.FundsCenter AS FundsCenter,
  _Assgmt.CommitmentItemInternalId AS CommitmentItemInternalId,
  _Assgmt.FunctionalArea AS FunctionalArea,
  _Assgmt.GrantID AS GrantID,
  _Assgmt.FundedProgram AS FundedProgram,
  _Assgmt.BudgetPeriod AS BudgetPeriod,
  _Assgmt.CostCenter AS CostCenter,
  _Assgmt.OrderID AS OrderID,
  _Assgmt.WBSElementInternalID AS WBSElementInternalID,
  _Assgmt.CostObject AS CostObject,
  _Assgmt.CostCtrActivityType AS CostCtrActivityType,
  _Assgmt.ProjectNetworkObject AS ProjectNetworkObject,
  _Assgmt.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  _Assgmt.BusinessProcess AS BusinessProcess,
  _Assgmt.SalesOrder AS SalesOrder,
  _Assgmt.SalesOrderItem AS SalesOrderItem,
  _Assgmt.ProfitabilitySegment AS ProfitabilitySegment,
  _Assgmt.ControllingArea AS ControllingArea,
  _Assgmt.FinancialManagementArea AS FinancialManagementArea,
  _ManualAccrual.AccrSubobjLastChangeDateTime AS AccrSubobjLastChangeDateTime
FROM I_AccrEngineAccrSubobjAssgmt AS _Assgmt
LEFT OUTER JOIN E_AccrEngineAccrSubobjAssgmt AS _Extension ON AccrualEngineAccrualObjectType = _Extension.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _Extension.AccrualObjectLogicalSystem AND CompanyCode = _Extension.CompanyCode AND AccrualObject = _Extension.AccrualObject AND AccrualSubobject = _Extension.AccrualSubobject AND AccrAcctAssgmtValdtyEndDte = _Extension.AccrAcctAssgmtValdtyEndDte  -- association [1..1]
;

Learn More