C_CashBankAddress
Cash Bank Address
C_CashBankAddress is a Consumption CDS View that provides data about "Cash Bank Address" in SAP S/4HANA. It reads from 1 data source (R_BankAddressTP) and exposes 62 fields with key fields BankCountry, BankInternalID.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_BankAddressTP | _BankAddress | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Cash Bank Address | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| Metadata.allowExtensions | true | view | |
| VDM.viewType | #CONSUMPTION | view |
Fields (62)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BankCountry | R_BankAddressTP | BankCountry | |
| KEY | BankInternalID | R_BankAddressTP | BankInternalID | |
| StreetName | R_BankAddressTP | StreetName | ||
| HouseNumber | R_BankAddressTP | HouseNumber | ||
| HouseNumberSupplementText | R_BankAddressTP | HouseNumberSupplementText | ||
| CityName | R_BankAddressTP | CityName | ||
| PostalCode | R_BankAddressTP | PostalCode | ||
| Country | R_BankAddressTP | Country | ||
| Region | R_BankAddressTP | Region | ||
| CorrespondenceLanguage | R_BankAddressTP | CorrespondenceLanguage | ||
| LanguageName | ||||
| DistrictName | R_BankAddressTP | DistrictName | ||
| VillageName | R_BankAddressTP | VillageName | ||
| CompanyPostalCode | R_BankAddressTP | CompanyPostalCode | ||
| StreetAddrNonDeliverableReason | R_BankAddressTP | StreetAddrNonDeliverableReason | ||
| StreetPrefixName1 | R_BankAddressTP | StreetPrefixName1 | ||
| StreetPrefixName2 | R_BankAddressTP | StreetPrefixName2 | ||
| StreetSuffixName1 | R_BankAddressTP | StreetSuffixName1 | ||
| StreetSuffixName2 | R_BankAddressTP | StreetSuffixName2 | ||
| Building | R_BankAddressTP | Building | ||
| Floor | R_BankAddressTP | Floor | ||
| RoomNumber | R_BankAddressTP | RoomNumber | ||
| FormOfAddress | R_BankAddressTP | FormOfAddress | ||
| TaxJurisdiction | R_BankAddressTP | TaxJurisdiction | ||
| TransportZone | R_BankAddressTP | TransportZone | ||
| AddressSearchTerm1 | R_BankAddressTP | AddressSearchTerm1 | ||
| AddressSearchTerm2 | R_BankAddressTP | AddressSearchTerm2 | ||
| POBox | R_BankAddressTP | POBox | ||
| POBoxAddrNonDeliverableReason | R_BankAddressTP | POBoxAddrNonDeliverableReason | ||
| POBoxIsWithoutNumber | R_BankAddressTP | POBoxIsWithoutNumber | ||
| POBoxPostalCode | R_BankAddressTP | POBoxPostalCode | ||
| POBoxLobbyName | R_BankAddressTP | POBoxLobbyName | ||
| POBoxDeviatingCityName | R_BankAddressTP | POBoxDeviatingCityName | ||
| POBoxDeviatingRegion | R_BankAddressTP | POBoxDeviatingRegion | ||
| POBoxDeviatingCountry | R_BankAddressTP | POBoxDeviatingCountry | ||
| CareOfName | R_BankAddressTP | CareOfName | ||
| DeliveryServiceTypeCode | R_BankAddressTP | DeliveryServiceTypeCode | ||
| DeliveryServiceNumber | R_BankAddressTP | DeliveryServiceNumber | ||
| AddressTimeZone | R_BankAddressTP | AddressTimeZone | ||
| SecondaryRegionName | R_BankAddressTP | SecondaryRegionName | ||
| TertiaryRegionName | R_BankAddressTP | TertiaryRegionName | ||
| AddressRepresentationCode | R_BankAddressTP | AddressRepresentationCode | ||
| AddressCodeDesc | ||||
| AddressID | R_BankAddressTP | AddressID | ||
| PhoneNumberCountry | R_BankAddressTP | PhoneNumberCountry | ||
| TelephoneCountryName | ||||
| PhoneNumber | R_BankAddressTP | PhoneNumber | ||
| PhoneExtensionNumber | R_BankAddressTP | PhoneExtensionNumber | ||
| InternationalPhoneNumber | R_BankAddressTP | InternationalPhoneNumber | ||
| TelephoneCountryPrefix | ||||
| MobilePhoneCountry | R_BankAddressTP | MobilePhoneCountry | ||
| MobilePhoneNumber | R_BankAddressTP | MobilePhoneNumber | ||
| InternationalMobilePhoneNumber | R_BankAddressTP | InternationalMobilePhoneNumber | ||
| FaxNumberCountry | R_BankAddressTP | FaxNumberCountry | ||
| FaxAreaCodeSubscriberNumber | R_BankAddressTP | FaxAreaCodeSubscriberNumber | ||
| FaxExtensionNumber | R_BankAddressTP | FaxExtensionNumber | ||
| InternationalFaxNumber | R_BankAddressTP | InternationalFaxNumber | ||
| EmailAddress | R_BankAddressTP | EmailAddress | ||
| BankCountryName | ||||
| RegionName | ||||
| _TelCountryPrefix | _TelCountryPrefix | |||
| _Bank | R_BankAddressTP | _Bank |
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Cash Bank Address'
@AccessControl.personalData.blocking:#REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #D,
sizeCategory: #L, // #XL,
dataClass: #MASTER //#MIXED
}
@Metadata.allowExtensions: true
@VDM.viewType: #CONSUMPTION
define view entity C_CashBankAddress as select from R_BankAddressTP as _BankAddress
{
key _BankAddress.BankCountry,
key _BankAddress.BankInternalID,
@Semantics.address.street: true
_BankAddress.StreetName,
@Semantics.address.streetNoNumber: true
_BankAddress.HouseNumber,
_BankAddress.HouseNumberSupplementText,
@Semantics.address.city: true
_BankAddress.CityName,
@Semantics.address.zipCode: true
_BankAddress.PostalCode,
@Semantics.address.country: true
@ObjectModel.text.element: [ 'BankCountryName' ]
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_CountryVH', element: 'Country' } }]
_BankAddress.Country,
@ObjectModel.text.element: [ 'RegionName' ]
@Consumption.valueHelpDefinition: [
{ entity : {name: 'I_RegionVH', element: 'Region' },
additionalBinding : [ { localElement : 'Country', element : 'Country' } ]
}]
_BankAddress.Region,
@ObjectModel.text.element: ['LanguageName']
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_Language', element: 'Language' } }]
_BankAddress.CorrespondenceLanguage,
@UI.hidden: true
_BankAddress._CorrespondenceLanguage._Text[1:Language = $session.system_language].LanguageName as LanguageName, //: localized,
_BankAddress.DistrictName,
_BankAddress.VillageName,
_BankAddress.CompanyPostalCode,
_BankAddress.StreetAddrNonDeliverableReason,
_BankAddress.StreetPrefixName1,
_BankAddress.StreetPrefixName2,
_BankAddress.StreetSuffixName1,
_BankAddress.StreetSuffixName2,
_BankAddress.Building,
_BankAddress.Floor,
_BankAddress.RoomNumber,
_BankAddress.FormOfAddress,
_BankAddress.TaxJurisdiction,
_BankAddress.TransportZone,
_BankAddress.AddressSearchTerm1,
_BankAddress.AddressSearchTerm2,
_BankAddress.POBox,
_BankAddress.POBoxAddrNonDeliverableReason,
_BankAddress.POBoxIsWithoutNumber,
_BankAddress.POBoxPostalCode,
_BankAddress.POBoxLobbyName,
_BankAddress.POBoxDeviatingCityName,
_BankAddress.POBoxDeviatingRegion,
_BankAddress.POBoxDeviatingCountry,
_BankAddress.CareOfName,
_BankAddress.DeliveryServiceTypeCode,
_BankAddress.DeliveryServiceNumber,
_BankAddress.AddressTimeZone,
_BankAddress.SecondaryRegionName,
_BankAddress.TertiaryRegionName,
@Consumption.valueHelpDefinition: [{ entity : {name: 'I_ActiveAddressRepresentation', element: 'AddressRepresentationCode' } }]//C_BankAddressRepCodeVH
@ObjectModel.text.element: ['AddressCodeDesc']
_BankAddress.AddressRepresentationCode, //is always empty
@UI.hidden: true
@Semantics.text: true
_BankAddress._AddressRepresentationCode._Text[1:Language = $session.system_language].AddressRepresentationDesc as AddressCodeDesc,
_BankAddress.AddressID,
// Telephone
@Consumption.valueHelpDefinition: [{ entity: {name: 'I_BusPartTelCountryPrefix',element: 'Country' },
additionalBinding: [
{element: 'TelephoneCountryPrefix',localElement:'TelephoneCountryPrefix',usage: #RESULT}
]
}]
@ObjectModel.text.element: ['TelephoneCountryName']
_BankAddress.PhoneNumberCountry,
@UI.hidden: true
@Semantics.text: true
_TelCountryPrefix._CountryText[1:Language = $session.system_language].CountryName as TelephoneCountryName,
_BankAddress.PhoneNumber,
_BankAddress.PhoneExtensionNumber,
_BankAddress.InternationalPhoneNumber, //Complete Number: Dialing Code+Number+Extension
_BankAddress._TelCountryPrefix.TelephoneCountryPrefix,
// Mobile Phone
_BankAddress.MobilePhoneCountry,
_BankAddress.MobilePhoneNumber,
_BankAddress.InternationalMobilePhoneNumber,
// Fax
_BankAddress.FaxNumberCountry,
_BankAddress.FaxAreaCodeSubscriberNumber,
_BankAddress.FaxExtensionNumber,
_BankAddress.InternationalFaxNumber,
// E-mail
_BankAddress.EmailAddress,
@UI.hidden: true
@Semantics.text: true
_BankAddress._Country._Text[1:Language = $session.system_language].CountryShortName as BankCountryName,
_BankAddress._Region._RegionText[1:Language = $session.system_language].RegionName as RegionName ,//INS DK01
_TelCountryPrefix,
/* Associations */
_BankAddress._Bank
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSREPRESENTATION",
"I_ADDRESSREPRESENTATIONTEXT",
"I_BUSPARTTELCOUNTRYPREFIX",
"I_COUNTRY",
"I_COUNTRYTEXT",
"I_LANGUAGE",
"I_LANGUAGETEXT",
"I_REGION",
"I_REGIONTEXT",
"R_BANKADDRESSTP"
],
"ASSOCIATED":
[
"I_BUSPARTTELCOUNTRYPREFIX",
"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