1. Home
  2. Resources
  3. SAP Tables
  4. BAPI_S_SEPA_MANDATE_CHANGE - SEPA: BAPI Structure for Changing a Mandate

SAP Table BAPI_S_SEPA_MANDATE_CHANGE

SEPA: BAPI Structure for Changing a Mandate

BAPI_S_SEPA_MANDATE_CHANGE (SEPA: BAPI Structure for Changing a Mandate) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPI_S_SEPA_MANDATE_CHANGE to other SAP tables.

BAPI_S_SEPA_MANDATE_CHANGE table fields

Field Data element Checktable Datatype Length Decimals
SEPA_CREDITOR_ID Creditor Identification Number SEPA_CRDID CHAR 35 0
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1 0
1 One-Time Mandate
N Recurring Use Mandate
SND_TYPE SEPA Mandate: Sender Type SEPA_SND_TYPE CHAR 10 0
SND_ID SEPA Mandate: Sender ID SEPA_SND_ID CHAR 70 0
SND_NAME1 Last name of business partner (person) BU_NAMEP_L CHAR 40 0
SND_NAME2 First name of business partner (person) BU_NAMEP_F CHAR 40 0
SND_STREET Street AD_STREET CHAR 60 0
SND_HOUSENUM House Number AD_HSNM1 CHAR 10 0
SND_POSTAL City postal code AD_PSTCD1 CHAR 10 0
SND_CITY City AD_CITY1 CHAR 40 0
SND_COUNTRY Country Key LAND1 CHAR 3 0
SND_LANGUAGE Language Key LANGU T002 LANG 1 0
SND_IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
SND_BIC SWIFT/BIC for International Payments SWIFT CHAR 11 0
SND_DIR_NAME SEPA: Name of Alternative Debtor SEPA_PAYMENT_FOR CHAR 40 0
REC_TYPE SEPA Mandate: Recipient Type SEPA_REC_TYPE CHAR 10 0
REC_ID SEPA Mandate: Recipient ID SEPA_REC_ID CHAR 70 0
REC_NAME1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
REC_NAME2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
REC_STREET Street AD_STREET CHAR 60 0
REC_HOUSENUM House Number AD_HSNM1 CHAR 10 0
REC_POSTAL City postal code AD_PSTCD1 CHAR 10 0
REC_CITY City AD_CITY1 CHAR 40 0
REC_COUNTRY Country Key LAND1 CHAR 3 0
REF_TYPE SEPA Mandate: Reference Type SEPA_REF_TYPE CHAR 10 0
REF_ID SEPA Mandate: Reference ID SEPA_REF_ID CHAR 70 0
REF_DESC Text Field TEXT50 CHAR 50 0
LIFETIME_FROM SEPA: Validity Date of Mandate (From) SEPA_VAL_FROM_DATE DATS 8 0
LIFETIME_TO SEPA: Validity Date of Mandate (To) SEPA_VAL_TO_DATE DATS 8 0
SIGN_CITY Location of Signature SEPA_SIGN_CITY CHAR 40 0
SIGN_DATE Date of Signature SEPA_SIGN_DATE DATS 8 0
STATUS SEPA: Mandate Status SEPA_STATUS CHAR 1 0
0 Entered
1 Active
2 To Be Confirmed
3 Locked
4 Canceled
5 Obsolete
6 Completed
SND_DIR_ID SEPA: ID of Alternative Debtor SEPA_SND_DIR_ID CHAR 70 0
REC_DIR_NAME SEPA: Name of Alternative Payee SEPA_REC_DIR_NAME CHAR 40 0
REC_DIR_ID SEPA: ID of Alternative Payee SEPA_REC_DIR_ID CHAR 70 0
B2B SEPA-Mandate: B2B Mandate SEPA_B2B CHAR 1 0
X Yes
NULL No
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) SEPA_SND_DEBTOR_ID CHAR 35 0
ORGF1 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID CHAR 20 0
ORGF2 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID CHAR 20 0
ORGF3 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONG CHAR 35 0
ORGF4 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONG CHAR 35 0
CONTRACT_ID BKK: SEPA Mandate Contract ID BKK_DTE_MND_CONTRACT_ID CHAR 50 0
CONTRACT_DESC BKK:SEPA Mandate Contract Description BKK_DTE_MND_CONTRACT_DESC CHAR 50 0
BANK_CRDTR Bank Is Creditor BKK_DTE_MND_BANK_CRDTR CHAR 1 0
X Yes
NULL No

BAPI_S_SEPA_MANDATE_CHANGE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPI_S_SEPA_MANDATE_CHANGE SND_LANGUAGE BAPI_S_SEPA_MANDATE_CHANGE SND_LANGUAGE T002 Language Keys (Component BC-I18) SPRAS