SAP ABAP View CRMV_ISU_POD (Specific IBASE_VIEW)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-S-CI (Application Component) Utilities Industry: Commercial and Industrial Customers
     ⤷ CRM_IU_CI_BTX (Package) Utilities Business Transactions

Basic Data

View Type	D	Database View
Database View	CRMV_ISU_POD
Short Description	Specific IBASE_VIEW
Root table	ECRM_ISU_TO_IDX	Index table for service industries technical objects

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ECRM_ISU_TO_IDX	ECRM_ISU_TO_IDX
2	COMM_PR_FRG_REL	COMM_PR_FRG_REL
3	ISU_POD
4	ADRC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	COMM_PR_FRG_REL	PRODUCT_GUID	JL	EQ				0	0
2	ECRM_ISU_TO_IDX	PRODUCT_GUID	JR	EQ			AND	0	0
3	COMM_PR_FRG_REL	FRAGMENT_GUID	JL	EQ				0	0
4	ISU_POD	FRG_GUID	JR	EQ			AND	0	0
5	ECRM_ISU_TO_IDX	ADRNO	JL	EQ				0	0
6	ADRC	ADDRNUMBER	JR	EQ			AND	0	0
7	COMM_PR_FRG_REL	CLIENT	JL	EQ				0	0
8	ECRM_ISU_TO_IDX	MANDT	JR	EQ			AND	0	0
9	ISU_POD	CLIENT	JL	EQ				0	0
10	ECRM_ISU_TO_IDX	MANDT	JR	EQ			AND	0	0
11	ADRC	CLIENT	JL	EQ				0	0
12	ECRM_ISU_TO_IDX	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ECRM_ISU_TO_IDX	MANDT		☐	MANDT	☐	Client
2	TO_GUID	ECRM_ISU_TO_IDX	PRODUCT_GUID		☐	COMT_PRODUCT_GUID	☐	Internal Unique ID of Product
3	DIVISION	ISU_POD	SPARTE		☐	EUI_SPARTE	☐	Division
4	PREMISE	ISU_POD	VSTELLE		☐	EUI_VSTELLE	☐	Premise
5	IS_QUOT_OBJ	ECRM_ISU_TO_IDX	IS_QUOT_OBJ		☐	CRMT_ISU_IS_QUOT	☐	Object Is a Quotation Object
6	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
7	STREETCODE	ADRC	STREETCODE		☐	AD_STRNUM	☐	Street Number for City/Street File
8	HOUSE_NUM1	ADRC	HOUSE_NUM1		☐	AD_HSNM1	☐	House Number
9	HOUSE_NUM2	ADRC	HOUSE_NUM2		☐	AD_HSNM2	☐	House number supplement
10	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
11	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
12	COUNTRY	ADRC	COUNTRY		☐	LAND1	☐	Country Key
13	LANGU	ADRC	LANGU		☐	SPRAS	☐	Language Key
14	EXT_UI	ISU_POD	EXT_UI		☐	EUI_EXT_UI	☐	Point of Delivery ID
15	STR_SUPPL1	ADRC	STR_SUPPL1		☐	AD_STRSPP1	☐	Street 2
16	STR_SUPPL2	ADRC	STR_SUPPL2		☐	AD_STRSPP2	☐	Street 3
17	STR_SUPPL3	ADRC	STR_SUPPL3		☐	AD_STRSPP3	☐	Street 4
18	BUILDING	ADRC	BUILDING		☐	AD_BLDNG	☐	Building (Number or Code)
19	FLOOR	ADRC	FLOOR		☐	AD_FLOOR	☐	Floor in building
20	ROOMNUMBER	ADRC	ROOMNUMBER		☐	AD_ROOMNUM	☐	Room or Appartment Number
21	LGZUSATZ	ISU_POD	LGZUSATZ		☐	EUI_LGZUSATZ	☐	Additional Information on Location
22	OUTL_CONT	ISU_POD	OUTL_CONT		☐	EUI_OUTL_CONTRACT	☐	Outline Contract Indicator
23	GRID_LEVL	ISU_POD	GRID_LEVL		☐	EUI_GRID_LEVEL	☐	Grid Level
24	GRID_LTYP	ISU_POD	GRID_LTYP		☐	EUI_GRID_LEVEL_TYPE	☐	Grid Level Type
25	GRID_ID	ISU_POD	GRID_ID		☐	EUI_GRID_ID	☐	Grid
26	INSTANCE	ECRM_ISU_TO_IDX	INSTANCE		☐	IB_INSTANCE	☐	IB: Component (instance)
27	FRAGMENT_GUID	COMM_PR_FRG_REL	FRAGMENT_GUID		☐	COMT_FRG_GUID	☐	Set GUID
28	VALTO	ECRM_ISU_TO_IDX	VALTO		☐	IB_VALTO	☐	IBase: Valid To
29	VALFR	ECRM_ISU_TO_IDX	VALFR		☐	IB_VALFR	☐	IBase: Valid From
30	IN_OBJNR	ECRM_ISU_TO_IDX	IN_OBJNR		☐	J_OBJNR	☐	Object number
31	PARENT	ECRM_ISU_TO_IDX	PARENT		☐	IB_PARENT	☐	IB: Superior component
32	PREMISE_GUID	ISU_POD	FF0047		☐	EUI_VSTGUID	☐	Premise GUID
33	MC_CITY1	ADRC	MC_CITY1		☐	AD_MC_CITY	☐	City name in upper case for search help
34	MC_STREET	ADRC	MC_STREET		☐	AD_MC_STRT	☐	Street name in upper case for search help

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	20141013
SAP Release Created in	701