I_Trrmanaccruals

DDL: I_TRRMANACCRUALS SQL: ITRRMANACCRUALS Type: view COMPOSITE

Revn.Recn.Mon. Manual Accruals

I_Trrmanaccruals is a Composite CDS View that provides data about "Revn.Recn.Mon. Manual Accruals" in SAP S/4HANA. It reads from 1 data source (P_Trrmanaccruals) and exposes 15 fields with key fields WBSElementInternalID, CompanyCode, Ledger, AssignmentRule, ChartOfAccounts.

Data Sources (1)

SourceAliasJoin Type
P_Trrmanaccruals calc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITRRMANACCRUALS view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Revn.Recn.Mon. Manual Accruals view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
KEY CompanyCode CompanyCode Receiver Company Code
KEY Ledger Ledger Ledger
KEY AssignmentRule AssignmentRule
KEY ChartOfAccounts ChartOfAccounts Node Class
KEY ValueUsage ValueUsage
KEY AssignmentSource AssignmentSource
KEY AccruedValuesAccount AccruedValuesAccount
KEY RecognizedValuesAccount RecognizedValuesAccount
WBSElement WBSElement WBS Internal ID
ResultAnalysisInternalID ResultAnalysisInternalID Results Analysis Key
AccrualAmtInCCCrcy AccrualAmtInCCCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
FiscalPeriod FiscalPeriod Tax period
FiscalYear FiscalYear G/L Fiscal Year

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_Trrmanaccruals.
-- 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: ITRRMANACCRUALS

CREATE VIEW I_Trrmanaccruals AS
SELECT
  WBSElementInternalID,
  CompanyCode,
  Ledger,
  AssignmentRule,
  ChartOfAccounts,
  ValueUsage,
  AssignmentSource,
  AccruedValuesAccount,
  RecognizedValuesAccount,
  WBSElement,
  ResultAnalysisInternalID,
  AccrualAmtInCCCrcy,
  CompanyCodeCurrency,
  FiscalPeriod,
  FiscalYear
FROM P_Trrmanaccruals AS calc
;