SEPA_MANDATE is a standard Bank Transparent Table in SAP Cross Application application, which stores SEPA Mandate data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for SEPA_MANDATE. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

SEPA_MANDATE — Meta Data

Description: SEPA Mandate
Main Category: Cross Application
Sub Category: Bank
Table type: Transparent Table (TRANSP)

SEPA_MANDATE — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 MGUID GUID in 'RAW' format X RAW 16
    3 .INCLUDE 0
    4 MNDID SEPA Mandate: Unique Reference to Mandate per Creditor CHAR 35
    5 MVERS SEPA Mandate: Version of Mandate (0 = Current Version) NUMC 4
    6 .INCLUDE 0
    7 .INCLUDE 0
    8 SIGN_CITY Location of Signature CHAR 40
    9 SIGN_DATE Date format CHAR DATS 8
    10 PAY_TYPE Type of payroll, R = regular or S = special CHAR 1
    11 VAL_FROM_DATE SEPA: Validity Date of Mandate (From) DATS 8
    12 VAL_TO_DATE SEPA: Validity Date of Mandate (To) DATS 8
    13 STATUS Indicates whether a Call-off is valid or invalid CHAR 1
    14 B2B SEPA-Mandate: B2B Mandate CHAR 1
    15 REASON_CODE Goods Receipt Reason Code CHAR 3 SEPA_RC_CUST
    16 .INCLUDE 0
    17 ERNAM Created by CHAR 12
    18 ERDAT Created on DATS 8
    19 ERTIM Time at which the object was created TIMS 6
    20 CHG_REASON Reason for Contract Change CHAR 5
    21 ORIGIN Origin CHAR 1
    22 ORIGIN_REC_CRDID SEPA Mandate: Original Creditor ID of Mandate CHAR 35
    23 ORIGIN_MNDID SEPA Mandate: Original Mandate of Mandate CHAR 35
    24 GLOCK Global Lock Set in Mandate CHAR 1
    25 GLOCK_VAL_FROM Global Mandate Lock - Valid From DATS 8
    26 GLOCK_VAL_TO Global Mandate Lock - Valid Until DATS 8
    27 ANWND SEPA: Application for Which Mandate Relevant CHAR 1 *
    28 ORI_ERNAM User who Created the Original Mandate CHAR 12
    29 ORI_ERDAT Date on Which Original Mandate Created DATS 8
    30 ORI_ERTIM Time when Original Mandate Was Created TIMS 6
    31 .INCLUDE 0
    32 .INCLUDE 0
    33 REF_TYPE Reference type (Released CHAR 10 *
    34 REF_ID Reference Id CHAR 70
    35 .INCLUDE 0
    36 REF_DESC Text Field CHAR 50
    37 .INCLUDE 0
    38 .INCLUDE 0
    39 SND_TYPE SEPA Mandate: Sender Type CHAR 10 *
    40 SND_ID SEPA Mandate: Sender ID CHAR 70
    41 .INCLUDE 0
    42 SND_NAME1 Last Name of Business Partner (Person) CHAR 40
    43 SND_NAME2 First Name of Business Partner (Person) CHAR 40
    44 SND_STREET Street CHAR 60
    45 SND_HOUSENUM House Number CHAR 10
    46 SND_POSTAL City postal code CHAR 10
    47 SND_CITY City CHAR 40
    48 SND_COUNTRY Country Key CHAR 3 T005
    49 SND_IBAN IBAN (International Bank Account Number) CHAR 34
    50 SND_BIC SWIFT/BIC for International Payments CHAR 11
    51 SND_DIR_NAME SEPA: Name of Alternative Debtor CHAR 40
    52 SND_LANGUAGE Language Key LANG 1 T002
    53 SND_DIR_ID SEPA: ID of Alternative Debtor CHAR 70
    54 SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) CHAR 35
    55 .INCLUDE 0
    56 .INCLUDE 0
    57 REC_TYPE Record Type EA RT CHAR 10 *
    58 REC_ID Record ID CHAR 70
    59 .INCLUDE 0
    60 REC_NAME1 Name 1 of organization CHAR 40
    61 REC_NAME2 Name 2 of organization CHAR 40
    62 REC_CRDID Creditor Identification Number CHAR 35
    63 REC_STREET Street CHAR 60
    64 REC_HOUSENUM House Number CHAR 10
    65 REC_POSTAL City postal code CHAR 10
    66 REC_CITY City CHAR 40
    67 REC_COUNTRY Country Key CHAR 3 T005
    68 REC_DIR_NAME SEPA: Name of Alternative Payee CHAR 40
    69 REC_DIR_ID SEPA: ID of Alternative Payee CHAR 70
    70 .INCLUDE 0
    71 FIRSTUSE_DATE Date DATS 8
    72 FIRSTUSE_DOCTYPE SEPA Mandate: Type of First Usage CHAR 10 *
    73 FIRSTUSE_DOCID SEPA Mandate: ID of First Usage CHAR 70
    74 LASTUSE_DATE Date DATS 8
    75 LASTUSE_DOCTYPE SEPA Mandate: Type of Last Usage CHAR 10 *
    76 LASTUSE_DOCID SEPA Mandate: ID of Last Usage CHAR 70
    77 FIRSTUSE_PAYRUN SEPA Mandate: ID of Payment Run of First Use CHAR 16
    78 .INCLUDE 0
    79 ORGF1 SEPA Mandate: Internal Organizational Data CHAR 20
    80 ORGF2 SEPA Mandate: Internal Organizational Data CHAR 20
    81 ORGF3 SEPA Mandate: Internal Organizational Data CHAR 35
    82 ORGF4 SEPA Mandate: Internal Organizational Data CHAR 35
    83 .INCLU--AP 0
    84 .INCLUDE 0
    85 /SAPF15/F15_BW CHAR 8 *
    86 /SAPF15/F15_KZ CHAR 12
    87 /SAPF15/GUID GUID RAW 16
    88 .INCLU--AP 0
    89 .INCLUDE 0
    90 CONTRACT_ID CRM Contract ID CHAR 50
    91 CONTRACT_DESC Contract Description CHAR 50
    92 BANK_CRDTR CHAR 1
    93 .INCLUDE 0
    94 LIMIT_AMOUNT Text (20 Characters) CURR 23
    95 LIMIT_CURR Display Currency for Limits CUKY 5 *
    96 LIMIT_NUMBER Limit for Payee - Limit Number NUMC 6
    97 LIMIT_UNIT Limit for Payee - Period Unit CHAR 1
    98 LIMIT_START_DATE Limit for Payee - Start Date DATS 8
    99 .INCLU--AP 0
    100 .INCLUDE 0
    101 LAUFD Date on Which the Program Is to Be Run DATS 8
    102 LAUFI Additional Identification CHAR 6