SAP ABAP Table RJHA6100 (IS-M: Screen Structure for Address/Order Header Data CntAccs)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	RJHA6100	Table Relationship Diagram
Short Description	IS-M: Screen Structure for Address/Order Header Data CntAccs

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	IS-M: Data Required for Business Partner Creation
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
6	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
7	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
8	KURST	☐	KURST_DEF	KURST	CHAR	4	0	IS-M: Standard Business Partner Exchange Rate Type	*
9	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
10	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
11	BP_KIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	TB004
12	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
13	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JGTGPNR
14	ALTINSGPNR	☐	ALTINSGPNR	CHAR15	CHAR	15	0	IS-M: Alternative Customer Number for Advertiser
15	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
16	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
17	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
18	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
19	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
20	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
21	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
22	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
23	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
24	PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	*
25	TELVW	☐	TELVW_ISP	TELVW_ISP	CHAR	10	0	IS-M: Telephone area code
26	TELNR	☐	ISPTELNR	ISPTELNR	CHAR	20	0	IS-M: Telephone Number (Without Conversion Routine)
27	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
28	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
29	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
30	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
31	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
32	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
33	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
34	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
35	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
36	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
37	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
38	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
39	J_SOC_SECU	☐	J_SOC_SECU	CHAR020	CHAR	20	0	IS-M: Social Insurance Number
40	.INCLUDE	☐				0	0	IS-M: Include Structure for Bank Data
41	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
42	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
43	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
44	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
45	BANKA	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
46	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
47	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
48	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
49	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
50	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
51	EXDATBI	☐	EXDATBI_CC	CHAR10	CHAR	10	0	Payment cards: Expiration date
52	INDATBI	☐	DATS	DATS	DATS	8	0	Field of type DATS
53	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
54	KPL_SUCHE	☐	IS_KPLFIND	XFELD	CHAR	1	0	IS-M: Addr.Search Incl.Major Customer and PO Box Addresses
55	SEL_AG_BOX	☐	XAUFTGEBER	XFELD	CHAR	1	0	Selection Indicator: Sold-to Party
56	SEL_IN_BOX	☐	XINSERENT	XINSERENT	CHAR	1	0	IS-M: Selection Indicator for Advertiser
57	SEL_RE_BOX	☐	XRECHNEMPF	XRECHNEMPF	CHAR	1	0	Selection Indicator for Bill-To Party
58	SEL_RG_BOX	☐	XREGULIERR	XFELD	CHAR	1	0	Payer
59	SEL_AR_BOX	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
60	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
61	AVM_NR	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
62	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
63	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
64	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
65	VTNR	☑	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	*
66	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
67	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
68	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
69	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
70	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	TJH91
71	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55
72	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
73	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
74	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
75	XSELOLDORDER	☐	XSELOLDORDER	XFELD	CHAR	1	0	IS-M/AM: Central Access - Select Legacy Orders Indicator
76	VARIANTE_ZE	☐	ISM_JHA6_VARIANTE	SLIS_VARI	CHAR	12	0	IS-M: Initial Variant for Order List CIC/Central Access

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHA6100	ANRED	TJG43	JANRED	REF	1	CN
2	RJHA6100	AUART	TJHAK	AUART	REF	1	CN
3	RJHA6100	AVM_NR	JHAK	AVM_NR	REF	1	CN
4	RJHA6100	BANKS	T005	LAND1
5	RJHA6100	BP_KIND	TB004	BPKIND
6	RJHA6100	BRAN_PAM	TBRC	BRACO
7	RJHA6100	BU_GROUP	TB001	BU_GROUP
8	RJHA6100	GPNR	JGTGPNR	GPNR
9	RJHA6100	INSERENT	JGTGPNR	GPNR
10	RJHA6100	KAMPAGNE	TJJKAMP	KAMPAGNE
11	RJHA6100	LAND1	T005	LAND1		1	CN
12	RJHA6100	NAMZU	T535N	TITEL
13	RJHA6100	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
14	RJHA6100	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
15	RJHA6100	PSTYV	TJHAP	PSTYV	REF	1	CN
16	RJHA6100	SPART	TSPA	SPART
17	RJHA6100	TERM_TYP	TJH55	TERM_TYP	REF	1	CN
18	RJHA6100	TITEL	T535N	TITEL	REF	1	CN
19	RJHA6100	VKBUR	TVKBZ	VKBUR
20	RJHA6100	VKGRP	TVBVK	VKGRP
21	RJHA6100	VKORG	TVKO	VKORG
22	RJHA6100	VORSW	T535N	TITEL
23	RJHA6100	VTWEG	TVTW	VTWEG
24	RJHA6100	WERBK_TYP	TJH91	WKOMBI_TYP

History

Last changed by/on	SAP	20130529
SAP Release Created in