C_RO_SAFTCompanyCode

DDL: C_RO_SAFTCOMPANYCODE SQL: CROSAFTCOCODE Type: view CONSUMPTION

Company Code data for RO SAFT

C_RO_SAFTCompanyCode is a Consumption CDS View that provides data about "Company Code data for RO SAFT" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 9 fields with key field CompanyCode.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode CompanyCode from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTCOCODE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Company Code data for RO SAFT view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
EmbeddedSwVersionStatusDesc Version EmbeddedSwVersionStatusDesc
ObjectName Version ObjectName
Version Version Version
VATRegistration I_CompanyCode VATRegistration
CompanyCodeName I_CompanyCode CompanyCodeName
CityName Address CityName
Country Address Country
CreationDate 
@AbapCatalog.sqlViewName: 'CROSAFTCOCODE'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true

@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Company Code data for RO SAFT'
define view C_RO_SAFTCompanyCode 
    as select from    I_CompanyCode         as CompanyCode
    left outer to one join I_Address_2 as Address        on  CompanyCode.AddressID = Address.AddressID
                                                         and Address.AddressRepresentationCode is initial
                                                         and Address.AddressPersonID           is initial
    join            I_SAFTProductVersion  as Version on  Version.ObjectName is not initial
                                                     and EmbeddedSwVersionDescription is initial
  
{
  key CompanyCode.CompanyCode                                          as CompanyCode,
  Version.EmbeddedSwVersionStatusDesc                                  as EmbeddedSwVersionStatusDesc,
  Version.ObjectName                                                   as ObjectName,
  Version.Version                                                      as Version,
  CompanyCode.VATRegistration                                          as VATRegistration,
  case
    when CompanyCode.VATRegistration <> '' then
      concat('00', substring(CompanyCode.VATRegistration, 3, 18 ) ) 
  end                                                                  as ReportingVATRegistration,
  CompanyCode.CompanyCodeName                                          as CompanyCodeName,                                                          
  Address.CityName                                                     as CityName,
  Address.Country                                                      as Country,
  //CompanyCode._Address._DefaultPhoneNumber.PhoneNumber                 as PhoneNumber,

  $session.system_date                                                 as CreationDate
  
}

Learn More