SAP ABAP Table RSBCTDPE_DPE_OPP_ITM (Opportunities (Header and Item))

Hierarchy

☛

BI_CONT (Software Component) Business Intelligence Content
⤷

BW-BCT-DPE (Application Component) Dynamic Pricing Engine
⤷

RS_BCT_DPE (Package) BW: Content DPE (Dynamic Pricing Engine)

Basic Data

Table Category	INTTAB	Structure
Structure	RSBCTDPE_DPE_OPP_ITM	Table Relationship Diagram
Short Description	Opportunities (Header and Item)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DMUPDMOD	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
2	DATASET_INDIC	RSBCTDPE_DATASET_INDIC	RSBCTDPE_D_DATASET_INDIC	CHAR	1	0	Dataset Indicator
3	DPE_SOURSYS	RSBCTDPE_DPE_LOGSYS	LOGSYS	CHAR	10	0	DAB System ID (Logical System)	*
4	OPP_INT_ID	RSBCTDPE_OPP_INT_ID		NUMC	10	0	Opportunity Internal ID
5	OPP_ITM_NO	RSBCTDPE_OPP_ITM_NO		NUMC	10	0	Opportunity Item Number
6	OPP_TYPE	RSBCTDPE_OPP_TYPE	RSBCTDPE_D_OPP_TYPE	NUMC	4	0	Opportunity: Type
7	OPP_BUYSELL	RSBCTDPE_OPP_BUYSELL		NUMC	4	0	Opportunity: Buy/Sell Ind.
8	OPP_BROKENLOT	RSBCTDPE_OPP_BROKENLOT		NUMC	4	0	Opportunity: Broken/Full Lot Indicator
9	OPP_NAME	RSBCTDPE_OPP_NAME	RSBCTDPE_D_NAMES60	CHAR	60	0	Name of Opportunity
10	OPP_CLASS	RSBCTDPE_OPP_CLASS		NUMC	10	0	Opportunity Classification
11	OPP_CLASS_PATH	RSBCTDPE_OPP_CLASS_PATH		CHAR	58	0	Opportunity Classification with Hierarchy
12	OPP_CDATE	RSBCTDPE_OPP_CDATE		CHAR	17	0	Opportunity Entry Date (Date and Time)
13	OPP_CHDATE	RSBCTDPE_OPP_CHDATE		CHAR	17	0	Opportunity Change Date (Date and Time)
14	OPP_START	RSBCTDPE_OPP_START		CHAR	17	0	Opportunity Start (Date and Time)
15	OPP_END	RSBCTDPE_OPP_END		CHAR	17	0	Opportunity End (Date and Time)
16	OPP_STATUS	RSBCTDPE_OPP_STATUS	RSBCTDPE_D_OPP_STATUS	NUMC	4	0	Business Opportunity Status
17	OPP_INITIATOR	RSBCTDPE_DPE_COMPANY_ID		CHAR	50	0	DAB Company ID (Trading Partner, BPartner or Other ID)
18	OPP_INIT_INDIC	RSBCTDPE_DPE_COMPANY_INDIC	RSBCTDPE_D_DPE_COMPANY_INDIC	NUMC	4	0	DAB Company Indicator: TPartner, BPartner or Other ID
19	DPE_USERID	RSBCTDPE_DPE_USERID		NUMC	10	0	DAB User ID
20	DPE_USERNAME	RSBCTDPE_DPE_USERNAME		CHAR	45	0	DAB User Name
21	PRODUCT	RSBCTDPE_PRODUCT		CHAR	32	0	Product (UID or GUID)
22	PROD_TEXT	RSBCTDPE_PRODUCT_SHORT_TEXT	RSBCTDPE_D_NAMES60	CHAR	60	0	Product Short Text
23	PROD_INDIC	RSBCTDPE_PRODUCT_INDIC	RSBCTDPE_D_PRODUCT_INDIC	CHAR	1	0	DAB Product Indicator: GUID/UID, DPE Intern. or Short Text
24	PROD_CATEG	RSBCTDPE_PRODCAT		CHAR	32	0	Product Category from EBP
25	PROD_CLASS	RSBCTDPE_PRODCLASS		NUMC	10	0	Product Classification (DPE Internal)
26	PROD_CLASS_PATH	RSBCTDPE_PRODCLASS_PATH		CHAR	58	0	Product Classification (DAB Internal) with Hierarchy
27	PROD_SOURSYS	RSBCTDPE_PRODUCT_SOURSYSTEM		CHAR	20	0	DAB: Source System of Product
28	HDR_PRICE_QUOTE	RSBCTDPE_HDR_PRICE_QUOTE	RSKYFAMO	CURR	17	2	DAB: Header Best Price Quote
29	HDR_START_PRICE	RSBCTDPE_HDR_START_PRICE	RSKYFAMO	CURR	17	2	DAB: Hdr Start Price
30	HDR_RESERVE_PRC	RSBCTDPE_HDR_RESERVE_PRICE	RSKYFAMO	CURR	17	2	Header Reserve Price
31	ITM_PRICE_QUOTE	RSBCTDPE_LISTING_PRICE_QUOTE	RSKYFAMO	CURR	17	2	DAB: Item Best Price Quote
32	ITM_START_PRICE	RSBCTDPE_LISTING_START_PRICE	RSKYFAMO	CURR	17	2	DAB: Item Start Price
33	ITM_RESERVE_PRC	RSBCTDPE_LISTING_RESERVE_PRICE	RSKYFAMO	CURR	17	2	Item Reserve Price
34	HDR_CURR	RSBCTDPE_DPE_HEADER_CURR		CUKY	5	0	DAB: Header Currency
35	ITM_CURR	RSBCTDPE_DPE_LISTING_CURR		CUKY	5	0	DAB: Currency for Item/Listing
36	OPP_ITM_QUAN	RSBCTDPE_OPP_ITM_QUANTITY		DEC	17	3	Opportunity: Quantity
37	OPP_UOM	RSBCTDPE_DPE_UOM		CHAR	3	0	DAB: Unit of Measure
38	OPP_INACTIVETIME	RSBCTDPE_OPP_INACTIVETIME		CHAR	17	0	Opportunity: Inactive Time
39	OPP_AVAIL_DATE	RSBCTDPE_OPP_AVAIL_DATE		CHAR	17	0	Opportunity: Availability Date
40	ITM_EXC_TEXT	RSBCTDPE_OPP_EX_ITM_TEXT	RSBCTDPE_D_NAMES60	CHAR	60	0	Exchange: Text for the Item
41	OPP_DELIV_DATE	RSBCTDPE_OPP_DELIVERY_DATE		DATS	8	0	Opportunity: Delivery Date (Requested Delivery Date)
42	ITM_DA_TYPE01	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
43	ITM_DA_NAME01	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
44	ITM_DA_VALUE01	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
45	ITM_DA_UNIT01	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
46	ITM_DA_CURR01	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
47	ITM_DA_TYPE02	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
48	ITM_DA_NAME02	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
49	ITM_DA_VALUE02	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
50	ITM_DA_UNIT02	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
51	ITM_DA_CURR02	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
52	ITM_DA_TYPE03	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
53	ITM_DA_NAME03	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
54	ITM_DA_VALUE03	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
55	ITM_DA_UNIT03	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
56	ITM_DA_CURR03	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
57	ITM_DA_TYPE04	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
58	ITM_DA_NAME04	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
59	ITM_DA_VALUE04	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
60	ITM_DA_UNIT04	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
61	ITM_DA_CURR04	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
62	ITM_DA_TYPE05	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
63	ITM_DA_NAME05	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
64	ITM_DA_VALUE05	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
65	ITM_DA_UNIT05	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
66	ITM_DA_CURR05	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
67	HDR_DA_TYPE01	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
68	HDR_DA_NAME01	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
69	HDR_DA_VALUE01	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
70	HDR_DA_UNIT01	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
71	HDR_DA_CURR01	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
72	HDR_DA_TYPE02	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
73	HDR_DA_NAME02	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
74	HDR_DA_VALUE02	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
75	HDR_DA_UNIT02	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
76	HDR_DA_CURR02	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
77	HDR_DA_TYPE03	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
78	HDR_DA_NAME03	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
79	HDR_DA_VALUE03	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
80	HDR_DA_UNIT03	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
81	HDR_DA_CURR03	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
82	HDR_DA_TYPE04	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
83	HDR_DA_NAME04	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
84	HDR_DA_VALUE04	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
85	HDR_DA_UNIT04	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
86	HDR_DA_CURR04	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency
87	HDR_DA_TYPE05	RSBCTDPE_DA_TYPE		CHAR	10	0	Placeholder for Dynamic Attributes: Type
88	HDR_DA_NAME05	RSBCTDPE_DA_NAME		CHAR	40	0	Placeholder for Dynamic Attributes: Name
89	HDR_DA_VALUE05	RSBCTDPE_DA_VALUE		CHAR	60	0	Placeholder for Dynamic Attributes: Value
90	HDR_DA_UNIT05	RSBCTDPE_DA_UNIT		CHAR	10	0	Placeholder for Dynamic Attributes: Unit
91	HDR_DA_CURR05	RSBCTDPE_DA_CURRENCY		CHAR	5	0	Placeholder for Dynamic Attributes: Currency