P_RealTimeMfgOrdTotalBalance

DDL: P_REALTIMEMFGORDTOTALBALANCE SQL: PRTMOTBALANCE Type: view COMPOSITE Package: FINS_PCC_EBW

Event-Based/Migrated Order Balance

P_RealTimeMfgOrdTotalBalance is a Composite CDS View that provides data about "Event-Based/Migrated Order Balance" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItemRawData, I_Ledger) and exposes 12 fields with key fields ObjectNumber, Ledger. Part of development package FINS_PCC_EBW.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItemRawData _item from
I_Ledger _ledger inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRTMOTBALANCE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ObjectNumber ControllingObject
KEY Ledger SourceLedger
AmountInCompanyCodeCurrency
AmountInGlobalCurrency
AmountInFreeDefinedCurrency1
AmountInFreeDefinedCurrency2
AmountInFreeDefinedCurrency3
AmountInFreeDefinedCurrency4
AmountInFreeDefinedCurrency5
AmountInFreeDefinedCurrency6
AmountInFreeDefinedCurrency7
AmountInFreeDefinedCurrency8 
@AbapCatalog.sqlViewName: 'PRTMOTBALANCE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Event-based Order Relevant Actual Cost'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true

define view P_RealTimeMfgOrdTotalBalance

  as select from I_GLAccountLineItemRawData   as _item
    inner join   I_Ledger as _ledger on  _ledger.Ledger     = _item.SourceLedger
    //and _ledger.IsLeadingLedger = 'X'  //support only leading leader in CE2005

                                     and _ledger.LedgerType = '' //standard ledger only

{

  key ControllingObject                   as ObjectNumber,
  key SourceLedger                   as Ledger,




      sum(AmountInCompanyCodeCurrency)              as AmountInCompanyCodeCurrency,
      sum(AmountInGlobalCurrency)              as AmountInGlobalCurrency,
      sum(AmountInFreeDefinedCurrency1)              as AmountInFreeDefinedCurrency1,
      sum(AmountInFreeDefinedCurrency2)              as AmountInFreeDefinedCurrency2,
      sum(AmountInFreeDefinedCurrency3)              as AmountInFreeDefinedCurrency3,
      sum(AmountInFreeDefinedCurrency4)              as AmountInFreeDefinedCurrency4,
      sum(AmountInFreeDefinedCurrency5)              as AmountInFreeDefinedCurrency5,
      sum(AmountInFreeDefinedCurrency6)              as AmountInFreeDefinedCurrency6,
      sum(AmountInFreeDefinedCurrency7)              as AmountInFreeDefinedCurrency7,
      sum(AmountInFreeDefinedCurrency8)              as AmountInFreeDefinedCurrency8


}
where
  (
       _item.AccountAssignmentType  =  'OR'
    or _item.AccountAssignmentType  =  'OP'
  )
  and(
       _item.OrderCategory    =  '10'
    or _item.OrderCategory    =  '40'
  )
  and _item.SubLedgerAcctLineItemType  <> '09101' 
  and _item.SubLedgerAcctLineItemType  <> '09111' 
  and  _item.BusinessTransactionCategory   <> 'TBCS' //ignore TBCS posting

  and  _item.OriginCtrlgDebitCreditCode <> ''
  and _item.ControllingObject <> ''
  and (_item.TransactionTypeDetermination    <> 'PRD' or _item.BusinessTransactionCategory <> 'EBVP')
  
group by
  ControllingObject,
  SourceLedger

Learn More