SAP BAPI_B1006_S_SEPA_MANDATE_DATA SEPA: BAPI Structure - All Relevant Fields Table data and field list

BAPI_B1006_S_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 "SEPA: BAPI Structure - All Relevant Fields" 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_BAPI_B1006_S_SEPA_MANDATE_DATA TYPE BAPI_B1006_S_SEPA_MANDATE_DATA.

The BAPI_B1006_S_SEPA_MANDATE_DATA table consists of various fields, each holding specific information or linking keys about SEPA: BAPI Structure - All Relevant Fields 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. .

BAPI_B1006_S_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 or numeric)

SAP BAPI_B1006_S_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 BAPI_B1006_S_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
APPLICATION	SEPA: Application for Which Mandate Relevant	SEPA_ANWND	CHAR	1	Assigned to domain		SEPA_ANWND
SEPA_CREDITOR_ID	Creditor Identification Number	SEPA_CRDID	CHAR	35			ID035
SEPA_MANDATE_ID	Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35			ID035
PAY_TYPE	SEPA: Transaction Type	SEPA_PAY_TYPE	CHAR	1			SEPA_PAY_TYPE
SND_TYPE	SEPA Mandate: Sender Type	SEPA_SND_TYPE	CHAR	10	Assigned to domain		OJ_NAME	OBJ
SND_ID	SEPA Mandate: Sender ID	SEPA_SND_ID	CHAR	70			SWO_TYPEID
SND_NAME1	Last name of business partner (person)	BU_NAMEP_L	CHAR	40			BU_NAME
SND_NAME2	First name of business partner (person)	BU_NAMEP_F	CHAR	40			BU_NAME
SND_STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
SND_HOUSENUM	House Number	AD_HSNM1	CHAR	10			TEXT10
SND_POSTAL	City postal code	AD_PSTCD1	CHAR	10			CHAR10
SND_CITY	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
SND_COUNTRY	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
SND_LANGUAGE	Language Key	LANGU	LANG	1	Assigned to domain	ISOLA	SPRAS
SND_IBAN	IBAN (International Bank Account Number)	IBAN	CHAR	34			IBAN
SND_BIC	SWIFT/BIC for International Payments	SWIFT	CHAR	11			SWIFT
SND_DIR_NAME	SEPA: Name of Alternative Debtor	SEPA_PAYMENT_FOR	CHAR	40			BU_NAME
REC_TYPE	SEPA Mandate: Recipient Type	SEPA_REC_TYPE	CHAR	10	Assigned to domain		OJ_NAME	OBJ
REC_ID	SEPA Mandate: Recipient ID	SEPA_REC_ID	CHAR	70			SWO_TYPEID
REC_NAME1	Name 1 of organization	BU_NAMEOR1	CHAR	40			BU_NAME
REC_NAME2	Name 2 of organization	BU_NAMEOR2	CHAR	40			BU_NAME
REC_STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
REC_HOUSENUM	House Number	AD_HSNM1	CHAR	10			TEXT10
REC_POSTAL	City postal code	AD_PSTCD1	CHAR	10			CHAR10
REC_CITY	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
REC_COUNTRY	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
REF_TYPE	SEPA Mandate: Reference Type	SEPA_REF_TYPE	CHAR	10	Assigned to domain		OJ_NAME	OBJ
REF_ID	SEPA Mandate: Reference ID	SEPA_REF_ID	CHAR	70			SWO_TYPEID
REF_DESC	Text Field	TEXT50	CHAR	50			TEXT50
LIFETIME_FROM	SEPA: Validity Date of Mandate (From)	SEPA_VAL_FROM_DATE	DATS	8			DATUM
LIFETIME_TO	SEPA: Validity Date of Mandate (To)	SEPA_VAL_TO_DATE	DATS	8			DATUM
SIGN_CITY	Location of Signature	SEPA_SIGN_CITY	CHAR	40			TEXT40
SIGN_DATE	Date of Signature	SEPA_SIGN_DATE	DATS	8			DATUM
STATUS	SEPA: Mandate Status	SEPA_STATUS	CHAR	1			SEPA_STATUS
SND_DIR_ID	SEPA: ID of Alternative Debtor	SEPA_SND_DIR_ID	CHAR	70			SWO_TYPEID
REC_DIR_NAME	SEPA: Name of Alternative Payee	SEPA_REC_DIR_NAME	CHAR	40			BU_NAME
REC_DIR_ID	SEPA: ID of Alternative Payee	SEPA_REC_DIR_ID	CHAR	70			SWO_TYPEID
B2B	SEPA-Mandate: B2B Mandate	SEPA_B2B	CHAR	1			XFELD
SND_DEBTOR_ID	SEPA: ID Number of Sender (External Reference)	SEPA_SND_DEBTOR_ID	CHAR	35			ID035
ORGF1	SEPA Mandate: Internal Organizational Data	SEPA_ORG_ID	CHAR	20			CHAR20
ORGF2	SEPA Mandate: Internal Organizational Data	SEPA_ORG_ID	CHAR	20			CHAR20
ORGF3	SEPA Mandate: Internal Organizational Data	SEPA_ORG_ID_LONG	CHAR	35			CHAR35
ORGF4	SEPA Mandate: Internal Organizational Data	SEPA_ORG_ID_LONG	CHAR	35			CHAR35
GLOBAL_LOCK	Global Lock Set in Mandate	SEPA_GLOCK	CHAR	1			BOOLEAN
GLOBAL_LOCK_FROM	Global Mandate Lock - Valid From	SEPA_GLOCK_VAL_FROM_DATE	DATS	8			DATUM
GLOBAL_LOCK_TO	Global Mandate Lock - Valid Until	SEPA_GLOCK_VAL_TO_DATE	DATS	8			DATUM
FIRSTUSE_DATE	Date	DATUM	DATS	8			DATUM
FIRSTUSE_DOCTYPE	SEPA Mandate: Type of First Usage	SEPA_FIRSTUSE_DOCTYPE	CHAR	10	Assigned to domain		OJ_NAME	OBJ
FIRSTUSE_DOCID	SEPA Mandate: ID of First Usage	SEPA_FIRSTUSE_DOCID	CHAR	70			SWO_TYPEID	OBJ
LASTUSE_DATE	Date	DATUM	DATS	8			DATUM
LASTUSE_DOCTYPE	SEPA Mandate: Type of Last Usage	SEPA_LASTUSE_DOCTYPE	CHAR	10	Assigned to domain		OJ_NAME	OBJ
LASTUSE_DOCID	SEPA Mandate: ID of Last Usage	SEPA_LASTUSE_DOCID	CHAR	70			SWO_TYPEID	OBJ
SEPA_CREDITOR_ID_ORIGIN	SEPA Mandate: Original Creditor ID of Mandate	SEPA_CRDID_ORIGIN	CHAR	35			ID035
SEPA_MANDATE_ID_ORIGIN	SEPA Mandate: Original Mandate of Mandate	SEPA_MNDID_ORIGIN	CHAR	35			ID035
VERSION	SEPA Mandate: Version of Mandate (0 = Current Version)	SEPA_MVERS	NUMC	4			NUM04
CREATOR	Author	CNAM	CHAR	12			SYCHAR12
CREATIONDATE	Date on which the object was created	BU_CRDAT	DATS	8			DATUM
CREATIONTIME	Time at which the object was created	BU_CRTIM	TIMS	6			UZEIT

Key field

Non-key field

< BAPI_AVAILABILITY - BAPI_B1006_T_SEPA_MANDATE_DATA - SEPA: BAPI Structure - All Relevant Fields >

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

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

How to access SAP table BAPI_B1006_S_SEPA_MANDATE_DATA

Within an ECC or HANA version of SAP you can also view further information about BAPI_B1006_S_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).