I_RRBDYNAMICITEMTOTALFLOW

CDS View

Total Flow of Dynamic Item

I_RRBDYNAMICITEMTOTALFLOW is a CDS View in S/4HANA. Total Flow of Dynamic Item. It contains 6 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 6 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_EngmntProjBillgAndRbls view inner COMPOSITE
P_RRBWrittenOffDynamicItem view from CONSUMPTION
P_RRBWrittenOffDynamicItem01 view from CONSUMPTION

Fields (6)

KeyField CDS FieldsUsed in Views
KEY RRBDynamicItem RRBDynamicItem 1
_RRBDynamicItemLongText _RRBDynamicItemLongText 1
BilledAmountInTransacCrcy BilledAmountInTransacCrcy 1
BilledQuantity BilledQuantity 1
RejectedAmtInTransCrcy RejectedAmtInTransCrcy,WriteOffAmount 2
RejectedQuantity RejectedQuantity 1 
@AbapCatalog.sqlViewName: 'IRRBDYNITMTOTFLW'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Total Flow of Dynamic Item'
@VDM.viewType: #BASIC
@ObjectModel.usageType: {
    serviceQuality: #C  ,
    sizeCategory : #L,
    dataClass: #TRANSACTIONAL
}
@VDM.lifecycle.contract.type:  #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities:[ #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE ]

define view I_RRBDynamicItemTotalFlow
  as select from ad01dlisf as DITotalFlow

  association [1..1] to I_RRBCostDynamicItem     as _DynamicItem            on  $projection.RRBDynamicItem = _DynamicItem.RRBDynamicItem
  association [0..1] to I_RRBDynamicItemLongText as _RRBDynamicItemLongText on  $projection.RRBDynamicItem       = _RRBDynamicItemLongText.RRBDynamicItem
                                                                            and _RRBDynamicItemLongText.Language = 'E'
{

  key DITotalFlow.dlinr                                                 as RRBDynamicItem,
  key DITotalFlow.dlius                                                 as RRBDynItmProfileUsage,

      @Semantics.unitOfMeasure: true
      _DynamicItem.UnitOfMeasure                                        as UnitOfMeasure,
      @Semantics.currencyCode: true
      _DynamicItem.TransactionCurrency                                  as TransactionCurrency,
      @Semantics.currencyCode: true
      _DynamicItem._WBSElement._CompanyCode.Currency                    as CompanyCodeCurrency,
      @Semantics.currencyCode: true
      _DynamicItem._WBSElement._ControllingArea.ControllingAreaCurrency as GlobalCurrency,

      //Quantities

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      DITotalFlow.in_megbtr                                             as BilledQuantity,

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      DITotalFlow.no_megbtr                                             as RejectedQuantity,

      //Billed Amounts

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      DITotalFlow.in_wtgbtr                                             as BilledAmountInTransacCrcy,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      DITotalFlow.in_wogbtr                                             as BilledAmountInObjectCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      DITotalFlow.in_wkgbtr                                             as BilledAmountInGlobalCurrency,

      //Rejected Amounts

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      DITotalFlow.no_wtgbtr                                             as RejectedAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      DITotalFlow.no_wogbtr                                             as RejectedAmountInObjectCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      DITotalFlow.no_wkgbtr                                             as RejectedAmountInGlobalCurrency,

      _DynamicItem,
      _RRBDynamicItemLongText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_RRBCOSTDYNAMICITEM",
"I_WBSELEMENTBASICDATA",
"AD01DLISF"
],
"ASSOCIATED":
[
"I_RRBCOSTDYNAMICITEM",
"I_RRBDYNAMICITEMLONGTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More