dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table SEPA_MANDATE

SEPA Mandate

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table SEPA_MANDATE (SEPA Mandate) is a standard table in SAP ERP. It belongs to the package BF_SEPA.

Technical Information

Table SEPA_MANDATE
Short Text SEPA Mandate
Package BF_SEPA
Table Type Transparent Table

Fields for Table SEPA_MANDATE

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 *
MGUID ✔ SEPA Mandate: GUID of Mandate SEPA_MGUID RAW 16
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35
MVERS SEPA Mandate: Version of Mandate (0 = Current Version) SEPA_MVERS NUMC 4
SIGN_CITY Location of Signature SEPA_SIGN_CITY CHAR 40
SIGN_DATE Date of Signature SEPA_SIGN_DATE DATS 8
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1
VAL_FROM_DATE SEPA: Validity Date of Mandate (From) SEPA_VAL_FROM_DATE DATS 8
VAL_TO_DATE SEPA: Validity Date of Mandate (To) SEPA_VAL_TO_DATE DATS 8
STATUS SEPA: Mandate Status SEPA_STATUS CHAR 1
B2B SEPA-Mandate: B2B Mandate SEPA_B2B CHAR 1
REASON_CODE Reason Code for Status Change SEPA_REASON_CODE CHAR 3 SEPA_RC_CUST
ERNAM User who Created the Current Version of the Mandate SEPA_ERNAM CHAR 12
ERDAT Date on Which the Current Mandate Version was Created SEPA_ERDAT DATS 8
ERTIM Time at Which the Current Mandate Version was Created SEPA_ERTIM TIMS 6
CHG_REASON SEPA: Reason for Change SEPA_CHG_REASON CHAR 5
ORIGIN Single-Character Indicator CHAR1 CHAR 1
ORIGIN_REC_CRDID SEPA Mandate: Original Creditor ID of Mandate SEPA_CRDID_ORIGIN CHAR 35
ORIGIN_MNDID SEPA Mandate: Original Mandate of Mandate SEPA_MNDID_ORIGIN CHAR 35
GLOCK Global Lock Set in Mandate SEPA_GLOCK CHAR 1
GLOCK_VAL_FROM Global Mandate Lock - Valid From SEPA_GLOCK_VAL_FROM_DATE DATS 8
GLOCK_VAL_TO Global Mandate Lock - Valid Until SEPA_GLOCK_VAL_TO_DATE DATS 8
ANWND SEPA: Application for Which Mandate Relevant SEPA_ANWND CHAR 1 *
ORI_ERNAM User who Created the Original Mandate SEPA_ORI_ERNAM CHAR 12
ORI_ERDAT Date on Which Original Mandate Created SEPA_ORI_ERDAT DATS 8
ORI_ERTIM Time when Original Mandate Was Created SEPA_ORI_ERTIM TIMS 6
REF_TYPE SEPA Mandate: Reference Type SEPA_REF_TYPE CHAR 10 *
REF_ID SEPA Mandate: Reference ID SEPA_REF_ID CHAR 70
REF_DESC Text Field TEXT50 CHAR 50
SND_TYPE SEPA Mandate: Sender Type SEPA_SND_TYPE CHAR 10 *
SND_ID SEPA Mandate: Sender ID SEPA_SND_ID CHAR 70
SND_NAME1 Last name of business partner (person) BU_NAMEP_L CHAR 40
SND_NAME2 First name of business partner (person) BU_NAMEP_F CHAR 40
SND_STREET Street AD_STREET CHAR 60
SND_HOUSENUM House Number AD_HSNM1 CHAR 10
SND_POSTAL City postal code AD_PSTCD1 CHAR 10
SND_CITY City AD_CITY1 CHAR 40
SND_COUNTRY Country Key LAND1 CHAR 3 T005
SND_IBAN IBAN (International Bank Account Number) IBAN CHAR 34
SND_BIC SWIFT/BIC for International Payments SWIFT CHAR 11
SND_DIR_NAME SEPA: Name of Alternative Debtor SEPA_PAYMENT_FOR CHAR 40
SND_LANGUAGE Language Key LANGU LANG 1 T002
SND_DIR_ID SEPA: ID of Alternative Debtor SEPA_SND_DIR_ID CHAR 70
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) SEPA_SND_DEBTOR_ID CHAR 35
REC_TYPE SEPA Mandate: Recipient Type SEPA_REC_TYPE CHAR 10 *
REC_ID SEPA Mandate: Recipient ID SEPA_REC_ID CHAR 70
REC_NAME1 Name 1 of organization BU_NAMEOR1 CHAR 40
REC_NAME2 Name 2 of organization BU_NAMEOR2 CHAR 40
REC_CRDID Creditor Identification Number SEPA_CRDID CHAR 35
REC_STREET Street AD_STREET CHAR 60
REC_HOUSENUM House Number AD_HSNM1 CHAR 10
REC_POSTAL City postal code AD_PSTCD1 CHAR 10
REC_CITY City AD_CITY1 CHAR 40
REC_COUNTRY Country Key LAND1 CHAR 3 T005
REC_DIR_NAME SEPA: Name of Alternative Payee SEPA_REC_DIR_NAME CHAR 40
REC_DIR_ID SEPA: ID of Alternative Payee SEPA_REC_DIR_ID CHAR 70
FIRSTUSE_DATE SEPA Mandate: Date of First Use SEPA_FIRSTUSE_DATE DATS 8
FIRSTUSE_DOCTYPE SEPA Mandate: Type of First Usage SEPA_FIRSTUSE_DOCTYPE CHAR 10 *
FIRSTUSE_DOCID SEPA Mandate: ID of First Usage SEPA_FIRSTUSE_DOCID CHAR 70
LASTUSE_DATE SEPA Mandate: Date of Last Use SEPA_LASTUSE_DATE DATS 8
LASTUSE_DOCTYPE SEPA Mandate: Type of Last Usage SEPA_LASTUSE_DOCTYPE CHAR 10 *
LASTUSE_DOCID SEPA Mandate: ID of Last Usage SEPA_LASTUSE_DOCID CHAR 70
FIRSTUSE_PAYRUN SEPA Mandate: ID of Payment Run of First Use SEPA_FIRSTUSE_PAYRUNID CHAR 16
ORGF1 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID CHAR 20
ORGF2 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID CHAR 20
ORGF3 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONG CHAR 35
ORGF4 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONG CHAR 35
/SAPF15/F15_BW Bewirtschafter /SAPF15/BEWIRTSCHAFTER CHAR 8 *
/SAPF15/F15_KZ Kassenzeichen /SAPF15/KASSENZEICHEN CHAR 12
/SAPF15/GUID GUID /SAPF15/GUID RAW 16
CONTRACT_ID BKK: SEPA Mandate Contract ID BKK_DTE_MND_CONTRACT_ID CHAR 50
CONTRACT_DESC BKK:SEPA Mandate Contract Description BKK_DTE_MND_CONTRACT_DESC CHAR 50
BANK_CRDTR Bank Is Creditor BKK_DTE_MND_BANK_CRDTR CHAR 1
LAUFD Date ID LAUFD_KK DATS 8
LAUFI Additional Identification Characteristic LAUFI_KK CHAR 6