SAP ABAP Table ROIUPC_SPADJ (Sales Point Adjustment Structure)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV-PC (Application Component) Product Control
     ⤷ OIU_RVPC (Package) PRA Product Control (Revenue)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUPC_SPADJ	Table Relationship Diagram
Short Description	Sales Point Adjustment Structure

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	DLYAV_01	☐	OIU_DLYAV_DAY_1	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 1
2	DLYAV_02	☐	OIU_DLYAV_DAY_2	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 2
3	DLYAV_03	☐	OIU_DLYAV_DAY_3	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 3
4	DLYAV_04	☐	OIU_DLYAV_DAY_4	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 4
5	DLYAV_05	☐	OIU_DLYAV_DAY_5	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 5
6	DLYAV_06	☐	OIU_DLYAV_DAY_6	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 6
7	DLYAV_07	☐	OIU_DLYAV_DAY_7	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 7
8	DLYAV_08	☐	OIU_DLYAV_DAY_8	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 8
9	DLYAV_09	☐	OIU_DLYAV_DAY_9	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 9
10	DLYAV_10	☐	OIU_DLYAV_DAY_10	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 10
11	DLYAV_11	☐	OIU_DLYAV_DAY_11	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 11
12	DLYAV_12	☐	OIU_DLYAV_DAY_12	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 12
13	DLYAV_13	☐	OIU_DLYAV_DAY_13	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 13
14	DLYAV_14	☐	OIU_DLYAV_DAY_14	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 14
15	DLYAV_15	☐	OIU_DLYAV_DAY_15	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 15
16	DLYAV_16	☐	OIU_DLYAV_DAY_16	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 16
17	DLYAV_17	☐	OIU_DLYAV_DAY_17	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 17
18	DLYAV_18	☐	OIU_DLYAV_DAY_18	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 18
19	DLYAV_19	☐	OIU_DLYAV_DAY_19	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 19
20	DLYAV_20	☐	OIU_DLYAV_DAY_20	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 20
21	DLYAV_21	☐	OIU_DLYAV_DAY_21	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 21
22	DLYAV_22	☐	OIU_DLYAV_DAY_22	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 22
23	DLYAV_23	☐	OIU_DLYAV_DAY_23	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 23
24	DLYAV_24	☐	OIU_DLYAV_DAY_24	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 24
25	DLYAV_25	☐	OIU_DLYAV_DAY_25	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 25
26	DLYAV_26	☐	OIU_DLYAV_DAY_26	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 26
27	DLYAV_27	☐	OIU_DLYAV_DAY_27	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 27
28	DLYAV_28	☐	OIU_DLYAV_DAY_28	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 28
29	DLYAV_29	☐	OIU_DLYAV_DAY_29	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 29
30	DLYAV_30	☐	OIU_DLYAV_DAY_30	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 30
31	DLYAV_31	☐	OIU_DLYAV_DAY_31	OIU_VOLUME_SIGN	DEC	13	3	Daily Avail Day 31
32	DAY_01	☐	OIU_VL_DAY_1	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 1
33	DAY_02	☐	OIU_VL_DAY_2	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 2
34	DAY_03	☐	OIU_VL_DAY_3	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 3
35	DAY_04	☐	OIU_VL_DAY_4	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 4
36	DAY_05	☐	OIU_VL_DAY_5	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 5
37	DAY_06	☐	OIU_VL_DAY_6	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 6
38	DAY_07	☐	OIU_VL_DAY_7	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 7
39	DAY_08	☐	OIU_VL_DAY_8	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 8
40	DAY_09	☐	OIU_VL_DAY_9	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 9
41	DAY_10	☐	OIU_VL_DAY_10	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 10
42	DAY_11	☐	OIU_VL_DAY_11	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 11
43	DAY_12	☐	OIU_VL_DAY_12	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 12
44	DAY_13	☐	OIU_VL_DAY_13	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 13
45	DAY_14	☐	OIU_VL_DAY_14	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 14
46	DAY_15	☐	OIU_VL_DAY_15	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 15
47	DAY_16	☐	OIU_VL_DAY_16	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 16
48	DAY_17	☐	OIU_VL_DAY_17	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 17
49	DAY_18	☐	OIU_VL_DAY_18	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 18
50	DAY_19	☐	OIU_VL_DAY_19	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 19
51	DAY_20	☐	OIU_VL_DAY_20	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 20
52	DAY_21	☐	OIU_VL_DAY_21	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 21
53	DAY_22	☐	OIU_VL_DAY_22	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 22
54	DAY_23	☐	OIU_VL_DAY_23	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 23
55	DAY_24	☐	OIU_VL_DAY_24	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 24
56	DAY_25	☐	OIU_VL_DAY_25	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 25
57	DAY_26	☐	OIU_VL_DAY_26	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 26
58	DAY_27	☐	OIU_VL_DAY_27	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 27
59	DAY_28	☐	OIU_VL_DAY_28	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 28
60	DAY_29	☐	OIU_VL_DAY_29	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 29
61	DAY_30	☐	OIU_VL_DAY_30	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 30
62	DAY_31	☐	OIU_VL_DAY_31	OIU_VOLUME_SIGN	DEC	13	3	Volume for Day 31
63	CT_NO	☐	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIU_RV_CT
64	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	*
65	MP_DE	☐	OIU_MP_DE	OIU_TEXT35	CHAR	35	0	Measurement point description
66	SPADJ_NO	☐	OIU_SPADJ_NO	OIU_SYS_NO	NUMC	12	0	Sales Point Adjustment System Number
67	PROD_DT	☐	OIU_PROD_DT	DATUM	DATS	8	0	Production date
68	PROD_MONTH	☐	OIU_PROD_MONTH	OIU_PROD_MONTH	ACCP	6	0	Production Month (YYYYMM)
69	DN_NO	☐	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	*
70	DN_DE	☐	OIU_DN_DE	OIU_TEXT35	CHAR	35	0	Delivery network description
71	DN_SET	☐	OIU_DN_SET	CHAR15	CHAR	15	0	Delivery Network Hierarchy Group
72	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag
73	MK_REP_NO	☐	OIU_MK_REP_NO	KUNNR	CHAR	10	0	Marketing Representative No	*
74	MK_REP_ISQ_NO	☐	OIU_MK_REP_ISQ_NO	OIU_MK_REP_ISQ_NO	CHAR	2	0	Marketing Representative Interest Sequence No
75	MK_REP_NM	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
76	TRNSP_NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
77	TRNSP_NO	☐	OIU_TRNSP_NO	KUNNR	CHAR	10	0	Transporter number	*
78	.INCLUDE	☐				0	0	Creator and date/time created
79	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
80	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUPC_SPADJ	CT_NO	OIU_RV_CT	CT_NO		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in