C_ESJISalesAreaQuery

DDL: C_ESJISALESAREAQUERY SQL: CESJISLSAREAQ Type: view CONSUMPTION

Customer Sales Area

C_ESJISalesAreaQuery is a Consumption CDS View that provides data about "Customer Sales Area" in SAP S/4HANA. It reads from 1 data source (I_CustomerSalesArea) and exposes 11 fields.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerSalesArea I_CustomerSalesArea from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (7)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
Customer Customer
SalesGroup I_CustomerSalesArea SalesGroup
SalesGroupName
SalesOffice I_CustomerSalesArea SalesOffice
SalesOfficeName
SalesOrganization I_CustomerSalesArea SalesOrganization
SalesOrganizationName
DistributionChannel I_CustomerSalesArea DistributionChannel
DistributionChannelName
Division I_CustomerSalesArea Division
DivisionName 
@AbapCatalog.sqlViewName: 'CESJISLSAREAQ'
@VDM.viewType: #CONSUMPTION 
@EndUserText.label: 'Customer Sales Area'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view C_ESJISalesAreaQuery 
with parameters
    P_Language : sylangu
as select from I_CustomerSalesArea {
        Customer,
        I_CustomerSalesArea.SalesGroup,
        I_CustomerSalesArea._SalesGroup._Text[1: Language = $parameters.P_Language].SalesGroupName,
        I_CustomerSalesArea.SalesOffice,
        I_CustomerSalesArea._SalesOffice._Text[1: Language = $parameters.P_Language].SalesOfficeName,
        I_CustomerSalesArea.SalesOrganization,
        I_CustomerSalesArea._SalesOrganization._Text[1: Language = $parameters.P_Language].SalesOrganizationName,
        I_CustomerSalesArea.DistributionChannel,
        I_CustomerSalesArea._DistributionChannel._Text[1: Language = $parameters.P_Language].DistributionChannelName,
        I_CustomerSalesArea.Division,
        I_CustomerSalesArea._Division._Text[1: Language = $parameters.P_Language].DivisionName
}           
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERSALESAREA",
"I_DISTRIBUTIONCHANNEL",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISION",
"I_DIVISIONTEXT",
"I_SALESGROUP",
"I_SALESGROUPTEXT",
"I_SALESOFFICE",
"I_SALESOFFICETEXT",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More