I_SLSORGANIZATIONDISTRCHNL
Distribution Channel for Sales Org
I_SLSORGANIZATIONDISTRCHNL is a CDS View in S/4HANA. Distribution Channel for Sales Org. It contains 4 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_Dischannelvaluehelp | view | from | CONSUMPTION | Distribution Channel by Sales Org. |
| C_PrepaymentDistrChnlVH | view | from | CONSUMPTION | Sales Org specific Distribution Channel |
| C_SalesOrganizationDistrChnlVH | view_entity | from | CONSUMPTION | Distribution Channel for Sales Organization |
| C_SubscrpnMassProcgDistrChnlVH | view_entity | from | CONSUMPTION | Distribution Channel |
| I_ACMDistChannelValueHelp | view_entity | from | BASIC | Distribution channel values |
| I_ACMDistributionChnlValueHelp | view | from | BASIC | List Of Distribution Channel |
| I_CmmdtyDistributionChannelVH | view | from | BASIC | Distribution Channel Data |
| I_Slsorgdistrchnltemp | view | from | COMPOSITE | Distibution channel VH |
Fields (4)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DistributionChannel | DistributionChannel | 3 |
| KEY | SalesOrganization | SalesOrganization | 3 |
| _DistributionChannel | _DistributionChannel | 2 | |
| _SalesOrganization | _SalesOrganization | 2 |
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Distribution Channel for Sales Org'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ISDSLSLSORGDISCH'
@Search.searchable: true
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataExtraction.enabled: true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE,
#CDS_MODELING_ASSOCIATION_TARGET,
#SEARCHABLE_ENTITY,
#EXTRACTION_DATA_SOURCE ]
define view I_SlsOrganizationDistrChnl
as select from tvkov
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
{
@ObjectModel.foreignKey.association: '_SalesOrganization'
@Search.defaultSearchElement: true
@Search.ranking: #HIGH
key vkorg as SalesOrganization,
@ObjectModel.foreignKey.association: '_DistributionChannel'
@Search.defaultSearchElement: true
@Search.ranking: #HIGH
key vtweg as DistributionChannel,
vtwku as ReferenceDistributionChannel,
vlgfi as ReferenceStore,
//Associations
_SalesOrganization,
_DistributionChannel
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVKOV"
],
"ASSOCIATED":
[
"I_DISTRIBUTIONCHANNEL",
"I_SALESORGANIZATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/