SAP ABAP Table RJK07 (Structure for Preassignment Screen SAPMJK07)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	RJK07	Table Relationship Diagram
Short Description	Structure for Preassignment Screen SAPMJK07

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	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
2	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
3	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
4	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
5	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
6	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TSPA
7	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
8	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
9	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
10	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
11	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
12	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
13	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
14	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
15	GUELTIGVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
16	GUELTIGBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
17	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
18	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
19	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
20	BEZUGGRD	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	TJK87
21	KUENDGRD	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	TJK83
22	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
23	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
24	WERBTRAEG	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	TJW09
25	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
26	VERSERVGES	☐	VSGPROV	GPNR	CHAR	10	0	Service company for commission payee	JGTGPNR
27	FKPER	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
28	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
29	RECHBEGINN	☐	RECHBEGINN	DATUM	DATS	8	0	Billing From
30	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
31	ZLSCH	☐	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	T042Z
32	RCODE	☐	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	TJKRRC
33	KSREMIND	☐	KSREMIND	KSREMIND	CHAR	2	0	IS-M/SD: Customer Procedure for Monitoring	*
34	MATNRWERB	☐	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift	*
35	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN_GENERIC	ISM_MARKETING_CAMPAIGN_GENERIC	RAW	16	0	IS-M: Marketing Campaign (Generic)
36	CAMPAIGN_TXT	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
37	VBELN_VL	☐	ISM_TEMPL_DOC_MSD	AVNR	CHAR	10	0	IS-M: Offer for Media Sales and Distribution	*
38	DESCR_L	☐	ISM_CMPG_DESCR_L	TEXT60	CHAR	60	0	IS-M: CRM, Description (Long)
39	XSEPAACTIVE	☐	XSEPAACTIVE	XFELD	CHAR	1	0	IS-M: Create SEPA Mandate with the Active Status
40	SIGN_CITY	☐	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
41	SIGN_DATE	☐	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJK07	AUART	TJAK	AUART
2	RJK07	BEZPER	TJD09	BEZPER
3	RJK07	BEZUGGRD	TJK87	BEZUGGRD
4	RJK07	BEZUGSTYP	JDTBEZTYP	BEZTYP
5	RJK07	DRERZ	JDTDRER	DRERZ
6	RJK07	ETMEINS	T006	MSEHI
7	RJK07	FKPER	TJK01	FKPER
8	RJK07	GPNR	JGTGPNR	GPNR
9	RJK07	KONDA	T188	KONDA
10	RJK07	KUENDGRD	TJK83	KUENDGRD
11	RJK07	KURST	TCURV	KURST
12	RJK07	LAND1	T005	LAND1
13	RJK07	LIEFERART	TJV01	LIEFERART
14	RJK07	PERFK	TFACD	IDENT
15	RJK07	PVA	JDTPVA	PVA
16	RJK07	RCODE	TJKRRC	RCODE
17	RJK07	SPART	TSPA	SPART
18	RJK07	SPRAS	T002	SPRAS
19	RJK07	VERSERVGES	JGTGPNR	GPNR
20	RJK07	VKBUR	TVBUR	VKBUR
21	RJK07	VKORG	TVKO	VKORG
22	RJK07	VTWEG	TVTW	VTWEG
23	RJK07	WAERK	TCURC	WAERS
24	RJK07	WERBEAKT	TJWAK	WERBEAKT
25	RJK07	WERBEART	TJWAR	WERBEART
26	RJK07	WERBTRAEG	TJW09	WERBTRAEG
27	RJK07	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in