I_CndnContrExtSlsCommsnStdVH

DDL: I_CNDNCONTREXTSLSCOMMSNSTDVH Type: view_entity COMPOSITE

External Sales Commissions

I_CndnContrExtSlsCommsnStdVH is a Composite CDS View that provides data about "External Sales Commissions" in SAP S/4HANA. It reads from 2 data sources (I_ConditionContract, I_CndnContrType) and exposes 21 fields with key field ConditionContract.

Data Sources (2)

SourceAliasJoin Type
I_ConditionContract Contract from
I_CndnContrType ContractType inner

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label External Sales Commissions view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ConditionContract view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract I_ConditionContract ConditionContract
CndnContrType I_ConditionContract CndnContrType
CndnContrTypeDesc
Customer I_ConditionContract Customer
PriorSupplier I_ConditionContract PriorSupplier
Supplier I_ConditionContract Supplier
DistributionChannel I_ConditionContract DistributionChannel
Division I_ConditionContract Division
PurchasingGroup I_ConditionContract PurchasingGroup
PurchasingOrganization I_ConditionContract PurchasingOrganization
SalesOrganization I_ConditionContract SalesOrganization
ExternalDocumentReferenceID I_ConditionContract ExternalDocumentReferenceID
CndnContrValidFrom I_ConditionContract CndnContrValidFrom
CndnContrValidTo I_ConditionContract CndnContrValidTo
PersonWorkAgreement I_ConditionContract PersonWorkAgreement
CompanyCode I_ConditionContract CompanyCode
CndnContrWorkerCostCenter I_ConditionContract CndnContrWorkerCostCenter
_Customer I_ConditionContract _Customer
_PriorSupplier I_ConditionContract _PriorSupplier
_Supplier I_ConditionContract _Supplier
_PersonWorkAgreement I_ConditionContract _PersonWorkAgreement
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@EndUserText.label: 'External Sales Commissions'
@ObjectModel: {
   dataCategory: #VALUE_HELP,
   representativeKey: 'ConditionContract',
   modelingPattern:       #VALUE_HELP_PROVIDER,
   supportedCapabilities: [#VALUE_HELP_PROVIDER, #SEARCHABLE_ENTITY ],
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #XXL
   }
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Metadata: {
  allowExtensions: false,
  ignorePropagatedAnnotations: true
}
@Search.searchable: true
@Consumption.ranked: true

define view entity I_CndnContrExtSlsCommsnStdVH
  as select from I_ConditionContract as Contract
    inner join   I_CndnContrType     as ContractType on Contract.CndnContrType = ContractType.CndnContrType
{
      // Facets for Searchable Fields

      @UI.facet: [{ purpose: #FILTER, type: #FIELDGROUP_REFERENCE, targetQualifier: 'FILTER_BASIC',    label: 'Contract Information'  },
                  { purpose: #FILTER, type: #FIELDGROUP_REFERENCE, targetQualifier: 'FILTER_VALIDITY', label: 'Contract Validity' }]

      @UI: {
            lineItem:   [{ position: 10, importance:#HIGH }],
            fieldGroup: [{ qualifier:'FILTER_BASIC', position: 10}]
      }
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 1.0
      @Search.ranking: #HIGH
  key Contract.ConditionContract,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.9
      @Search.ranking: #LOW
      @UI: {
            lineItem:   [{ position: 20, importance:#HIGH }],
            fieldGroup: [{ qualifier:'FILTER_BASIC', position: 20}],
            textArrangement: #TEXT_FIRST
      }
      @ObjectModel.text.element:  [ 'CndnContrTypeDesc' ]
      Contract.CndnContrType,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.9
      @Search.ranking: #LOW
      @Semantics.text:true
      @Consumption.filter.hidden: true
      Contract._CndnContrType._Text[1: Language = $session.system_language ].CndnContrTypeDesc,

      @Consumption.hidden: true
      Contract.Customer,
      @Consumption.hidden: true
      Contract.PriorSupplier,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @UI: { lineItem: [{ position: 30, importance:#HIGH }] }
      Contract.Supplier,

      @Consumption.hidden: true
      Contract.DistributionChannel,
      @Consumption.hidden: true
      Contract.Division,
      @Consumption.hidden: true
      Contract.PurchasingGroup,
      @Consumption.hidden: true
      Contract.PurchasingOrganization,
      @Consumption.hidden: true
      Contract.SalesOrganization,

      @UI: {
           lineItem:    [{ position: 40, importance:#HIGH }],
           fieldGroup:  [{ qualifier:'FILTER_BASIC', position: 30}]
      }
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      @Search.ranking: #LOW
      Contract.ExternalDocumentReferenceID,
      @UI: {
            lineItem:   [{ position: 50, importance:#HIGH }],
            fieldGroup: [{ qualifier:'FILTER_VALIDITY', position: 10}]
      }
      @Semantics.businessDate.from: true
      Contract.CndnContrValidFrom,
      @UI: {
            lineItem:   [{ position: 60, importance:#HIGH }],
            fieldGroup: [{ qualifier:'FILTER_VALIDITY', position: 20}]
      }
      @Semantics.businessDate.to: true
      Contract.CndnContrValidTo,

      /* Worker related fields */
      @Consumption.hidden: true
      Contract.PersonWorkAgreement,
      @Consumption.hidden: true
      Contract.CompanyCode,
      @Consumption.hidden: true
      Contract.CndnContrWorkerCostCenter,

      @Consumption.hidden: true
      Contract._Customer,
      @Consumption.hidden: true
      Contract._PriorSupplier,
      @Consumption.hidden: true
      Contract._Supplier,
      @Consumption.hidden: true
      Contract._PersonWorkAgreement
}
where
      ContractType.CndnContrPartnerCat                              = 'V'
  and ContractType.CndnContrSettlmtType                             = '1'
  and ContractType._CndnContrClassfctnType.CndnContrProcessCategory = '3'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNDNCONTRCLASSFCTNTYPE",
"I_CNDNCONTRTYPE",
"I_CNDNCONTRTYPETEXT",
"I_CONDITIONCONTRACT"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_PERSONWORKAGREEMENT_1",
"I_SUPPLIER"
],
"BASE":
[
"I_CONDITIONCONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/