SAP table SEPA_STR_DATA_MANDATE_CHNG_1 (Dynpro Structure for Change to Mandates)

Field Description Data Type Length Decimals Checktable Data Element
MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
SIGN_DATE Date of Signature DATS 8 0 SEPA_SIGN_DATE
VAL_FROM_DATE SEPA: Validity Date of Mandate (From) DATS 8 0 SEPA_VAL_FROM_DATE
VAL_TO_DATE SEPA: Validity Date of Mandate (To) DATS 8 0 SEPA_VAL_TO_DATE
STATUS SEPA: Mandate Status CHAR 1 0 SEPA_STATUS
0 Entered
1 Active
2 To Be Confirmed
3 Locked
4 Canceled
5 Obsolete
6 Completed
ORIGIN Single-Character Flag CHAR 1 0 CHAR1
GLOCK Global Lock Set in Mandate CHAR 1 0 SEPA_GLOCK
GLOCK_VAL_FROM Global Mandate Lock - Valid From DATS 8 0 SEPA_GLOCK_VAL_FROM_DATE
GLOCK_VAL_TO Global Mandate Lock - Valid Until DATS 8 0 SEPA_GLOCK_VAL_TO_DATE
ANWND SEPA: Application for Which Mandate Relevant CHAR 1 0 SEPA_ANWND
REF_TYPE SEPA Mandate: Reference Type CHAR 10 0 * SEPA_REF_TYPE
REF_ID SEPA Mandate: Reference ID CHAR 70 0 SEPA_REF_ID
REF_DESC Text Field CHAR 50 0 TEXT50
REC_TYPE SEPA Mandate: Recipient Type CHAR 10 0 * SEPA_REC_TYPE
REC_ID SEPA Mandate: Recipient ID CHAR 70 0 SEPA_REC_ID
REC_NAME1 Name 1 of organization CHAR 40 0 BU_NAMEOR1
REC_NAME2 Name 2 of organization CHAR 40 0 BU_NAMEOR2
REC_CRDID Creditor Identification Number CHAR 35 0 SEPA_CRDID
REC_STREET Street CHAR 60 0 AD_STREET
REC_HOUSENUM House Number CHAR 10 0 AD_HSNM1
REC_POSTAL City postal code CHAR 10 0 AD_PSTCD1
REC_CITY City CHAR 40 0 AD_CITY1
REC_COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
REC_DIR_NAME SEPA: Name of Alternative Payee CHAR 40 0 SEPA_REC_DIR_NAME
REC_DIR_ID SEPA: ID of Alternative Payee CHAR 70 0 SEPA_REC_DIR_ID
SND_TYPE SEPA Mandate: Sender Type CHAR 10 0 * SEPA_SND_TYPE
SND_ID SEPA Mandate: Sender ID CHAR 70 0 SEPA_SND_ID
SND_NAME1 Last name of business partner (person) CHAR 40 0 BU_NAMEP_L
SND_NAME2 First name of business partner (person) CHAR 40 0 BU_NAMEP_F
SND_STREET Street CHAR 60 0 AD_STREET
SND_HOUSENUM House Number CHAR 10 0 AD_HSNM1
SND_POSTAL City postal code CHAR 10 0 AD_PSTCD1
SND_CITY City CHAR 40 0 AD_CITY1
SND_COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
SND_IBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN
SND_BIC SWIFT/BIC for International Payments CHAR 11 0 SWIFT
SND_DIR_NAME SEPA: Name of Alternative Debtor CHAR 40 0 SEPA_PAYMENT_FOR
SND_LANGUAGE Language Key LANG 1 0 T002 LANGU
SND_DIR_ID SEPA: ID of Alternative Debtor CHAR 70 0 SEPA_SND_DIR_ID
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) CHAR 35 0 SEPA_SND_DEBTOR_ID
FIRSTUSE_DATE SEPA Mandate: Date of First Use DATS 8 0 SEPA_FIRSTUSE_DATE
FIRSTUSE_DOCTYPE SEPA Mandate: Type of First Usage CHAR 10 0 * SEPA_FIRSTUSE_DOCTYPE
FIRSTUSE_DOCID SEPA Mandate: ID of First Usage CHAR 70 0 SEPA_FIRSTUSE_DOCID
LASTUSE_DATE SEPA Mandate: Date of Last Use DATS 8 0 SEPA_LASTUSE_DATE
LASTUSE_DOCTYPE SEPA Mandate: Type of Last Usage CHAR 10 0 * SEPA_LASTUSE_DOCTYPE
LASTUSE_DOCID SEPA Mandate: ID of Last Usage CHAR 70 0 SEPA_LASTUSE_DOCID
FIRSTUSE_PAYRUN SEPA Mandate: ID of Payment Run of First Use CHAR 16 0 SEPA_FIRSTUSE_PAYRUNID
ORGF1 SEPA Mandate: Internal Organizational Data CHAR 20 0 SEPA_ORG_ID
ORGF2 SEPA Mandate: Internal Organizational Data CHAR 20 0 SEPA_ORG_ID
ORGF3 SEPA Mandate: Internal Organizational Data CHAR 35 0 SEPA_ORG_ID_LONG
ORGF4 SEPA Mandate: Internal Organizational Data CHAR 35 0 SEPA_ORG_ID_LONG

SEPA_STR_DATA_MANDATE_CHNG_1 foreign key relationships

Table Field Check Table Check Field
0 SEPA_STR_DATA_MANDATE_CHNG_1 REC_COUNTRY T005 Countries MANDT
0 SEPA_STR_DATA_MANDATE_CHNG_1 REC_COUNTRY T005 Countries LAND1
1 SEPA_STR_DATA_MANDATE_CHNG_1 SND_COUNTRY T005 Countries MANDT
1 SEPA_STR_DATA_MANDATE_CHNG_1 SND_COUNTRY T005 Countries LAND1
0 SEPA_STR_DATA_MANDATE_CHNG_1 SND_LANGUAGE T002 Language Keys (Component BC-I18) SPRAS