P_TH_ADDRESS2

DDL: P_TH_ADDRESS2 SQL: PTHIAVADDRESS2 Type: view COMPOSITE Package: GLO_FIN_IS_VAT_TH

Address for TH VAT Report

P_TH_ADDRESS2 is a Composite CDS View that provides data about "Address for TH VAT Report" in SAP S/4HANA. It reads from 1 data source (I_Address_2) and exposes 25 fields with key fields AddressID, AddressPersonID, AddressRepresentationCode. Part of development package GLO_FIN_IS_VAT_TH.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_Address_2 Address from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PTHIAVADDRESS2 view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_Address_2 AddressID
KEY AddressPersonID I_Address_2 AddressPersonID
KEY AddressRepresentationCode I_Address_2 AddressRepresentationCode
AddressObjectType I_Address_2 AddressObjectType
OrganizationName1 OrganizationName1
OrganizationName2 OrganizationName2
OrganizationName3 OrganizationName3
OrganizationName4 OrganizationName4
OrganizationName411asTaxPayerName
District DistrictName
HomeCityName VillageName
PostalCode PostalCode
Street Street
StreetName StreetName
StreetPrefixName StreetPrefixName1
AdditionalStreetPrefixName StreetPrefixName2
StreetSuffixName StreetSuffixName1
HouseNumber HouseNumber
Building Building
Floor Floor
RoomNumber RoomNumber
Country Country
Region Region
RegionNameendasCityName
AddressCreatedByUser I_Address_2 AddressCreatedByUser 
@AbapCatalog.sqlViewName: 'PTHIAVADDRESS2'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
define view P_TH_ADDRESS2
  as select from I_Address_2 as Address
{
  key Address.AddressID,
  key Address.AddressPersonID,
  key Address.AddressRepresentationCode,
      Address.AddressObjectType,

      OrganizationName1,

      OrganizationName2,

      OrganizationName3,

      OrganizationName4,

      concat_with_space(concat_with_space(Address.OrganizationName1,Address.OrganizationName2, 1),
      concat_with_space(Address.OrganizationName3,Address.OrganizationName4, 1), 1)

                        as TaxPayerName,

      DistrictName      as District,

      VillageName       as HomeCityName,

      PostalCode,

      Street,

      StreetName,

      StreetPrefixName1 as StreetPrefixName,

      StreetPrefixName2 as AdditionalStreetPrefixName,


      StreetSuffixName1 as StreetSuffixName,



      HouseNumber,

      Building,

      Floor,

      RoomNumber,

      Country,

      Region,

      case
        when Address.CityName is not initial
        then Address.CityName
        when Address.CityName is initial and Address.AddressRepresentationCode = 'T'
        then Address._Region._RegionText[1:Language = '2'].RegionName
        else Address._Region._RegionText[1:Language = 'E'].RegionName
      end

                        as CityName,


      @Semantics.user.createdBy: true
      Address.AddressCreatedByUser,
      case when  Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber!= '' then  Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber
           when Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber!= '' then  Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber
           else '' end  as PhoneNumber
}

Learn More