I_ACMCUSTOMERCOUNTERPARTY

CDS View

Interface for Customer counter party

I_ACMCUSTOMERCOUNTERPARTY is a CDS View in S/4HANA. Interface for Customer counter party. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CounterPartyWithSide view from COMPOSITE 
@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