SEPA_MANDATE

SEPA Mandate | #masterdata | Component: Bank
Column Name Description
MANDT FK Client
MGUID SEPA Mandate: GUID of Mandate
Column Name Description
💲 Currency (LIMIT_CURR):
LIMIT_AMOUNT Mandate Amount Limit
Column Name Description
Column Name Description
SIGN_DATE Date of Signature
VAL_FROM_DATE SEPA: Validity Date of Mandate (From)
VAL_TO_DATE SEPA: Validity Date of Mandate (To)
ERDAT Date on Which the Current Mandate Version was Created
ERTIM Time at Which the Current Mandate Version was Created
GLOCK_VAL_FROM Global Mandate Lock - Valid From
GLOCK_VAL_TO Global Mandate Lock - Valid Until
ORI_ERDAT Date on Which Original Mandate Created
ORI_ERTIM Time when Original Mandate Was Created
FIRSTUSE_DATE SEPA Mandate: Date of First Use
LASTUSE_DATE SEPA Mandate: Date of Last Use
LAUFD Date ID
LIMIT_START_DATE Mandate Limit - Start Date
Column Name Description
PAY_TYPE SEPA: Payment Type Show values
STATUS SEPA: Mandate Status Show values
B2B SEPA-Mandate: B2B Mandate Show values
CHG_REASON SEPA: Reason for Change Show values
GLOCK Global Lock Set in Mandate Show values
BANK_CRDTR Bank Is Creditor Show values
LIMIT_UNIT Mandate Limit - Period Unit Show values
Column Name Description Domain name
MNDID Unique Reference to Mandate for each Payee ID035
MVERS SEPA Mandate: Version of Mandate (0 = Current Version) NUM04
SIGN_CITY Location of Signature TEXT40
ERNAM User who Created the Current Version of the Mandate SYCHAR12
ORIGIN Single-Character Flag CHAR1
ORIGIN_REC_CRDID SEPA Mandate: Original Creditor ID of Mandate ID035
ORIGIN_MNDID SEPA Mandate: Original Mandate of Mandate ID035
ORI_ERNAM User who Created the Original Mandate SYCHAR12
REF_TYPE SEPA Mandate: Reference Type OJ_NAME
REF_ID SEPA Mandate: Reference ID SWO_TYPEID
REF_DESC Text Field TEXT50
SND_TYPE SEPA Mandate: Sender Type OJ_NAME
SND_ID SEPA Mandate: Sender ID SWO_TYPEID
SND_NAME1 Last name of business partner (person) BU_NAME
SND_NAME2 First name of business partner (person) BU_NAME
SND_STREET Street TEXT60
SND_HOUSENUM House Number TEXT10
SND_POSTAL City postal code CHAR10
SND_CITY City TEXT40
SND_IBAN IBAN (International Bank Account Number) IBAN
SND_BIC SWIFT/BIC for International Payments SWIFT
SND_DIR_NAME SEPA: Name of Alternative Debtor BU_NAME
SND_DIR_ID SEPA: ID of Alternative Debtor SWO_TYPEID
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) ID035
REC_TYPE SEPA Mandate: Recipient Type OJ_NAME
REC_ID SEPA Mandate: Recipient ID SWO_TYPEID
REC_NAME1 Name 1 of organization BU_NAME
REC_NAME2 Name 2 of organization BU_NAME
REC_CRDID Creditor Identification Number ID035
REC_STREET Street TEXT60
REC_HOUSENUM House Number TEXT10
REC_POSTAL City postal code CHAR10
REC_CITY City TEXT40
REC_DIR_NAME SEPA: Name of Alternative Payee BU_NAME
REC_DIR_ID SEPA: ID of Alternative Payee SWO_TYPEID
FIRSTUSE_DOCTYPE SEPA Mandate: Type of First Usage OJ_NAME
FIRSTUSE_DOCID SEPA Mandate: ID of First Usage SWO_TYPEID
LASTUSE_DOCTYPE SEPA Mandate: Type of Last Usage OJ_NAME
LASTUSE_DOCID SEPA Mandate: ID of Last Usage SWO_TYPEID
FIRSTUSE_PAYRUN SEPA Mandate: ID of Payment Run of First Use CHAR16
ORGF1 SEPA Mandate: Internal Organizational Data CHAR20
ORGF2 SEPA Mandate: Internal Organizational Data CHAR20
ORGF3 SEPA Mandate: Internal Organizational Data CHAR35
ORGF4 SEPA Mandate: Internal Organizational Data CHAR35
/SAPF15/F15_BW null /SAPF15/BEWIRTSCHAFTER
/SAPF15/F15_KZ null CHAR12
/SAPF15/GUID GUID SYSUUID
CONTRACT_ID BKK: SEPA Mandate Contract ID BKK_MANDATE_CONTRACT
CONTRACT_DESC BKK:SEPA Mandate Contract Description BKK_MANDATE_CONTRACT
LAUFI Run ID LAUFI_KK
LIMIT_NUMBER Mandate Limit Number FSFND_LIMIT_NO
Master Data Relations Join Conditions
Client SEPA_MANDATE.MANDT == T000.MANDT
Reason Code for Status Change
  • SEPA: Mandate Status
  • Client
  • ?
  • Reason Code for Status Change
Country/Region Key
  • Country/Region Key
  • Client
  • SEPA_MANDATE.REC_COUNTRY == T005.LAND1
  • SEPA_MANDATE.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • SEPA_MANDATE.SND_COUNTRY == T005.LAND1
  • SEPA_MANDATE.MANDT == T005.MANDT
Language Key SEPA_MANDATE.SND_LANGUAGE == T002.SPRAS