SAP BUS_EI_COM_SEPA_MANDATE_DATA Com. Interface: Business Partner SEPA Mandates Table data and field list

BUS_EI_COM_SEPA_MANDATE_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Com. Interface: Business Partner SEPA Mandates" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BUS_EI_COM_SEPA_MANDATE_DATA TYPE BUS_EI_COM_SEPA_MANDATE_DATA.

The BUS_EI_COM_SEPA_MANDATE_DATA table consists of various fields, each holding specific information or linking keys about Com. Interface: Business Partner SEPA Mandates data available in SAP. These include SEPA_CREDITOR_ID (Creditor Identification Number), SEPA_MANDATE_ID (Unique Referene to Mandate per Payment Recipient), PAY_TYPE (SEPA: Transaction Type), SND_TYPE (SEPA Mandate: Sender Type)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

BUS_EI_COM_SEPA_MANDATE_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP BUS_EI_COM_SEPA_MANDATE_DATA structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BUS_EI_COM_SEPA_MANDATE_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
APPLICATIONSEPA: Application for Which Mandate Relevant SEPA_ANWNDCHAR1Assigned to domainSEPA_ANWND
SEPA_CREDITOR_IDCreditor Identification Number SEPA_CRDIDCHAR35ID035
SEPA_MANDATE_IDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
PAY_TYPESEPA: Transaction Type SEPA_PAY_TYPECHAR1SEPA_PAY_TYPE
SND_TYPESEPA Mandate: Sender Type SEPA_SND_TYPECHAR10Assigned to domainOJ_NAMEOBJ
SND_IDSEPA Mandate: Sender ID SEPA_SND_IDCHAR70SWO_TYPEID
SND_NAME1Last name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
SND_NAME2First name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
SND_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
SND_HOUSENUMHouse Number AD_HSNM1CHAR10TEXT10
SND_POSTALCity postal code AD_PSTCD1CHAR10CHAR10
SND_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
SND_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
SND_LANGUAGELanguage Key LANGULANG1Assigned to domainISOLASPRAS
SND_IBANIBAN (International Bank Account Number) IBANCHAR34IBAN
SND_BICSWIFT/BIC for International Payments SWIFTCHAR11SWIFT
SND_DIR_NAMESEPA: Name of Alternative Debtor SEPA_PAYMENT_FORCHAR40BU_NAME
REC_TYPESEPA Mandate: Recipient Type SEPA_REC_TYPECHAR10Assigned to domainOJ_NAMEOBJ
REC_IDSEPA Mandate: Recipient ID SEPA_REC_IDCHAR70SWO_TYPEID
REC_NAME1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
REC_NAME2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
REC_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
REC_HOUSENUMHouse Number AD_HSNM1CHAR10TEXT10
REC_POSTALCity postal code AD_PSTCD1CHAR10CHAR10
REC_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
REC_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
REF_TYPESEPA Mandate: Reference Type SEPA_REF_TYPECHAR10Assigned to domainOJ_NAMEOBJ
REF_IDSEPA Mandate: Reference ID SEPA_REF_IDCHAR70SWO_TYPEID
REF_DESCText Field TEXT50CHAR50TEXT50
LIFETIME_FROMSEPA: Validity Date of Mandate (From) SEPA_VAL_FROM_DATEDATS8DATUM
LIFETIME_TOSEPA: Validity Date of Mandate (To) SEPA_VAL_TO_DATEDATS8DATUM
SIGN_CITYLocation of Signature SEPA_SIGN_CITYCHAR40TEXT40
SIGN_DATEDate of Signature SEPA_SIGN_DATEDATS8DATUM
STATUSSEPA: Mandate Status SEPA_STATUSCHAR1SEPA_STATUS
SND_DIR_IDSEPA: ID of Alternative Debtor SEPA_SND_DIR_IDCHAR70SWO_TYPEID
REC_DIR_NAMESEPA: Name of Alternative Payee SEPA_REC_DIR_NAMECHAR40BU_NAME
REC_DIR_IDSEPA: ID of Alternative Payee SEPA_REC_DIR_IDCHAR70SWO_TYPEID
B2BSEPA-Mandate: B2B Mandate SEPA_B2BCHAR1XFELD
SND_DEBTOR_IDSEPA: ID Number of Sender (External Reference) SEPA_SND_DEBTOR_IDCHAR35ID035
ORGF1SEPA Mandate: Internal Organizational Data SEPA_ORG_IDCHAR20CHAR20
ORGF2SEPA Mandate: Internal Organizational Data SEPA_ORG_IDCHAR20CHAR20
ORGF3SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONGCHAR35CHAR35
ORGF4SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONGCHAR35CHAR35
GLOBAL_LOCKGlobal Lock Set in Mandate SEPA_GLOCKCHAR1BOOLEAN
GLOBAL_LOCK_FROMGlobal Mandate Lock - Valid From SEPA_GLOCK_VAL_FROM_DATEDATS8DATUM
GLOBAL_LOCK_TOGlobal Mandate Lock - Valid Until SEPA_GLOCK_VAL_TO_DATEDATS8DATUM
FIRSTUSE_DATEDate DATUMDATS8DATUM
FIRSTUSE_DOCTYPESEPA Mandate: Type of First Usage SEPA_FIRSTUSE_DOCTYPECHAR10Assigned to domainOJ_NAMEOBJ
FIRSTUSE_DOCIDSEPA Mandate: ID of First Usage SEPA_FIRSTUSE_DOCIDCHAR70SWO_TYPEIDOBJ
LASTUSE_DATEDate DATUMDATS8DATUM
LASTUSE_DOCTYPESEPA Mandate: Type of Last Usage SEPA_LASTUSE_DOCTYPECHAR10Assigned to domainOJ_NAMEOBJ
LASTUSE_DOCIDSEPA Mandate: ID of Last Usage SEPA_LASTUSE_DOCIDCHAR70SWO_TYPEIDOBJ
SEPA_CREDITOR_ID_ORIGINSEPA Mandate: Original Creditor ID of Mandate SEPA_CRDID_ORIGINCHAR35ID035
SEPA_MANDATE_ID_ORIGINSEPA Mandate: Original Mandate of Mandate SEPA_MNDID_ORIGINCHAR35ID035
VERSIONSEPA Mandate: Version of Mandate (0 = Current Version) SEPA_MVERSNUMC4NUM04
CREATORAuthor CNAMCHAR12SYCHAR12
CREATIONDATEDate on which the object was created BU_CRDATDATS8DATUM
CREATIONTIMETime at which the object was created BU_CRTIMTIMS6UZEIT
BUAG_IDCharacter Field of Length 12 CHAR12CHAR12CHAR12

Key field Non-key field



How do I retrieve data from SAP structure BUS_EI_COM_SEPA_MANDATE_DATA using ABAP code?

As BUS_EI_COM_SEPA_MANDATE_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BUS_EI_COM_SEPA_MANDATE_DATA as there is no data to select.

How to access SAP table BUS_EI_COM_SEPA_MANDATE_DATA

Within an ECC or HANA version of SAP you can also view further information about BUS_EI_COM_SEPA_MANDATE_DATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).