C_REIntegObjectPlanActualQ

DDL: C_REINTEGOBJECTPLANACTUALQ SQL: CREINTEGOBJPLACQ Type: view CONSUMPTION
50 Fields 1 Data Sources

Real Estate Objects Plan Actual - Qry

C_REIntegObjectPlanActualQ is a Consumption CDS View that provides data about "Real Estate Objects Plan Actual - Qry" in SAP S/4HANA. It reads from 1 data source (I_REIntegObjectCtrlgPlanActual) and exposes 50 fields.

Data Sources (1)

SourceAliasJoin Type
I_REIntegObjectCtrlgPlanActual _ActualPlanJournalEntryItem from

Parameters (5)

NameTypeDefault
P_PlanningCategory fcom_category
P_Language sylangu
P_BusinessUser syuname
P_ControllingArea kokrs
P_Ledger fins_ledger

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CREINTEGOBJPLACQ view
EndUserText.label Real Estate Objects Plan Actual - 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 (50)

KeyFieldSource TableSource FieldDescription
resultElementControllingArea
resultElementLedger
CompanyCode
GLAccount GLAccount General Ledger
GLAccountName
FREEFiscalPeriod
FiscalYear I_REIntegObjectCtrlgPlanActual 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
REIntegrationObjectNumberSite Site
REIntegrationObjectNumberLvl1 REIntegrationObjectNumberBldng Building/Land
REOccupancyObjectNumber REOccupancyObjectNumber Occupancy Group
RealEstateServiceGroupNumber RealEstateServiceGroupNumber Service Group
RECostSettlementServiceDate RECostSettlementServiceDate
RECostCategory RECostCategory Cost Category
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 I_REIntegObjectCtrlgPlanActual AccountingDocument Journal Entry
LedgerGLLineItem I_REIntegObjectCtrlgPlanActual 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_REIntegObjectPlanActualQ.
-- 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: CREINTEGOBJPLACQ
-- Parameters: P_PlanningCategory : fcom_category, P_Language : sylangu, P_BusinessUser : syuname, P_ControllingArea : kokrs, P_Ledger : fins_ledger

CREATE VIEW C_REIntegObjectPlanActualQ AS
SELECT
  resultElement: 'ControllingArea' AS resultElementControllingArea,
  resultElement: 'Ledger' AS resultElementLedger,
  binding: [ { targetElement : 'IsLeadingLedger' , type : #CONSTANT, value : 'X' AS CompanyCode,
  GLAccount,
  _GLAccountInChartOfAccounts._Text[1:Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  _ActualPlanJournalEntryItem.FiscalYear AS FiscalYear,
  FiscalYearPeriod,
  FiscalYearVariant,
  CompanyCodeCurrency,
  ProfitCenter,
  ControllingArea,
  REIntegrationObjectNumberBldng AS REIntegrationObjectNumberLvl1,
  REOccupancyObjectNumber,
  RealEstateServiceGroupNumber,
  RECostSettlementServiceDate,
  RECostCategory,
  AccountAssignmentType,
  CostCtrActivityType,
  CostCenter,
  CostSourceUnit,
  Customer,
  CustomerGroup,
  ControllingDebitCreditCode,
  FunctionalArea,
  GlobalCurrency,
  _ActualPlanJournalEntryItem.AccountingDocument AS AccountingDocument,
  _ActualPlanJournalEntryItem.LedgerGLLineItem AS 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_REIntegObjectCtrlgPlanActual AS _ActualPlanJournalEntryItem
;

Learn More