P_CompanyCodeAddress

DDL: P_COMPANYCODEADDRESS SQL: PCOMADDRE Type: view COMPOSITE Package: GLO_FIN_IS_CF_MY

Get Company Code Address

P_CompanyCodeAddress is a Composite CDS View that provides data about "Get Company Code Address" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 15 fields with key field CompanyCode. Part of development package GLO_FIN_IS_CF_MY.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCOMADDRE view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
CompanyCodeName I_CompanyCode CompanyCodeName
BusinessPartnerName1
BusinessPartnerName2
BusinessPartnerName3
HouseNumber
StreetPrefixName
StreetName
CityName
HomeCityName
Region
Country
PostalCode
VATRegistration I_CompanyCode VATRegistration
PostalCode111asCompanyCodeAddress 
@AbapCatalog.sqlViewName: 'PCOMADDRE'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_CompanyCodeAddress
  as select from I_CompanyCode
{

  key I_CompanyCode.CompanyCode,
      I_CompanyCode.CompanyCodeName,
      I_CompanyCode._Address.BusinessPartnerName1,
      I_CompanyCode._Address.BusinessPartnerName2,
      I_CompanyCode._Address.BusinessPartnerName3,
      I_CompanyCode._Address.HouseNumber,
      I_CompanyCode._Address.StreetPrefixName,
      I_CompanyCode._Address.StreetName,
      I_CompanyCode._Address.CityName,
      I_CompanyCode._Address.HomeCityName,
      I_CompanyCode._Address.Region,
      I_CompanyCode._Address.Country,
      I_CompanyCode._Address.PostalCode,
      I_CompanyCode.VATRegistration,


       replace(concat_with_space(I_CompanyCode._Address.HouseNumber,concat_with_space(concat_with_space(I_CompanyCode._Address.StreetName, I_CompanyCode._Address.CityName, 1),
             concat_with_space(I_CompanyCode._Address.Country,I_CompanyCode._Address.PostalCode, 1), 1),1) ,',',' ') as CompanyCodeAddress

}

Learn More