v_ukm_single_vector

DDL: V_UKM_SINGLE_VECTOR SQL: V_UKM_SINGLE_VEC Type: view

Payment Behavior Summary

v_ukm_single_vector is a CDS View that provides data about "Payment Behavior Summary" in SAP S/4HANA. It reads from 2 data sources (t000, ukmbp_vector_it) and exposes 1 field with key field partner.

Data Sources (2)

SourceAliasJoin Type
t000 _t000 inner
ukmbp_vector_it _vector from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_UKM_SINGLE_VEC view
EndUserText.label Payment Behavior Summary view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY partner ukmbp_vector_it partner
@AbapCatalog.sqlViewName: 'V_UKM_SINGLE_VEC'
@EndUserText.label: 'Payment Behavior Summary'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
//CDS Hardening: lines commented out with ////////

define view v_ukm_single_vector
  as select from ukmbp_vector_it as _vector
    inner join   t000            as _t000 on  _vector.client = _t000.mandt
                                          and _vector.logsys = _t000.logsys
{
  key _vector.partner
////////  ,

////////  key _vector.credit_sgmnt,

////////  key _vector.logsys,

////////      _vector.paymnt_curr,

////////      @Semantics.amount.currencyCode: 'paymnt_curr'

////////      _vector.paymnt_amount,

////////      _vector.paymnt_date,

////////      @Semantics.currencyCode: true

////////      _vector.ovdue_curr,

////////      @Semantics.amount.currencyCode: 'ovdue_curr'

////////      _vector.ovdue_amount,

////////      _vector.ovdue_net_date,

////////      _vector.dunn_max_lv,

////////      _vector.idx_figure,

////////      @Semantics.currencyCode: true

////////      _vector.idx_curr,

////////      @Semantics.amount.currencyCode: 'idx_curr'

////////      _vector.sales_vol,

////////      _vector.sales_max

}