SAP ABAP Table RJVSOCOMPL_LIST (IS-M/SD: Structure w/Overview of Complaints for Ship.Order)

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	RJVSOCOMPL_LIST	Table Relationship Diagram
Short Description	IS-M/SD: Structure w/Overview of Complaints for Ship.Order

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	FVNR	☐	FVNR	FVNR	NUMC	10	0	IS-M: Number of Shipping Problem Message	*
2	ORDNBR	☐	SHIPORDNBR	SHIPORDNBR	CHAR	10	0	Address-Based Shipping Order Number	*
3	POSNBR	☐	SHIPORDPOSNBR	SHIPORDPOSNBR	NUMC	8	0	Address-Based Shipping Order Item Number	*
4	COMPLDATE	☐	ISM_COMPLDATE	DATUM	DATS	8	0	IS-M/SD: Complaint Date
5	MISSINGFROM	☐	FEHLERSEIT	DATS	DATS	8	0	IS-M/SD: Start of Complaint Period
6	MISSINGTO	☐	FEHLERBIS	DATS	DATS	8	0	IS-M/SD: End of Complaint Period
7	COMPLREASON	☐	FVGRUND	FVGRUND	CHAR	4	0	IS-M: Reason for Shipping Problem Message or Complaint	TJV43
8	COMPLRESULT	☐	ISM_REKLERGB	ISM_REKLERGB	CHAR	2	0	IS-M: Complaint Result	TJK17
9	COMPLORIGIN	☐	FVVERURS	FVVERURS	CHAR	4	0	IS-M: Origin of Shipping Problem Message or Complaint	TJV45
10	COMPLDAYS_QUANT	☐	ISM_COMPLDAYS_QUAN	NUMC3	NUMC	3	0	IS-M/SD: Number of Complaint Days
11	RKMENGE	☐	RKMENGE	MENGGPOS	QUAN	10	0	Number of complaint copies
12	NLMENGE	☐	NLMENGE	MENGGPOS	QUAN	10	0	Number of Copies for Subsequent Delivery
13	GSMENGE	☐	GSMENGE	MENGGPOS	QUAN	10	0	Number of Copies to be Included in Credit Memo
14	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	*
15	PUBLICATION	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
16	EDITION	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
17	MEDIAPRODUCT	☐	ISMMATNR_PRODUCT	MATNR	CHAR	18	0	Media Product	MARA
18	MEDIAISSUE	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
19	ADDRESS	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
20	ADDRESS_VARIANT	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
21	ADDRESSLINE_WE	☐	ADDRESSLINE_WE	CHAR80	CHAR	80	0	IS-M: Name and Address of Ship-to Party
22	.INCLUDE	☐				0	0	IS-M: Structure for WWW, BP Address Data
23	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
24	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
25	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
26	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
27	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
28	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
29	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
30	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
31	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
32	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
33	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
34	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
35	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
36	STRASSEWWW	☐	STRASSEWWW	TEXT55	CHAR	55	0	IS-M: Street in WWW (Contains Street Name and Directionals)
37	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
38	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
39	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
40	HAUSNWWW	☐	HSNMRWWW	HAUSNUMMER	CHAR	10	0	IS-M: House Number in WWW (Contains House Number and Affix)
41	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
42	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
43	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
44	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
45	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	*
46	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
47	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
48	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
49	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
50	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
51	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
52	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
53	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
54	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
55	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
56	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
57	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
58	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
59	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
60	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	*
61	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	*
62	PRIVACY_STATUS	☐	ADDRESS_PRIVACY_STATUS	ADDRESS_PRIVACY_STATUS	CHAR	1	0	IS-M: Status of Address As Regards Data Protection
63	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	*
64	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	*
65	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
66	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
67	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
68	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
69	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
70	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
71	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJVSOCOMPL_LIST	ADDRESS	JGTSADR	ADRNR
2	RJVSOCOMPL_LIST	ANRED	TJG43	JANRED	REF	1	CN
3	RJVSOCOMPL_LIST	COMPLORIGIN	TJV45	FVVERURS
4	RJVSOCOMPL_LIST	COMPLREASON	TJV43	FVGRUND
5	RJVSOCOMPL_LIST	COMPLRESULT	TJK17	REKLERGB
6	RJVSOCOMPL_LIST	EDITION	JDTPVA	PVA
7	RJVSOCOMPL_LIST	LAND1	T005	LAND1	KEY
8	RJVSOCOMPL_LIST	MEDIAPRODUCT	MARA	MATNR
9	RJVSOCOMPL_LIST	POSTDIRECTIONAL	TJS41	DIRECTIONAL	REF	1	CN
10	RJVSOCOMPL_LIST	PREDIRECTIONAL	TJS41	DIRECTIONAL	REF	1	CN
11	RJVSOCOMPL_LIST	PUBLICATION	JDTDRER	DRERZ
12	RJVSOCOMPL_LIST	REGIO	T005S	BLAND	REF	1	CN
13	RJVSOCOMPL_LIST	SPRAS	T002	SPRAS	REF	1	CN
14	RJVSOCOMPL_LIST	TITEL	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in	464