C_Q2CCustomerQuickView
Customer
C_Q2CCustomerQuickView is a Consumption CDS View that provides data about "Customer" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 23 fields with key field Customer.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Customer | customer | from |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Customer | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| UI.headerInfo.imageUrl | BusinessPartnerImageURL | view | |
| UI.headerInfo.title.type | #STANDARD | view | |
| UI.headerInfo.title.value | CustomerName | view | |
| UI.headerInfo.description.type | #STANDARD | view | |
| UI.headerInfo.description.value | Customer | view | |
| ObjectModel.representativeKey | Customer | view |
Fields (23)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Customer | I_Customer | Customer | Customer |
| AddressID | I_Customer | AddressID | ||
| CustomerName | I_Customer | CustomerName | Name | |
| sstring500asBusinessPartnerImageURL | ||||
| PostalCode | ||||
| CityName | ||||
| Country | ||||
| OrganizationBPName1 | I_Customer | OrganizationBPName1 | ||
| OrganizationBPName2 | I_Customer | OrganizationBPName2 | ||
| CustomerAccountGroup | I_Customer | CustomerAccountGroup | ||
| AuthorizationGroup | I_Customer | AuthorizationGroup | ||
| IsBusinessPurposeCompleted | I_Customer | IsBusinessPurposeCompleted | ||
| DataControllerSet | I_Customer | DataControllerSet | ||
| DataController1 | I_Customer | DataController1 | ||
| DataController2 | I_Customer | DataController2 | ||
| DataController3 | I_Customer | DataController3 | ||
| DataController4 | I_Customer | DataController4 | ||
| DataController5 | I_Customer | DataController5 | ||
| DataController6 | I_Customer | DataController6 | ||
| DataController7 | I_Customer | DataController7 | ||
| DataController8 | I_Customer | DataController8 | ||
| DataController9 | I_Customer | DataController9 | ||
| DataController10 | I_Customer | DataController10 |
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Customer'
@VDM: {
viewType: #CONSUMPTION
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:
{ usageType: {
serviceQuality: #C,
sizeCategory: #XL,
dataClass: #MASTER } }
@UI.headerInfo:{
imageUrl: 'BusinessPartnerImageURL',
title: {
type: #STANDARD,
value: 'CustomerName'
},
description: {
type: #STANDARD,
value: 'Customer'
}
}
@ObjectModel.representativeKey: 'Customer'
define view entity C_Q2CCustomerQuickView
as select from I_Customer as customer
{
@UI.facet: [ {
purpose: #QUICK_VIEW,
type: #FIELDGROUP_REFERENCE,
targetQualifier: 'CustomerQuickView',
label: 'Standard Address'
}
]
@EndUserText.label : 'Customer'
@ObjectModel.text.element: [ 'CustomerName' ]
key customer.Customer,
@Consumption.hidden: true
customer.AddressID,
@EndUserText.label : 'Name'
@Semantics.text:true
@Semantics.name.fullName: true
customer.CustomerName,
@UI.hidden: true
@Semantics.imageUrl: true
cast (
case
when _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory = '1'
then 'sap-icon://customer'
else 'sap-icon://building'
end as abap.sstring( 500 ) ) as BusinessPartnerImageURL,
@UI: {
fieldGroup: [{ qualifier:'CustomerQuickView', position: 10}]}
@Semantics.address.zipCode:true
customer._AddressDefaultRepresentation.PostalCode,
@UI: {
fieldGroup: [{ qualifier:'CustomerQuickView', position: 20}]}
@Semantics.address.city:true
customer._AddressDefaultRepresentation.CityName,
@UI: {
fieldGroup: [{ qualifier:'CustomerQuickView', position: 30}]}
@Semantics.address.country:true
customer._AddressDefaultRepresentation.Country,
@UI.hidden: true
customer.OrganizationBPName1,
@UI.hidden: true
customer.OrganizationBPName2,
// DCL relevant fields
@Consumption.hidden: true
customer.CustomerAccountGroup,
@Consumption.hidden: true
customer.AuthorizationGroup,
@Consumption.hidden: true
@Semantics.booleanIndicator: true
customer.IsBusinessPurposeCompleted,
//Added for DPP Data Controller
@Consumption.hidden:true
customer.DataControllerSet,
@Consumption.hidden:true
customer.DataController1,
@Consumption.hidden:true
customer.DataController2,
@Consumption.hidden:true
customer.DataController3,
@Consumption.hidden:true
customer.DataController4,
@Consumption.hidden:true
customer.DataController5,
@Consumption.hidden:true
customer.DataController6,
@Consumption.hidden:true
customer.DataController7,
@Consumption.hidden:true
customer.DataController8,
@Consumption.hidden:true
customer.DataController9,
@Consumption.hidden:true
customer.DataController10
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_ORGANIZATIONADDRESS"
],
"ASSOCIATED":
[],
"BASE":
[],
"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