SAP ABAP Table OIU_SB_MGDD (Marketing Group Determination Detail)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIU_SB_MGDD	Table Relationship Diagram
Short Description	Marketing Group Determination Detail

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	MGDH_NO	☑	OIU_MGDH_NO	OIU_SYS_NO	NUMC	12	0	Marketing Group Header No
3	OWN_NO	☑	OIU_OWN_NO	LIFNR	CHAR	10	0	PRA owner	LFA1
4	OWN_INT_TYPE_CD	☑	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
5	OWN_ISQ_NO	☑	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
6	EFF_FROM_DT	☑	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
7	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
8	MK_REP_NO	☐	OIU_MK_REP_NO	KUNNR	CHAR	10	0	Marketing Representative No	*
9	MK_REP_ISQ_NO	☐	OIU_MK_REP_ISQ_NO	OIU_MK_REP_ISQ_NO	CHAR	2	0	Marketing Representative Interest Sequence No
10	PU_REP_NO	☐	OIU_PU_REP_NO	KUNNR	CHAR	10	0	Purchasing Representative No	*
11	PU_REP_ISQ_NO	☐	OIU_PU_REP_ISQ_NO	OIU_PU_REP_ISQ_NO	CHAR	2	0	Purchasing Representative Interest Sequence No
12	DO_WARN_FL	☐	OIU_DO_WARN_FL	OIU_X_FLAG	CHAR	1	0	Division order warning flag
13	KW_OWN_CD	☐	OIU_KW_OWN_CD	OIU_KW_OWN_CD	CHAR	1	0	Keep whole owner code
14	.INCLUDE	☐				0	0	Creator and date/time created
15	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
16	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	OIU_SB_MGDD	OWN_INT_TYPE_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD	KEY	1	CN
2	OIU_SB_MGDD	OWN_NO	LFA1	LIFNR		1	CN

History

Last changed by/on	SAP	20050301
SAP Release Created in