P_TH_Companycode_D

DDL: P_TH_COMPANYCODE_D Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_TH

Thailand company code default address

P_TH_Companycode_D is a Composite CDS View that provides data about "Thailand company code default address" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 4 fields with key field CompanyCode. Part of development package GLO_FIN_IS_VAT_TH.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
AddressID I_CompanyCode AddressID
AddressRepresentationCode Address AddressRepresentationCode
CompanyCodeNameendasCompanyCodeName 
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #D
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
define view entity P_TH_Companycode_D
  as select from  I_CompanyCode
    left outer to one join P_TH_ADDRESS2                 as Address            on  Address.AddressID                 = I_CompanyCode.AddressID
                                                                               and Address.AddressRepresentationCode is initial
{

  key I_CompanyCode.CompanyCode,
      I_CompanyCode.AddressID,
      Address.AddressRepresentationCode,
      case
        when Address.OrganizationName1 <> '' or Address.OrganizationName2 <> ''
          or Address.OrganizationName3 <> '' or Address.OrganizationName4 <> ''
        then Address.TaxPayerName
        else I_CompanyCode.CompanyCodeName
      end                                                        as CompanyCodeName
}

Learn More