P_RU_COMPANYCODEDATA1

CDS View

Get OKVED for a company code

P_RU_COMPANYCODEDATA1 is a CDS View in S/4HANA. Get OKVED for a company code. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_CompanyCodeData view from COMPOSITE Company Code Data

Fields (5)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
AddressID AddressID 1
CompanyCodeName CompanyCodeName 1
RU_CompanyCodeINN RU_CompanyCodeINN 1
RU_CompanyCodeKPP RU_CompanyCodeKPP 1
@AbapCatalog.sqlViewName: 'PRUCOMPANYDATA1'
@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_CompanyCodeData1 with parameters P_PeriodEndDate:    datum

as select from I_Ru_CompanyCodeData 
            
  {

   key I_Ru_CompanyCodeData.CompanyCode,
   I_Ru_CompanyCodeData.AddressID,
   I_Ru_CompanyCodeData.CompanyCodeName,
   I_Ru_CompanyCodeData.RU_CompanyCodeINN, 
   I_Ru_CompanyCodeData.RU_CompanyCodeKPP,
   $parameters.P_PeriodEndDate as PeriodEndDate
    
  }