SAP ABAP Table RJSEPAWUL_SDAUF (SEPA: SD Orders in Where-Used List)
Hierarchy
☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media
Basic Data
Table Category INTTAB    Structure 
Structure RJSEPAWUL_SDAUF   Table Relationship Diagram
Short Description SEPA: SD Orders in Where-Used List    
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 PARNR PARNR PARNR NUMC 10   0   Number of contact person  
2 ISMADDRESS LINES LINES CHAR 80   0   Address line  
3 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document *
4 POSNR POSNR_VA POSNR NUMC 6   0   Sales Document Item *
5 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
6 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
7 SPART SPART_AK SPART CHAR 2   0   Division for order header *
8 MATNR MATNR MATNR CHAR 18   0   Material Number *
9 VDATU EDATU_VBAK DATUM DATS 8   0   Requested delivery date  
10 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
11 .INCLUDE       0   0   SEPA Mandate: Standard Fields (Cannot be Enhanced)  
12 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
13 MVERS SEPA_MVERS NUM04 NUMC 4   0   SEPA Mandate: Version of Mandate (0 = Current Version)  
14 .INCLUDE       0   0   SEPA Mandate: Management Data  
15 .INCLUDE       0   0   SEPA Mandate: Management Data (External Fields)  
16 SIGN_CITY SEPA_SIGN_CITY TEXT40 CHAR 40   0   Location of Signature  
17 SIGN_DATE SEPA_SIGN_DATE DATUM DATS 8   0   Date of Signature  
18 PAY_TYPE SEPA_PAY_TYPE SEPA_PAY_TYPE CHAR 1   0   SEPA: Payment Type  
19 VAL_FROM_DATE SEPA_VAL_FROM_DATE DATUM DATS 8   0   SEPA: Validity Date of Mandate (From)  
20 VAL_TO_DATE SEPA_VAL_TO_DATE DATUM DATS 8   0   SEPA: Validity Date of Mandate (To)  
21 STATUS SEPA_STATUS SEPA_STATUS CHAR 1   0   SEPA: Mandate Status  
22 B2B SEPA_B2B XFELD CHAR 1   0   SEPA-Mandate: B2B Mandate  
23 REASON_CODE SEPA_REASON_CODE SEPA_REASON_CODE CHAR 3   0   Reason Code for Status Change SEPA_RC_CUST
24 .INCLUDE       0   0   SEPA Mandate: Management Data (Internal Data)  
25 ERNAM SEPA_ERNAM SYCHAR12 CHAR 12   0   User who Created the Current Version of the Mandate  
26 ERDAT SEPA_ERDAT DATUM DATS 8   0   Date on Which the Current Mandate Version was Created  
27 ERTIM SEPA_ERTIM UZEIT TIMS 6   0   Time at Which the Current Mandate Version was Created  
28 CHG_REASON SEPA_CHG_REASON SEPA_CHG_REASON CHAR 5   0   SEPA: Reason for Change  
29 ORIGIN CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
30 ORIGIN_REC_CRDID SEPA_CRDID_ORIGIN ID035 CHAR 35   0   SEPA Mandate: Original Creditor ID of Mandate  
31 ORIGIN_MNDID SEPA_MNDID_ORIGIN ID035 CHAR 35   0   SEPA Mandate: Original Mandate of Mandate  
32 GLOCK SEPA_GLOCK BOOLEAN CHAR 1   0   Global Lock Set in Mandate  
33 GLOCK_VAL_FROM SEPA_GLOCK_VAL_FROM_DATE DATUM DATS 8   0   Global Mandate Lock - Valid From  
34 GLOCK_VAL_TO SEPA_GLOCK_VAL_TO_DATE DATUM DATS 8   0   Global Mandate Lock - Valid Until  
35 ANWND SEPA_ANWND SEPA_ANWND CHAR 1   0   SEPA: Application for Which Mandate Relevant *
36 ORI_ERNAM SEPA_ORI_ERNAM SYCHAR12 CHAR 12   0   User who Created the Original Mandate  
37 ORI_ERDAT SEPA_ORI_ERDAT DATUM DATS 8   0   Date on Which Original Mandate Created  
38 ORI_ERTIM SEPA_ORI_ERTIM UZEIT TIMS 6   0   Time when Original Mandate Was Created  
39 .INCLUDE       0   0   SEPA Mandate: Data for Referencing to Other Objects  
40 .INCLUDE       0   0   SEPA Mandate: ID of Referenced Object  
41 REF_TYPE SEPA_REF_TYPE OJ_NAME CHAR 10   0   SEPA Mandate: Reference Type *
42 REF_ID SEPA_REF_ID SWO_TYPEID CHAR 70   0   SEPA Mandate: Reference ID  
43 .INCLUDE       0   0   SEPA Mandate: Data of Referenced Object  
44 REF_DESC TEXT50 TEXT50 CHAR 50   0   Text Field  
45 .INCLUDE       0   0   SEPA Mandate: Sender Data (Debited Bank Account)  
46 .INCLUDE       0   0   SEPA Mandate: ID of Sender  
47 SND_TYPE SEPA_SND_TYPE OJ_NAME CHAR 10   0   SEPA Mandate: Sender Type *
48 SND_ID SEPA_SND_ID SWO_TYPEID CHAR 70   0   SEPA Mandate: Sender ID  
49 .INCLUDE       0   0   SEPA Mandate: Sender Data  
50 SND_NAME1 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
51 SND_NAME2 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
52 SND_STREET AD_STREET TEXT60 CHAR 60   0   Street  
53 SND_HOUSENUM AD_HSNM1 TEXT10 CHAR 10   0   House Number  
54 SND_POSTAL AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
55 SND_CITY AD_CITY1 TEXT40 CHAR 40   0   City  
56 SND_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
57 SND_IBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
58 SND_BIC SWIFT SWIFT CHAR 11   0   SWIFT/BIC for International Payments  
59 SND_DIR_NAME SEPA_PAYMENT_FOR BU_NAME CHAR 40   0   SEPA: Name of Alternative Debtor  
60 SND_LANGUAGE LANGU SPRAS LANG 1   0   Language Key T002
61 SND_DIR_ID SEPA_SND_DIR_ID SWO_TYPEID CHAR 70   0   SEPA: ID of Alternative Debtor  
62 SND_DEBTOR_ID SEPA_SND_DEBTOR_ID ID035 CHAR 35   0   SEPA: ID Number of Sender (External Reference)  
63 .INCLUDE       0   0   SEPA Mandate: Recipient Data (Beneficiary Bank Account)  
64 .INCLUDE       0   0   SEPA Mandate: ID of Recipient  
65 REC_TYPE SEPA_REC_TYPE OJ_NAME CHAR 10   0   SEPA Mandate: Recipient Type *
66 REC_ID SEPA_REC_ID SWO_TYPEID CHAR 70   0   SEPA Mandate: Recipient ID  
67 .INCLUDE       0   0   SEPA Mandate: Recipient Data  
68 REC_NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
69 REC_NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
70 REC_CRDID SEPA_CRDID ID035 CHAR 35   0   Creditor Identification Number  
71 REC_STREET AD_STREET TEXT60 CHAR 60   0   Street  
72 REC_HOUSENUM AD_HSNM1 TEXT10 CHAR 10   0   House Number  
73 REC_POSTAL AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
74 REC_CITY AD_CITY1 TEXT40 CHAR 40   0   City  
75 REC_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
76 REC_DIR_NAME SEPA_REC_DIR_NAME BU_NAME CHAR 40   0   SEPA: Name of Alternative Payee  
77 REC_DIR_ID SEPA_REC_DIR_ID SWO_TYPEID CHAR 70   0   SEPA: ID of Alternative Payee  
78 .INCLUDE       0   0   SEPA Mandate: Usage Data  
79 FIRSTUSE_DATE SEPA_FIRSTUSE_DATE DATUM DATS 8   0   SEPA Mandate: Date of First Use  
80 FIRSTUSE_DOCTYPE SEPA_FIRSTUSE_DOCTYPE OJ_NAME CHAR 10   0   SEPA Mandate: Type of First Usage *
81 FIRSTUSE_DOCID SEPA_FIRSTUSE_DOCID SWO_TYPEID CHAR 70   0   SEPA Mandate: ID of First Usage  
82 LASTUSE_DATE SEPA_LASTUSE_DATE DATUM DATS 8   0   SEPA Mandate: Date of Last Use  
83 LASTUSE_DOCTYPE SEPA_LASTUSE_DOCTYPE OJ_NAME CHAR 10   0   SEPA Mandate: Type of Last Usage *
84 LASTUSE_DOCID SEPA_LASTUSE_DOCID SWO_TYPEID CHAR 70   0   SEPA Mandate: ID of Last Usage  
85 FIRSTUSE_PAYRUN SEPA_FIRSTUSE_PAYRUNID CHAR16 CHAR 16   0   SEPA Mandate: ID of Payment Run of First Use  
86 .INCLUDE       0   0   SEPA Mandate: Internal Organizational Data  
87 ORGF1 SEPA_ORG_ID CHAR20 CHAR 20   0   SEPA Mandate: Internal Organizational Data  
88 ORGF2 SEPA_ORG_ID CHAR20 CHAR 20   0   SEPA Mandate: Internal Organizational Data  
89 ORGF3 SEPA_ORG_ID_LONG CHAR35 CHAR 35   0   SEPA Mandate: Internal Organizational Data  
90 ORGF4 SEPA_ORG_ID_LONG CHAR35 CHAR 35   0   SEPA Mandate: Internal Organizational Data  
91 ALVSTYLE LVC_T_STYL   TTYP 0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RJSEPAWUL_SDAUF REASON_CODE SEPA_RC_CUST REASON_CODE    
2 RJSEPAWUL_SDAUF REC_COUNTRY T005 LAND1    
3 RJSEPAWUL_SDAUF SND_COUNTRY T005 LAND1    
4 RJSEPAWUL_SDAUF SND_LANGUAGE T002 SPRAS    
History
Last changed by/on SAP  20140121 
SAP Release Created in