P_PH_CompanyCodeAddress

DDL: P_PH_COMPANYCODEADDRESS SQL: PPHSLCOMADDRE Type: view COMPOSITE

P_PH_CompanyCodeAddress is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 15 fields with key field CompanyCode.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPHSLCOMADDRE view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
CompanyCodeName I_CompanyCode CompanyCodeName
AddresseeName1
AddresseeName2
AddresseeName3
HouseNumber
StreetPrefixName1
StreetName
CityName
VillageName
Region
Country
PostalCode
VATRegistration I_CompanyCode VATRegistration
PostalCode111asCompanyCodeAddress 
@AbapCatalog.sqlViewName: 'PPHSLCOMADDRE'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations:true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_PH_CompanyCodeAddress
  as select from I_CompanyCode
{
  key I_CompanyCode.CompanyCode,
      I_CompanyCode.CompanyCodeName,
      I_CompanyCode._OrgAddressDefaultRprstn.AddresseeName1,
      I_CompanyCode._OrgAddressDefaultRprstn.AddresseeName2,
      I_CompanyCode._OrgAddressDefaultRprstn.AddresseeName3,
      I_CompanyCode._OrgAddressDefaultRprstn.HouseNumber,
      I_CompanyCode._OrgAddressDefaultRprstn.StreetPrefixName1,
      I_CompanyCode._OrgAddressDefaultRprstn.StreetName,
      I_CompanyCode._OrgAddressDefaultRprstn.CityName,
      I_CompanyCode._OrgAddressDefaultRprstn.VillageName,
      I_CompanyCode._OrgAddressDefaultRprstn.Region,
      I_CompanyCode._OrgAddressDefaultRprstn.Country,
      I_CompanyCode._OrgAddressDefaultRprstn.PostalCode,
      I_CompanyCode.VATRegistration,
         
        replace(replace(replace(replace(replace(concat_with_space(_OrgAddressDefaultRprstn.HouseNumber,concat_with_space(concat_with_space(concat_with_space(concat_with_space(concat_with_space(concat_with_space(_OrgAddressDefaultRprstn.StreetPrefixName1, _OrgAddressDefaultRprstn.StreetPrefixName2, 1), _OrgAddressDefaultRprstn.StreetName, 1), _OrgAddressDefaultRprstn.StreetSuffixName1, 1), _OrgAddressDefaultRprstn.StreetSuffixName2, 1),  _OrgAddressDefaultRprstn.CityName, 1),
             concat_with_space(_OrgAddressDefaultRprstn.Country, _OrgAddressDefaultRprstn.PostalCode, 1), 1),1) ,'|',''),',',''),'&',''),'''',''),'"','') as CompanyCodeAddress        
}

Learn More