P_COActualCube

DDL: P_COACTUALCUBE SQL: PFICOACTULECUBE Type: view COMPOSITE
40 Fields 1 Data Sources

P_COActualCube is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_COActualLineItem) and exposes 40 fields with key fields ControllingObject, ControllingKeySubNumber, FiscalYearPeriod, ControllingValueType, ChartOfAccounts.

Data Sources (1)

SourceAliasJoin Type
I_COActualLineItem I_COActualLineItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PFICOACTULECUBE view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject ControllingObject Object number
KEY ControllingKeySubNumber ControllingKeySubNumber
KEY FiscalYearPeriod FiscalYearPeriod Period/Year
KEY ControllingValueType
KEY ChartOfAccounts ChartOfAccounts Node Class
KEY CostElement CostElement G/L Account
KEY Version Version XML Vers.
KEY BusinessTransactionType BusinessTransactionType Bus.transaction
KEY CostOriginGroup CostOriginGroup Origin Group
KEY OriginSenderObject OriginSenderObject
KEY OriginCostCenter OriginCostCenter
KEY OriginCostCtrActivityType OriginCostCtrActivityType
KEY ControllingDebitCreditCode OriginCtrlgDebitCreditCode Debit/CreditInd
KEY AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
KEY AccountAssignment AccountAssignment Sender Acct Assgmt
KEY CostCenter CostCenter Cost Center
KEY ActivityType ActivityType Activity Type
KEY OrderID OrderID Order ID
KEY OrderItem OrderItem
KEY PartnerAccountAssignmentType PartnerAccountAssignmentType Partner Account Assignment Type
KEY PartnerCostObject PartnerCostObject Partner Cost Object
KEY PartnerCostCenter PartnerCostCenter Sender Cost Ctr
KEY PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
KEY PartnerOrder PartnerOrder Partner Order
KEY PartnerBusinessProcess PartnerBusinessProcess Part. Bus. Process
KEY CtrlgOriginClassification CtrlgOriginClassification
KEY WorkCenterInternalID WorkCenterInternalID Work Center
KEY OrderOperation OrderOperation Operation or Phase
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY UnitOfMeasure UnitOfMeasure Unit Protected Qty
KEY GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
KEY CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInGlobalCurrency
FixedAmountInGlobalCrcy
AmountInCompanyCodeCurrency
curr232else0endasFixedAmountInCoCodeCrcy
AmountInObjectCurrency
TotalQuantity
FixedQuantity

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_COActualCube.
-- 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: PFICOACTULECUBE

CREATE VIEW P_COActualCube AS
SELECT
  ControllingObject,
  ControllingKeySubNumber,
  FiscalYearPeriod,
  cast('04' as co_wrttp) AS ControllingValueType,
  ChartOfAccounts,
  CostElement,
  Version,
  BusinessTransactionType,
  CostOriginGroup,
  OriginSenderObject,
  OriginCostCenter,
  OriginCostCtrActivityType,
  OriginCtrlgDebitCreditCode AS ControllingDebitCreditCode,
  AccountAssignmentType,
  AccountAssignment,
  CostCenter,
  ActivityType,
  OrderID,
  OrderItem,
  PartnerAccountAssignmentType,
  PartnerCostObject,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerBusinessProcess,
  CtrlgOriginClassification,
  WorkCenterInternalID,
  OrderOperation,
  Material,
  Plant,
  UnitOfMeasure,
  GlobalCurrency,
  CompanyCodeCurrency,
  sum(AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  sum(FixedAmountInGlobalCrcy) AS FixedAmountInGlobalCrcy,
  sum(AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  sum(case when AmountInGlobalCurrency <> 0 then cast(round(cast(division(FixedAmountInGlobalCrcy, AmountInGlobalCurrency, 6) as abap.dec(14, 6)) * AmountInCompanyCodeCurrency, 2) as abap.curr(23, 2)) else 0 end) as FixedAmountInCoCodeCrcy AS curr232else0endasFixedAmountInCoCodeCrcy,
  sum(AmountInObjectCurrency) AS AmountInObjectCurrency,
  sum(TotalQuantity) AS TotalQuantity,
  sum(FixedQuantity) AS FixedQuantity
FROM I_COActualLineItem
;

Learn More