CIC_PlantAddress

DDL: CIC_PLANTADDRESS Type: view_entity
29 Fields 2 Data Sources 2 Associations

Proj. view on Plant address

CIC_PlantAddress is a CDS View that provides data about "Proj. view on Plant address" in SAP S/4HANA. It reads from 2 data sources (I_Plant, adrc) and exposes 29 fields with key fields AddressID, Plant. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_Plant _Plant inner
adrc _PlantAddress from

Associations (2)

CardinalityTargetAliasCondition
[1..1] CIC_GEO_COORDINATES _geolocation $projection.AddressID = _geolocation.addrnumber
[1..1] CIC_IANATimeZone _IANAZone $projection.AddressTimeZone = _IANAZone.tzone and _IANAZone.flagsapdefault = 'X'

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Proj. view on Plant address view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY AddressID adrc addrnumber Address Number
KEY Plant I_Plant Plant Valuation Area
IANATimeZone _IANAZone ianatzone IANA time zone
Region adrc region Venue Region
Country adrc country Venue: Ctry/Reg
SecondaryRegionName adrc county Wyoming County
SecondaryRegion adrc county_code County code
TertiaryRegion adrc township_code Township code
TertiaryRegionName adrc township Township
PostalCode adrc post_code1 Postal Code
CityName adrc city1 City
CityCode adrc city_code Japan City Code
AdditionalCityName adrc home_city Different City
DistrictName adrc city2 District
BPCityDistrictCode adrc cityp_code District Code
StreetName adrc street Street Code
Street adrc streetcode Street Code
HouseNumber adrc house_num1 House Number
Building adrc building Building code
Floor adrc floor Floor
RoomNumber adrc roomnumber Room Number
latitude _geolocation latitude Latitude
longitude _geolocation longitude Longitude
altitude _geolocation altitude Height
BusinessPartnerName1 adrc name1 PA text
BusinessPartnerName2 adrc name2 Name2/First nme
BusinessPartnerName3 adrc name3 Name 3
BusinessPartnerName4 adrc name4 Name 4
AddressTimeZone adrc time_zone TimeZone

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view CIC_PlantAddress.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW CIC_PlantAddress AS
SELECT
  _PlantAddress.addrnumber AS AddressID,
  _Plant.Plant AS Plant,
  _IANAZone.ianatzone AS IANATimeZone,
  _PlantAddress.region AS Region,
  _PlantAddress.country AS Country,
  _PlantAddress.county AS SecondaryRegionName,
  _PlantAddress.county_code AS SecondaryRegion,
  _PlantAddress.township_code AS TertiaryRegion,
  _PlantAddress.township AS TertiaryRegionName,
  _PlantAddress.post_code1 AS PostalCode,
  _PlantAddress.city1 AS CityName,
  _PlantAddress.city_code AS CityCode,
  _PlantAddress.home_city AS AdditionalCityName,
  _PlantAddress.city2 AS DistrictName,
  _PlantAddress.cityp_code AS BPCityDistrictCode,
  _PlantAddress.street AS StreetName,
  _PlantAddress.streetcode AS Street,
  _PlantAddress.house_num1 AS HouseNumber,
  _PlantAddress.building AS Building,
  _PlantAddress.floor AS Floor,
  _PlantAddress.roomnumber AS RoomNumber,
  _geolocation.latitude AS latitude,
  _geolocation.longitude AS longitude,
  _geolocation.altitude AS altitude,
  _PlantAddress.name1 AS BusinessPartnerName1,
  _PlantAddress.name2 AS BusinessPartnerName2,
  _PlantAddress.name3 AS BusinessPartnerName3,
  _PlantAddress.name4 AS BusinessPartnerName4,
  _PlantAddress.time_zone AS AddressTimeZone
FROM adrc AS _PlantAddress
INNER JOIN I_Plant AS _Plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CIC_GEO_COORDINATES AS _geolocation ON AddressID = _geolocation.addrnumber  -- association [1..1]
LEFT OUTER JOIN CIC_IANATimeZone AS _IANAZone ON AddressTimeZone = _IANAZone.tzone AND _IANAZone.flagsapdefault = 'X'  -- association [1..1]
;

Learn More