BUS_EI_BUPA_SEPA_MANDATE SAP (External Interface: Structure Type for Sepa Mandate) Structure details

Dictionary Type: Structure
Description: External Interface: Structure Type for Sepa Mandate




ABAP Code to SELECT data from BUS_EI_BUPA_SEPA_MANDATE
Related tables to BUS_EI_BUPA_SEPA_MANDATE
Access table BUS_EI_BUPA_SEPA_MANDATE




Structure field list including key, data, relationships and ABAP select examples

BUS_EI_BUPA_SEPA_MANDATE 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 "External Interface: Structure Type for Sepa Mandate" 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_BUPA_SEPA_MANDATE TYPE BUS_EI_BUPA_SEPA_MANDATE.

The BUS_EI_BUPA_SEPA_MANDATE table consists of various fields, each holding specific information or linking keys about External Interface: Structure Type for Sepa Mandate data available in SAP. These include DATA (), APPLICATION (SEPA: Application for Which Mandate Relevant), SEPA_CREDITOR_ID (Creditor Identification Number), SEPA_MANDATE_ID (Unique Referene to Mandate per Payment Recipient).. 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. .

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


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TASKExternal Interface:Change Indicator SEPA MANDATES BUS_EI_SEPA_MANDATE_TASKCHAR1BU_EI_SEPA_MANDATE_TASK
DATA 0
APPLICATIONSEPA: Application for Which Mandate Relevant SEPA_ANWNDCHAR1SEPA_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_TYPECHAR10OJ_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 LAND1CHAR3LAND1LND
SND_LANGUAGELanguage Key LANGULANG1ISOLASPRAS
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_TYPECHAR10OJ_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 LAND1CHAR3LAND1LND
REF_TYPESEPA Mandate: Reference Type SEPA_REF_TYPECHAR10OJ_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
.INCLU--AP 0
CONTRACT_IDBKK: SEPA Mandate Contract ID BKK_DTE_MND_CONTRACT_IDCHAR50BKK_MANDATE_CONTRACT
CONTRACT_DESCBKK:SEPA Mandate Contract Description BKK_DTE_MND_CONTRACT_DESCCHAR50BKK_MANDATE_CONTRACT
BANK_CRDTRBank Is Creditor BKK_DTE_MND_BANK_CRDTRCHAR1XFELD
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_DOCTYPECHAR10OJ_NAMEOBJ
FIRSTUSE_DOCIDSEPA Mandate: ID of First Usage SEPA_FIRSTUSE_DOCIDCHAR70SWO_TYPEIDOBJ
LASTUSE_DATEDate DATUMDATS8DATUM
LASTUSE_DOCTYPESEPA Mandate: Type of Last Usage SEPA_LASTUSE_DOCTYPECHAR10OJ_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
DATAX 0
APPLICATIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SEPA_CREDITOR_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SEPA_MANDATE_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PAY_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_NAME1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_NAME2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_STREETUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_HOUSENUMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_POSTALUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_CITYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_COUNTRYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_LANGUAGEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_IBANUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_BICUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_DIR_NAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_NAME1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_NAME2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_STREETUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_HOUSENUMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_POSTALUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_CITYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_COUNTRYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REF_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REF_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REF_DESCUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LIFETIME_FROMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LIFETIME_TOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SIGN_CITYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SIGN_DATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STATUSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_DIR_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_DIR_NAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REC_DIR_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
B2BUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SND_DEBTOR_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ORGF1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ORGF2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ORGF3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ORGF4Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
GLOBAL_LOCKUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
GLOBAL_LOCK_FROMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
GLOBAL_LOCK_TOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FIRSTUSE_DATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FIRSTUSE_DOCTYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FIRSTUSE_DOCIDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LASTUSE_DATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LASTUSE_DOCTYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LASTUSE_DOCIDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SEPA_CREDITOR_ID_ORIGINUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SEPA_MANDATE_ID_ORIGINUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VERSIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CREATORUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CREATIONDATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CREATIONTIMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE

Key field Non-key field



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

As BUS_EI_BUPA_SEPA_MANDATE 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_BUPA_SEPA_MANDATE as there is no data to select.

How to access SAP table BUS_EI_BUPA_SEPA_MANDATE

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!