FARMLVD_PAYMTADV

DDL: FARMLVD_PAYMTADV Type: view_entity Package: FINS_AR_MACHINE_LEARNING

Payment Advice Information

FARMLVD_PAYMTADV is a CDS View that provides data about "Payment Advice Information" in SAP S/4HANA. It reads from 3 data sources (I_Customer, I_PaymentAdvice, I_PaymentAdviceItem) and exposes 21 fields. Part of development package FINS_AR_MACHINE_LEARNING.

3 data source(s) 21 fields

Data Sources (3)

SourceAliasJoin Type
I_Customer cust left_outer
I_PaymentAdvice PaymentAdviceHeader from
I_PaymentAdviceItem PaymentAdviceItem inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Payment Advice Information view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (21)

KeyFieldSource TableSource FieldDescription
PaymentAdvice I_PaymentAdvice PaymentAdvice
PaymentAdviceItem I_PaymentAdviceItem PaymentAdviceItem
PaymentAdviceAccountType I_PaymentAdviceItem PaymentAdviceAccountType
CreationDate I_PaymentAdvice CreationDate
CompanyCode I_PaymentAdviceItem CompanyCode
PaymentAdviceAccount
PaymentCurrency I_PaymentAdvice PaymentCurrency
PaidAmountInPaytCurrency I_PaymentAdvice PaidAmountInPaytCurrency
PaymentAdviceSelectionField I_PaymentAdviceItem PaymentAdviceSelectionField
PaytAdvcExternalSelectionField I_PaymentAdviceItem PaytAdvcExternalSelectionField
AccountingDocument I_PaymentAdviceItem AccountingDocument
DocumentReferenceID I_PaymentAdviceItem DocumentReferenceID
AssignmentReference I_PaymentAdviceItem AssignmentReference
InvoiceDate I_PaymentAdviceItem InvoiceDate
NetPaymentAmountInPaytCurrency I_PaymentAdviceItem NetPaymentAmountInPaytCurrency
Currency I_PaymentAdviceItem Currency
FiscalYear I_PaymentAdviceItem FiscalYear
PaymentDifferenceReason I_PaymentAdviceItem PaymentDifferenceReason
DeductionAmountInPaytCurrency I_PaymentAdviceItem DeductionAmountInPaytCurrency
CustomerName I_Customer CustomerName
CityName I_Customer CityName 
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Payment Advice Information'
@ObjectModel.usageType.sizeCategory:#XXL
@ObjectModel.usageType.dataClass:  #MIXED 
@ObjectModel.usageType.serviceQuality: #D
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view entity FARMLVD_PAYMTADV as 
select from I_PaymentAdvice as PaymentAdviceHeader 
inner join I_PaymentAdviceItem as PaymentAdviceItem
        on PaymentAdviceHeader.CompanyCode = PaymentAdviceItem.CompanyCode
       and PaymentAdviceHeader.PaymentAdviceAccountType = PaymentAdviceItem.PaymentAdviceAccountType
       and PaymentAdviceHeader.PaymentAdviceAccount = PaymentAdviceItem.PaymentAdviceAccount
       and PaymentAdviceHeader.PaymentAdvice = PaymentAdviceItem.PaymentAdvice 
left outer join I_Customer as cust
        on PaymentAdviceItem.PaymentAdviceAccount = cust.Customer{
   PaymentAdviceHeader.PaymentAdvice,
   PaymentAdviceItem.PaymentAdviceItem,
   PaymentAdviceItem.PaymentAdviceAccountType,
   PaymentAdviceHeader.CreationDate,
   PaymentAdviceItem.CompanyCode,
   case when PaymentAdviceHeader.PaymentAdviceAccount = '*' then PaymentAdviceItem.PaymentAdviceAltvAccount else PaymentAdviceHeader.PaymentAdviceAccount end as PaymentAdviceAccount,
   PaymentAdviceHeader.PaymentCurrency,
  @Semantics.amount.currencyCode: 'PaymentCurrency'
   PaymentAdviceHeader.PaidAmountInPaytCurrency,
   PaymentAdviceItem.PaymentAdviceSelectionField,
   PaymentAdviceItem.PaytAdvcExternalSelectionField,
   PaymentAdviceItem.AccountingDocument,
   PaymentAdviceItem.DocumentReferenceID,
   PaymentAdviceItem.AssignmentReference,
   PaymentAdviceItem.InvoiceDate,
   PaymentAdviceItem.NetPaymentAmountInPaytCurrency,
   PaymentAdviceItem.Currency,
   PaymentAdviceItem.FiscalYear,
   PaymentAdviceItem.PaymentDifferenceReason,
   PaymentAdviceItem.DeductionAmountInPaytCurrency,
   cust.CustomerName,
   cust.CityName
} where PaymentAdviceItem.PaymentAdviceAccountType = 'D'

Learn More