P_I_Customer_F2187

DDL: P_I_CUSTOMER_F2187 SQL: PICUSTOMERF2187 Type: view CONSUMPTION
10 Fields 1 Data Sources 2 Associations 1 Fiori Apps

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.

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 Sold-to Party
BusinessPartnerUUID
BusinessPartner
BusinessPartnerCategory
CustomerName CustomerName Name of Customer
AuthorizationGroup AuthorizationGroup AuthorizGroup
CustomerAccountGroup CustomerAccountGroup Account group
CustomerClassification CustomerClassification Customer Class.
_CustomerContact _CustomerContact
_CustomerClassification _CustomerClassification

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_I_Customer_F2187.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PICUSTOMERF2187

CREATE VIEW P_I_Customer_F2187 AS
SELECT
  Customer,
  _Customer._CustomerToBusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  CustomerName,
  AuthorizationGroup,
  CustomerAccountGroup,
  CustomerClassification
FROM I_Customer AS _Customer
LEFT OUTER JOIN C_Customer360_Contactop AS _CustomerContact ON businesspartneruuid = _CustomerContact.PartnerUUID  -- association [0..*]
LEFT OUTER JOIN I_CustomerClassificationText AS _CustomerClassification ON CustomerClassification = _CustomerClassification.CustomerClassification  -- association [0..*]
;

Learn More