I_SalesArea
Sales Area
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.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| tvta | tvta | from |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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 (15)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 |
Fields (16)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesOrganization | vkorg | ||
| KEY | DistributionChannel | vtweg | ||
| KEY | Division | spart | ||
| ReferenceDistributionChannel | vtwku | |||
| RefSlsOrgForSlsDocType | vkoau | |||
| RefDistrChnlForSlsDocType | vtwau | |||
| RefDivisionForSlsDocType | spaau | |||
| ATPResultModeControl | revfp | |||
| CreditControlArea | kkber | |||
| ReferenceDivision | spaku | |||
| _SalesOrganization | _SalesOrganization | |||
| _DistributionChannel | _DistributionChannel | |||
| _Division | _Division | |||
| _ReferenceDistributionChannel | _ReferenceDistributionChannel | |||
| _CreditControlArea | _CreditControlArea | |||
| _ReferenceDivision | _ReferenceDivision |
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Sales Area'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ISDSALESAREA'
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataExtraction: {
enabled: true,
delta.changeDataCapture.automatic: true
}
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE,
#CDS_MODELING_ASSOCIATION_TARGET,
#EXTRACTION_DATA_SOURCE ]
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view I_SalesArea
as select from tvta
association [0..1] to I_SalesOrganization as _SalesOrganization on $projection.SalesOrganization = _SalesOrganization.SalesOrganization
association [0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
association [0..1] to I_Division as _Division on $projection.Division = _Division.Division
association [0..1] to I_DistributionChannel as _ReferenceDistributionChannel on $projection.ReferenceDistributionChannel = _ReferenceDistributionChannel.DistributionChannel
association [0..1] to I_CreditControlArea as _CreditControlArea on $projection.CreditControlArea = _CreditControlArea.CreditControlArea
association [0..1] to I_Division as _ReferenceDivision on $projection.ReferenceDivision = _ReferenceDivision.Division
{
@ObjectModel.foreignKey.association: '_SalesOrganization'
key vkorg as SalesOrganization,
@ObjectModel.foreignKey.association: '_DistributionChannel'
key vtweg as DistributionChannel,
@ObjectModel.foreignKey.association: '_Division'
key spart as Division,
@ObjectModel.foreignKey.association: '_ReferenceDistributionChannel'
vtwku as ReferenceDistributionChannel,
vkoau as RefSlsOrgForSlsDocType,
vtwau as RefDistrChnlForSlsDocType,
spaau as RefDivisionForSlsDocType,
revfp as ATPResultModeControl,
@ObjectModel.foreignKey.association: '_CreditControlArea'
kkber as CreditControlArea,
@ObjectModel.foreignKey.association: '_ReferenceDivision'
spaku as ReferenceDivision,
_SalesOrganization,
_DistributionChannel,
_Division,
_ReferenceDistributionChannel,
_CreditControlArea,
_ReferenceDivision
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVTA"
],
"ASSOCIATED":
[
"I_CREDITCONTROLAREA",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESORGANIZATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA