A_BankScriptedAddress_3
Scripted Addresses
A_BankScriptedAddress_3 is a Consumption CDS View that provides data about "Scripted Addresses" in SAP S/4HANA. It reads from 1 data source (R_BankScriptedAddressTP) and exposes 42 fields with key fields BankCountry, BankInternalID, AddressRepresentationCode.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_BankScriptedAddressTP | R_BankScriptedAddressTP | projection |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Scripted Addresses | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| VDM.viewType | #CONSUMPTION | view | |
| OData.entityType.name | Bank_Type | view |
Fields (42)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BankCountry | BankCountry | ||
| KEY | BankInternalID | BankInternalID | ||
| KEY | AddressRepresentationCode | AddressRepresentationCode | ||
| LongBankName | LongBankName | |||
| LongBankBranch | LongBankBranch | |||
| StreetName | StreetName | |||
| HouseNumber | HouseNumber | |||
| HouseNumberSupplementText | HouseNumberSupplementText | |||
| CityName | CityName | |||
| PostalCode | PostalCode | |||
| Country | Country | |||
| Region | Region | |||
| CorrespondenceLanguage | CorrespondenceLanguage | |||
| 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 | |||
| 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 | |||
| _BankredirectedtoA_Bank_3 |
@EndUserText.label: 'Scripted Addresses'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #MASTER}
@VDM: {
viewType: #CONSUMPTION
}
@OData.entityType.name: 'Bank_Type'
define view entity A_BankScriptedAddress_3
as projection on R_BankScriptedAddressTP as BankScriptedAddress
{
key BankCountry,
key BankInternalID,
key AddressRepresentationCode, //adrc-nation <> ''
LongBankName, //char80 ... must be exposed. Contains scripted value for A_Bank_3.LongBankName
LongBankBranch, //char80
StreetName,
HouseNumber,
HouseNumberSupplementText,
CityName,
PostalCode,
Country,
Region,
CorrespondenceLanguage,
DistrictName,
VillageName,
CompanyPostalCode,
StreetAddrNonDeliverableReason,
StreetPrefixName1,
StreetPrefixName2,
StreetSuffixName1,
StreetSuffixName2,
Building,
Floor,
RoomNumber,
FormOfAddress,
TaxJurisdiction,
TransportZone,
POBox,
POBoxAddrNonDeliverableReason,
POBoxIsWithoutNumber,
POBoxPostalCode,
POBoxLobbyName,
POBoxDeviatingCityName,
POBoxDeviatingRegion,
POBoxDeviatingCountry,
CareOfName,
DeliveryServiceTypeCode,
DeliveryServiceNumber,
AddressTimeZone,
SecondaryRegionName,
TertiaryRegionName,
// Associations
BankScriptedAddress._BankAddress : redirected to parent A_BankAddress_3,
BankScriptedAddress._Bank : redirected to A_Bank_3
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_BANKSCRIPTEDADDRESSTP"
],
"ASSOCIATED":
[
"A_BANKADDRESS_3",
"A_BANK_3",
"R_BANKADDRESSTP",
"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