I_HCMBuildingAddress

DDL: I_HCMBUILDINGADDRESS Type: view_entity BASIC
12 Fields 1 Data Sources

HCM Building Address

I_HCMBuildingAddress is a Basic CDS View that provides data about "HCM Building Address" in SAP S/4HANA. It reads from 1 data source (t777a) and exposes 12 fields with key field HCMBuilding.

Data Sources (1)

SourceAliasJoin Type
t777a t777a from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label HCM Building Address view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY HCMBuilding build Building
HCMBuildingName stext Text
CareOfName cname User
HCMStreet stras Street/House
HCMCityName ort01 Province
HCMPostalCode pstlz Postal Code
Country land1 Trip Ctry/Reg
PhoneNumber Telephone number
FaxNumber Fax number
Region regio Resident Region
AdditionalStreetSuffixName strs2 Street
HCMHouseNumber hausn House number

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 I_HCMBuildingAddress.
-- 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 I_HCMBuildingAddress AS
SELECT
  build AS HCMBuilding,
  stext AS HCMBuildingName,
  cname AS CareOfName,
  stras AS HCMStreet,
  ort01 AS HCMCityName,
  pstlz AS HCMPostalCode,
  land1 AS Country,
  cast( telnr as ad_tlnmbr ) AS PhoneNumber,
  cast( faxnr as telfx ) AS FaxNumber,
  regio AS Region,
  strs2 AS AdditionalStreetSuffixName,
  hausn AS HCMHouseNumber
FROM t777a
;

Learn More