I_BPCustDeptAddrDepdntInfoTP
TP view for CustDep AddrDepInfo
I_BPCustDeptAddrDepdntInfoTP is a Transactional CDS View that provides data about "TP view for CustDep AddrDepInfo" in SAP S/4HANA. It reads from 1 data source (I_CustDepartmentAddrDepdntInfo) and exposes 16 fields with key fields Customer, AddressID, BusinessPartner, CustomerDepartment. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CustDepartmentAddrDepdntInfo | BPCustDeptAddrDepdntInfoTP | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_BusinessPartnerTP | _BusinessPartner | $projection.businesspartner = _BusinessPartner.BusinessPartner |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICUSDEPADDEPTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.writeDraftPersistence | IBPADDRDEP_D | view | |
| ObjectModel.writeEnabled | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | TP view for CustDep AddrDepInfo | view | |
| ObjectModel.draftEnabled | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| Search.searchable | true | view |
Fields (16)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Customer | Customer | ||
| KEY | AddressID | AddressID | ||
| KEY | BusinessPartner | |||
| KEY | CustomerDepartment | CustomerDepartment | ||
| AddressIDForEdit | AddressID | |||
| CustomerForEdit | Customer | |||
| CustomerDepartmentForEdit | CustomerDepartment | |||
| ReceivingPoint | ReceivingPoint | |||
| RetailLocationSellingAreaSize | RetailLocationSellingAreaSize | |||
| RetailLocationSellingAreaUnit | RetailLocationSellingAreaUnit | |||
| DepartmentLayout | DepartmentLayout | |||
| DepartmentLayoutAreaSchema | DepartmentLayoutAreaSchema | |||
| BusinessPartnerForEdit | ||||
| FormattedAddress | ||||
| _Customer | _Customer | |||
| _BusinessPartner | _BusinessPartner |
@AbapCatalog.sqlViewName: 'ICUSDEPADDEPTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeDraftPersistence: 'IBPADDRDEP_D'
@ObjectModel.writeEnabled: true
@ObjectModel.semanticKey: ['Customer', 'AddressID', 'BusinessPartner', 'CustomerDepartment']
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP view for CustDep AddrDepInfo'
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
define view I_BPCustDeptAddrDepdntInfoTP
as select from I_CustDepartmentAddrDepdntInfo as BPCustDeptAddrDepdntInfoTP
association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.businesspartner = _BusinessPartner.BusinessPartner
{
key Customer,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #HIGH
key AddressID,
key _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
key CustomerDepartment,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
AddressID as AddressIDForEdit,
Customer as CustomerForEdit,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
CustomerDepartment as CustomerDepartmentForEdit,
ReceivingPoint,
RetailLocationSellingAreaSize,
RetailLocationSellingAreaUnit,
DepartmentLayout,
DepartmentLayoutAreaSchema,
_Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartnerForEdit,
cast( ' ' as abap.sstring( 260 ) ) as FormattedAddress,
/* Associations */
// _Address,
_Customer,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
_BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTDEPARTMENTADDRDEPDNTINFO",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP",
"I_CUSTOMER"
],
"BASE":
[
"I_CUSTDEPARTMENTADDRDEPDNTINFO"
],
"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