I_CAPaymentMethodApplArea

DDL: I_CAPAYMENTMETHODAPPLAREA Type: view_entity BASIC

Payment Method per Application Area

I_CAPaymentMethodApplArea is a Basic CDS View that provides data about "Payment Method per Application Area" in SAP S/4HANA. It reads from 2 data sources (I_CAApplicationArea, tfk042za) and exposes 9 fields with key fields Country, CAPaymentMethod, CAApplicationArea. It has 3 associations to related views.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_CAApplicationArea ApplArea inner
tfk042za tfk042za from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Country _Country $projection.Country = _Country.Country
[0..*] I_CAPaymentMethodText _PaymentMethodText $projection.Country = _PaymentMethodText.Country and $projection.CAPaymentMethod = _PaymentMethodText.CAPaymentMethod
[1..1] I_CAApplicationArea _ApplArea $projection.CAApplicationArea = _ApplArea.CAApplicationArea

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey CAPaymentMethod view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Payment Method per Application Area view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Country tfk042za land1
KEY CAPaymentMethod tfk042za zlsch
KEY CAApplicationArea tfk042za applk
CADocumentType tfk042za blart
CAClearingReason tfk042za augrd
CANoteToPayeeCategory tfk042za preftyp
_Country _Country
_PaymentMethodText _PaymentMethodText
_ApplArea _ApplArea 
@VDM.viewType: #BASIC

@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
@ObjectModel.representativeKey: 'CAPaymentMethod'
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]

@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Payment Method per Application Area'

define view entity I_CAPaymentMethodApplArea
  as select from tfk042za
    inner join   I_CAApplicationArea as ApplArea on tfk042za.applk = ApplArea.CAApplicationArea

  association [1..1] to I_Country             as _Country           on  $projection.Country = _Country.Country
  association [0..*] to I_CAPaymentMethodText as _PaymentMethodText on  $projection.Country         = _PaymentMethodText.Country
                                                                    and $projection.CAPaymentMethod = _PaymentMethodText.CAPaymentMethod
  association [1..1] to I_CAApplicationArea   as _ApplArea          on  $projection.CAApplicationArea = _ApplArea.CAApplicationArea

{
      @ObjectModel.foreignKey.association: '_Country'
  key tfk042za.land1   as Country,
      @ObjectModel.text.association: '_PaymentMethodText'
  key tfk042za.zlsch   as CAPaymentMethod,
      @ObjectModel.foreignKey.association: '_ApplArea'   
  key tfk042za.applk   as CAApplicationArea,
      tfk042za.blart   as CADocumentType,
      tfk042za.augrd   as CAClearingReason,
      tfk042za.preftyp as CANoteToPayeeCategory,

      _Country,
      _PaymentMethodText,
      _ApplArea
}

where
  ApplArea.CAApplicationAreaIsActive = 'X'

Learn More