m_v_eop_vendor

DDL: M_V_EOP_VENDOR SQL: CDS_M_EOP_VENDOR Type: view

EOP Check CDS View: Vendor Master

m_v_eop_vendor is a CDS View that provides data about "EOP Check CDS View: Vendor Master" in SAP S/4HANA. It reads from 2 data sources (lfa1, lfb1) and exposes 19 fields with key fields lifnr, bukrs. It has 1 association to related views.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
lfa1 lfa1 from
lfb1 lfb1 inner

Parameters (2)

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

Associations (1)

CardinalityTargetAliasCondition
[1..1] lfa1 _lfa1 lfa1.lifnr = _lfa1.lifnr

Annotations (10)

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

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY lifnr lfa1 lifnr
KEY bukrs lfb1 bukrs
kunnr lfa1 kunnr
ktokk lfa1 ktokk
werks lfa1 werks
cvp_xblck lfa1 cvp_xblck
xcpdk lfa1 xcpdk
_lfa1 _lfa1
DataController1 lfa1 data_ctrlr1
DataController2 lfa1 data_ctrlr2
DataController3 lfa1 data_ctrlr3
DataController4 lfa1 data_ctrlr4
DataController5 lfa1 data_ctrlr5
DataController6 lfa1 data_ctrlr6
DataController7 lfa1 data_ctrlr7
DataController8 lfa1 data_ctrlr8
DataController9 lfa1 data_ctrlr9
DataController10 lfa1 data_ctrlr10
DataControllerSet lfa1 xdcset 
@EndUserText.label: 'EOP Check CDS View: Vendor Master'
@ClientHandling.type:#CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CDS_M_EOP_VENDOR'
@OData.publish: false
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #L

define view m_v_eop_vendor
  with parameters
    p_lifnr : abap.char( 10 ),
    p_bukrs : abap.char( 4 )
  as select from lfa1 as lfa1
    inner join   lfb1 as lfb1 on lfb1.lifnr = lfa1.lifnr

  association [1..1] to lfa1 as _lfa1 on lfa1.lifnr = _lfa1.lifnr

{
  key lfa1.lifnr     as lifnr,
  key lfb1.bukrs     as bukrs,
      lfa1.kunnr     as kunnr,
      lfa1.ktokk     as ktokk,
      lfa1.werks     as werks,
      lfa1.cvp_xblck as cvp_xblck,
      lfa1.xcpdk     as xcpdk,
      _lfa1,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr1 as DataController1,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr2 as DataController2,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr3 as DataController3,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr4 as DataController4,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr5 as DataController5,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr6 as DataController6,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr7 as DataController7,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr8 as DataController8,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr9 as DataController9,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.data_ctrlr10 as DataController10,
      @Consumption.hidden: true
      @UI.hidden: true
      lfa1.xdcset as DataControllerSet
      
}
where
      lfa1.lifnr = $parameters.p_lifnr
  and lfb1.bukrs = $parameters.p_bukrs;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"LFA1",
"LFB1"
],
"ASSOCIATED":
[
"LFA1"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More