P_UNSETTLEDREFUNDS

DDL: P_UNSETTLEDREFUNDS Type: view_entity COMPOSITE

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

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_AcctgDocPaymentCardData AcctgDoc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OperationalAcctgDocItem _AcctgDocItem AcctgDoc.CompanyCode = _AcctgDocItem.CompanyCode and AcctgDoc.AccountingDocument = _AcctgDocItem.AccountingDocument and AcctgDoc.FiscalYear = _AcctgDocItem.FiscalYear and AcctgDoc.PaymentCardItem = _AcctgDocItem.PaymentCardItem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY AuthorizationByPaytSrvcPrvdr AuthorizationByPaytSrvcPrvdr
PaymentAmount
AuthorizationCurrency AuthorizationCurrency 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
//@EndUserText.label: 'Unsettled refunds'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view entity P_UNSETTLEDREFUNDS
  as select from I_AcctgDocPaymentCardData as AcctgDoc
  association [1..1] to I_OperationalAcctgDocItem as _AcctgDocItem on  AcctgDoc.CompanyCode        = _AcctgDocItem.CompanyCode
                                                                   and AcctgDoc.AccountingDocument = _AcctgDocItem.AccountingDocument
                                                                   and AcctgDoc.FiscalYear         = _AcctgDocItem.FiscalYear
                                                                   and AcctgDoc.PaymentCardItem    = _AcctgDocItem.PaymentCardItem
{
  key AuthorizationByPaytSrvcPrvdr,
      @Semantics.amount.currencyCode: 'AuthorizationCurrency'
      sum(_AcctgDocItem.AmountInTransactionCurrency) as PaymentAmount, // is a negative value

      AuthorizationCurrency
}
where
      AuthorizationByPaytSrvcPrvdr              <> ''
  and PaytCardSettlementIsCarriedOut            =  ' '
  and _AcctgDocItem._JournalEntry.IsReversed    <> 'X'
  and _AcctgDocItem.AmountInTransactionCurrency <  0

group by
  AuthorizationByPaytSrvcPrvdr,
  AuthorizationCurrency
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCTGDOCPAYMENTCARDDATA",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More