I_REArchtrObjCostCtrPlnActlC

DDL: I_REARCHTROBJCOSTCTRPLNACTLC Type: view_entity COMPOSITE Package: VDM_RE_CO
100 Fields 2 Data Sources 5 Associations

RE AO Cost Center Plan Actual - Cube

I_REArchtrObjCostCtrPlnActlC is a Composite CDS View (Cube) that provides data about "RE AO Cost Center Plan Actual - Cube" in SAP S/4HANA. It reads from 2 data sources (I_ActualPlanJournalEntryItem, P_REArchtrObjAssgmtCalc2) and exposes 100 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 5 associations to related views. Part of development package VDM_RE_CO.

Data Sources (2)

SourceAliasJoin Type
I_ActualPlanJournalEntryItem _ActualPlanJournalEntryItem inner
P_REArchtrObjAssgmtCalc2 _REArchtrObjCtrlgObjAssgmt from

Associations (5)

CardinalityTargetAliasCondition
[0..1] P_REArchtrObjAssgmtCalc5 _REArchtrObjBuildingLandToSite $projection.REArchitectureObjectUUID = _REArchtrObjBuildingLandToSite.REArchitectureObjectUUID
[0..1] I_REGnrcRentalObjPortfolio _REGnrcRentalObjPortfolio $projection.REGnrcRentalObjPortfolioID = _REGnrcRentalObjPortfolio.REGnrcRentalObjPortfolioID
[1..1] I_REArchitectureObject _REArchitectureObject $projection.REArchitectureObjectUUID = _REArchitectureObject.REArchitectureObjectUUID
[1..1] I_REArchtrObjectBuildingLand _REArchtrObjectBuildingLand $projection.REArchitectureObjectUUID = _REArchtrObjectBuildingLand.REArchitectureObjectUUID
[1..1] I_REArchitectureObjectSite _REArchitectureObjectSite $projection.REArchitectureObjectParentUUID = _REArchitectureObjectSite.REArchitectureObjectUUID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
EndUserText.label RE AO Cost Center Plan Actual - Cube view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #COMPOSITE view

Fields (100)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_ActualPlanJournalEntryItem SourceLedger Source Ledger
KEY Ledger I_ActualPlanJournalEntryItem Ledger Ledger
KEY CompanyCode I_ActualPlanJournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear I_ActualPlanJournalEntryItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_ActualPlanJournalEntryItem AccountingDocument Journal Entry
KEY FinancialPlanningReqTransSqnc I_ActualPlanJournalEntryItem FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket I_ActualPlanJournalEntryItem FinancialPlanningDataPacket Data packet number
KEY ActualPlanJournalEntryItem I_ActualPlanJournalEntryItem ActualPlanJournalEntryItem
REArchitectureObjectNumberSite
REArchtrObjectSiteName _REArchtrObjBuildingLandToSite REArchitectureObjectSiteName
REArchitectureObjectParentUUID _REArchtrObjBuildingLandToSite REArchitectureObjectSiteUUID
REArchtrObjectNumberBldngLand P_REArchtrObjAssgmtCalc2 REArchtrObjectNumberBldngLand Building/Land Object Number
REArchtrObjectBldngLandName P_REArchtrObjAssgmtCalc2 REArchtrObjectBldngLandName
REArchitectureObjectUUID P_REArchtrObjAssgmtCalc2 REArchitectureObjectUUID UUID Architecture Object
REGenericRentalObjParentUUID P_REArchtrObjAssgmtCalc2 REGenericRentalObjParentUUID UUID Parent GO
REGnrcRentalObjPortfolioID P_REArchtrObjAssgmtCalc2 REGnrcRentalObjPortfolioID Portfolio ID
GLAccount
AccountingDocumentType I_ActualPlanJournalEntryItem AccountingDocumentType Journal Entry Type
FiscalPeriod
FiscalYearPeriod I_ActualPlanJournalEntryItem FiscalYearPeriod Period/Year
FiscalYearVariant I_ActualPlanJournalEntryItem FiscalYearVariant FY Variant
FiscalYearQuarter
FiscalQuarter
ChartOfAccounts
CompanyCodeCurrency I_ActualPlanJournalEntryItem CompanyCodeCurrency Local Currency
ProfitCenter I_ActualPlanJournalEntryItem ProfitCenter Profit Center
ControllingArea I_ActualPlanJournalEntryItem ControllingArea Controlling Area
AccountAssignmentType I_ActualPlanJournalEntryItem AccountAssignmentType Sndr AcctAssgmt Type
BusinessTransactionType
CostCtrActivityType I_ActualPlanJournalEntryItem CostCtrActivityType Activity Type
CostCenter I_ActualPlanJournalEntryItem CostCenter Cost Center
CostSourceUnit I_ActualPlanJournalEntryItem CostSourceUnit
Customer I_ActualPlanJournalEntryItem Customer Sold-to Party
CustomerGroup I_ActualPlanJournalEntryItem CustomerGroup Customer Group
ControllingDebitCreditCode I_ActualPlanJournalEntryItem ControllingDebitCreditCode Dr/Cr ind. CO
FunctionalArea I_ActualPlanJournalEntryItem FunctionalArea Sendr Fctl Area
GlobalCurrency I_ActualPlanJournalEntryItem GlobalCurrency GM Billing Element: Global Currency
LedgerGLLineItem I_ActualPlanJournalEntryItem LedgerGLLineItem Journal Entry Item
LedgerFiscalYear I_ActualPlanJournalEntryItem LedgerFiscalYear
OrderID I_ActualPlanJournalEntryItem OrderID Order ID
PlanningCategory I_ActualPlanJournalEntryItem PlanningCategory Plan Category
PostingDate I_ActualPlanJournalEntryItem PostingDate Posting Date for GR
ProjectExternalID I_ActualPlanJournalEntryItem ProjectExternalID Project def.
Segment I_ActualPlanJournalEntryItem Segment Segment number
PartnerCompany I_ActualPlanJournalEntryItem PartnerCompany Trading Partner
TransactionCurrency I_ActualPlanJournalEntryItem TransactionCurrency Transaction Currency
WBSElementExternalID I_ActualPlanJournalEntryItem WBSElementExternalID WBS Element External ID
BusinessArea I_ActualPlanJournalEntryItem BusinessArea Business Area
IsStatisticalOrder I_ActualPlanJournalEntryItem IsStatisticalOrder Statistical Order
IsStatisticalCostCenter I_ActualPlanJournalEntryItem IsStatisticalCostCenter Cost Center Is Stat.
WBSIsStatisticalWBSElement I_ActualPlanJournalEntryItem WBSIsStatisticalWBSElement Statistical
ActualAmountInCompanyCodeCrcy
ActualAmountInTransactionCrcy I_ActualPlanJournalEntryItem ActualAmountInTransactionCrcy Dummy Field of Amt
ActualAmountInGlobalCurrency I_ActualPlanJournalEntryItem ActualAmountInGlobalCurrency
PlanAmountInCompanyCodeCrcy I_ActualPlanJournalEntryItem PlanAmountInCompanyCodeCrcy
PlanAmountInTransactionCrcy I_ActualPlanJournalEntryItem PlanAmountInTransactionCrcy
PlanAmountInGlobalCurrency I_ActualPlanJournalEntryItem PlanAmountInGlobalCurrency
AmountInTransactionCurrency I_ActualPlanJournalEntryItem AmountInTransactionCurrency Pt Crcy Amt
AmountInCompanyCodeCurrency I_ActualPlanJournalEntryItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency I_ActualPlanJournalEntryItem AmountInGlobalCurrency Amount in Global Currency
ValuationQuantity
ActualValuationQuantity I_ActualPlanJournalEntryItem ActualValuationQuantity
PlanValuationQuantity I_ActualPlanJournalEntryItem PlanValuationQuantity
_SourceLedger I_ActualPlanJournalEntryItem _SourceLedger
_Ledger I_ActualPlanJournalEntryItem _Ledger
_CompanyCode I_ActualPlanJournalEntryItem _CompanyCode
_FiscalYear I_ActualPlanJournalEntryItem _FiscalYear
_JournalEntry I_ActualPlanJournalEntryItem _JournalEntry
_GLAccountInChartOfAccounts I_ActualPlanJournalEntryItem _GLAccountInChartOfAccounts
_GLAccountInCompanyCode I_ActualPlanJournalEntryItem _GLAccountInCompanyCode
_LedgerFiscalYearForVariant I_ActualPlanJournalEntryItem _LedgerFiscalYearForVariant
_FiscalYearPeriod I_ActualPlanJournalEntryItem _FiscalYearPeriod
_FiscalPeriodForVariant I_ActualPlanJournalEntryItem _FiscalPeriodForVariant
_FiscalYearPeriodForVariant I_ActualPlanJournalEntryItem _FiscalYearPeriodForVariant
_ChartOfAccounts I_ActualPlanJournalEntryItem _ChartOfAccounts
_BusinessTransactionType I_ActualPlanJournalEntryItem _BusinessTransactionType
_CostCtrActivityType I_ActualPlanJournalEntryItem _CostCtrActivityType
_Customer I_ActualPlanJournalEntryItem _Customer
_CustomerGroup I_ActualPlanJournalEntryItem _CustomerGroup
_ControllingDebitCreditCode I_ActualPlanJournalEntryItem _ControllingDebitCreditCode
_FunctionalArea I_ActualPlanJournalEntryItem _FunctionalArea
_PlanningCategory I_ActualPlanJournalEntryItem _PlanningCategory
_ProjectExternalID I_ActualPlanJournalEntryItem _ProjectExternalID
_Segment I_ActualPlanJournalEntryItem _Segment
_PartnerCompany I_ActualPlanJournalEntryItem _PartnerCompany
_FiscalYearVariant I_ActualPlanJournalEntryItem _FiscalYearVariant
_CompanyCodeCurrency I_ActualPlanJournalEntryItem _CompanyCodeCurrency
_ProfitCenter I_ActualPlanJournalEntryItem _ProfitCenter
_ControllingArea I_ActualPlanJournalEntryItem _ControllingArea
_CostCenter I_ActualPlanJournalEntryItem _CostCenter
_WBSElementExternalID I_ActualPlanJournalEntryItem _WBSElementExternalID
_InternalOrder I_ActualPlanJournalEntryItem _InternalOrder
_Order I_ActualPlanJournalEntryItem _Order
_BusinessArea I_ActualPlanJournalEntryItem _BusinessArea
_AccountingDocumentType I_ActualPlanJournalEntryItem _AccountingDocumentType
_FiscalCalendarDate I_ActualPlanJournalEntryItem _FiscalCalendarDate
_REArchitectureObject _REArchitectureObject
_REArchtrObjectBuildingLand _REArchtrObjectBuildingLand
_REArchitectureObjectSite _REArchitectureObjectSite
_REGnrcRentalObjPortfolio _REGnrcRentalObjPortfolio

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_REArchtrObjCostCtrPlnActlC.
-- 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 I_REArchtrObjCostCtrPlnActlC AS
SELECT
  _ActualPlanJournalEntryItem.SourceLedger AS SourceLedger,
  _ActualPlanJournalEntryItem.Ledger AS Ledger,
  _ActualPlanJournalEntryItem.CompanyCode AS CompanyCode,
  _ActualPlanJournalEntryItem.FiscalYear AS FiscalYear,
  _ActualPlanJournalEntryItem.AccountingDocument AS AccountingDocument,
  _ActualPlanJournalEntryItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _ActualPlanJournalEntryItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  _ActualPlanJournalEntryItem.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  cast(_REArchtrObjBuildingLandToSite.REArchitectureObjectSiteNumber as reobvdmobnrsite preserving type) AS REArchitectureObjectNumberSite,
  _REArchtrObjBuildingLandToSite.REArchitectureObjectSiteName AS REArchtrObjectSiteName,
  _REArchtrObjBuildingLandToSite.REArchitectureObjectSiteUUID AS REArchitectureObjectParentUUID,
  _REArchtrObjCtrlgObjAssgmt.REArchtrObjectNumberBldngLand AS REArchtrObjectNumberBldngLand,
  _REArchtrObjCtrlgObjAssgmt.REArchtrObjectBldngLandName AS REArchtrObjectBldngLandName,
  _REArchtrObjCtrlgObjAssgmt.REArchitectureObjectUUID AS REArchitectureObjectUUID,
  _REArchtrObjCtrlgObjAssgmt.REGenericRentalObjParentUUID AS REGenericRentalObjParentUUID,
  _REArchtrObjCtrlgObjAssgmt.REGnrcRentalObjPortfolioID AS REGnrcRentalObjPortfolioID,
  _ActualPlanJournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  _ActualPlanJournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  _ActualPlanJournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  _ActualPlanJournalEntryItem._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  _ActualPlanJournalEntryItem._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  _ActualPlanJournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ActualPlanJournalEntryItem.ProfitCenter AS ProfitCenter,
  _ActualPlanJournalEntryItem.ControllingArea AS ControllingArea,
  _ActualPlanJournalEntryItem.AccountAssignmentType AS AccountAssignmentType,
  _ActualPlanJournalEntryItem.CostCtrActivityType AS CostCtrActivityType,
  _ActualPlanJournalEntryItem.CostCenter AS CostCenter,
  _ActualPlanJournalEntryItem.CostSourceUnit AS CostSourceUnit,
  _ActualPlanJournalEntryItem.Customer AS Customer,
  _ActualPlanJournalEntryItem.CustomerGroup AS CustomerGroup,
  _ActualPlanJournalEntryItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _ActualPlanJournalEntryItem.FunctionalArea AS FunctionalArea,
  _ActualPlanJournalEntryItem.GlobalCurrency AS GlobalCurrency,
  _ActualPlanJournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  _ActualPlanJournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  _ActualPlanJournalEntryItem.OrderID AS OrderID,
  _ActualPlanJournalEntryItem.PlanningCategory AS PlanningCategory,
  _ActualPlanJournalEntryItem.PostingDate AS PostingDate,
  _ActualPlanJournalEntryItem.ProjectExternalID AS ProjectExternalID,
  _ActualPlanJournalEntryItem.Segment AS Segment,
  _ActualPlanJournalEntryItem.PartnerCompany AS PartnerCompany,
  _ActualPlanJournalEntryItem.TransactionCurrency AS TransactionCurrency,
  _ActualPlanJournalEntryItem.WBSElementExternalID AS WBSElementExternalID,
  _ActualPlanJournalEntryItem.BusinessArea AS BusinessArea,
  _ActualPlanJournalEntryItem.IsStatisticalOrder AS IsStatisticalOrder,
  _ActualPlanJournalEntryItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  _ActualPlanJournalEntryItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  _ActualPlanJournalEntryItem.ActualAmountInTransactionCrcy AS ActualAmountInTransactionCrcy,
  _ActualPlanJournalEntryItem.ActualAmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  _ActualPlanJournalEntryItem.PlanAmountInCompanyCodeCrcy AS PlanAmountInCompanyCodeCrcy,
  _ActualPlanJournalEntryItem.PlanAmountInTransactionCrcy AS PlanAmountInTransactionCrcy,
  _ActualPlanJournalEntryItem.PlanAmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  _ActualPlanJournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _ActualPlanJournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _ActualPlanJournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ActualPlanJournalEntryItem.ActualValuationQuantity AS ActualValuationQuantity,
  _ActualPlanJournalEntryItem.PlanValuationQuantity AS PlanValuationQuantity,
  _ActualPlanJournalEntryItem._SourceLedger AS _SourceLedger,
  _ActualPlanJournalEntryItem._Ledger AS _Ledger,
  _ActualPlanJournalEntryItem._CompanyCode AS _CompanyCode,
  _ActualPlanJournalEntryItem._FiscalYear AS _FiscalYear,
  _ActualPlanJournalEntryItem._JournalEntry AS _JournalEntry,
  _ActualPlanJournalEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  _ActualPlanJournalEntryItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  _ActualPlanJournalEntryItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  _ActualPlanJournalEntryItem._FiscalYearPeriod AS _FiscalYearPeriod,
  _ActualPlanJournalEntryItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  _ActualPlanJournalEntryItem._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  _ActualPlanJournalEntryItem._ChartOfAccounts AS _ChartOfAccounts,
  _ActualPlanJournalEntryItem._BusinessTransactionType AS _BusinessTransactionType,
  _ActualPlanJournalEntryItem._CostCtrActivityType AS _CostCtrActivityType,
  _ActualPlanJournalEntryItem._Customer AS _Customer,
  _ActualPlanJournalEntryItem._CustomerGroup AS _CustomerGroup,
  _ActualPlanJournalEntryItem._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  _ActualPlanJournalEntryItem._FunctionalArea AS _FunctionalArea,
  _ActualPlanJournalEntryItem._PlanningCategory AS _PlanningCategory,
  _ActualPlanJournalEntryItem._ProjectExternalID AS _ProjectExternalID,
  _ActualPlanJournalEntryItem._Segment AS _Segment,
  _ActualPlanJournalEntryItem._PartnerCompany AS _PartnerCompany,
  _ActualPlanJournalEntryItem._FiscalYearVariant AS _FiscalYearVariant,
  _ActualPlanJournalEntryItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _ActualPlanJournalEntryItem._ProfitCenter AS _ProfitCenter,
  _ActualPlanJournalEntryItem._ControllingArea AS _ControllingArea,
  _ActualPlanJournalEntryItem._CostCenter AS _CostCenter,
  _ActualPlanJournalEntryItem._WBSElementExternalID AS _WBSElementExternalID,
  _ActualPlanJournalEntryItem._InternalOrder AS _InternalOrder,
  _ActualPlanJournalEntryItem._Order AS _Order,
  _ActualPlanJournalEntryItem._BusinessArea AS _BusinessArea,
  _ActualPlanJournalEntryItem._AccountingDocumentType AS _AccountingDocumentType,
  _ActualPlanJournalEntryItem._FiscalCalendarDate AS _FiscalCalendarDate
FROM P_REArchtrObjAssgmtCalc2 AS _REArchtrObjCtrlgObjAssgmt
INNER JOIN I_ActualPlanJournalEntryItem AS _ActualPlanJournalEntryItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_REArchtrObjAssgmtCalc5 AS _REArchtrObjBuildingLandToSite ON REArchitectureObjectUUID = _REArchtrObjBuildingLandToSite.REArchitectureObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_REGnrcRentalObjPortfolio AS _REGnrcRentalObjPortfolio ON REGnrcRentalObjPortfolioID = _REGnrcRentalObjPortfolio.REGnrcRentalObjPortfolioID  -- association [0..1]
LEFT OUTER JOIN I_REArchitectureObject AS _REArchitectureObject ON REArchitectureObjectUUID = _REArchitectureObject.REArchitectureObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_REArchtrObjectBuildingLand AS _REArchtrObjectBuildingLand ON REArchitectureObjectUUID = _REArchtrObjectBuildingLand.REArchitectureObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_REArchitectureObjectSite AS _REArchitectureObjectSite ON REArchitectureObjectParentUUID = _REArchitectureObjectSite.REArchitectureObjectUUID  -- association [1..1]
;

Learn More