SAP ABAP View TBAH_MIC_DCS_SEL (View for DCS/MIC Combination)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA-GTF-TRB (Application Component) Financial Risk Management Basis
     ⤷ FTR_BASIS_PERSISTENCY (Package) Treasury Basis Objects - Data Persistency

Basic Data

View Type	D	Database View
Database View	TBAH_MIC_DCS_SEL
Short Description	View for DCS/MIC Combination
Root table	TBAC_DCS_MIC	Dervative contract specification - MIC

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TBAC_DCS_MIC	TBAC_DCS_MIC
2	TBAC_DCS
3	TBAC_MIC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TBAC_DCS	CLIENT	JL	EQ				0	0
2	TBAC_DCS_MIC	CLIENT	JR	EQ			AND	0	0
3	TBAC_DCS	DCSID	JL	EQ				0	0
4	TBAC_DCS_MIC	DCSID	JR	EQ			AND	0	0
5	TBAC_MIC	CLIENT	JL	EQ				0	0
6	TBAC_DCS_MIC	CLIENT	JR	EQ			AND	0	0
7	TBAC_MIC	MIC	JL	EQ				0	0
8	TBAC_DCS_MIC	MIC	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	TBAC_DCS_MIC	CLIENT		☐	MANDT	☐	Client
2	DCSID	TBAC_DCS_MIC	DCSID		☐	TBA_DCSID	☐	Derivative Contract Specification ID
3	DERIVATIVETYPE	TBAC_DCS	DERIVATIVETYPE		☐	TBA_DERIVATIVETYPE	☐	Derivative Category
4	LIFECYCLESTATUS	TBAC_DCS	LIFECYCLESTATUS		☐	TBA_DCS_LIFECYCLESTATUS	☐	Derivative Contract Specification of Lifecycle Status
5	MIC	TBAC_DCS_MIC	MIC		☐	TBA_MIC	☐	Market Identifier Code
6	COUNTRY	TBAC_MIC	COUNTRY		☐	LAND1	☐	Country Key
7	LOCATION	TBAC_MIC	LOCATION		☐	ORT01	☐	City
8	MIC_STATUS	TBAC_MIC	MIC_STATUS		☐	TBA_MIC_STATUS	☐	Market Identifier Code Status
9	IN_USE	TBAC_MIC	IN_USE		☐	TBA_MIC_ACTIVE	☐	Market Identifier Code Can Be Used for Trading

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20140802
SAP Release Created in