SAP ABAP Table SEPA_MANDATE (SEPA Mandate)
Hierarchy
☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-BK (Application Component) Bank
     ⤷ BF_SEPA (Package) Single Euro Payments Area (Mandate)
Basic Data
Table Category TRANSP    Transparent table 
Transparent table SEPA_MANDATE   Table Relationship Diagram
Short Description SEPA Mandate    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 MGUID SEPA_MGUID   RAW 16   0   SEPA Mandate: GUID of Mandate  
3 .INCLUDE       0   0   SEPA Mandate: Standard Fields (Cannot be Enhanced)  
4 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
5 MVERS SEPA_MVERS NUM04 NUMC 4   0   SEPA Mandate: Version of Mandate (0 = Current Version)  
6 .INCLUDE       0   0   SEPA Mandate: Management Data  
7 .INCLUDE       0   0   SEPA Mandate: Management Data (External Fields)  
8 SIGN_CITY SEPA_SIGN_CITY TEXT40 CHAR 40   0   Location of Signature  
9 SIGN_DATE SEPA_SIGN_DATE DATUM DATS 8   0   Date of Signature  
10 PAY_TYPE SEPA_PAY_TYPE SEPA_PAY_TYPE CHAR 1   0   SEPA: Payment Type  
11 VAL_FROM_DATE SEPA_VAL_FROM_DATE DATUM DATS 8   0   SEPA: Validity Date of Mandate (From)  
12 VAL_TO_DATE SEPA_VAL_TO_DATE DATUM DATS 8   0   SEPA: Validity Date of Mandate (To)  
13 STATUS SEPA_STATUS SEPA_STATUS CHAR 1   0   SEPA: Mandate Status  
14 B2B SEPA_B2B XFELD CHAR 1   0   SEPA-Mandate: B2B Mandate  
15 REASON_CODE SEPA_REASON_CODE SEPA_REASON_CODE CHAR 3   0   Reason Code for Status Change SEPA_RC_CUST
16 .INCLUDE       0   0   SEPA Mandate: Management Data (Internal Data)  
17 ERNAM SEPA_ERNAM SYCHAR12 CHAR 12   0   User who Created the Current Version of the Mandate  
18 ERDAT SEPA_ERDAT DATUM DATS 8   0   Date on Which the Current Mandate Version was Created  
19 ERTIM SEPA_ERTIM UZEIT TIMS 6   0   Time at Which the Current Mandate Version was Created  
20 CHG_REASON SEPA_CHG_REASON SEPA_CHG_REASON CHAR 5   0   SEPA: Reason for Change  
21 ORIGIN CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
22 ORIGIN_REC_CRDID SEPA_CRDID_ORIGIN ID035 CHAR 35   0   SEPA Mandate: Original Creditor ID of Mandate  
23 ORIGIN_MNDID SEPA_MNDID_ORIGIN ID035 CHAR 35   0   SEPA Mandate: Original Mandate of Mandate  
24 GLOCK SEPA_GLOCK BOOLEAN CHAR 1   0   Global Lock Set in Mandate  
25 GLOCK_VAL_FROM SEPA_GLOCK_VAL_FROM_DATE DATUM DATS 8   0   Global Mandate Lock - Valid From  
26 GLOCK_VAL_TO SEPA_GLOCK_VAL_TO_DATE DATUM DATS 8   0   Global Mandate Lock - Valid Until  
27 ANWND SEPA_ANWND SEPA_ANWND CHAR 1   0   SEPA: Application for Which Mandate Relevant *
28 ORI_ERNAM SEPA_ORI_ERNAM SYCHAR12 CHAR 12   0   User who Created the Original Mandate  
29 ORI_ERDAT SEPA_ORI_ERDAT DATUM DATS 8   0   Date on Which Original Mandate Created  
30 ORI_ERTIM SEPA_ORI_ERTIM UZEIT TIMS 6   0   Time when Original Mandate Was Created  
31 .INCLUDE       0   0   SEPA Mandate: Data for Referencing to Other Objects  
32 .INCLUDE       0   0   SEPA Mandate: ID of Referenced Object  
33 REF_TYPE SEPA_REF_TYPE OJ_NAME CHAR 10   0   SEPA Mandate: Reference Type *
34 REF_ID SEPA_REF_ID SWO_TYPEID CHAR 70   0   SEPA Mandate: Reference ID  
35 .INCLUDE       0   0   SEPA Mandate: Data of Referenced Object  
36 REF_DESC TEXT50 TEXT50 CHAR 50   0   Text Field  
37 .INCLUDE       0   0   SEPA Mandate: Sender Data (Debited Bank Account)  
38 .INCLUDE       0   0   SEPA Mandate: ID of Sender  
39 SND_TYPE SEPA_SND_TYPE OJ_NAME CHAR 10   0   SEPA Mandate: Sender Type *
40 SND_ID SEPA_SND_ID SWO_TYPEID CHAR 70   0   SEPA Mandate: Sender ID  
41 .INCLUDE       0   0   SEPA Mandate: Sender Data  
42 SND_NAME1 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
43 SND_NAME2 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
44 SND_STREET AD_STREET TEXT60 CHAR 60   0   Street  
45 SND_HOUSENUM AD_HSNM1 TEXT10 CHAR 10   0   House Number  
46 SND_POSTAL AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
47 SND_CITY AD_CITY1 TEXT40 CHAR 40   0   City  
48 SND_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
49 SND_IBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
50 SND_BIC SWIFT SWIFT CHAR 11   0   SWIFT/BIC for International Payments  
51 SND_DIR_NAME SEPA_PAYMENT_FOR BU_NAME CHAR 40   0   SEPA: Name of Alternative Debtor  
52 SND_LANGUAGE LANGU SPRAS LANG 1   0   Language Key T002
53 SND_DIR_ID SEPA_SND_DIR_ID SWO_TYPEID CHAR 70   0   SEPA: ID of Alternative Debtor  
54 SND_DEBTOR_ID SEPA_SND_DEBTOR_ID ID035 CHAR 35   0   SEPA: ID Number of Sender (External Reference)  
55 .INCLUDE       0   0   SEPA Mandate: Recipient Data (Beneficiary Bank Account)  
56 .INCLUDE       0   0   SEPA Mandate: ID of Recipient  
57 REC_TYPE SEPA_REC_TYPE OJ_NAME CHAR 10   0   SEPA Mandate: Recipient Type *
58 REC_ID SEPA_REC_ID SWO_TYPEID CHAR 70   0   SEPA Mandate: Recipient ID  
59 .INCLUDE       0   0   SEPA Mandate: Recipient Data  
60 REC_NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
61 REC_NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
62 REC_CRDID SEPA_CRDID ID035 CHAR 35   0   Creditor Identification Number  
63 REC_STREET AD_STREET TEXT60 CHAR 60   0   Street  
64 REC_HOUSENUM AD_HSNM1 TEXT10 CHAR 10   0   House Number  
65 REC_POSTAL AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
66 REC_CITY AD_CITY1 TEXT40 CHAR 40   0   City  
67 REC_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
68 REC_DIR_NAME SEPA_REC_DIR_NAME BU_NAME CHAR 40   0   SEPA: Name of Alternative Payee  
69 REC_DIR_ID SEPA_REC_DIR_ID SWO_TYPEID CHAR 70   0   SEPA: ID of Alternative Payee  
70 .INCLUDE       0   0   SEPA Mandate: Usage Data  
71 FIRSTUSE_DATE SEPA_FIRSTUSE_DATE DATUM DATS 8   0   SEPA Mandate: Date of First Use  
72 FIRSTUSE_DOCTYPE SEPA_FIRSTUSE_DOCTYPE OJ_NAME CHAR 10   0   SEPA Mandate: Type of First Usage *
73 FIRSTUSE_DOCID SEPA_FIRSTUSE_DOCID SWO_TYPEID CHAR 70   0   SEPA Mandate: ID of First Usage  
74 LASTUSE_DATE SEPA_LASTUSE_DATE DATUM DATS 8   0   SEPA Mandate: Date of Last Use  
75 LASTUSE_DOCTYPE SEPA_LASTUSE_DOCTYPE OJ_NAME CHAR 10   0   SEPA Mandate: Type of Last Usage *
76 LASTUSE_DOCID SEPA_LASTUSE_DOCID SWO_TYPEID CHAR 70   0   SEPA Mandate: ID of Last Usage  
77 FIRSTUSE_PAYRUN SEPA_FIRSTUSE_PAYRUNID CHAR16 CHAR 16   0   SEPA Mandate: ID of Payment Run of First Use  
78 .INCLUDE       0   0   SEPA Mandate: Internal Organizational Data  
79 ORGF1 SEPA_ORG_ID CHAR20 CHAR 20   0   SEPA Mandate: Internal Organizational Data  
80 ORGF2 SEPA_ORG_ID CHAR20 CHAR 20   0   SEPA Mandate: Internal Organizational Data  
81 ORGF3 SEPA_ORG_ID_LONG CHAR35 CHAR 35   0   SEPA Mandate: Internal Organizational Data  
82 ORGF4 SEPA_ORG_ID_LONG CHAR35 CHAR 35   0   SEPA Mandate: Internal Organizational Data  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SEPA_MANDATE REASON_CODE SEPA_RC_CUST REASON_CODE    
2 SEPA_MANDATE REC_COUNTRY T005 LAND1    
3 SEPA_MANDATE SND_COUNTRY T005 LAND1    
4 SEPA_MANDATE SND_LANGUAGE T002 SPRAS    
History
Last changed by/on SAP  20131122 
SAP Release Created in 700