I_SalesArea

DDL: I_SALESAREA SQL: ISDSALESAREA Type: view BASIC

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)

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 (15)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/