I_CUSTOMERDEPARTMENT
Customer Master Department Data
I_CUSTOMERDEPARTMENT is a CDS View in S/4HANA. Customer Master Department Data. It contains 7 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CustomerDepartmentTP | view | from | TRANSACTIONAL | Transactional Processing view for Customer Department |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Customer | Customer,CustomerForEdit | 1 |
| KEY | CustomerDepartment | CustomerDepartment,CustomerDepartmentForEdit | 1 |
| DepartmentLayout | DepartmentLayout | 1 | |
| DepartmentLayoutAreaSchema | DepartmentLayoutAreaSchema | 1 | |
| ReceivingPoint | ReceivingPoint | 1 | |
| RetailLocationSellingAreaSize | RetailLocationSellingAreaSize | 1 | |
| RetailLocationSellingAreaUnit | RetailLocationSellingAreaUnit | 1 |
@AbapCatalog.sqlViewName: 'ICUSTDEPARTMENT'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Customer Master Department Data'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
//@AccessControl.personalData.blockingIndicator: 'IsBusinessPurposeCompleted'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'CustomerDepartment'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC
//@Analytics.dataCategory: #DIMENSION
define view I_CustomerDepartment as select from wrf4
association [1..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
{
@ObjectModel.foreignKey.association: '_Customer'
key wrf4.locnr as Customer,
key wrf4.abtnr as CustomerDepartment,
wrf4.empst as ReceivingPoint,
@Semantics.quantity.unitOfMeasure: 'RetailLocationSellingAreaUnit'
wrf4.verfl as RetailLocationSellingAreaSize,
wrf4.verfe as RetailLocationSellingAreaUnit,
wrf4.layvr as DepartmentLayout,
wrf4.flvar as DepartmentLayoutAreaSchema,
//added for DCL
@UI.hidden: true
@Consumption.filter.hidden: true
@Semantics.booleanIndicator:true
_Customer.IsBusinessPurposeCompleted,
_Customer
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"WRF4"
],
"ASSOCIATED":
[
"I_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/