I_CustomerDepartmentTP

DDL: I_CUSTOMERDEPARTMENTTP SQL: IBPDEPARTMENTTP Type: view TRANSACTIONAL

Transactional Processing view for Customer Department

I_CustomerDepartmentTP is a Transactional CDS View that provides data about "Transactional Processing view for Customer Department" in SAP S/4HANA. It reads from 1 data source (I_CustomerDepartment) and exposes 14 fields with key fields Customer, CustomerDepartment, BusinessPartner. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerDepartment BPCustomerDepartment from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.businesspartner = _BusinessPartner.BusinessPartner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBPDEPARTMENTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Transactional Processing view for Customer Department view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence BUPA_WRF4_D view
ObjectModel.writeEnabled true 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 (14)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustomerDepartment Customer
KEY CustomerDepartment I_CustomerDepartment CustomerDepartment
KEY BusinessPartner
CustomerForEdit I_CustomerDepartment Customer
CustomerDepartmentForEdit I_CustomerDepartment CustomerDepartment
BusinessPartnerForEdit
BusinessPartnerUUID
ReceivingPoint I_CustomerDepartment ReceivingPoint
RetailLocationSellingAreaSize I_CustomerDepartment RetailLocationSellingAreaSize
RetailLocationSellingAreaUnit I_CustomerDepartment RetailLocationSellingAreaUnit
DepartmentLayout I_CustomerDepartment DepartmentLayout
DepartmentLayoutAreaSchema I_CustomerDepartment DepartmentLayoutAreaSchema
_Customer _Customer
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IBPDEPARTMENTTP'
@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey:true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Transactional Processing view for Customer Department'
@VDM.viewType: #TRANSACTIONAL

@ObjectModel.writeDraftPersistence: 'BUPA_WRF4_D'
@ObjectModel.writeEnabled: true

@ObjectModel.semanticKey: ['BusinessPartner', 'Customer', 'CustomerDepartment']
@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_CustomerDepartmentTP 
    as select from I_CustomerDepartment as BPCustomerDepartment   
    
    association [1..1] to I_BusinessPartnerTP       as _BusinessPartner     on  $projection.businesspartner = _BusinessPartner.BusinessPartner

{
    key BPCustomerDepartment.Customer,
    key BPCustomerDepartment.CustomerDepartment,
    key BPCustomerDepartment._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
    
    BPCustomerDepartment.Customer                                                                       as CustomerForEdit,
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8
    @Search.ranking: #HIGH
    @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
    BPCustomerDepartment.CustomerDepartment                                                             as CustomerDepartmentForEdit,
    
    BPCustomerDepartment._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner          as BusinessPartnerForEdit,
    BPCustomerDepartment._Customer._CustomerToBusinessPartner.BusinessPartnerUUID,
    
    BPCustomerDepartment.ReceivingPoint,

    BPCustomerDepartment.RetailLocationSellingAreaSize,
    BPCustomerDepartment.RetailLocationSellingAreaUnit,
    BPCustomerDepartment.DepartmentLayout,
    BPCustomerDepartment.DepartmentLayoutAreaSchema,
    
    _Customer,
    
    @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
    _BusinessPartner
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERDEPARTMENT",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP",
"I_CUSTOMER"
],
"BASE":
[
"I_CUSTOMERDEPARTMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More