C_MM_IncotermValueHelp

DDL: C_MM_INCOTERMVALUEHELP SQL: CMMINCOTERM_VH Type: view CONSUMPTION

Incoterm Value Help

C_MM_IncotermValueHelp is a Consumption CDS View that provides data about "Incoterm Value Help" in SAP S/4HANA. It reads from 2 data sources (tincvmap, I_IncotermsClassification) and exposes 5 fields with key fields IncotermsClassification, IncotermsVersion. It has 1 association to related views. It is exposed through 1 OData service (UI_SALESQUOTATIONMANAGE).

2 data source(s) Exposed by 1 service(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
tincvmap _tincvmap left_outer
I_IncotermsClassification IncotermsClassification from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_IncotermsVersion _IncotermsVersion _IncotermsVersion.IncotermsVersion = $projection.IncotermsVersion

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMMINCOTERM_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.semanticKey IncotermsClassification view
ObjectModel.representativeKey IncotermsClassification view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Incoterm Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY IncotermsClassification IncotermsClassification
KEY IncotermsVersion tincvmap incov
IncotermsClassificationName
LocationIsMandatory LocationIsMandatory
_IncotermsVersion _IncotermsVersion 
@AbapCatalog.sqlViewName: 'CMMINCOTERM_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: 'IncotermsClassification'
@ObjectModel.representativeKey: 'IncotermsClassification'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Incoterm Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_MM_IncotermValueHelp
  as select from    I_IncotermsClassification as IncotermsClassification

    left outer join tincvmap                  as _tincvmap on IncotermsClassification = _tincvmap.inco1 //LEFT OUTER Join as also Incoterms w/o record in TINCVMAP shall be returned


  association [0..1] to I_IncotermsVersion as _IncotermsVersion on _IncotermsVersion.IncotermsVersion = $projection.IncotermsVersion

{

      @ObjectModel.text.element:  [ 'IncotermsClassificationName' ]
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1.0 }
  key IncotermsClassification,
      @ObjectModel.foreignKey.association: '_IncotermsVersion'
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1.0 }
  key _tincvmap.incov                                                           as IncotermsVersion,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      _Text[1: Language = $session.system_language].IncotermsClassificationName as IncotermsClassificationName,

      LocationIsMandatory,
      
      @Consumption.filter.hidden: true
      _IncotermsVersion

}

Learn More