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