P_ACMSupplier

DDL: P_ACMSUPPLIER Type: view_entity BASIC

ACM Supplier Value help

P_ACMSupplier is a Basic CDS View that provides data about "ACM Supplier Value help" in SAP S/4HANA. It reads from 1 data source (lfa1) and exposes 8 fields with key field Supplier.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
lfa1 lfa1 from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ACM Supplier Value help view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Supplier
SupplierName
OrganizationBPName1 name1
OrganizationBPName2 name2
stras stras
ort01 ort01
regio regio
pstlz pstlz 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'ACM Supplier Value help'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC
@VDM.private: true
define view entity P_ACMSupplier
  as select from lfa1
{

  key cast(lfa1.lifnr as lifnr preserving type)                                                                         as Supplier,
      //      @Semantics.text: true

      cast(substring(rtrim(replace(concat(name1, concat(' &@', name2)), '&@', ''),' '),1,80) as md_supplier_name)       as SupplierName,
      ltrim(cast(concat( concat(concat( concat(concat_with_space( anred, name1, 1 ), '/' ),stras ), '/'),
                   concat_with_space(concat_with_space(ort01,regio, 1 ), pstlz,1 ) )  as md_supplier_full_name) , ' ' ) as SupplierFullName,
      name1                                                                                                             as OrganizationBPName1, //+Free Text Search

      name2                                                                                                             as OrganizationBPName2, //+Free Text Search

      stras,
      ort01,
      regio,
      pstlz


}
where
  loevm is initial and cvp_xblck is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"LFA1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More