C_CorrespondenceAddress

DDL: C_CORRESPONDENCEADDRESS SQL: CCORRADDRESS Type: view CONSUMPTION

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
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":""
}
}*/