P_TH_SUPPLIER_ADDR_D

DDL: P_TH_SUPPLIER_ADDR_D Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_TH

Supplier's Default Address for TH VAT Report

P_TH_SUPPLIER_ADDR_D is a Composite CDS View that provides data about "Supplier's Default Address for TH VAT Report" in SAP S/4HANA. It reads from 2 data sources (I_Address_2, I_Supplier) and exposes 28 fields with key fields AddressID, AddressPersonID, Supplier. Part of development package GLO_FIN_IS_VAT_TH.

2 data source(s) 28 fields

Data Sources (2)

SourceAliasJoin Type
I_Address_2 I_Address from
I_Supplier SUPPLIER right_outer

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_Address_2 AddressID
KEY AddressPersonID I_Address_2 AddressPersonID
KEY Supplier I_Supplier Supplier
AddressRepresentationCode I_Address_2 AddressRepresentationCode
AddressObjectType I_Address_2 AddressObjectType
OrganizationName1 I_Address_2 OrganizationName1
OrganizationName2 I_Address_2 OrganizationName2
OrganizationName3 I_Address_2 OrganizationName3
OrganizationName4 I_Address_2 OrganizationName4
District I_Address_2 DistrictName
HomeCityName I_Address_2 VillageName
PostalCode I_Address_2 PostalCode
Street I_Address_2 Street
StreetName I_Address_2 StreetName
StreetPrefixName I_Address_2 StreetPrefixName1
AdditionalStreetPrefixName I_Address_2 StreetPrefixName2
StreetSuffixName I_Address_2 StreetSuffixName1
HouseNumber I_Address_2 HouseNumber
Building I_Address_2 Building
Floor I_Address_2 Floor
RoomNumber I_Address_2 RoomNumber
Country I_Address_2 Country
Region I_Address_2 Region
RegionNameendasCityName
AddressCreatedByUser I_Address_2 AddressCreatedByUser
_Region I_Address_2 _Region
_CurrentDfltLandlinePhoneNmbr I_Address_2 _CurrentDfltLandlinePhoneNmbr
_CurrentDfltMobilePhoneNumber I_Address_2 _CurrentDfltMobilePhoneNumber 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
define view entity P_TH_SUPPLIER_ADDR_D
  as select from I_Address_2 as I_Address
    right outer join       I_Supplier      as SUPPLIER on  I_Address.AddressID                 = SUPPLIER.AddressID
                                                       and I_Address.AddressRepresentationCode = ''

{
  key I_Address.AddressID,
  key I_Address.AddressPersonID,
  key SUPPLIER.Supplier,

      I_Address.AddressRepresentationCode,
      I_Address.AddressObjectType,

      I_Address.OrganizationName1,

      I_Address.OrganizationName2,

      I_Address.OrganizationName3,

      I_Address.OrganizationName4,

      I_Address.DistrictName      as District,

      I_Address.VillageName       as HomeCityName,

      I_Address.PostalCode,

      I_Address.Street,

      I_Address.StreetName,

      I_Address.StreetPrefixName1 as StreetPrefixName,

      I_Address.StreetPrefixName2 as AdditionalStreetPrefixName,


      I_Address.StreetSuffixName1 as StreetSuffixName,

      I_Address.HouseNumber,

      I_Address.Building,

      I_Address.Floor,

      I_Address.RoomNumber,

      I_Address.Country,

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

                        as CityName,

      @Semantics.user.createdBy: true
      I_Address.AddressCreatedByUser,

      I_Address._Region,
      I_Address._CurrentDfltLandlinePhoneNmbr,
      I_Address._CurrentDfltMobilePhoneNumber
}

Learn More