C_ReExAssignCostCenter

DDL: C_REEXASSIGNCOSTCENTER SQL: CREEXASSCOSTCNTR Type: view CONSUMPTION

Cost Center

C_ReExAssignCostCenter is a Consumption CDS View that provides data about "Cost Center" in SAP S/4HANA. It reads from 1 data source (I_CostCenter) and exposes 19 fields with key fields ControllingArea, CostCenter, ValidityEndDate. It has 1 association to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_CostCenter CostCenter from

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingAreaText $projection.ControllingArea = _ControllingAreaText.ControllingArea association[0..*] to I_CostCenterText as _Text on $projection.ControllingArea = _Text.ControllingArea and $projection.CostCenter = _Text.CostCenter and $projection.ValidityEndDate = _Text.ValidityEndDate

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CREEXASSCOSTCNTR view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Cost Center view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea I_CostCenter ControllingArea
KEY CostCenter I_CostCenter CostCenter
KEY ValidityEndDate I_CostCenter ValidityEndDate
ValidityStartDate I_CostCenter ValidityStartDate
CompanyCode I_CostCenter CompanyCode
BusinessArea I_CostCenter BusinessArea
CostCenterCategory I_CostCenter CostCenterCategory
CostCtrResponsiblePersonName I_CostCenter CostCtrResponsiblePersonName
CostCtrResponsibleUser I_CostCenter CostCtrResponsibleUser
CostCenterCurrency I_CostCenter CostCenterCurrency
ProfitCenter I_CostCenter ProfitCenter
Department I_CostCenter Department
Country I_CostCenter Country
CityName I_CostCenter CityName
Region I_CostCenter Region
Language I_CostCenter Language
FunctionalArea I_CostCenter FunctionalArea
CostCenterName
CostCenterDescription 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CREEXASSCOSTCNTR'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Cost Center'
@VDM.viewType: #CONSUMPTION

@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true

define view C_ReExAssignCostCenter with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu 
   // as select distinct from I_CostCenter 

         //   left outer join I_CostCenterText on I_CostCenter.ControllingArea = I_CostCenterText.ControllingArea and

         //                                       I_CostCenter.CostCenter = I_CostCenterText.CostCenter and

         //                                       I_CostCenter.ValidityEndDate = I_CostCenterText.ValidityEndDate

         
           as select from I_CostCenter as CostCenter
  

  association [0..1] to I_ControllingArea      as _ControllingAreaText on   $projection.ControllingArea = _ControllingAreaText.ControllingArea
  association[0..*] to I_CostCenterText           as _Text                  on  $projection.ControllingArea    = _Text.ControllingArea and
                                                                                $projection.CostCenter         = _Text.CostCenter and
                                                                                $projection.ValidityEndDate    = _Text.ValidityEndDate
  
{
      @Search.defaultSearchElement: true     
      @Search.ranking: #HIGH
  key CostCenter.ControllingArea                         as ControllingArea,
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
  key CostCenter.CostCenter                              as CostCenter,
  key CostCenter.ValidityEndDate                         as ValidityEndDate,
      CostCenter.ValidityStartDate                       as ValidityStartDate,
      CostCenter.CompanyCode                             as CompanyCode,
      CostCenter.BusinessArea                            as BusinessArea,
      CostCenter.CostCenterCategory                      as CostCenterCategory,
      CostCenter.CostCtrResponsiblePersonName            as CostCtrResponsiblePersonName,
      CostCenter.CostCtrResponsibleUser                  as CostCtrResponsibleUser,
      CostCenter.CostCenterCurrency                      as CostCenterCurrency,
      CostCenter.ProfitCenter                            as ProfitCenter,
      CostCenter.Department                              as Department,
      CostCenter.Country                                 as Country,
      CostCenter.CityName                                as CityName,
      CostCenter.Region                                  as Region,
      CostCenter.Language                                as Language,
      CostCenter.FunctionalArea                          as FunctionalArea,
      @Semantics.text: true
      _Text[1: Language = $parameters.P_Language].CostCenterName                         as CostCenterName,
      @Semantics.text: true
      _Text[1: Language = $parameters.P_Language].CostCenterDescription                  as CostCenterDescription
           
      
} 
//where I_CostCenter.Language = $parameters.P_Language;



/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTCENTER",
"I_COSTCENTERTEXT"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_COSTCENTERTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More