1. Home
  2. Resources
  3. SAP Tables
  4. SEPA_STR_DATA_MANDATE_CHNG_1 - Dynpro Structure for Change to Mandates

SAP Table SEPA_STR_DATA_MANDATE_CHNG_1

Dynpro Structure for Change to Mandates

SEPA_STR_DATA_MANDATE_CHNG_1 (Dynpro Structure for Change to Mandates) 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 SEPA_STR_DATA_MANDATE_CHNG_1 to other SAP tables.

Source: SEPA_STR_DATA_MANDATE_CHNG_1 (Dynpro Structure for Change to Mandates)

SEPA_STR_DATA_MANDATE_CHNG_1 table fields

Field Data element Checktable Datatype Length Decimals
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
SIGN_DATE Date of Signature SEPA_SIGN_DATE DATS 8 0
VAL_FROM_DATE SEPA: Validity Date of Mandate (From) SEPA_VAL_FROM_DATE DATS 8 0
VAL_TO_DATE SEPA: Validity Date of Mandate (To) SEPA_VAL_TO_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
ORIGIN Single-Character Indicator CHAR1 CHAR 1 0
GLOCK Global Lock Set in Mandate SEPA_GLOCK CHAR 1 0
X true
- false
NULL unknown
GLOCK_VAL_FROM Global Mandate Lock - Valid From SEPA_GLOCK_VAL_FROM_DATE DATS 8 0
GLOCK_VAL_TO Global Mandate Lock - Valid Until SEPA_GLOCK_VAL_TO_DATE DATS 8 0
ANWND SEPA: Application for Which Mandate Relevant SEPA_ANWND CHAR 1 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
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_CRDID Creditor Identification Number SEPA_CRDID CHAR 35 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 T005 CHAR 3 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
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 T005 CHAR 3 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
SND_LANGUAGE Language Key LANGU T002 LANG 1 0
SND_DIR_ID SEPA: ID of Alternative Debtor SEPA_SND_DIR_ID CHAR 70 0
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) SEPA_SND_DEBTOR_ID CHAR 35 0
FIRSTUSE_DATE SEPA Mandate: Date of First Use SEPA_FIRSTUSE_DATE DATS 8 0
FIRSTUSE_DOCTYPE SEPA Mandate: Type of First Usage SEPA_FIRSTUSE_DOCTYPE CHAR 10 0
FIRSTUSE_DOCID SEPA Mandate: ID of First Usage SEPA_FIRSTUSE_DOCID CHAR 70 0
LASTUSE_DATE SEPA Mandate: Date of Last Use SEPA_LASTUSE_DATE DATS 8 0
LASTUSE_DOCTYPE SEPA Mandate: Type of Last Usage SEPA_LASTUSE_DOCTYPE CHAR 10 0
LASTUSE_DOCID SEPA Mandate: ID of Last Usage SEPA_LASTUSE_DOCID CHAR 70 0
FIRSTUSE_PAYRUN SEPA Mandate: ID of Payment Run of First Use SEPA_FIRSTUSE_PAYRUNID CHAR 16 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

SEPA_STR_DATA_MANDATE_CHNG_1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SEPA_STR_DATA_MANDATE_CHNG_1 REC_COUNTRY SYST MANDT T005 Countries MANDT
SEPA_STR_DATA_MANDATE_CHNG_1 REC_COUNTRY SEPA_STR_DATA_MANDATE_CHNG_1 REC_COUNTRY T005 Countries LAND1
SEPA_STR_DATA_MANDATE_CHNG_1 SND_COUNTRY SYST MANDT T005 Countries MANDT
SEPA_STR_DATA_MANDATE_CHNG_1 SND_COUNTRY SEPA_STR_DATA_MANDATE_CHNG_1 SND_COUNTRY T005 Countries LAND1
SEPA_STR_DATA_MANDATE_CHNG_1 SND_LANGUAGE SEPA_STR_DATA_MANDATE_CHNG_1 SND_LANGUAGE T002 Language Keys (Component BC-I18) SPRAS