P_EBASO_ORDERCOST4

CDS View

Event-Based Analyze Summarization Object - Order Cost

P_EBASO_ORDERCOST4 is a CDS View in S/4HANA. Event-Based Analyze Summarization Object - Order Cost. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EBASO_OrderCost5 view_entity from COMPOSITE Event-Based Analyze Summarization Object - Order Cost 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

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

define view entity P_EBASO_OrderCost4
  with parameters
    P_FromFiscalYearPeriod : fis_jahrper,
    P_ToFiscalYearPeriod   : fis_jahrper,
    P_Ledger               : fins_ledger
  as select from P_EBASO_OrderCost3( P_FromFiscalYearPeriod : $parameters.P_FromFiscalYearPeriod,
                                     P_ToFiscalYearPeriod   : $parameters.P_ToFiscalYearPeriod,
                                     P_Ledger               : $parameters.P_Ledger )
{
  key Ledger,
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key LedgerGLLineItem,

  key FinancialPlanningReqTransSqnc,
  key FinancialPlanningDataPacket,
  key FinancialPlanningEntryItem,

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

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

      CostElement,
      ControllingDebitCreditCode,
      CtrlgOrignClassificationFoFltr, // original Origin Indicator

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

      SubLedgerAcctLineItemType,
      IsLotSizeIndependent,

      // Orig. Objects

      OriginCostCenter,
      OriginCostCtrActivityType,

      CtrlgOriginClassification, // adjusted Origin Indicator

      Plant,
      Material,
      CostOriginGroup,
      Partner,
      OriginObject,

      DisplayCurrency,

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

      //figures for Actual Costs

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

      CreditActlCostInDspCrcy,
      DebitActlCostInDspCrcy,
      ActlCostInDspCrcy,

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

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

      //figures for Plan Costs

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

      CreditPlanCostInDspCrcy,
      DebitPlanCostInDspCrcy,
      PlanCostInDspCrcy,

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

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

      // Variances

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

      NonSplitVarcAmtInDspCrcy, //SLALineType = 09120

      InptPrVarcAmtInDspCrcy,   //SLALineType = 09130

      InptQtyVarcAmtInDspCrcy,  //SLALineType = 09131

      RsceUsgeVarcAmtInDspCrcy, //SLALineType = 09132

      OutpPrVarcAmtInDspCrcy,   //SLALineType = 09138

      LotSizeVarcAmtInDspCrcy,  //SLALineType = 09139

      RmngVarcAmtInDspCrcy,     //SLALineType = 09140


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

      // WIP/Reserve

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

      WIPCostInDspCrcy,
      UnrlzdCostRsrvAmtInDspCrcy,

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

      //WIP Quantities

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

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

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

      // Deviations

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

      //Actual - Plan deviation

      DebitActlPlnDiffCostInDspCrcy
}
where

  //eliminate the plan/actual postings of process orders between order and item

  //when both the order and item data are requested

  //refer to ABAP function K_KKB_CO_OBJECT_TO_KKBC

  //Normal Orders or ( whichever Order and ControllingValueType <> 01, 04)

         MfgOrderHasMultipleItems      <> 'X' //Not Joint Production

  or(
         ControllingValueType          <> '01' //Plan

    and  ControllingValueType          <> '04' //Actual

  )
  or(    //Debits on Header level - Goods Issues / Confirmations


         (
         ControllingDebitCreditCode    =  'H'  //Debit

         or ControllingDebitCreditCode =  'S'  //Debit

       )
    and  AccountAssignmentType         =  'OR' //Order Header

  )
  or(    //Credits on Item level - Goods Receipt


         (
         ControllingDebitCreditCode    =  'A'  //Credit

         or ControllingDebitCreditCode =  'L'  //Credit

       )
    and  AccountAssignmentType         =  'OP' //Order Item

  )
  //do not eliminate settlement e.g. to KS

  or(    //After Settlement


         CtrlgOriginClassification     =  'S'
    and(
         ControllingDebitCreditCode    =  'A' //Credit

      or ControllingDebitCreditCode    =  'L' //Credit

    )
    and  ControllingValueType          =  '04' //Actual

    and  AccountAssignmentType         =  'OR' //Order Header

    and(
         PartnerObjectType             <> 'OP'
      or PartnerOrder                  <> OrderID
    )
  )

Learn More