P_EBASO_OrderCost5

DDL: P_EBASO_ORDERCOST5 Type: view_entity COMPOSITE Package: ODATA_CO_EB_ANALYZE_SUM_OBJECT
73 Fields 2 Data Sources

Event-Based Analyze Summarization Object - Order Cost

P_EBASO_OrderCost5 is a Composite CDS View that provides data about "Event-Based Analyze Summarization Object - Order Cost" in SAP S/4HANA. It reads from 2 data sources (I_ControllingArea, P_EBASO_OrderCost4) and exposes 73 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package ODATA_CO_EB_ANALYZE_SUM_OBJECT.

Data Sources (2)

SourceAliasJoin Type
I_ControllingArea I_ControllingArea inner
P_EBASO_OrderCost4 P_EBASO_OrderCost4 from

Parameters (3)

NameTypeDefault
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper
P_Ledger fins_ledger

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY Ledger _Costs Ledger Ledger
KEY CompanyCode _Costs CompanyCode Receiver Company Code
KEY FiscalYear _Costs FiscalYear G/L Fiscal Year
KEY AccountingDocument _Costs AccountingDocument Journal Entry
KEY LedgerGLLineItem _Costs LedgerGLLineItem Journal Entry Item
KEY FinancialPlanningReqTransSqnc _Costs FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket _Costs FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem _Costs FinancialPlanningEntryItem
KEY ControllingValueType _Costs ControllingValueType
KEY SelectedCurrencyBranch _Costs SelectedCurrencyBranch
PlantForFilter _Costs PlantForFilter
OrderDescription _Costs OrderDescription
OrderType _Costs OrderType Order Type
Product _Costs Product Product Sold
OrderID _Costs OrderID Order ID
OrderCategory _Costs OrderCategory Order Category
ProfitCenter _Costs ProfitCenter Profit Center
MRPPlant _Costs MRPPlant Plant
StorageLocation _Costs StorageLocation StorageLocation
ProductionVersion _Costs ProductionVersion Version ID
SalesOrder _Costs SalesOrder SD Document
SalesOrderItem _Costs SalesOrderItem Sales Order Item
WBSElementInternalID _Costs WBSElementInternalID WBS Internal ID
MfgOrderHasMultipleItems _Costs MfgOrderHasMultipleItems
ControllingArea _Costs ControllingArea Controlling Area
ReferenceOrder _Costs ReferenceOrder Reference Order
ResponsibleCostCenter _Costs ResponsibleCostCenter Responsible Cost Center
CostElement _Costs CostElement G/L Account
ControllingDebitCreditCode _Costs ControllingDebitCreditCode Dr/Cr ind. CO
CtrlgOrignClassificationFoFltr _Costs CtrlgOrignClassificationFoFltr
OrderItem _Costs OrderItem
PartnerAccountAssignment _Costs PartnerAccountAssignment Partner Account Assignment
PartnerCostCenter _Costs PartnerCostCenter Sender Cost Ctr
PartnerCostCtrActivityType _Costs PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerOrder _Costs PartnerOrder Partner Order
UnitOfMeasure _Costs UnitOfMeasure Unit Protected Qty
MaterialForFilter _Costs MaterialForFilter
CostOriginGroupForFilter _Costs CostOriginGroupForFilter
SubLedgerAcctLineItemType _Costs SubLedgerAcctLineItemType SLALineItemType
IsLotSizeIndependent _Costs IsLotSizeIndependent
OriginCostCenter _Costs OriginCostCenter
OriginCostCtrActivityType _Costs OriginCostCtrActivityType
CtrlgOriginClassification _Costs CtrlgOriginClassification
OriginObject _Costs OriginObject Reference Document
CostOriginGroup _Costs CostOriginGroup Origin Group
Partner _Costs Partner With Partner
Plant _Costs Plant Valuation Area
Material _Costs Material Vehicle Model
ChartOfAccounts I_ControllingArea ChartOfAccounts Node Class
DisplayCurrency _Costs DisplayCurrency Display Currency
CreditActlCostInDspCrcy _Costs CreditActlCostInDspCrcy
DebitActlCostInDspCrcy _Costs DebitActlCostInDspCrcy
ActlCostInDspCrcy _Costs ActlCostInDspCrcy
ActualQuantity _Costs ActualQuantity
CreditPlanCostInDspCrcy _Costs CreditPlanCostInDspCrcy
DebitPlanCostInDspCrcy _Costs DebitPlanCostInDspCrcy
PlanCostInDspCrcy _Costs PlanCostInDspCrcy
PlanQuantity _Costs PlanQuantity
CostVarianceInDspCrcy
InptPrVarcAmtInDspCrcy _Costs InptPrVarcAmtInDspCrcy
InptQtyVarcAmtInDspCrcy _Costs InptQtyVarcAmtInDspCrcy
RsceUsgeVarcAmtInDspCrcy _Costs RsceUsgeVarcAmtInDspCrcy
OutpPrVarcAmtInDspCrcy _Costs OutpPrVarcAmtInDspCrcy
LotSizeVarcAmtInDspCrcy _Costs LotSizeVarcAmtInDspCrcy
RmngVarcAmtInDspCrcy _Costs RmngVarcAmtInDspCrcy
WIPCostInDspCrcy _Costs WIPCostInDspCrcy
UnrlzdCostRsrvAmtInDspCrcy _Costs UnrlzdCostRsrvAmtInDspCrcy
WIPQuantity _Costs WIPQuantity
DebitActlPlnDiffCostInDspCrcy _Costs DebitActlPlnDiffCostInDspCrcy
DebitActlPlanDiffPercent 0
ActlPlnDiffCostInDspCrcy
ActlPlanDiffQuantity
DspCrcyActlPlanDiffPct 0

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_EBASO_OrderCost5.
-- 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.
-- Parameters: P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_Ledger : fins_ledger

CREATE VIEW P_EBASO_OrderCost5 AS
SELECT
  _Costs.Ledger AS Ledger,
  _Costs.CompanyCode AS CompanyCode,
  _Costs.FiscalYear AS FiscalYear,
  _Costs.AccountingDocument AS AccountingDocument,
  _Costs.LedgerGLLineItem AS LedgerGLLineItem,
  _Costs.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _Costs.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  _Costs.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  _Costs.ControllingValueType AS ControllingValueType,
  _Costs.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  _Costs.PlantForFilter AS PlantForFilter,
  _Costs.OrderDescription AS OrderDescription,
  _Costs.OrderType AS OrderType,
  _Costs.Product AS Product,
  _Costs.OrderID AS OrderID,
  _Costs.OrderCategory AS OrderCategory,
  _Costs.ProfitCenter AS ProfitCenter,
  _Costs.MRPPlant AS MRPPlant,
  _Costs.StorageLocation AS StorageLocation,
  _Costs.ProductionVersion AS ProductionVersion,
  _Costs.SalesOrder AS SalesOrder,
  _Costs.SalesOrderItem AS SalesOrderItem,
  _Costs.WBSElementInternalID AS WBSElementInternalID,
  _Costs.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  _Costs.ControllingArea AS ControllingArea,
  _Costs.ReferenceOrder AS ReferenceOrder,
  _Costs.ResponsibleCostCenter AS ResponsibleCostCenter,
  _Costs.CostElement AS CostElement,
  _Costs.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _Costs.CtrlgOrignClassificationFoFltr AS CtrlgOrignClassificationFoFltr,
  _Costs.OrderItem AS OrderItem,
  _Costs.PartnerAccountAssignment AS PartnerAccountAssignment,
  _Costs.PartnerCostCenter AS PartnerCostCenter,
  _Costs.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  _Costs.PartnerOrder AS PartnerOrder,
  _Costs.UnitOfMeasure AS UnitOfMeasure,
  _Costs.MaterialForFilter AS MaterialForFilter,
  _Costs.CostOriginGroupForFilter AS CostOriginGroupForFilter,
  _Costs.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  _Costs.IsLotSizeIndependent AS IsLotSizeIndependent,
  _Costs.OriginCostCenter AS OriginCostCenter,
  _Costs.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  _Costs.CtrlgOriginClassification AS CtrlgOriginClassification,
  _Costs.OriginObject AS OriginObject,
  _Costs.CostOriginGroup AS CostOriginGroup,
  _Costs.Partner AS Partner,
  _Costs.Plant AS Plant,
  _Costs.Material AS Material,
  I_ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  _Costs.DisplayCurrency AS DisplayCurrency,
  _Costs.CreditActlCostInDspCrcy AS CreditActlCostInDspCrcy,
  _Costs.DebitActlCostInDspCrcy AS DebitActlCostInDspCrcy,
  _Costs.ActlCostInDspCrcy AS ActlCostInDspCrcy,
  _Costs.ActualQuantity AS ActualQuantity,
  _Costs.CreditPlanCostInDspCrcy AS CreditPlanCostInDspCrcy,
  _Costs.DebitPlanCostInDspCrcy AS DebitPlanCostInDspCrcy,
  _Costs.PlanCostInDspCrcy AS PlanCostInDspCrcy,
  _Costs.PlanQuantity AS PlanQuantity,
  _Costs.InptPrVarcAmtInDspCrcy + _Costs.InptQtyVarcAmtInDspCrcy + _Costs.RsceUsgeVarcAmtInDspCrcy + _Costs.OutpPrVarcAmtInDspCrcy + _Costs.LotSizeVarcAmtInDspCrcy + _Costs.RmngVarcAmtInDspCrcy + _Costs.NonSplitVarcAmtInDspCrcy AS CostVarianceInDspCrcy,
  _Costs.InptPrVarcAmtInDspCrcy AS InptPrVarcAmtInDspCrcy,
  _Costs.InptQtyVarcAmtInDspCrcy AS InptQtyVarcAmtInDspCrcy,
  _Costs.RsceUsgeVarcAmtInDspCrcy AS RsceUsgeVarcAmtInDspCrcy,
  _Costs.OutpPrVarcAmtInDspCrcy AS OutpPrVarcAmtInDspCrcy,
  _Costs.LotSizeVarcAmtInDspCrcy AS LotSizeVarcAmtInDspCrcy,
  _Costs.RmngVarcAmtInDspCrcy AS RmngVarcAmtInDspCrcy,
  _Costs.WIPCostInDspCrcy AS WIPCostInDspCrcy,
  _Costs.UnrlzdCostRsrvAmtInDspCrcy AS UnrlzdCostRsrvAmtInDspCrcy,
  _Costs.WIPQuantity AS WIPQuantity,
  _Costs.DebitActlPlnDiffCostInDspCrcy AS DebitActlPlnDiffCostInDspCrcy,
  0 AS DebitActlPlanDiffPercent,
  _Costs.ActlCostInDspCrcy - _Costs.PlanCostInDspCrcy AS ActlPlnDiffCostInDspCrcy,
  _Costs.ActualQuantity - _Costs.PlanQuantity AS ActlPlanDiffQuantity,
  0 AS DspCrcyActlPlanDiffPct
FROM P_EBASO_OrderCost4
INNER JOIN I_ControllingArea ON /* join condition not captured in parsed metadata */
;

Learn More