J2G_SHSM_DEBI1

DDL: J2G_SHSM_DEBI1 SQL: J_2G_SHSMDEBI1 Type: view

J2G_SHSM_DEBI1 is a CDS View in SAP S/4HANA. It reads from 1 data source (kna1) and exposes 19 fields with key fields kunnr, mcod1, mcod3, pstlz, sortl.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
kna1 kna1 from

Annotations (10)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName J_2G_SHSMDEBI1 view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY kunnr
KEY mcod1
KEY mcod3
KEY pstlz
KEY sortl
KEY stcd2
CustomerAccountGroup kna1 ktokd
AuthorizationGroup kna1 begru
DataControllerSet kna1 xdcset
DataController1 kna1 data_ctrlr1
DataController2 kna1 data_ctrlr2
DataController3 kna1 data_ctrlr3
DataController4 kna1 data_ctrlr4
DataController5 kna1 data_ctrlr5
DataController6 kna1 data_ctrlr6
DataController7 kna1 data_ctrlr7
DataController8 kna1 data_ctrlr8
DataController9 kna1 data_ctrlr9
DataController10 kna1 data_ctrlr10 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'J_2G_SHSMDEBI1'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
define view J2G_SHSM_DEBI1
   //as select from j_2gdebi1

   as select from kna1
{
   key cast( kna1.kunnr as kunnr preserving type ) as kunnr,
   key cast( kna1.mcod1 as mcdd1 preserving type ) as mcod1,
   key cast( kna1.mcod3 as mcdd3 preserving type ) as mcod3,
   key cast( kna1.pstlz as pstlz preserving type ) as pstlz,
   key cast( kna1.sortl as sortl preserving type ) as sortl,
   key cast( kna1.stcd2 as j_2gafm preserving type ) as stcd2,
   
   @Consumption.hidden: true
   kna1.ktokd   as CustomerAccountGroup,
   @Consumption.hidden: true
   kna1.begru   as AuthorizationGroup,
        
   // Fields added For Data Controller in DCL .... NOT TO BE CONSUMED.

    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.xdcset          as DataControllerSet,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr1     as DataController1,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr2     as DataController2,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr3     as DataController3,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr4     as DataController4,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr5     as DataController5,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr6     as DataController6,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr7     as DataController7,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr8     as DataController8,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr9     as DataController9,
    @UI.hidden: true
    @Consumption.filter.hidden: true      
    kna1.data_ctrlr10    as DataController10
 
}

Learn More