C_ESJICustomerQuery

DDL: C_ESJICUSTOMERQUERY SQL: CESJICUSTQUERY Type: view CONSUMPTION
21 Fields 1 Data Sources 5 Associations

Customer

C_ESJICustomerQuery is a Consumption CDS View that provides data about "Customer" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 21 fields. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Customer I_Customer from

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (5)

CardinalityTargetAliasCondition
[0..*] C_ESJIContactPersonQuery _ContactPerson $projection.Customer = _ContactPerson.Customer
[0..*] C_ESJISalesAreaQuery _SalesOrganization $projection.Customer = _SalesOrganization.Customer
[0..*] C_ESJISalesOrderQuery _SalesOrder $projection.Customer = _SalesOrder.SoldToParty
[0..*] C_ESJIQuotationQuery _SalesQuotation $projection.Customer = _SalesQuotation.SoldToParty
[0..*] C_ESJIOutboundDeliveryQuery _OutboundDelivery $projection.Customer = _OutboundDelivery.SoldToParty

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CESJICUSTQUERY view
EndUserText.label Customer view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (21)

KeyFieldSource TableSource FieldDescription
ObjectType
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
Industry Industry Industry Sector
PhoneNumber
Location _StandardAddress AdditionalStreetSuffixName Street 5
HouseNumber _StandardAddress HouseNumber House Number
StreetName _StandardAddress StreetName Text
CityName _StandardAddress CityName Name
PostalCode _StandardAddress PostalCode Postal Code
EmailAddress
Region _StandardAddress Region Venue Region
RegionName
Country _StandardAddress Country Venue: Ctry/Reg
CountryName
AuthorizationGroup AuthorizationGroup AuthorizGroup
_ContactPerson _ContactPerson
_SalesOrganization _SalesOrganization
_SalesOrder _SalesOrder
_SalesQuotation _SalesQuotation
_OutboundDelivery _OutboundDelivery

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 C_ESJICustomerQuery.
-- 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: CESJICUSTQUERY
-- Parameters: P_Language : sylangu

CREATE VIEW C_ESJICustomerQuery AS
SELECT
  'KNA1_ESJI' AS ObjectType,
  Customer,
  CustomerName,
  Industry,
  _StandardAddress._DefaultPhoneNumber.PhoneNumber AS PhoneNumber,
  _StandardAddress.AdditionalStreetSuffixName AS Location,
  _StandardAddress.HouseNumber AS HouseNumber,
  _StandardAddress.StreetName AS StreetName,
  _StandardAddress.CityName AS CityName,
  _StandardAddress.PostalCode AS PostalCode,
  _StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _StandardAddress.Region AS Region,
  _StandardAddress._Region._RegionText[1: Language=$parameters.P_Language].RegionName AS RegionName,
  _StandardAddress.Country AS Country,
  _StandardAddress._Country._Text[1: Language=$parameters.P_Language].CountryName AS CountryName,
  AuthorizationGroup
FROM I_Customer
LEFT OUTER JOIN C_ESJIContactPersonQuery AS _ContactPerson ON Customer = _ContactPerson.Customer  -- association [0..*]
LEFT OUTER JOIN C_ESJISalesAreaQuery AS _SalesOrganization ON Customer = _SalesOrganization.Customer  -- association [0..*]
LEFT OUTER JOIN C_ESJISalesOrderQuery AS _SalesOrder ON Customer = _SalesOrder.SoldToParty  -- association [0..*]
LEFT OUTER JOIN C_ESJIQuotationQuery AS _SalesQuotation ON Customer = _SalesQuotation.SoldToParty  -- association [0..*]
LEFT OUTER JOIN C_ESJIOutboundDeliveryQuery AS _OutboundDelivery ON Customer = _OutboundDelivery.SoldToParty  -- association [0..*]
;

Learn More