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