I_ACMCustomerCounterparty

DDL: I_ACMCUSTOMERCOUNTERPARTY SQL: IACMCUSTCPTY Type: view BASIC

Interface for Customer counter party

I_ACMCustomerCounterparty is a Basic CDS View that provides data about "Interface for Customer counter party" in SAP S/4HANA. It reads from 1 data source (kna1) and exposes 10 fields with key field Counterparty.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
kna1 kna1 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMCUSTCPTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Interface for Customer counter party view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Counterparty
CustomerName
Side
Country land1
ACMCounterpartyLastName name1
AdditionalName name2
ACMCounterpartyCity ort01
PostalCode pstlz
Region regio
IsBusinessPurposeCompleted cvp_xblck 
@AbapCatalog.sqlViewName: 'IACMCUSTCPTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
//@VDM.private: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Interface for Customer counter party'
define view I_ACMCustomerCounterparty 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

      
      cast( 'V' as wlf_pr_side)                                                                                   as Side,
      land1                                                                                                       as Country,
     // name1                                                                                                       as Name1,

      name1 as ACMCounterpartyLastName,
     // name2                                                                                                       as Name2,

      name2 as AdditionalName,
     // ort01                                                                                                       as City,

      ort01 as ACMCounterpartyCity,
      pstlz                                                                                                       as PostalCode,
      regio                                                                                                       as Region,
      cvp_xblck                                                                                                   as IsBusinessPurposeCompleted
}
where
  loevm is initial and
  cvp_xblck is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNA1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More