I_SEPAMandateBasic

DDL: I_DIRECTDEBITMANDATEEXT Type: extend_view_entity Package: BF_DDMA
9 Fields

Extension by fields in the structure DDMA_S_MNDT_DB

I_SEPAMandateBasic is a CDS View that provides data about "Extension by fields in the structure DDMA_S_MNDT_DB" in SAP S/4HANA. Part of development package BF_DDMA.

Fields (9)

KeyFieldSource TableSource FieldDescription
SenderCountryOrRegion sepa_mandate land1_ddma Country/Reg.
MandateDirectDebitProcedure sepa_mandate proc_ddma DD Procedure
BankCountry sepa_mandate banks_ddma Bank Ctry/Reg.
PayingBankKey sepa_mandate bankl_ddma Bank Key
BankAccount sepa_mandate bankn_ddma Bank Account
BankControlKey sepa_mandate bkont_ddma Control Key
ReferenceBankDetails sepa_mandate bkref_ddma Reference
ShortKeyHouseBank sepa_mandate hbkid_ddma House Bank
AccountDetails sepa_mandate hktid_ddma Account ID

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_SEPAMandateBasic.
-- 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 I_SEPAMandateBasic AS
SELECT
  sepa_mandate.land1_ddma AS SenderCountryOrRegion,
  sepa_mandate.proc_ddma AS MandateDirectDebitProcedure,
  sepa_mandate.banks_ddma AS BankCountry,
  sepa_mandate.bankl_ddma AS PayingBankKey,
  sepa_mandate.bankn_ddma AS BankAccount,
  sepa_mandate.bkont_ddma AS BankControlKey,
  sepa_mandate.bkref_ddma AS ReferenceBankDetails,
  sepa_mandate.hbkid_ddma AS ShortKeyHouseBank,
  sepa_mandate.hktid_ddma AS AccountDetails
;

Learn More