P_EBASO_OrderCost5

DDL: P_EBASO_ORDERCOST5 Type: view_entity COMPOSITE Package: ODATA_CO_EB_ANALYZE_SUM_OBJECT

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.

2 data source(s) 73 fields

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
KEY CompanyCode _Costs CompanyCode
KEY FiscalYear _Costs FiscalYear
KEY AccountingDocument _Costs AccountingDocument
KEY LedgerGLLineItem _Costs LedgerGLLineItem
KEY FinancialPlanningReqTransSqnc _Costs FinancialPlanningReqTransSqnc
KEY FinancialPlanningDataPacket _Costs FinancialPlanningDataPacket
KEY FinancialPlanningEntryItem _Costs FinancialPlanningEntryItem
KEY ControllingValueType _Costs ControllingValueType
KEY SelectedCurrencyBranch _Costs SelectedCurrencyBranch
PlantForFilter _Costs PlantForFilter
OrderDescription _Costs OrderDescription
OrderType _Costs OrderType
Product _Costs Product
OrderID _Costs OrderID
OrderCategory _Costs OrderCategory
ProfitCenter _Costs ProfitCenter
MRPPlant _Costs MRPPlant
StorageLocation _Costs StorageLocation
ProductionVersion _Costs ProductionVersion
SalesOrder _Costs SalesOrder
SalesOrderItem _Costs SalesOrderItem
WBSElementInternalID _Costs WBSElementInternalID
MfgOrderHasMultipleItems _Costs MfgOrderHasMultipleItems
ControllingArea _Costs ControllingArea
ReferenceOrder _Costs ReferenceOrder
ResponsibleCostCenter _Costs ResponsibleCostCenter
CostElement _Costs CostElement
ControllingDebitCreditCode _Costs ControllingDebitCreditCode
CtrlgOrignClassificationFoFltr _Costs CtrlgOrignClassificationFoFltr
OrderItem _Costs OrderItem
PartnerAccountAssignment _Costs PartnerAccountAssignment
PartnerCostCenter _Costs PartnerCostCenter
PartnerCostCtrActivityType _Costs PartnerCostCtrActivityType
PartnerOrder _Costs PartnerOrder
UnitOfMeasure _Costs UnitOfMeasure
MaterialForFilter _Costs MaterialForFilter
CostOriginGroupForFilter _Costs CostOriginGroupForFilter
SubLedgerAcctLineItemType _Costs SubLedgerAcctLineItemType
IsLotSizeIndependent _Costs IsLotSizeIndependent
OriginCostCenter _Costs OriginCostCenter
OriginCostCtrActivityType _Costs OriginCostCtrActivityType
CtrlgOriginClassification _Costs CtrlgOriginClassification
OriginObject _Costs OriginObject
CostOriginGroup _Costs CostOriginGroup
Partner _Costs Partner
Plant _Costs Plant
Material _Costs Material
ChartOfAccounts I_ControllingArea ChartOfAccounts
DisplayCurrency _Costs DisplayCurrency
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 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view entity P_EBASO_OrderCost5
  with parameters
    P_FromFiscalYearPeriod : fis_jahrper,
    P_ToFiscalYearPeriod   : fis_jahrper,
    P_Ledger               : fins_ledger
  as select from P_EBASO_OrderCost4( P_FromFiscalYearPeriod : $parameters.P_FromFiscalYearPeriod,
                                     P_ToFiscalYearPeriod   : $parameters.P_ToFiscalYearPeriod,
                                     P_Ledger               : $parameters.P_Ledger ) as _Costs

    inner join   I_ControllingArea on I_ControllingArea.ControllingArea = _Costs.ControllingArea
{
  key _Costs.Ledger,
  key _Costs.CompanyCode,
  key _Costs.FiscalYear,
  key _Costs.AccountingDocument,
  key _Costs.LedgerGLLineItem,

  key _Costs.FinancialPlanningReqTransSqnc,
  key _Costs.FinancialPlanningDataPacket,
  key _Costs.FinancialPlanningEntryItem,

  key _Costs.ControllingValueType,
      @Environment.sql.passValue: true
  key _Costs.SelectedCurrencyBranch,

      _Costs.PlantForFilter,
      _Costs.OrderDescription,
      _Costs.OrderType,
      _Costs.Product,
      _Costs.OrderID,
      _Costs.OrderCategory,
      _Costs.ProfitCenter,
      _Costs.MRPPlant,
      _Costs.StorageLocation,
      _Costs.ProductionVersion,
      _Costs.SalesOrder,
      _Costs.SalesOrderItem,
      _Costs.WBSElementInternalID,
      _Costs.MfgOrderHasMultipleItems,
      _Costs.ControllingArea,
      _Costs.ReferenceOrder,
      _Costs.ResponsibleCostCenter,

      _Costs.CostElement,
      _Costs.ControllingDebitCreditCode,
      _Costs.CtrlgOrignClassificationFoFltr, // original Origin Indicator

      _Costs.OrderItem,
      _Costs.PartnerAccountAssignment,
      _Costs.PartnerCostCenter,
      _Costs.PartnerCostCtrActivityType,
      _Costs.PartnerOrder,
      _Costs.UnitOfMeasure,
      _Costs.MaterialForFilter,
      _Costs.CostOriginGroupForFilter,

      _Costs.SubLedgerAcctLineItemType,
      _Costs.IsLotSizeIndependent,

      // Orig. Objects

      _Costs.OriginCostCenter,
      _Costs.OriginCostCtrActivityType,

      _Costs.CtrlgOriginClassification, // adjusted Origin Indicator

      _Costs.OriginObject,
      _Costs.CostOriginGroup,
      _Costs.Partner,
      _Costs.Plant,
      _Costs.Material,

      I_ControllingArea.ChartOfAccounts,

      _Costs.DisplayCurrency,

      // Actual Costs

      _Costs.CreditActlCostInDspCrcy,
      _Costs.DebitActlCostInDspCrcy,
      _Costs.ActlCostInDspCrcy,

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      _Costs.ActualQuantity,

      // Plan Costs

      _Costs.CreditPlanCostInDspCrcy,
      _Costs.DebitPlanCostInDspCrcy,
      _Costs.PlanCostInDspCrcy,

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      _Costs.PlanQuantity,

      /////////////////////////////////////////////////////////////////////////////////////

      // Variances

      /////////////////////////////////////////////////////////////////////////////////////

      _Costs.InptPrVarcAmtInDspCrcy + _Costs.InptQtyVarcAmtInDspCrcy + _Costs.RsceUsgeVarcAmtInDspCrcy + _Costs.OutpPrVarcAmtInDspCrcy + _Costs.LotSizeVarcAmtInDspCrcy + _Costs.RmngVarcAmtInDspCrcy + _Costs.NonSplitVarcAmtInDspCrcy as CostVarianceInDspCrcy, //Total Cost Variance


      _Costs.InptPrVarcAmtInDspCrcy,   //SLALineType = 09130

      _Costs.InptQtyVarcAmtInDspCrcy,  //SLALineType = 09131

      _Costs.RsceUsgeVarcAmtInDspCrcy, //SLALineType = 09132

      _Costs.OutpPrVarcAmtInDspCrcy,   //SLALineType = 09138

      _Costs.LotSizeVarcAmtInDspCrcy,  //SLALineType = 09139

      _Costs.RmngVarcAmtInDspCrcy,     //SLALineType = 09140


      // WIP / Reserve

      _Costs.WIPCostInDspCrcy,
      _Costs.UnrlzdCostRsrvAmtInDspCrcy,

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      _Costs.WIPQuantity,

      /////////////////////////////////////////////////////////////////////////////////////

      // Calculates deviations

      /////////////////////////////////////////////////////////////////////////////////////

      //Actual - Plan deviation

      _Costs.DebitActlPlnDiffCostInDspCrcy,

      // !!! cast to 0 and recalculate in ABAP

      0                                                                                                                                                                                                 as DebitActlPlanDiffPercent,
      _Costs.ActlCostInDspCrcy - _Costs.PlanCostInDspCrcy                                                                                                                                               as ActlPlnDiffCostInDspCrcy,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      _Costs.ActualQuantity - _Costs.PlanQuantity                                                                                                                                                       as ActlPlanDiffQuantity,

      //  !!! cast to 0 and recalculate in ABAP

      0                                                                                                                                                                                                 as DspCrcyActlPlanDiffPct
}

Learn More