P_ARCustomerSalesArea

DDL: P_ARCUSTOMERSALESAREA SQL: PARCUSTOMERSA Type: view CONSUMPTION

AR Customer Sales Area

P_ARCustomerSalesArea is a Consumption CDS View that provides data about "AR Customer Sales Area" in SAP S/4HANA. It reads from 1 data source (I_CustomerSalesArea) and exposes 9 fields with key fields Customer, SalesOrganization, DistributionChannel, Division.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerSalesArea I_CustomerSalesArea from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PARCUSTOMERSA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label AR Customer Sales Area view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
CompanyCode _SalesOrganization CompanyCode
_Customer _Customer
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division 
@AbapCatalog.sqlViewName: 'PARCUSTOMERSA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'AR Customer Sales Area'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_ARCustomerSalesArea as 

select from I_CustomerSalesArea {
  key Customer,
  key SalesOrganization,
  key DistributionChannel,
  key Division,
  
      _SalesOrganization.CompanyCode,
      
      _Customer,
      _SalesOrganization,
      _DistributionChannel,
      _Division
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERSALESAREA",
"I_SALESORGANIZATION"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESORGANIZATION"
],
"BASE":
[
"I_CUSTOMERSALESAREA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More