I_SalesArea

DDL: I_SALESAREA SQL: ISDSALESAREA Type: view BASIC
16 Fields 1 Data Sources 6 Associations

Sales Area

I_SalesArea (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales Area · Sales

I_SalesArea is a Basic CDS View that provides data about "Sales Area" in SAP S/4HANA. It reads from 1 data source (tvta) and exposes 16 fields with key fields SalesOrganization, DistributionChannel, Division. It has 6 associations to related views.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentSD-CRF-ORG
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul><li><p>What are the available sales areas?</p></li> <li><p>What is the reference distribution channel for customer master and product master?</p></li> <li><p>What is the reference division for customer master?</p></li> <li><p>What is the reference sales organization, reference distribution channel, or reference division for the sales document type?</p></li> <li><p>What is the system reaction specified for a sales area in case of inventory shortage?</p></li> <li><p>What is the credit control area of a sales area?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tvta tvta from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization
[0..1] I_DistributionChannel _DistributionChannel $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..1] I_Division _Division $projection.Division = _Division.Division
[0..1] I_DistributionChannel _ReferenceDistributionChannel $projection.ReferenceDistributionChannel = _ReferenceDistributionChannel.DistributionChannel
[0..1] I_CreditControlArea _CreditControlArea $projection.CreditControlArea = _CreditControlArea.CreditControlArea
[0..1] I_Division _ReferenceDivision $projection.ReferenceDivision = _ReferenceDivision.Division

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Sales Area view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDSALESAREA view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.sapObjectNodeType.name SalesArea view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization vkorg Sales Organization
KEY DistributionChannel vtweg Distribution Channel
KEY Division spart Source supplier
ReferenceDistributionChannel vtwku Reference distrib.channel for cust.and material masters
RefSlsOrgForSlsDocType vkoau Reference sales org.for sales doc.types (by sales area)
RefDistrChnlForSlsDocType vtwau Distribution channel for sales doc types
RefDivisionForSlsDocType spaau Reference division for document types (by sales area)
ATPResultModeControl revfp Rule for transferring the results of the availability check
CreditControlArea kkber Credit Control Area
ReferenceDivision spaku Reference division for customers
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_ReferenceDistributionChannel _ReferenceDistributionChannel
_CreditControlArea _CreditControlArea
_ReferenceDivision _ReferenceDivision

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 I_SalesArea.
-- 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: ISDSALESAREA

CREATE VIEW I_SalesArea AS
SELECT
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  vtwku AS ReferenceDistributionChannel,
  vkoau AS RefSlsOrgForSlsDocType,
  vtwau AS RefDistrChnlForSlsDocType,
  spaau AS RefDivisionForSlsDocType,
  revfp AS ATPResultModeControl,
  kkber AS CreditControlArea,
  spaku AS ReferenceDivision
FROM tvta
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _ReferenceDistributionChannel ON ReferenceDistributionChannel = _ReferenceDistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_Division AS _ReferenceDivision ON ReferenceDivision = _ReferenceDivision.Division  -- association [0..1]
;

Learn More