I_CndnContrProcVarSlsAssgmt

DDL: I_CNDNCONTRPROCVARSLSASSGMT Type: view BASIC

Process Variant Sales Area Assgmt

I_CndnContrProcVarSlsAssgmt is a Basic CDS View (Dimension) that provides data about "Process Variant Sales Area Assgmt" in SAP S/4HANA. It reads from 1 data source (wcb_c_proc_var_v) and exposes 8 fields with key fields CndnContrProcVar, SalesOrganization, DistributionChannel, Division. It has 4 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
wcb_c_proc_var_v wcb_c_proc_var_v from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_CndnContrProcVar _CndnContrProcVar $projection.CndnContrProcVar = _CndnContrProcVar.CndnContrProcVar
[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

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName IWCBPROCVARSDASG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 001 view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey CndnContrProcVar view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
EndUserText.label Process Variant Sales Area Assgmt view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CndnContrProcVar process_variant
KEY SalesOrganization vkorg
KEY DistributionChannel vtweg
KEY Division spart
_CndnContrProcVar _CndnContrProcVar
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division 
@AbapCatalog: {
  sqlViewName: 'IWCBPROCVARSDASG',
  compiler.compareFilter: true,
  buffering: {
    status: #ACTIVE,
    type: #GENERIC,
    numberOfKeyFields: 001
  },
  preserveKey: true
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
   representativeKey: 'CndnContrProcVar',
   modelingPattern: #ANALYTICAL_DIMENSION,
   supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE],
   usageType: {
     dataClass:      #CUSTOMIZING,
     serviceQuality: #B,
     sizeCategory:   #S
   }
}
@ClientHandling: {
     type: #INHERITED,
     algorithm: #SESSION_VARIABLE
}
@Analytics: {
    dataCategory: #DIMENSION,
    dataExtraction.enabled: false,
    internalName: #LOCAL
}
@EndUserText.label: 'Process Variant Sales Area Assgmt'
@Metadata.ignorePropagatedAnnotations: true
define view I_CndnContrProcVarSlsAssgmt
  as select from wcb_c_proc_var_v
  association [0..1] to I_CndnContrProcVar    as _CndnContrProcVar    on $projection.CndnContrProcVar = _CndnContrProcVar.CndnContrProcVar
  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
{
  key process_variant       as CndnContrProcVar,
      @ObjectModel.foreignKey.association: '_SalesOrganization'
  key vkorg                 as SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
  key vtweg                 as DistributionChannel,
      @ObjectModel.foreignKey.association: '_Division'
  key spart                 as Division,

      //Associations

      _CndnContrProcVar,
      _SalesOrganization,
      _DistributionChannel,
      _Division
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WCB_C_PROC_VAR_V"
],
"ASSOCIATED":
[
"I_CNDNCONTRPROCVAR",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESORGANIZATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More