I_CUSTOMERDEPARTMENTTP

CDS View

Transactional Processing view for Customer Department

I_CUSTOMERDEPARTMENTTP is a CDS View in S/4HANA. Transactional Processing view for Customer Department. It contains 12 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 12 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CustomerDepartment view from CONSUMPTION Consumption view for Customer Department

Fields (12)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY Customer Customer 1
KEY CustomerDepartment CustomerDepartment 1
BusinessPartnerForEdit BusinessPartnerForEdit 1
BusinessPartnerUUID BusinessPartnerUUID 1
CustomerDepartmentForEdit CustomerDepartmentForEdit 1
CustomerForEdit CustomerForEdit 1
DepartmentLayout DepartmentLayout 1
DepartmentLayoutAreaSchema DepartmentLayoutAreaSchema 1
ReceivingPoint ReceivingPoint 1
RetailLocationSellingAreaSize RetailLocationSellingAreaSize 1
RetailLocationSellingAreaUnit RetailLocationSellingAreaUnit 1 
@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