C_CorrespondenceAddress

DDL: C_CORRESPONDENCEADDRESS SQL: CCORRADDRESS Type: view CONSUMPTION
41 Fields 1 Data Sources

Address with printable lines for an address label

C_CorrespondenceAddress is a Consumption CDS View that provides data about "Address with printable lines for an address label" in SAP S/4HANA. It reads from 1 data source (I_Address) and exposes 41 fields with key field AddressID.

Data Sources (1)

SourceAliasJoin Type
I_Address I_Address from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCORRADDRESS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
Search.searchable true view
EndUserText.label Address with printable lines for an address label view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID Ship-to address
CorrespondenceLanguage CorrespondenceLanguage Language
POBox POBox PO Box
POBoxIsWithoutNumber POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode POBoxPostalCode PO Box Postal Code
POBoxLobbyName POBoxLobbyName PO Box Lobby
AddressTimeZone AddressTimeZone Time Zone
CityFileTestStatus CityFileTestStatus Check Status
FullName FullName Name
CityName CityName Name
HomeCityName HomeCityName Different City
PostalCode PostalCode Postal Code
StreetName StreetName Text
HouseNumber HouseNumber House Number
Building Building Building code
Floor Floor Floor
RoomNumber RoomNumber Room Number
Country Country Venue: Ctry/Reg
Region Region Venue Region
FormOfAddress FormOfAddress Title Key
BusinessPartnerName1 BusinessPartnerName1 Name
BusinessPartnerName2 BusinessPartnerName2 Name 2
Nation Nation Country/Region
PhoneNumber PhoneNumber Telephone no.
SearchTerm1 SearchTerm1 Search Term 1
SearchTerm2 SearchTerm2 Search Term 2
StreetSearch StreetSearch Street
CitySearch CitySearch City
BusinessPartnerName3 BusinessPartnerName3 Name 3
BusinessPartnerName4 BusinessPartnerName4 Name 4
Person Person Person/ Farm/ Field
CorrespncAddrLine1Text
CorrespncAddrLine2Text
CorrespncAddrLine3Text
CorrespncAddrLine4Text
CorrespncAddrLine5Text
CorrespncAddrLine6Text
CorrespncAddrLine7Text
CorrespncAddrLine8Text
CorrespncAddrLine9Text
CorrespncAddrShortWthStrText

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 C_CorrespondenceAddress.
-- 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.
-- SQL view name: CCORRADDRESS

CREATE VIEW C_CorrespondenceAddress AS
SELECT
  AddressID,
  CorrespondenceLanguage,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  AddressTimeZone,
  CityFileTestStatus,
  FullName,
  CityName,
  HomeCityName,
  PostalCode,
  StreetName,
  HouseNumber,
  Building,
  Floor,
  RoomNumber,
  Country,
  Region,
  FormOfAddress,
  BusinessPartnerName1,
  BusinessPartnerName2,
  Nation,
  PhoneNumber,
  SearchTerm1,
  SearchTerm2,
  StreetSearch,
  CitySearch,
  BusinessPartnerName3,
  BusinessPartnerName4,
  Person,
  cast( ' ' as lines ) AS CorrespncAddrLine1Text,
  cast( ' ' as lines ) AS CorrespncAddrLine2Text,
  cast( ' ' as lines ) AS CorrespncAddrLine3Text,
  cast( ' ' as lines ) AS CorrespncAddrLine4Text,
  cast( ' ' as lines ) AS CorrespncAddrLine5Text,
  cast( ' ' as lines ) AS CorrespncAddrLine6Text,
  cast( ' ' as lines ) AS CorrespncAddrLine7Text,
  cast( ' ' as lines ) AS CorrespncAddrLine8Text,
  cast( ' ' as lines ) AS CorrespncAddrLine9Text,
  cast( ' ' as ad_line_s ) AS CorrespncAddrShortWthStrText
FROM I_Address
;

Learn More