C_OneTimeAcctSEPAMandtList

DDL: C_ONETIMEACCTSEPAMANDTLIST SQL: COTASEPALIST Type: view CONSUMPTION Package: ODATA_ONE_TIME_ACCOUNT_REUSE
105 Fields 1 Data Sources 1 OData Services

SEPA Mandate List for One Time Account

C_OneTimeAcctSEPAMandtList is a Consumption CDS View that provides data about "SEPA Mandate List for One Time Account" in SAP S/4HANA. It reads from 1 data source (R_FinSEPAMandateDraftTP) and exposes 105 fields with key fields SEPAMandateUUID, SEPAMandateImageType. It is exposed through 1 OData service (UI_JOURNALENTRYONETIMEACCOUNT). Part of development package ODATA_ONE_TIME_ACCOUNT_REUSE.

Data Sources (1)

SourceAliasJoin Type
R_FinSEPAMandateDraftTP R_FinSEPAMandateDraftTP from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName COTASEPALIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label SEPA Mandate List for One Time Account view
ObjectModel.query.implementedBy ABAP:CL_FOTA_SEPA_MANDATE_QUERY view

OData Services (1)

ServiceBindingVersionContractRelease
UI_JOURNALENTRYONETIMEACCOUNT UI_JOURNALENTRY_OTA_O2 V2 C1 NOT_RELEASED

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY SEPAMandateUUID SEPAMandateUUID Mandate ID
KEY SEPAMandateImageType SEPAMandateImageType
SEPAMandateVersion SEPAMandateVersion
SEPAMandateApplication SEPAMandateApplication
SEPAMandate SEPAMandate SEPA Mandate
SEPAMandateSender SEPAMandateSender Document Reference
PayingCompanyCode PayingCompanyCode Paying Company Code
PayingCompanyCodeName _PayingCompanyCode CompanyCodeName Company Name
SEPAMandateStatus SEPAMandateStatus
SEPAMandateStatusName
SEPAMandateStatusChangeReason SEPAMandateStatusChangeReason
SEPAMandateStsChangeReasonName
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
SEPAPaymentType SEPAPaymentType
SEPAPaymentTypeName
SEPAMandateIsB2BMandate SEPAMandateIsB2BMandate
SEPASignatureCityName SEPASignatureCityName
SEPASignatureDate SEPASignatureDate
SEPAMandateCreatedByUser SEPAMandateCreatedByUser
CreatedByUserDescription CreatedByUserDescription Description
SEPAMandateCreationDate SEPAMandateCreationDate
SEPAMandateCreationTime SEPAMandateCreationTime
OriglSEPAMandateCreatedByUser OriglSEPAMandateCreatedByUser
OriglCreatedByUserDescription OriglCreatedByUserDescription
OriglSEPAMandateCreationDate OriglSEPAMandateCreationDate
OriglSEPAMandateCreationTime OriglSEPAMandateCreationTime
SenderLastName SenderLastName Last Name
SenderFirstName SenderFirstName First Name
SenderStreetName SenderStreetName Street
SenderHouseNumber SenderHouseNumber House Number
SenderPostalCode SenderPostalCode Postal Code
SenderCityName SenderCityName City
SenderCountry SenderCountry Country/Reg.
SenderCountryName
SenderLanguage SenderLanguage Language
SenderLanguageName
SEPAMandateSenderExternalID SEPAMandateSenderExternalID
SEPAMandateAlternativePyrName SEPAMandateAlternativePyrName Name
SEPAMandateAlternativePayer SEPAMandateAlternativePayer ID
SEPAMandateSenderIBAN SEPAMandateSenderIBAN
SEPAMandateSenderBankSWIFTCode SEPAMandateSenderBankSWIFTCode
RecipientName1 RecipientName1 Name 1
RecipientName2 RecipientName2 Name 2
SEPAMandateCreditor SEPAMandateCreditor Creditor ID
RecipientStreetName RecipientStreetName Street
RecipientHouseNumber RecipientHouseNumber House Number
RecipientPostalCode RecipientPostalCode Postal Code
RecipientCityName RecipientCityName City
RecipientCountry RecipientCountry Country/Region
SEPAMandateAlternativePyeName SEPAMandateAlternativePyeName Name
SEPAMandateAlternativePayee SEPAMandateAlternativePayee ID
SEPAMandateChangeReason SEPAMandateChangeReason
OriginalSEPAMandateCreditor OriginalSEPAMandateCreditor
OriginalSEPAMandate OriginalSEPAMandate
SEPAMandateReferenceType SEPAMandateReferenceType
SEPAMandateReferenceTypeName
SEPAMandateReference SEPAMandateReference
SEPAMandateReferenceDesc SEPAMandateReferenceDesc
SEPAMandateSenderType SEPAMandateSenderType
SEPAMandateSenderTypeName
SEPAMandateRecipientType SEPAMandateRecipientType
SEPAMandateRecipientTypeName
SEPAMandateRecipient SEPAMandateRecipient
SEPAMandateFirstUseDate SEPAMandateFirstUseDate
SEPAMandateFirstUseObjTypeCode SEPAMandateFirstUseObjTypeCode
SEPAMandateFirstUseObjTypeText
SEPAMandateFirstUsePaymentDoc SEPAMandateFirstUsePaymentDoc
SEPAMandateFirstUsePaymentRun SEPAMandateFirstUsePaymentRun
SEPAMandateLastUseDate SEPAMandateLastUseDate
SEPAMandateLastUseObjTypeCode SEPAMandateLastUseObjTypeCode
SEPAMandateLastUseObjTypeText
SEPAMandateLastUsePaymentDoc SEPAMandateLastUsePaymentDoc
SEPAMandateOrganizationalUnit1 SEPAMandateOrganizationalUnit1
SEPAMandateOrganizationalUnit2 SEPAMandateOrganizationalUnit2
SEPAMandateOrganizationalUnit3 SEPAMandateOrganizationalUnit3
SEPAMandateOrganizationalUnit4 SEPAMandateOrganizationalUnit4
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocumentItem AccountingDocumentItem Posting View Item
OneTimeAccountSourceDocType OneTimeAccountSourceDocType
OneTimeAccountSourceDocument OneTimeAccountSourceDocument
OneTimeAccountSourceDocItem OneTimeAccountSourceDocItem
FinSEPAMandateTransactionType FinSEPAMandateTransactionType
FinSEPAMandateProcessingStage FinSEPAMandateProcessingStage
DraftEntityOperationCode
IsActiveEntity
HasActiveEntity
HasDraftEntity
SEPAMandateAttchObjectKey
_Application _Application
_CompanyCode _CompanyCode
_PayingCompanyCode _PayingCompanyCode
_SEPAPaymentType _SEPAPaymentType
_SEPAMandateStatus _SEPAMandateStatus
_FirstUseObjTypeText _FirstUseObjTypeText
_LastUseObjTypeText _LastUseObjTypeText
_CreatedByUser _CreatedByUser
_SEPAChangeReason _SEPAChangeReason
_OriglCreatedByUser _OriglCreatedByUser
_SEPASenderTypeText _SEPASenderTypeText
_SEPAReferenceTypeText _SEPAReferenceTypeText
_SEPARecipientTypeText _SEPARecipientTypeText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_OneTimeAcctSEPAMandtList.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: COTASEPALIST

CREATE VIEW C_OneTimeAcctSEPAMandtList AS
SELECT
  SEPAMandateUUID,
  SEPAMandateImageType,
  SEPAMandateVersion,
  SEPAMandateApplication,
  SEPAMandate,
  SEPAMandateSender,
  PayingCompanyCode,
  _PayingCompanyCode.CompanyCodeName AS PayingCompanyCodeName,
  SEPAMandateStatus,
  _SEPAMandateStatus._Text[1:Language =$session.system_language].SEPAMandateStatusName AS SEPAMandateStatusName,
  SEPAMandateStatusChangeReason,
  _SEPAChangeReason._Text[1:Language =$session.system_language].SEPAMandateStsChangeReasonName AS SEPAMandateStsChangeReasonName,
  ValidityStartDate,
  ValidityEndDate,
  SEPAPaymentType,
  _SEPAPaymentType._Text[1:Language =$session.system_language].SEPAPaymentTypeName AS SEPAPaymentTypeName,
  SEPAMandateIsB2BMandate,
  SEPASignatureCityName,
  SEPASignatureDate,
  SEPAMandateCreatedByUser,
  CreatedByUserDescription,
  SEPAMandateCreationDate,
  SEPAMandateCreationTime,
  OriglSEPAMandateCreatedByUser,
  OriglCreatedByUserDescription,
  OriglSEPAMandateCreationDate,
  OriglSEPAMandateCreationTime,
  SenderLastName,
  SenderFirstName,
  SenderStreetName,
  SenderHouseNumber,
  SenderPostalCode,
  SenderCityName,
  SenderCountry,
  _SenderCountryText[1:Language =$session.system_language].CountryName AS SenderCountryName,
  SenderLanguage,
  _SenderLanguageText[1:Language =$session.system_language].LanguageName AS SenderLanguageName,
  SEPAMandateSenderExternalID,
  SEPAMandateAlternativePyrName,
  SEPAMandateAlternativePayer,
  SEPAMandateSenderIBAN,
  SEPAMandateSenderBankSWIFTCode,
  RecipientName1,
  RecipientName2,
  SEPAMandateCreditor,
  RecipientStreetName,
  RecipientHouseNumber,
  RecipientPostalCode,
  RecipientCityName,
  RecipientCountry,
  SEPAMandateAlternativePyeName,
  SEPAMandateAlternativePayee,
  SEPAMandateChangeReason,
  OriginalSEPAMandateCreditor,
  OriginalSEPAMandate,
  SEPAMandateReferenceType,
  cast(_SEPAReferenceTypeText[1:Language =$session.system_language].BusinessObjectTypeDescription as fsepa_ref_type_name preserving type ) AS SEPAMandateReferenceTypeName,
  SEPAMandateReference,
  SEPAMandateReferenceDesc,
  SEPAMandateSenderType,
  _SEPASenderTypeText[1:Language =$session.system_language].SEPAMandateSenderTypeName AS SEPAMandateSenderTypeName,
  SEPAMandateRecipientType,
  _SEPARecipientTypeText[1:Language =$session.system_language].BusinessObjectTypeDescription AS SEPAMandateRecipientTypeName,
  SEPAMandateRecipient,
  SEPAMandateFirstUseDate,
  SEPAMandateFirstUseObjTypeCode,
  _FirstUseObjTypeText[1:Language =$session.system_language].BusinessObjectTypeDescription AS SEPAMandateFirstUseObjTypeText,
  SEPAMandateFirstUsePaymentDoc,
  SEPAMandateFirstUsePaymentRun,
  SEPAMandateLastUseDate,
  SEPAMandateLastUseObjTypeCode,
  _LastUseObjTypeText[1:Language =$session.system_language].BusinessObjectTypeDescription AS SEPAMandateLastUseObjTypeText,
  SEPAMandateLastUsePaymentDoc,
  SEPAMandateOrganizationalUnit1,
  SEPAMandateOrganizationalUnit2,
  SEPAMandateOrganizationalUnit3,
  SEPAMandateOrganizationalUnit4,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  OneTimeAccountSourceDocType,
  OneTimeAccountSourceDocument,
  OneTimeAccountSourceDocItem,
  FinSEPAMandateTransactionType,
  FinSEPAMandateProcessingStage,
  cast('' as char1) AS DraftEntityOperationCode,
  cast('' as boole_d) AS IsActiveEntity,
  cast('' as boole_d) AS HasActiveEntity,
  cast('' as boole_d) AS HasDraftEntity,
  cast('' as swo_typeid) AS SEPAMandateAttchObjectKey
FROM R_FinSEPAMandateDraftTP
;

Learn More