P_DirectDebitMandate

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_DirectDebitMandate.
-- 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.

CREATE VIEW P_DirectDebitMandate AS
SELECT
  SEPAMandateUUID AS DirectDebitMandateUUID,
  SEPAMandate AS DirectDebitMandate,
  SEPAMandateVersion AS MandateVersion,
  SEPASignatureCityName AS MandateSignatureLocation,
  SEPASignatureDate AS MandateSignatureDate,
  SEPAPaymentType AS MandatePaymentType,
  ValidityStartDate AS MandateValidityDateStartDate,
  ValidityEndDate AS MandateValidityEndDate,
  _SEPAMandateStatus._Text[1:Language =$session.system_language].SEPAMandateStatusName AS MandateStatusName,
  SEPAMandateStatus AS MandateStatus,
  SEPAMandateIsB2BMandate AS MandateIsB2BMandate,
  _MandateChangeReason._Text[1:Language =$session.system_language].SEPAMandateStsChangeReasonName AS MandateStatusChangeReasonName,
  SEPAMandateStatusChangeReason AS MandateStatusChangeReason,
  cast(SEPAMandateCreatedByUser as sepa_cds_ernam preserving type) AS MandateCreatedByUser,
  SEPAMandateCreationDate AS MandateCreationDate,
  SEPAMandateCreationTime AS MandateCreationTime,
  SEPAMandateChangeReason AS DirectDebitMandateChangeReason,
  OriginalSEPAMandateCreditor AS OriginalMandateCreditor,
  OriginalSEPAMandate AS OriginalMandate,
  SEPAMandateIsLocked AS MandateIsLocked,
  SEPAMandateApplication AS MandateApplication,
  SEPAMandateApplication AS TemporaryMandateApplication,
  OriglSEPAMandateCreatedByUser AS IDOriginalMandateCreatedByUser,
  OriglSEPAMandateCreationDate AS OriglMandateCreationDate,
  OriglSEPAMandateCreationTime AS OriglMandateCreationTime,
  SEPAMandateReferenceType AS MandateReferenceType,
  SEPAMandateReference AS MandateReference,
  SEPAMandateReferenceDesc AS MandateReferenceDesc,
  cast( SEPAMandateSenderType as sepa_cds_snd_type preserving type ) AS MandateSenderType,
  SEPAMandateSender AS MandateSender,
  SenderLastName,
  SenderFirstName,
  SenderStreetName,
  SenderHouseNumber,
  SenderPostalCode,
  SenderCityName,
  SenderCountry,
  SEPAMandateSenderIBAN AS MandateSenderIBAN,
  SEPAMandateSenderBankSWIFTCode AS MandateSenderBankSWIFTCode,
  SenderLanguage,
  SEPAMandateAlternativePayer AS MandateAlternativeDebtor,
  SEPAMandateRecipientType AS MandateRecipientType,
  SEPAMandateRecipient AS MandateRecipient,
  RecipientName1,
  RecipientName2,
  SEPAMandateCreditor AS MandateCreditor,
  RecipientStreetName,
  RecipientHouseNumber,
  RecipientPostalCode,
  RecipientCityName,
  RecipientCountry,
  SEPAMandateAlternativePyeName AS MandateAlternativePayeeName,
  SEPAMandateAlternativePayee AS MandateAlternativePayee,
  SEPAMandateFirstUseDate AS MandateFirstUseDate,
  SEPAMandateFirstUseObjTypeCode AS MandateFirstUseObjTypeCode,
  SEPAMandateFirstUsePaymentDoc AS MandateFirstUseInPaymentDoc,
  SEPAMandateLastUseDate AS MandateLastUseDate,
  SEPAMandateLastUseObjTypeCode AS MandateLastUseObjTypeCode,
  SEPAMandateLastUsePaymentDoc AS MandateLastUseInPaymentDoc,
  SEPAMandateFirstUsePaymentRun AS MandateFirstUsePaymentRun,
  SEPAMandateOrganizationalUnit1 AS MandateOrganizationalUnit1,
  SEPAMandateOrganizationalUnit2 AS MandateOrganizationalUnit2,
  SEPAMandateOrganizationalUnit3 AS MandateOrganizationalUnit3,
  SEPAMandateOrganizationalUnit4 AS MandateOrganizationalUnit4,
  SenderCountryOrRegion,
  MandateDirectDebitProcedure,
  BankCountry,
  PayingBankKey,
  BankAccount,
  BankControlKey,
  ReferenceBankDetails,
  ShortKeyHouseBank,
  AccountDetails
FROM I_SEPAMandateBasic
LEFT OUTER JOIN I_SEPAApplication AS _Application ON MandateApplication = _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 MandateStatus = _SEPAMandateStatus.SEPAMandateStatus  -- association [1..1]
LEFT OUTER JOIN I_SEPAMandateStatusChgReason AS _MandateChangeReason ON MandateApplication = _MandateChangeReason.SEPAMandateApplication AND MandateStatus = _MandateChangeReason.SEPAMandateStatus AND MandateStatusChangeReason = _MandateChangeReason.SEPAMandateStatusChangeReason  -- association [1..1]
LEFT OUTER JOIN I_SEPAMandateStsChgRsnText AS _MandateChangeReasonText ON MandateApplication = _MandateChangeReasonText.SEPAMandateApplication AND MandateStatus = _MandateChangeReasonText.SEPAMandateStatus AND MandateStatusChangeReason = _MandateChangeReasonText.SEPAMandateStatusChangeReason AND _MandateChangeReasonText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ManageSEPASenderTypeText AS _SenderTypeText ON MandateSenderType = _SenderTypeText.SEPAMandateSenderType  -- association [0..*]
LEFT OUTER JOIN I_BusinessObjTypeText AS _ReferenceTypeText ON MandateReferenceType = _ReferenceTypeText.BusinessObjectType  -- association [0..*]
LEFT OUTER JOIN I_BusinessObjTypeText AS _RecipientTypeText ON MandateRecipientType = _RecipientTypeText.BusinessObjectType  -- association [0..*]
LEFT OUTER JOIN I_SEPAPaymentType AS _PaymentType ON MandatePaymentType = _PaymentType.SEPAPaymentType  -- association [1..1]
LEFT OUTER JOIN I_BusinessObjTypeText AS _FirstUseObjTypeText ON MandateFirstUseObjTypeCode = _FirstUseObjTypeText.BusinessObjectType  -- association [0..*]
LEFT OUTER JOIN I_BusinessObjTypeText AS _LastUseObjTypeText ON MandateLastUseObjTypeCode = _LastUseObjTypeText.BusinessObjectType  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON MandateCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _OriglCreatedByUser ON IDOriginalMandateCreatedByUser = _OriglCreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _PayerBankCountryText ON _PayerBankCountryText.Country = BankCountry AND _PayerBankCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _SenderCountryText ON _SenderCountryText.Country = SenderCountry AND _SenderCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _PayerCountryText ON _PayerCountryText.Country = BankCountry AND _PayerCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _RecipientCountryText ON _RecipientCountryText.Country = RecipientCountry AND _RecipientCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON _ContractAccountHeader.ContractAccount = ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountText ON _ContractAccountText.ContractAccount = ContractAccount AND _ContractAccountText.BusinessPartner = BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ProviderContract AS _ProviderContractText ON _ProviderContractText.ProviderContract = CAContract  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplicationText ON _CASubApplicationText.CASubApplication = CASubApplication  -- association [1..1]
LEFT OUTER JOIN I_SEPAApplicationText AS _MandateApplicationText ON MandateApplication = _MandateApplicationText.SEPAMandateApplication AND _MandateApplicationText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SEPAPaymentTypeText AS _MandatePaymentTypeText ON MandatePaymentType = _MandatePaymentTypeText.SEPAPaymentType AND _MandatePaymentTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SEPAMandateStatusText AS _SEPAMandateStatusText ON MandateStatus = _SEPAMandateStatusText.SEPAMandateStatus AND _SEPAMandateStatusText.Language = $session.system_language  -- association [1..1]
;