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

History

Last changed by/on	SAP	20140121
SAP Release Created in