P_TH_Companycode_T

DDL: P_TH_COMPANYCODE_T Type: view_entity COMPOSITE

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

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from

Parameters (1)

NameTypeDefault
P_Language ad_nation

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 TH_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_T
  with parameters
    @Consumption.defaultValue: 'T'
    P_Language          : ad_nation
  as select from  I_CompanyCode
    left outer to one join P_TH_ADDRESS2                 as TH_Address         on  TH_Address.AddressID                 = I_CompanyCode.AddressID
                                                                               and TH_Address.AddressRepresentationCode = $parameters.P_Language
{

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

Learn More