SAP CDS VIEW

@AbapCatalog.sqlViewName: 'ZCH_DDL_LIFNR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: '供应商主数据'
define view ZCH_LIFNR_VIEW as select from lfa1 inner join lfb1 on lfa1.lifnr = lfb1.lifnr {
    lfb1.bukrs,
    lfa1.lifnr,
    lfa1.name1 as ZLIFNR
}
where lfa1.mandt = $session.client