P_ACMApplicationCounterparty

DDL: P_ACMAPPLICATIONCOUNTERPARTY Type: view_entity BASIC

Counterparty in ACM Maintain Application

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

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
kna1 kna1 from
lfa1 lfa1 union

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Counterparty in ACM Maintain Application 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 (10)

KeyFieldSource TableSource FieldDescription
KEY Counterparty
CustomerName
ACMCounterpartyFirstName name1
ACMCounterpartyLastName name2
IsBusinessPurposeCompleted cvp_xblck
CustomerName
ACMCounterpartyFirstName name1
ACMCounterpartyLastName name2
IsBusinessPurposeCompleted cvp_xblck
ACMDocumentSide 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Counterparty in ACM Maintain Application'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC
@VDM.private: true
define view entity P_ACMApplicationCounterparty
  as select from kna1
{

      @ObjectModel.text.element: ['CustomerName']
  key cast(kna1.kunnr as kunnr preserving type)                                                                        as Counterparty,
      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

      cvp_xblck                                                                                                        as IsBusinessPurposeCompleted,
      cast( 'V' as /accgo/e_contract_side )                                                                            as ACMDocumentSide
}
where
  loevm is initial

union

select from lfa1
{

  key cast(lfa1.lifnr as lifnr preserving type)                                                                         as Counterparty,

      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

      cvp_xblck                                                                                                         as IsBusinessPurposeCompleted,
      cast( 'M' as /accgo/e_contract_side )                                                                             as ACMDocumentSide
}
where
  loevm is initial

Learn More