P_ACMCounterparty

DDL: P_ACMCOUNTERPARTY Type: view_entity BASIC

ACM Counterparty Value help

P_ACMCounterparty is a Basic CDS View that provides data about "ACM Counterparty Value help" in SAP S/4HANA. It reads from 2 data sources (kna1, lfa1) and exposes 14 fields with key field Counterparty.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
kna1 kna1 from
lfa1 lfa1 union

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label ACM Counterparty 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 (14)

KeyFieldSource TableSource FieldDescription
KEY Counterparty
CustomerName
ACMCounterpartyFirstName name1
ACMCounterpartyLastName name2
stras stras
ort01 ort01
regio regio
CustomerName
ACMCounterpartyFirstName name1
ACMCounterpartyLastName name2
stras stras
ort01 ort01
regio regio
pstlz pstlz 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'ACM Counterparty Value help'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC
@VDM.private: true
define view entity P_ACMCounterparty
  as select from kna1
{

      @ObjectModel.text.element: ['CustomerName']
  key cast(kna1.kunnr as kunnr preserving type)                                                                        as Counterparty,
      @Semantics.text:true
      cast(substring(rtrim(replace(concat(name1, concat(' &@', name2)), '&@', ''),' '),1,80) as md_customer_name)      as CustomerName,

      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_customer_full_name) , ' ' ) as CounterpartyFullName, //KF: different with S4


      name1                                                                                                            as ACMCounterpartyFirstName, //+Free Text Search

      name2                                                                                                            as ACMCounterpartyLastName, //+Free Text Search

      stras,
      ort01,
      regio,
      pstlz

}
where
  loevm is initial and cvp_xblck is initial

union

select from lfa1
{

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

      cast(substring(rtrim(replace(concat(name1, concat(' &@', name2)), '&@', ''),' '),1,80) as md_supplier_name)       as CustomerName,
      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 CounterpartyFullName,
      name1                                                                                                             as ACMCounterpartyFirstName, //+Free Text Search

      name2                                                                                                             as ACMCounterpartyLastName, //+Free Text Search

      stras,
      ort01,
      regio,
      pstlz


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

Learn More