P_I_Customer_F2187

DDL: P_I_CUSTOMER_F2187 SQL: PICUSTOMERF2187 Type: view CONSUMPTION

P view to get properties for Cust360

P_I_Customer_F2187 is a Consumption CDS View that provides data about "P view to get properties for Cust360" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 10 fields with key field Customer. It has 2 associations to related views. It is used in 1 Fiori application: Customer - 360° View.

1 data source(s) Used in 1 Fiori app(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer _Customer from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_Customer360_Contactop _CustomerContact $projection.businesspartneruuid = _CustomerContact.PartnerUUID
[0..*] I_CustomerClassificationText _CustomerClassification $projection.CustomerClassification = _CustomerClassification.CustomerClassification

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PICUSTOMERF2187 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label P view to get properties for Cust360 view

Fiori Apps (1)

App IDApp NameTypeDescription
F2187 Customer - 360° View Fact sheet Overview of one specific customer by having a look at aggregated sales data

Customer - 360° View

Business Role: Internal Sales Representative

With this app you can get an overview of one specific customer by reviewing aggregated sales data from the past and the present.You can, for example, display the sales areas and their specific data as well as related sales documents, including sales scheduling agreements. To see more details, you can navigate to related apps.

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
BusinessPartnerUUID
BusinessPartner
BusinessPartnerCategory
CustomerName CustomerName
AuthorizationGroup AuthorizationGroup
CustomerAccountGroup CustomerAccountGroup
CustomerClassification CustomerClassification
_CustomerContact _CustomerContact
_CustomerClassification _CustomerClassification 
@AbapCatalog.sqlViewName: 'PICUSTOMERF2187'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M

@EndUserText.label: 'P view to get properties for Cust360'
define view P_I_Customer_F2187
  as select from I_Customer as _Customer

  association [0..*] to C_Customer360_Contactop          as _CustomerContact        on  $projection.businesspartneruuid = _CustomerContact.PartnerUUID

  association [0..*] to I_CustomerClassificationText as _CustomerClassification on  $projection.CustomerClassification = _CustomerClassification.CustomerClassification
{
  key Customer,
      _Customer._CustomerToBusinessPartner.BusinessPartnerUUID,
      
      _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
      
      _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory,
      
      CustomerName,
      AuthorizationGroup,
      CustomerAccountGroup,
      CustomerClassification,

      // Expose Associations

      _CustomerContact,
      _CustomerClassification
}

Learn More