P_RU_CompanyCodeData_Lang

DDL: P_RU_COMPANYCODEDATA_LANG SQL: PRUCOMPANYDATAL Type: view COMPOSITE Package: GLO_FIN_IS_RU

Company Code Data in Logon Language

P_RU_CompanyCodeData_Lang is a Composite CDS View that provides data about "Company Code Data in Logon Language" in SAP S/4HANA. It reads from 6 data sources and exposes 10 fields with key field CompanyCode. Part of development package GLO_FIN_IS_RU.

6 data source(s) 10 fields

Data Sources (6)

SourceAliasJoin Type
I_AddlCompanyCodeInformation AddlInfoOKFS left_outer
I_AddlCompanyCodeInformation AddlInfoOKOPF left_outer
I_AddlCompanyCodeInformation AddlInfoOKPO left_outer
I_AddlCompanyCodeInformation AddlInfoOKVED left_outer
I_OrganizationAddress Address left_outer
P_RU_CompanyCodeData1_Lang P_RU_CompanyCodeData1_Lang from

Parameters (1)

NameTypeDefault
P_PeriodEndDate datum

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRUCOMPANYDATAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_RU_CompanyCodeData1_Lang CompanyCode
AddressID P_RU_CompanyCodeData1_Lang AddressID
CompanyCodeName P_RU_CompanyCodeData1_Lang CompanyCodeName
RU_CompanyCodeINN P_RU_CompanyCodeData1_Lang RU_CompanyCodeINN
RU_CompanyCodeKPP P_RU_CompanyCodeData1_Lang RU_CompanyCodeKPP
RU_CompanyCodeOKVED I_AddlCompanyCodeInformation CompanyCodeParameterValue
RU_CompanyCodeOKPO I_AddlCompanyCodeInformation CompanyCodeParameterValue
RU_CompanyCodeOKFS I_AddlCompanyCodeInformation CompanyCodeParameterValue
RU_CompanyCodeOKOPF I_AddlCompanyCodeInformation CompanyCodeParameterValue
Region I_OrganizationAddress Region 
@AbapCatalog.sqlViewName: 'PRUCOMPANYDATAL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@VDM.private: true
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true 

define view P_RU_CompanyCodeData_Lang with parameters P_PeriodEndDate:    datum

as select from P_RU_CompanyCodeData1_Lang( P_PeriodEndDate: $parameters.P_PeriodEndDate ) 

  left outer join I_AddlCompanyCodeInformation as AddlInfoOKVED on AddlInfoOKVED.CompanyCode = P_RU_CompanyCodeData1_Lang.CompanyCode and 
                                                              (P_RU_CompanyCodeData1_Lang.PeriodEndDate < '20161231'  and AddlInfoOKVED.CompanyCodeParameterType = 'SAPR12' or
                                                               P_RU_CompanyCodeData1_Lang.PeriodEndDate >= '20161231' and AddlInfoOKVED.CompanyCodeParameterType = 'SAPR18' )
                                                              
  left outer join I_AddlCompanyCodeInformation as AddlInfoOKPO on AddlInfoOKPO.CompanyCode = P_RU_CompanyCodeData1_Lang.CompanyCode and 
                                                                  AddlInfoOKPO.CompanyCodeParameterType = 'SAPR02'    
 
  left outer join I_AddlCompanyCodeInformation as AddlInfoOKFS on AddlInfoOKFS.CompanyCode = P_RU_CompanyCodeData1_Lang.CompanyCode and 
                                                                  AddlInfoOKFS.CompanyCodeParameterType = 'SAPR05'  
                                                                  
  left outer join I_AddlCompanyCodeInformation as AddlInfoOKOPF on AddlInfoOKOPF.CompanyCode = P_RU_CompanyCodeData1_Lang.CompanyCode and 
                                                                  AddlInfoOKOPF.CompanyCodeParameterType = 'SAPR06'                                                                                                                                                                                                  
                                                              
                                                                     
  left outer join I_OrganizationAddress as Address on Address.AddressID = P_RU_CompanyCodeData1_Lang.AddressID and
                                                      Address.AddressPersonID is initial and 
                                                      Address.AddressRepresentationCode is initial       
  
      
  {

   key P_RU_CompanyCodeData1_Lang.CompanyCode,
   P_RU_CompanyCodeData1_Lang.AddressID,
   P_RU_CompanyCodeData1_Lang.CompanyCodeName,
   P_RU_CompanyCodeData1_Lang.RU_CompanyCodeINN, 
   P_RU_CompanyCodeData1_Lang.RU_CompanyCodeKPP, 
     
   AddlInfoOKVED.CompanyCodeParameterValue as RU_CompanyCodeOKVED,
   AddlInfoOKPO.CompanyCodeParameterValue as RU_CompanyCodeOKPO,
   AddlInfoOKFS.CompanyCodeParameterValue as RU_CompanyCodeOKFS,
   AddlInfoOKOPF.CompanyCodeParameterValue as RU_CompanyCodeOKOPF,
   
   Address.Region
   
  }

Learn More