C_BankAddressTP
Consumption Bank Address TP
C_BankAddressTP is a Consumption CDS View that provides data about "Consumption Bank Address TP" in SAP S/4HANA. It reads from 1 data source (R_BankAddressTP) and exposes 63 fields with key fields BankCountry, BankInternalID.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_BankAddressTP | R_BankAddressTP | projection |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Consumption Bank Address TP | view | |
| Metadata.allowExtensions | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| VDM.viewType | #CONSUMPTION | view |
Fields (63)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BankCountry | BankCountry | ||
| KEY | BankInternalID | BankInternalID | ||
| StreetName | StreetName | |||
| HouseNumber | HouseNumber | |||
| HouseNumberSupplementText | HouseNumberSupplementText | |||
| CityName | CityName | |||
| PostalCode | PostalCode | |||
| Country | Country | |||
| Region | Region | |||
| CorrespondenceLanguage | CorrespondenceLanguage | |||
| LanguageNameasLanguageNamelocalized | ||||
| DistrictName | DistrictName | |||
| VillageName | VillageName | |||
| CompanyPostalCode | CompanyPostalCode | |||
| StreetAddrNonDeliverableReason | StreetAddrNonDeliverableReason | |||
| StreetPrefixName1 | StreetPrefixName1 | |||
| StreetPrefixName2 | StreetPrefixName2 | |||
| StreetSuffixName1 | StreetSuffixName1 | |||
| StreetSuffixName2 | StreetSuffixName2 | |||
| Building | Building | |||
| Floor | Floor | |||
| RoomNumber | RoomNumber | |||
| FormOfAddress | FormOfAddress | |||
| TaxJurisdiction | TaxJurisdiction | |||
| TransportZone | TransportZone | |||
| AddressSearchTerm1 | AddressSearchTerm1 | |||
| AddressSearchTerm2 | AddressSearchTerm2 | |||
| POBox | POBox | |||
| POBoxAddrNonDeliverableReason | POBoxAddrNonDeliverableReason | |||
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | |||
| POBoxPostalCode | POBoxPostalCode | |||
| POBoxLobbyName | POBoxLobbyName | |||
| POBoxDeviatingCityName | POBoxDeviatingCityName | |||
| POBoxDeviatingRegion | POBoxDeviatingRegion | |||
| POBoxDeviatingCountry | POBoxDeviatingCountry | |||
| CareOfName | CareOfName | |||
| DeliveryServiceTypeCode | DeliveryServiceTypeCode | |||
| DeliveryServiceNumber | DeliveryServiceNumber | |||
| AddressTimeZone | AddressTimeZone | |||
| SecondaryRegionName | SecondaryRegionName | |||
| TertiaryRegionName | TertiaryRegionName | |||
| AddressRepresentationCode | AddressRepresentationCode | |||
| AddressCodeDesc | ||||
| AddressID | AddressID | |||
| PhoneNumberCountry | PhoneNumberCountry | |||
| PhoneNumber | PhoneNumber | |||
| PhoneExtensionNumber | PhoneExtensionNumber | |||
| InternationalPhoneNumber | InternationalPhoneNumber | |||
| TelephoneCountryPrefix | _TelCountryPrefix | TelephoneCountryPrefix | ||
| MobilePhoneCountry | MobilePhoneCountry | |||
| MobilePhoneNumber | MobilePhoneNumber | |||
| InternationalMobilePhoneNumber | InternationalMobilePhoneNumber | |||
| FaxNumberCountry | FaxNumberCountry | |||
| FaxAreaCodeSubscriberNumber | FaxAreaCodeSubscriberNumber | |||
| FaxExtensionNumber | FaxExtensionNumber | |||
| InternationalFaxNumber | InternationalFaxNumber | |||
| EmailAddress | EmailAddress | |||
| BankCountryName | ||||
| RegionName | ||||
| _BankredirectedtoparentC_BankTP | ||||
| _Country | _Country | |||
| _FormOfAddress | _FormOfAddress | |||
| _Region | _Region |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption Bank Address TP'
@Metadata.allowExtensions: true
@ObjectModel.usageType:{
serviceQuality: #D,
sizeCategory: #L,
dataClass: #MASTER
}
@VDM.viewType: #CONSUMPTION
define view entity C_BankAddressTP
as projection on R_BankAddressTP as BankAddress
{
key BankCountry,
key BankInternalID,
//@Semantics.text: true
//LongBankName, //char80 ... it is exposed via case condition in C_BankTP
//LongBankBranch, //char80
@Semantics.address.street: true
StreetName,
@Semantics.address.streetNoNumber: true
HouseNumber,
HouseNumberSupplementText,
@Semantics.address.city: true
CityName,
/*@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_PostalCityVH',
element: 'PostalCode' }
}] */
@Semantics.address.zipCode: true
PostalCode,
@Semantics.address.country: true
@ObjectModel.text.element: [ 'BankCountryName' ]
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_CountryVH', element: 'Country' } }]
Country,
@ObjectModel.text.element: [ 'RegionName' ]
@Consumption.valueHelpDefinition: [
{ entity : {name: 'I_RegionVH', element: 'Region' },
additionalBinding : [ { localElement : 'Country', element : 'Country' } ]
}]
Region,
@ObjectModel.text.element: ['LanguageName']
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_Language', element: 'Language' } }]
CorrespondenceLanguage,
@UI.hidden: true
_CorrespondenceLanguage._Text.LanguageName as LanguageName : localized,
//AddressObjectType,
//PrfrdCommMediumType,
//AddresseeFullName,
DistrictName,
VillageName,
CompanyPostalCode,
StreetAddrNonDeliverableReason,
StreetPrefixName1,
StreetPrefixName2,
StreetSuffixName1,
StreetSuffixName2,
Building,
Floor,
RoomNumber,
FormOfAddress,
TaxJurisdiction,
TransportZone,
AddressSearchTerm1,
AddressSearchTerm2,
POBox,
POBoxAddrNonDeliverableReason,
POBoxIsWithoutNumber,
POBoxPostalCode,
POBoxLobbyName,
POBoxDeviatingCityName,
POBoxDeviatingRegion,
POBoxDeviatingCountry,
CareOfName,
DeliveryServiceTypeCode,
DeliveryServiceNumber,
AddressTimeZone,
SecondaryRegionName,
TertiaryRegionName,
//@ObjectModel.text.association: '_AddressRepresentationCode._Text'
@Consumption.valueHelpDefinition: [{ entity : {name: 'I_ActiveAddressRepresentation', element: 'AddressRepresentationCode' } }]//C_BankAddressRepCodeVH
@ObjectModel.text.element: ['AddressCodeDesc']
AddressRepresentationCode, //is always empty
@UI.hidden: true
@Semantics.text: true
_AddressRepresentationCode._Text[1:Language = $session.system_language].AddressRepresentationDesc as AddressCodeDesc,
AddressID,
// Telephone
@Consumption.valueHelpDefinition: [{ entity: {name: 'I_BusPartTelCountryPrefix',element: 'Country' },
additionalBinding: [
{element: 'TelephoneCountryPrefix',localElement:'TelephoneCountryPrefix',usage: #RESULT}
]
}]
PhoneNumberCountry,
PhoneNumber,
PhoneExtensionNumber,
InternationalPhoneNumber, //Complete Number: Dialing Code+Number+Extension
_TelCountryPrefix.TelephoneCountryPrefix,
// Mobile Phone
MobilePhoneCountry,
MobilePhoneNumber,
@Semantics.telephone.type: [#PREF]
InternationalMobilePhoneNumber,
// Fax
FaxNumberCountry,
FaxAreaCodeSubscriberNumber,
FaxExtensionNumber,
InternationalFaxNumber,
// E-mail
// @Semantics.eMail.address
EmailAddress,
// URL
// UniformResourceIdentifier,
@UI.hidden: true
@Semantics.text: true
_Country._Text[1:Language = $session.system_language].CountryShortName as BankCountryName,
@UI.hidden: true
@Semantics.text: true
_Region._RegionText[1:Language = $session.system_language].RegionName as RegionName, //INS DK01
/* Associations */
BankAddress._Bank : redirected to parent C_BankTP,
BankAddress._BankScriptVariant : redirected to composition child C_BankScriptedAddressTP,
_Country,
_FormOfAddress,
_Region
// _AddressRepresentationCode
// _Language
// _CorrespondenceLanguage
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSREPRESENTATION",
"I_ADDRESSREPRESENTATIONTEXT",
"I_BUSPARTTELCOUNTRYPREFIX",
"I_COUNTRY",
"I_COUNTRYTEXT",
"I_LANGUAGE",
"I_LANGUAGETEXT",
"I_REGION",
"I_REGIONTEXT",
"R_BANKADDRESSTP"
],
"ASSOCIATED":
[
"C_BANKSCRIPTEDADDRESSTP",
"C_BANKTP",
"I_COUNTRY",
"I_FORMOFADDRESS",
"I_REGION",
"R_BANKSCRIPTEDADDRESSTP",
"R_BANKTP"
],
"BASE":
[
"R_BANKADDRESSTP"
],
"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