m_v_eop_customer

DDL: M_V_EOP_CUSTOMER SQL: CDS_M_EOP_CUST Type: view

EOP Check CDS View: Customer Master

m_v_eop_customer is a CDS View that provides data about "EOP Check CDS View: Customer Master" in SAP S/4HANA. It reads from 2 data sources (kna1, knb1) and exposes 18 fields with key field kunnr. It has 1 association to related views.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
kna1 kna1 from
knb1 knb1 inner

Parameters (2)

NameTypeDefault
p_kunnr abap.char( 10 )
p_bukrs abap.char( 4 )

Associations (1)

CardinalityTargetAliasCondition
[1..1] kna1 _kna1 kna1.kunnr = _kna1.kunnr

Annotations (10)

NameValueLevelField
EndUserText.label EOP Check CDS View: Customer Master view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CDS_M_EOP_CUST view
OData.publish false view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY kunnr kna1 kunnr
lifnr kna1 lifnr
bukrs knb1 bukrs
ktokd kna1 ktokd
cvp_xblock_b kna1 cvp_xblck
xcpdk kna1 xcpdk
_kna1 _kna1
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
DataControllerSet kna1 xdcset 
@EndUserText.label: 'EOP Check CDS View: Customer Master'
@ClientHandling.type:#CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CDS_M_EOP_CUST'
@OData.publish: false
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #L

define view m_v_eop_customer
  with parameters
    p_kunnr : abap.char( 10 ),
    p_bukrs : abap.char( 4 )
  as select from kna1 as kna1
    inner join   knb1 as knb1 on knb1.kunnr = kna1.kunnr

  association [1..1] to kna1 as _kna1 on kna1.kunnr = _kna1.kunnr

{
  key kna1.kunnr        as kunnr,
      kna1.lifnr        as lifnr,
      knb1.bukrs        as bukrs,
      kna1.ktokd        as ktokd,
      kna1.cvp_xblck    as cvp_xblock_b,
      kna1.xcpdk        as xcpdk,
      _kna1,
      
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr1  as DataController1,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr2  as DataController2,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr3  as DataController3,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr4  as DataController4,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr5  as DataController5,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr6  as DataController6,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr7  as DataController7,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr8  as DataController8,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr9  as DataController9,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.data_ctrlr10 as DataController10,
      @Consumption.hidden: true
      @UI.hidden: true
      kna1.xdcset       as DataControllerSet
}
where
      kna1.kunnr = $parameters.p_kunnr
  and knb1.bukrs = $parameters.p_bukrs;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNA1",
"KNB1"
],
"ASSOCIATED":
[
"KNA1"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More