I_SEPAMandate

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 I_SEPAMandate.
-- 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: ISEPAMANDATE

CREATE VIEW I_SEPAMandate AS
SELECT
  mguid AS SEPAMandateUUID,
  mndid AS SEPAMandate,
  mvers AS SEPAMandateVersion,
  sign_city AS SEPASignatureCityName,
  sign_date AS SEPASignatureDate,
  pay_type AS SEPAPaymentType,
  val_from_date AS ValidityStartDate,
  val_to_date AS ValidityEndDate,
  status AS SEPAMandateStatus,
  b2b AS SEPAMandateIsB2BMandate,
  reason_code AS SEPAMandateStatusChangeReason,
  ernam AS SEPAMandateCreatedByUser,
  erdat AS SEPAMandateCreationDate,
  ertim AS SEPAMandateCreationTime,
  chg_reason AS SEPAMandateChangeReason,
  origin_rec_crdid AS OriginalSEPAMandateCreditor,
  origin_mndid AS OriginalSEPAMandate,
  glock AS SEPAMandateIsLocked,
  cast(glock_val_from as sepa_cds_glock_val_from_date preserving type ) AS SEPAMandateLockStartDate,
  cast(glock_val_to as sepa_cds_glock_val_to_date preserving type ) AS SEPAMandateLockEndDate,
  anwnd AS SEPAMandateApplication,
  ori_ernam AS OriglSEPAMandateCreatedByUser,
  ori_erdat AS OriglSEPAMandateCreationDate,
  ori_ertim AS OriglSEPAMandateCreationTime,
  ref_type AS SEPAMandateReferenceType,
  ref_id AS SEPAMandateReference,
  ref_desc AS SEPAMandateReferenceDesc,
  snd_type AS SEPAMandateSenderType,
  snd_id AS SEPAMandateSender,
  snd_name1 AS SenderLastName,
  snd_name2 AS SenderFirstName,
  snd_street AS SenderStreetName,
  snd_housenum AS SenderHouseNumber,
  snd_postal AS SenderPostalCode,
  snd_city AS SenderCityName,
  snd_country AS SenderCountry,
  snd_language AS SenderLanguage,
  snd_iban AS SEPAMandateSenderIBAN,
  snd_bic AS SEPAMandateSenderBankSWIFTCode,
  cast(snd_dir_name as fsepa_alternative_payer_name preserving type ) AS SEPAMandateAlternativePyrName,
  snd_dir_id AS SEPAMandateAlternativePayer,
  cast(snd_debtor_id as fsepa_snd_debtor_id preserving type ) AS SEPAMandateSenderExternalID,
  rec_type AS SEPAMandateRecipientType,
  rec_id AS SEPAMandateRecipient,
  rec_name1 AS RecipientName1,
  rec_name2 AS RecipientName2,
  rec_crdid AS SEPAMandateCreditor,
  rec_street AS RecipientStreetName,
  rec_housenum AS RecipientHouseNumber,
  rec_postal AS RecipientPostalCode,
  rec_city AS RecipientCityName,
  rec_country AS RecipientCountry,
  rec_dir_name AS SEPAMandateAlternativePyeName,
  rec_dir_id AS SEPAMandateAlternativePayee,
  firstuse_date AS SEPAMandateFirstUseDate,
  firstuse_doctype AS SEPAMandateFirstUseObjTypeCode,
  firstuse_docid AS SEPAMandateFirstUsePaymentDoc,
  lastuse_date AS SEPAMandateLastUseDate,
  lastuse_doctype AS SEPAMandateLastUseObjTypeCode,
  lastuse_docid AS SEPAMandateLastUsePaymentDoc,
  firstuse_payrun AS SEPAMandateFirstUsePaymentRun,
  orgf1 AS SEPAMandateOrganizationalUnit1,
  orgf2 AS SEPAMandateOrganizationalUnit2,
  orgf3 AS SEPAMandateOrganizationalUnit3,
  orgf4 AS SEPAMandateOrganizationalUnit4,
  laufd AS CAMassRunDate,
  laufi AS CAMassRunID
FROM sepa_mandate
;