P_RU_CompanyCodeData

DDL: P_RU_COMPANYCODEDATA SQL: PRUCOMPANYDATA Type: view COMPOSITE

P_RU_CompanyCodeData is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 10 fields with key field CompanyCode.

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 P_RU_CompanyCodeData1 from

Parameters (1)

NameTypeDefault
P_PeriodEndDate datum

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRUCOMPANYDATA 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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_RU_CompanyCodeData1 CompanyCode
AddressID P_RU_CompanyCodeData1 AddressID
CompanyCodeName P_RU_CompanyCodeData1 CompanyCodeName
RU_CompanyCodeINN P_RU_CompanyCodeData1 RU_CompanyCodeINN
RU_CompanyCodeKPP P_RU_CompanyCodeData1 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: 'PRUCOMPANYDATA'
@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
define view P_RU_CompanyCodeData with parameters P_PeriodEndDate:    datum

as select from P_RU_CompanyCodeData1( P_PeriodEndDate: $parameters.P_PeriodEndDate ) 
      
//  left outer join P_CompanyCodeAddlSpec as CompanyCodeOkved

//     on CompanyCodeOkved.bukrs = P_RU_CompanyCodeData1.CompanyCode and 

//     (  P_RU_CompanyCodeData1.PeriodEndDate < '20161231'  and CompanyCodeOkved.party = 'SAPR12' or

//        P_RU_CompanyCodeData1.PeriodEndDate >= '20161231' and CompanyCodeOkved.party = 'SAPR18')

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

   key P_RU_CompanyCodeData1.CompanyCode,
   P_RU_CompanyCodeData1.AddressID,
   P_RU_CompanyCodeData1.CompanyCodeName,
   P_RU_CompanyCodeData1.RU_CompanyCodeINN, 
   P_RU_CompanyCodeData1.RU_CompanyCodeKPP, 
     
   AddlInfoOKVED.CompanyCodeParameterValue as RU_CompanyCodeOKVED,
   AddlInfoOKPO.CompanyCodeParameterValue as RU_CompanyCodeOKPO,
   AddlInfoOKFS.CompanyCodeParameterValue as RU_CompanyCodeOKFS,
   AddlInfoOKOPF.CompanyCodeParameterValue as RU_CompanyCodeOKOPF,
   
   Address.Region
   
  }   
  
   
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDLCOMPANYCODEINFORMATION",
"I_ORGANIZATIONADDRESS",
"P_RU_COMPANYCODEDATA1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More