C_ESJICustomerQuery

DDL: C_ESJICUSTOMERQUERY SQL: CESJICUSTQUERY Type: view CONSUMPTION Package: ESJI_SD_JAM_INTEG_CDS_CONT

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. Part of development package ESJI_SD_JAM_INTEG_CDS_CONT.

1 data source(s) 21 fields

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
CustomerName CustomerName
Industry Industry
PhoneNumber
Location _StandardAddress AdditionalStreetSuffixName
HouseNumber _StandardAddress HouseNumber
StreetName _StandardAddress StreetName
CityName _StandardAddress CityName
PostalCode _StandardAddress PostalCode
EmailAddress
Region _StandardAddress Region
RegionName
Country _StandardAddress Country
CountryName
AuthorizationGroup AuthorizationGroup
_ContactPerson _ContactPerson
_SalesOrganization _SalesOrganization
_SalesOrder _SalesOrder
_SalesQuotation _SalesQuotation
_OutboundDelivery _OutboundDelivery 
@AbapCatalog.sqlViewName: 'CESJICUSTQUERY'
@EndUserText.label: 'Customer'
@VDM.viewType: #CONSUMPTION 
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view C_ESJICustomerQuery
with parameters
    P_Language : sylangu 
as select from I_Customer
association [0..*] to C_ESJIContactPersonQuery    as _ContactPerson                on $projection.Customer        = _ContactPerson.Customer
association [0..*] to C_ESJISalesAreaQuery        as _SalesOrganization            on $projection.Customer        = _SalesOrganization.Customer
association [0..*] to C_ESJISalesOrderQuery       as _SalesOrder                   on $projection.Customer        = _SalesOrder.SoldToParty
association [0..*] to C_ESJIQuotationQuery        as _SalesQuotation               on $projection.Customer        = _SalesQuotation.SoldToParty
association [0..*] to C_ESJIOutboundDeliveryQuery as _OutboundDelivery             on $projection.Customer        = _OutboundDelivery.SoldToParty
{
    'KNA1_ESJI' as ObjectType,
    Customer,
    CustomerName,
    Industry,
    _StandardAddress._DefaultPhoneNumber.PhoneNumber,
    _StandardAddress.AdditionalStreetSuffixName as Location,

    _StandardAddress.HouseNumber,

    _StandardAddress.StreetName,

    _StandardAddress.CityName,

    _StandardAddress.PostalCode,
    _StandardAddress._DefaultEmailAddress.EmailAddress,
    _StandardAddress.Region,
    _StandardAddress._Region._RegionText[1: Language=$parameters.P_Language].RegionName,
    _StandardAddress.Country,
    _StandardAddress._Country._Text[1: Language=$parameters.P_Language].CountryName,
    AuthorizationGroup,
    _ContactPerson,
    _SalesOrganization,
    _SalesOrder,
    _SalesQuotation,
    _OutboundDelivery

}

Learn More