FOP_SETTLEDREFUNDS

DDL: FOP_SETTLEDREFUNDS SQL: FOPSETTLEDRFNDS Type: view

FOP_SETTLEDREFUNDS is a CDS View in SAP S/4HANA. It reads from 1 data source (bsegc) and exposes 3 fields with key field aunum. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
bsegc bsegc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OperationalAcctgDocItem _AcctgDocItem bsegc.bukrs = _AcctgDocItem.CompanyCode and bsegc.belnr = _AcctgDocItem.AccountingDocument and bsegc.gjahr = _AcctgDocItem.FiscalYear and bsegc.rfzei = _AcctgDocItem.PaymentCardItem and _AcctgDocItem.FinancialAccountType = 'S'

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FOPSETTLEDRFNDS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY aunum aunum
autwr
ccwae ccwae 
@AbapCatalog.sqlViewName: 'FOPSETTLEDRFNDS'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Unsettled refunds'

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #X
define view FOP_SETTLEDREFUNDS
  as select from bsegc
  association [1..1] to I_OperationalAcctgDocItem    as _AcctgDocItem    on  bsegc.bukrs = _AcctgDocItem.CompanyCode
                                                                         and bsegc.belnr = _AcctgDocItem.AccountingDocument
                                                                         and bsegc.gjahr = _AcctgDocItem.FiscalYear
                                                                         and bsegc.rfzei = _AcctgDocItem.PaymentCardItem
                                                                         and _AcctgDocItem.FinancialAccountType = 'S'
{
  key aunum,
      @Semantics: { amount : {currencyCode: 'Ccwae'} }
      sum( _AcctgDocItem.AmountInTransactionCurrency ) as autwr,  // is a negative value

      ccwae
}

where
      aunum <> ''
  and settl =  'X'
  and _AcctgDocItem.AmountInTransactionCurrency < 0
  
  group by aunum, ccwae
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM",
"BSEGC"
],
"ASSOCIATED":
[
"I_OPERATIONALACCTGDOCITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More