SHSM_FAR_DBUKA

DDL: SHSM_FAR_DBUKA SQL: SHSMFARDBUKA Type: view

Value-Help for Company Code with regard to customer

SHSM_FAR_DBUKA is a CDS View that provides data about "Value-Help for Company Code with regard to customer" in SAP S/4HANA. It reads from 3 data sources (kna1, knb1, t001) and exposes 8 fields with key fields kunnr, bukrs.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
kna1 kna1 inner
knb1 knb1 from
t001 t001 inner

Annotations (11)

NameValueLevelField
EndUserText.label Value-Help for Company Code with regard to customer view
AbapCatalog.sqlViewName SHSMFARDBUKA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY kunnr knb1 kunnr
KEY bukrs knb1 bukrs
butxt t001 butxt
ort01 t001 ort01
waers t001 waers
begru knb1 begru
kna1_begru kna1 begru
ktokd kna1 ktokd 
@EndUserText.label: 'Value-Help for Company Code with regard to customer'
@AbapCatalog.sqlViewName: 'SHSMFARDBUKA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
define view SHSM_FAR_DBUKA as select from knb1
    inner join t001
      on knb1.bukrs = t001.bukrs
    inner join kna1
      on knb1.kunnr = kna1.kunnr
{
    key knb1.kunnr,
    key knb1.bukrs,
        t001.butxt,
        t001.ort01,
        t001.waers,

     @Consumption.hidden: true
       knb1.begru as begru,
     @Consumption.hidden: true
       kna1.begru as kna1_begru,
     @Consumption.hidden: true
       kna1.ktokd as ktokd

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNA1",
"KNB1",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More