P_AccrEngnAccrSimlnEntryItem

DDL: P_ACCRENGNACCRSIMLNENTRYITEM Type: view_entity COMPOSITE Package: ODATA_GL_ACE_DSP_ACCR_OBJ
14 Fields 1 Data Sources 1 Associations

Accrual Simulation Entry Item

P_AccrEngnAccrSimlnEntryItem is a Composite CDS View that provides data about "Accrual Simulation Entry Item" in SAP S/4HANA. It reads from 1 data source (I_FinancialPlanningEntryItem) and exposes 14 fields with key fields FinancialPlanningReqTransSqnc, FinancialPlanningDataPacket, FinancialPlanningEntryItem. It has 1 association to related views. Part of development package ODATA_GL_ACE_DSP_ACCR_OBJ.

Data Sources (1)

SourceAliasJoin Type
I_FinancialPlanningEntryItem I_FinancialPlanningEntryItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PlanningCategory _PlanningCategoryForAccrual $projection.PlanningCategory = _PlanningCategoryForAccrual.PlanningCategory

Annotations (7)

NameValueLevelField
EndUserText.label Accrual Simulation Entry Item view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem Object GUID
AccrualObjectType AccrualObjectType Accrual Object Type
AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
CompanyCode CompanyCode Receiver Company Code
AccrualObject AccrualObject External Reference of Accrual Object
AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
AccrualItemType AccrualItemType Accrual Item Type
Ledger Ledger Ledger
PlanningCategory PlanningCategory Plan Category
FiscalYearPeriod FiscalYearPeriod Period/Year
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency

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 P_AccrEngnAccrSimlnEntryItem.
-- 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 P_AccrEngnAccrSimlnEntryItem AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  AccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  PlanningCategory,
  FiscalYearPeriod,
  AmountInTransactionCurrency,
  TransactionCurrency
FROM I_FinancialPlanningEntryItem
LEFT OUTER JOIN I_PlanningCategory AS _PlanningCategoryForAccrual ON PlanningCategory = _PlanningCategoryForAccrual.PlanningCategory  -- association [0..1]
;

Learn More