P_AUDIT_AT_KNA1

DDL: P_AUDIT_AT_KNA1 SQL: PAUDITATKNA1 Type: view BASIC

P_AUDIT_AT_KNA1 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (kna1) and exposes 30 fields with key fields bukrs, kunnr.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
kna1 kna1 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PAUDITATKNA1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MASTER view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY bukrs knb1 bukrs
KEY kunnr kna1 kunnr
land1 kna1 land1
name1 kna1 name1
name2 kna1 name2
ort01 kna1 ort01
pstlz kna1 pstlz
sortl kna1 sortl
stras kna1 stras
adrnr kna1 adrnr
mcod1 kna1 mcod1
mcod2 kna1 mcod2
mcod3 kna1 mcod3
konzs kna1 konzs
lifnr kna1 lifnr
stkzu kna1 stkzu
stceg kna1 stceg
txjcd kna1 txjcd
ktokd kna1 ktokd
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.sqlViewName: 'PAUDITATKNA1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MASTER

define view P_AUDIT_AT_KNA1
  as select from kna1
    join         knb1 on knb1.kunnr = kna1.kunnr
{
  key knb1.bukrs,
  key kna1.kunnr,
      kna1.land1,
      kna1.name1,
      kna1.name2,
      kna1.ort01,
      kna1.pstlz,
      kna1.sortl,
      kna1.stras,
      kna1.adrnr,
      kna1.mcod1,
      kna1.mcod2,
      kna1.mcod3,
      kna1.konzs,
      kna1.lifnr,
      kna1.stkzu,
      kna1.stceg,
      kna1.txjcd,
      kna1.ktokd, //Customer Account Group for dcl

     //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.xdcset as DataControllerSet,                                                                                                                                                                      
      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr1 as DataController1,                                                                                                                                                                      
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr2 as DataController2,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr3 as DataController3,
     //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr4 as DataController4,
     //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr5 as DataController5,                                                                                                                                                                       
      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr6 as DataController6,                                                                                                                                                                        
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr7 as DataController7,                                                                                                                                                                      
     //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr8 as DataController8,
     //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr9 as DataController9,                                                                                                                                   
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
     kna1.data_ctrlr10 as DataController10
}

Learn More