C_FinInvoiceSEPAMandateFDP

DDL: C_FININVOICESEPAMANDATEFDP Type: view_entity CONSUMPTION Package: FINS_OUTPUT_MGMT_FO_FICUS_INV

SEPA Mandate for FI Customer Invoice

C_FinInvoiceSEPAMandateFDP is a Consumption CDS View that provides data about "SEPA Mandate for FI Customer Invoice" in SAP S/4HANA. It reads from 1 data source (I_SEPAMandate) and exposes 15 fields with key field SEPAMandateUUID. Part of development package FINS_OUTPUT_MGMT_FO_FICUS_INV.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_SEPAMandate I_SEPAMandate from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SEPA Mandate for FI Customer Invoice view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SEPAMandateUUID SEPAMandateUUID
SEPAMandate SEPAMandate
SEPAMandateVersion SEPAMandateVersion
SEPASignatureCityName SEPASignatureCityName
SEPASignatureDate SEPASignatureDate
SEPAPaymentType SEPAPaymentType
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
SEPAMandateStatus SEPAMandateStatus
SEPAMandateSenderType SEPAMandateSenderType
SEPAMandateSender SEPAMandateSender
SEPAMandateSenderIBAN SEPAMandateSenderIBAN
SEPAMandateSenderBankSWIFTCode SEPAMandateSenderBankSWIFTCode
SEPAMandateRecipient SEPAMandateRecipient
SEPAMandateApplication SEPAMandateApplication 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'SEPA Mandate for FI Customer Invoice'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@ObjectModel.supportedCapabilities: [ #OUTPUT_FORM_DATA_PROVIDER ]
@VDM.viewType: #CONSUMPTION
define view entity C_FinInvoiceSEPAMandateFDP
  as select from I_SEPAMandate
{
  key SEPAMandateUUID,
      SEPAMandate,
      SEPAMandateVersion,
      SEPASignatureCityName,
      SEPASignatureDate,
      SEPAPaymentType,
      ValidityStartDate,
      ValidityEndDate,
      SEPAMandateStatus,
      SEPAMandateSenderType,
      SEPAMandateSender,
      SEPAMandateSenderIBAN,
      SEPAMandateSenderBankSWIFTCode,
      SEPAMandateRecipient,
      SEPAMandateApplication
}
where SEPAMandateApplication = 'F'        //FI

  and SEPAMandateStatus = '1'             //active

  and SEPAMandateVersion = '0000'
  and SEPAMandateSenderType = 'BUS3007'   //Customer

  and ValidityStartDate <= $session.system_date
  and ValidityEndDate   >= $session.system_date

Learn More