C_CashBankScriptedAddress
Cash Bank Scripted Address
C_CashBankScriptedAddress is a Consumption CDS View that provides data about "Cash Bank Scripted Address" in SAP S/4HANA. It reads from 1 data source (R_BankScriptedAddressTP) and exposes 32 fields with key fields BankCountry, BankInternalID, AddressRepresentationCode. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_BankScriptedAddressTP | _BankScriptedAddress | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_Bank_2 | _BankDetail | $projection.BankCountry = _BankDetail.BankCountry and $projection.BankInternalID = _BankDetail.BankInternalID |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Cash Bank Scripted Address | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| Metadata.allowExtensions | true | view | |
| VDM.viewType | #CONSUMPTION | view |
Fields (32)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BankCountry | R_BankScriptedAddressTP | BankCountry | |
| KEY | BankInternalID | R_BankScriptedAddressTP | BankInternalID | |
| KEY | AddressRepresentationCode | R_BankScriptedAddressTP | AddressRepresentationCode | |
| AddressCodeDesc | ||||
| LongBankName | R_BankScriptedAddressTP | LongBankName | ||
| LongBankBranch | R_BankScriptedAddressTP | LongBankBranch | ||
| StreetName | R_BankScriptedAddressTP | StreetName | ||
| HouseNumber | R_BankScriptedAddressTP | HouseNumber | ||
| HouseNumberSupplementText | R_BankScriptedAddressTP | HouseNumberSupplementText | ||
| CityName | R_BankScriptedAddressTP | CityName | ||
| Building | R_BankScriptedAddressTP | Building | ||
| RoomNumber | R_BankScriptedAddressTP | RoomNumber | ||
| Floor | R_BankScriptedAddressTP | Floor | ||
| StreetPrefixName1 | R_BankScriptedAddressTP | StreetPrefixName1 | ||
| StreetPrefixName2 | R_BankScriptedAddressTP | StreetPrefixName2 | ||
| StreetSuffixName1 | R_BankScriptedAddressTP | StreetSuffixName1 | ||
| StreetSuffixName2 | R_BankScriptedAddressTP | StreetSuffixName2 | ||
| DistrictName | R_BankScriptedAddressTP | DistrictName | ||
| VillageName | R_BankScriptedAddressTP | VillageName | ||
| Country | R_BankScriptedAddressTP | Country | ||
| BankCountryName | ||||
| AddressSearchTerm1 | R_BankScriptedAddressTP | AddressSearchTerm1 | ||
| AddressSearchTerm2 | R_BankScriptedAddressTP | AddressSearchTerm2 | ||
| POBoxLobbyName | R_BankScriptedAddressTP | POBoxLobbyName | ||
| POBoxDeviatingCityName | R_BankScriptedAddressTP | POBoxDeviatingCityName | ||
| CareOfName | R_BankScriptedAddressTP | CareOfName | ||
| SecondaryRegionName | R_BankScriptedAddressTP | SecondaryRegionName | ||
| TertiaryRegionName | R_BankScriptedAddressTP | TertiaryRegionName | ||
| BankName | _BankDetail | BankName | ||
| CountryShortName | ||||
| AddressID | R_BankScriptedAddressTP | AddressID | ||
| _Bank | _Bank |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Cash Bank Scripted Address'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #MASTER //#MIXED
}
@Metadata.allowExtensions: true
@VDM.viewType: #CONSUMPTION
define view entity C_CashBankScriptedAddress as select from R_BankScriptedAddressTP as _BankScriptedAddress
association [1..1] to I_Bank_2 as _BankDetail on $projection.BankCountry = _BankDetail.BankCountry
and $projection.BankInternalID = _BankDetail.BankInternalID
{ @ObjectModel.text.element: [ 'CountryShortName' ]
key _BankScriptedAddress.BankCountry,
@ObjectModel.text.element: [ 'BankName' ]
key _BankScriptedAddress.BankInternalID,
@Consumption.valueHelpDefinition: [{ entity : {name: 'C_BankAddressRepresentationVH', element: 'AddressRepresentationCode' } }]//C_BankAddressRepCodeVH
@ObjectModel.text.element: ['AddressCodeDesc']
key _BankScriptedAddress.AddressRepresentationCode as AddressRepresentationCode, //is not initial
@UI.hidden: true
@Semantics.text: true
_BankScriptedAddress._AddressRepresentationCode._Text[1:Language = $session.system_language].AddressRepresentationDesc as AddressCodeDesc,
_BankScriptedAddress.LongBankName, //char80
_BankScriptedAddress.LongBankBranch, //char80
_BankScriptedAddress.StreetName,
_BankScriptedAddress.HouseNumber,
_BankScriptedAddress.HouseNumberSupplementText,
_BankScriptedAddress.CityName,
_BankScriptedAddress.Building,
_BankScriptedAddress.RoomNumber,
_BankScriptedAddress.Floor,
//----Address---- Fields ADRC where NATION <> ''
_BankScriptedAddress.StreetPrefixName1,
_BankScriptedAddress.StreetPrefixName2,
_BankScriptedAddress.StreetSuffixName1,
_BankScriptedAddress.StreetSuffixName2,
_BankScriptedAddress.DistrictName,
_BankScriptedAddress.VillageName,
@ObjectModel.text.element: [ 'BankCountryName' ]
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_CountryVH', element: 'Country' } }]
_BankScriptedAddress.Country,
@UI.hidden: true
@Semantics.text: true
_BankScriptedAddress._Country._Text[1:Language = $session.system_language].CountryShortName as BankCountryName,
_BankScriptedAddress.AddressSearchTerm1,
_BankScriptedAddress.AddressSearchTerm2,
_BankScriptedAddress.POBoxLobbyName,
_BankScriptedAddress.POBoxDeviatingCityName,
_BankScriptedAddress.CareOfName,
_BankScriptedAddress.SecondaryRegionName,
_BankScriptedAddress.TertiaryRegionName,
@UI.hidden: true
_BankDetail.BankName,
@UI.hidden: true
_BankDetail._Country._Text[1:Language = $session.system_language].CountryShortName as CountryShortName,
_BankScriptedAddress.AddressID, //adrc-ADDRNUMBER -> additional?,
_Bank
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSREPRESENTATION",
"I_ADDRESSREPRESENTATIONTEXT",
"I_BANK_2",
"I_COUNTRY",
"I_COUNTRYTEXT",
"R_BANKSCRIPTEDADDRESSTP"
],
"ASSOCIATED":
[
"R_BANKTP"
],
"BASE":
[
"R_BANKSCRIPTEDADDRESSTP"
],
"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