C_CorrespondenceAddress
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)
| Source | Alias | Join Type |
|---|---|---|
| I_Address | I_Address | from |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | AddressID | AddressID | ||
| CorrespondenceLanguage | CorrespondenceLanguage | |||
| POBox | POBox | |||
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | |||
| POBoxPostalCode | POBoxPostalCode | |||
| POBoxLobbyName | POBoxLobbyName | |||
| AddressTimeZone | AddressTimeZone | |||
| CityFileTestStatus | CityFileTestStatus | |||
| FullName | FullName | |||
| CityName | CityName | |||
| HomeCityName | HomeCityName | |||
| PostalCode | PostalCode | |||
| StreetName | StreetName | |||
| HouseNumber | HouseNumber | |||
| Building | Building | |||
| Floor | Floor | |||
| RoomNumber | RoomNumber | |||
| Country | Country | |||
| Region | Region | |||
| FormOfAddress | FormOfAddress | |||
| BusinessPartnerName1 | BusinessPartnerName1 | |||
| BusinessPartnerName2 | BusinessPartnerName2 | |||
| Nation | Nation | |||
| PhoneNumber | PhoneNumber | |||
| SearchTerm1 | SearchTerm1 | |||
| SearchTerm2 | SearchTerm2 | |||
| StreetSearch | StreetSearch | |||
| CitySearch | CitySearch | |||
| BusinessPartnerName3 | BusinessPartnerName3 | |||
| BusinessPartnerName4 | BusinessPartnerName4 | |||
| Person | Person | |||
| CorrespncAddrLine1Text | ||||
| CorrespncAddrLine2Text | ||||
| CorrespncAddrLine3Text | ||||
| CorrespncAddrLine4Text | ||||
| CorrespncAddrLine5Text | ||||
| CorrespncAddrLine6Text | ||||
| CorrespncAddrLine7Text | ||||
| CorrespncAddrLine8Text | ||||
| CorrespncAddrLine9Text | ||||
| CorrespncAddrShortWthStrText |
@AbapCatalog.sqlViewName: 'CCORRADDRESS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
//@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.preserveKey:true
@Search.searchable: true
@EndUserText.label: 'Address with printable lines for an address label'
define view C_CorrespondenceAddress
as select from I_Address
{
@Search.defaultSearchElement: true
key 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,
// export parameters for ADDRESS_INTO_PRINTFORM
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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA