C_REAcctgObjectPlanActualQ

DDL: C_REACCTGOBJECTPLANACTUALQ SQL: CREACCOBJPLNACTQ Type: view CONSUMPTION
51 Fields 1 Data Sources

RE Accounting Objects Plan/Actuals - Qry

C_REAcctgObjectPlanActualQ is a Consumption CDS View that provides data about "RE Accounting Objects Plan/Actuals - Qry" in SAP S/4HANA. It reads from 1 data source (I_ActualPlanJournalEntryItem) and exposes 51 fields.

Data Sources (1)

SourceAliasJoin Type
I_ActualPlanJournalEntryItem I_ActualPlanJournalEntryItem from

Parameters (6)

NameTypeDefault
P_PlanningCategory fcom_category
P_KeyDate vdm_v_key_date
P_Language sylangu
P_BusinessUser syuname
P_ControllingArea kokrs
P_Ledger fins_ledger

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CREACCOBJPLNACTQ view
EndUserText.label RE Accounting Objects Plan/Actuals - Qry view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.settings.maxProcessingEffort #HIGH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Analytics.query true view
OData.publish true view
Metadata.ignorePropagatedAnnotations true view

Fields (51)

KeyFieldSource TableSource FieldDescription
resultElementControllingArea
resultElementLedger
GLAccount GLAccount General Ledger
GLAccountName
FREEFiscalPeriod
FiscalYear FiscalYear G/L Fiscal Year
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant FiscalYearVariant FY Variant
ChartOfAccounts
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
REBusinessEntity
RealEstateBuilding RealEstateBuilding Building
RealEstateProperty RealEstateProperty Land
RERentalObject RERentalObject
RealEstateContract RealEstateContract Real Estate Contract
REServiceChargeKey REServiceChargeKey
RESettlementUnitID RESettlementUnitID
SettlementReferenceDate SettlementReferenceDate Reference date
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
BusinessTransactionType
CostCtrActivityType CostCtrActivityType Activity Type
CostCenter CostCenter Cost Center
CostSourceUnit CostSourceUnit
Customer Customer Sold-to Party
CustomerGroup CustomerGroup Customer Group
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
FunctionalArea FunctionalArea Sendr Fctl Area
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AccountingDocument AccountingDocument Journal Entry
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
LedgerFiscalYear LedgerFiscalYear
OrderID OrderID Order ID
PlanningCategory PlanningCategory Plan Category
PostingDate PostingDate Posting Date for GR
ProjectExternalID ProjectExternalID Project def.
Segment Segment Segment number
PartnerCompany PartnerCompany Trading Partner
TransactionCurrency TransactionCurrency Transaction Currency
WBSElementExternalID WBSElementExternalID WBS Element External ID
IsStatisticalOrder IsStatisticalOrder Statistical Order
IsStatisticalCostCenter IsStatisticalCostCenter Cost Center Is Stat.
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
DifferenceAmtInTransCrcy 1 Difference Actual Plan in Trans Crcy
TransCrcyDifferencePct 1 Difference (%) TC
DifferenceAmtInCoCodeCrcy 1 Difference Actual Plan in CC Crcy
CoCodeCrcyDifferencePct 1 Difference (%) CC
DifferenceAmtInGlobalCrcy 0 Difference Actual Plan in Global Crcy
GlobalCrcyDifferencePct 1 Difference (%) GC
ValuationQuantity ValuationQuantity

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_REAcctgObjectPlanActualQ.
-- 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: CREACCOBJPLNACTQ
-- Parameters: P_PlanningCategory : fcom_category, P_KeyDate : vdm_v_key_date, P_Language : sylangu, P_BusinessUser : syuname, P_ControllingArea : kokrs, P_Ledger : fins_ledger

CREATE VIEW C_REAcctgObjectPlanActualQ AS
SELECT
  resultElement: 'ControllingArea' AS resultElementControllingArea,
  resultElement: 'Ledger' AS resultElementLedger,
  GLAccount,
  _GLAccountInChartOfAccounts._Text[1:Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  FiscalYear,
  FiscalYearPeriod,
  FiscalYearVariant,
  CompanyCodeCurrency,
  ProfitCenter,
  ControllingArea,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate,
  AccountAssignmentType,
  CostCtrActivityType,
  CostCenter,
  CostSourceUnit,
  Customer,
  CustomerGroup,
  ControllingDebitCreditCode,
  FunctionalArea,
  GlobalCurrency,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  OrderID,
  PlanningCategory,
  PostingDate,
  ProjectExternalID,
  Segment,
  PartnerCompany,
  TransactionCurrency,
  WBSElementExternalID,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  WBSIsStatisticalWBSElement,
  1 AS DifferenceAmtInTransCrcy,
  1 AS TransCrcyDifferencePct,
  1 AS DifferenceAmtInCoCodeCrcy,
  1 AS CoCodeCrcyDifferencePct,
  0 AS DifferenceAmtInGlobalCrcy,
  1 AS GlobalCrcyDifferencePct,
  ValuationQuantity
FROM I_ActualPlanJournalEntryItem
;

Learn More