I_GHOSecdryGeoLocVH

Secondary Geo Location | view: IGHOSECGEOGLOCVH | Extraction: Not supported | Component: UOM: Master Data

Tables used: OIU_CM_LXSGL_TX, UPOC_UDM_REGION

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical
Other (1)
🔗 Relations (4)

Column Name	Description
Country FK	Country/Region Key
PrimaryGeogrlLocation FK	Primary geographical location (PRI geo. loc.)
Region FK	Region (State, Province, County)
SecondaryGeogrlLocation FK	Secondary geographic location

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
SecondaryGeogrlLocationName	Secondary Geographical Location Description	CHAR30

Master Data Relations	Join Conditions
Country/Region Key Country/Region Key Client	`I_GHOSECDRYGEOLOCVH.COUNTRY == T005.LAND1` `I_GHOSECDRYGEOLOCVH.MANDT == T005.MANDT`
Primary geographical location (PRI geo. loc.) Country/Region Key Client Primary geographical location (PRI geo. loc.)	`I_GHOSECDRYGEOLOCVH.COUNTRY == OIU_CM_LXPGL.LAND1` `I_GHOSECDRYGEOLOCVH.MANDT == OIU_CM_LXPGL.MANDT` `I_GHOSECDRYGEOLOCVH.PRIMARYGEOGRLLOCATION == OIU_CM_LXPGL.PRI_GEO_LOC`
Region (State, Province, County) Country/Region Key Client Region (State, Province, County)	`I_GHOSECDRYGEOLOCVH.COUNTRY == T005S.LAND1` `I_GHOSECDRYGEOLOCVH.MANDT == T005S.MANDT` `I_GHOSECDRYGEOLOCVH.REGION == T005S.BLAND`
Secondary Geographical Location Country/Region Key Client Primary geographical location (PRI geo. loc.) Secondary geographic location	`I_GHOSECDRYGEOLOCVH.COUNTRY == OIU_CM_LXSGL.LAND1` `I_GHOSECDRYGEOLOCVH.MANDT == OIU_CM_LXSGL.MANDT` `I_GHOSECDRYGEOLOCVH.PRIMARYGEOGRLLOCATION == OIU_CM_LXSGL.PRI_GEO_LOC` `I_GHOSECDRYGEOLOCVH.SECONDARYGEOGRLLOCATION == OIU_CM_LXSGL.SEC_GEO_LOC`