P_ManageSEPAMandate

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 P_ManageSEPAMandate.
-- 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: PMNGSEPA

CREATE VIEW P_ManageSEPAMandate AS
SELECT
  SEPAMandateUUID,
  SEPAMandateApplication,
  SEPAMandate,
  ValidityStartDate,
  ValidityEndDate,
  SEPAMandateCreationDate,
  SEPAMandateIsLocked,
  cast(SEPAMandateCreatedByUser as sepa_cds_ernam preserving type) AS SEPAMandateCreatedByUser,
  SEPAMandateStatus,
  _SEPAMandateStatus._Text[1:Language =$session.system_language].SEPAMandateStatusName AS SEPAMandateStatusName,
  SEPAMandateReferenceType,
  cast(_SEPAReferenceTypeText[1:Language =$session.system_language].BusinessObjectTypeDescription as fsepa_ref_type_name preserving type ) AS SEPAMandateReferenceTypeName,
  SEPAMandateReference,
  cast( SEPAMandateReferenceDesc as sepa_cds_ref_desc preserving type ) AS SEPAMandateReferenceDesc,
  cast( SEPAMandateSenderType as sepa_cds_snd_type preserving type ) AS SEPAMandateSenderType,
  _SEPASenderTypeText[1:Language =$session.system_language].SEPAMandateSenderTypeName AS SEPAMandateSenderTypeName,
  SEPAMandateSender,
  SEPAMandateRecipientType,
  _SEPARecipientTypeText[1:Language =$session.system_language].BusinessObjectTypeDescription AS SEPAMandateRecipientTypeName,
  SEPAMandateRecipient,
  cast(250 as sepa_cds_maxnum) AS MaximumNumberOfHits,
  cast('' as sepa_cds_snd_type) AS SenderType,
  CAMassRunDate,
  CAMassRunID,
  SEPAPaymentType,
  _SEPAPaymentType._Text[1:Language =$session.system_language].SEPAPaymentTypeName AS SEPAPaymentTypeName,
  SEPAMandateFirstUseObjTypeCode,
  cast(_FirstUseObjTypeText[1:Language =$session.system_language].BusinessObjectTypeDescription as fsepa_firstuse_doctype_name preserving type ) AS SEPAMandateFirstUseObjTypeText,
  SEPAMandateFirstUsePaymentDoc,
  SEPAMandateLastUseObjTypeCode,
  cast(_LastUseObjTypeText[1:Language =$session.system_language].BusinessObjectTypeDescription as fsepa_lastuse_doctype_name preserving type ) AS SEPAMandateLastUseObjTypeText,
  SEPAMandateCreditor,
  SEPAMandateSenderIBAN,
  SEPAMandateSenderBankSWIFTCode,
  SEPAMandateFirstUsePaymentRun,
  cast( SEPAMandateLastUseDate as sepa_cds_lastuse_date preserving type ) AS SEPAMandateLastUseDate,
  cast( SEPAMandateFirstUseDate as sepa_cds_firstuse_date preserving type ) AS SEPAMandateFirstUseDate,
  SEPAMandateVersion,
  SEPAMandateIsB2BMandate,
  OriginalSEPAMandateCreditor,
  OriginalSEPAMandate,
  SEPAMandateLastUsePaymentDoc,
  SEPAMandateAlternativePayer,
  SEPASignatureCityName,
  SEPASignatureDate,
  SEPAMandateChangeReason,
  SEPAMandateStatusChangeReason,
  _SEPAChangeReason._Text[1:Language =$session.system_language].SEPAMandateStsChangeReasonName AS SEPAMandateStsChangeReasonName,
  SEPAMandateLockStartDate,
  SEPAMandateLockEndDate,
  SEPAMandateAlternativePyeName,
  SEPAMandateAlternativePayee,
  SEPAMandateOrganizationalUnit1,
  SEPAMandateOrganizationalUnit2,
  SEPAMandateOrganizationalUnit3,
  SEPAMandateOrganizationalUnit4,
  OriglSEPAMandateCreatedByUser,
  OriglSEPAMandateCreationDate,
  SEPAMandateAlternativePyrName,
  SEPAMandateSenderExternalID,
  SenderLastName,
  SenderFirstName,
  SenderStreetName,
  SenderHouseNumber,
  SenderPostalCode,
  SenderCityName,
  SenderCountry,
  RecipientName1,
  RecipientName2,
  RecipientStreetName,
  RecipientHouseNumber,
  RecipientPostalCode,
  RecipientCityName,
  RecipientCountry
FROM I_SEPAMandate
LEFT OUTER JOIN I_SEPAApplication AS _Application ON SEPAMandateApplication = _Application.SEPAMandateApplication  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PayingCompanyCode ON PayingCompanyCode = _PayingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CAStandardCompanyCode ON CAStandardCompanyCode = _CAStandardCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SEPAMandateStatus AS _SEPAMandateStatus ON SEPAMandateStatus = _SEPAMandateStatus.SEPAMandateStatus  -- association [1..1]
LEFT OUTER JOIN I_SEPAMandateStatusChgReason AS _SEPAChangeReason ON SEPAMandateApplication = _SEPAChangeReason.SEPAMandateApplication AND SEPAMandateStatus = _SEPAChangeReason.SEPAMandateStatus AND SEPAMandateStatusChangeReason = _SEPAChangeReason.SEPAMandateStatusChangeReason  -- association [1..1]
LEFT OUTER JOIN I_ManageSEPASenderTypeText AS _SEPASenderTypeText ON SEPAMandateSenderType = _SEPASenderTypeText.SEPAMandateSenderType  -- association [0..*]
LEFT OUTER JOIN I_BusinessObjTypeText AS _SEPAReferenceTypeText ON SEPAMandateReferenceType = _SEPAReferenceTypeText.BusinessObjectType  -- association [0..*]
LEFT OUTER JOIN I_BusinessObjTypeText AS _SEPARecipientTypeText ON SEPAMandateRecipientType = _SEPARecipientTypeText.BusinessObjectType  -- association [0..*]
LEFT OUTER JOIN I_SEPAPaymentType AS _SEPAPaymentType ON SEPAPaymentType = _SEPAPaymentType.SEPAPaymentType  -- association [1..1]
LEFT OUTER JOIN I_BusinessObjTypeText AS _FirstUseObjTypeText ON SEPAMandateFirstUseObjTypeCode = _FirstUseObjTypeText.BusinessObjectType  -- association [0..*]
LEFT OUTER JOIN I_BusinessObjTypeText AS _LastUseObjTypeText ON SEPAMandateLastUseObjTypeCode = _LastUseObjTypeText.BusinessObjectType  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON SEPAMandateCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _OriglCreatedByUser ON OriglSEPAMandateCreatedByUser = _OriglCreatedByUser.UserID  -- association [1..1]
;