I_BackendCoCodeForPurg

DDL: I_BACKENDCOCODEFORPURG SQL: IBACKENDCOCODE Type: view BASIC

Backend company codes for Hub Scenario

I_BackendCoCodeForPurg is a Basic CDS View (Dimension) that provides data about "Backend company codes for Hub Scenario" in SAP S/4HANA. It reads from 1 data source (mmpur_c_be_ccreg) and exposes 9 fields with key fields ProcurementHubSourceSystem, CompanyCode. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
mmpur_c_be_ccreg mmpur_c_be_ccreg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BackendSourceSystem _BackendSourceSystem $projection.ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName IBACKENDCOCODE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Backend company codes for Hub Scenario view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey CompanyCode view
Metadata.allowExtensions true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ProcurementHubSourceSystem be_source_sys
KEY CompanyCode be_co_code
CompanyCodeName be_co_code_name
ProcmtHubCompanyCodeUniqueID be_cc_unique_id
SourceSystem be_source_sys
LogicalSystem _BackendSourceSystem LogicalSystem
ProcurementHubSourceSystemName _BackendSourceSystem ProcurementHubSourceSystemName
CommSyst _BackendSourceSystem CommSyst
_BackendSourceSystem _BackendSourceSystem 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.sqlViewName: 'IBACKENDCOCODE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Backend company codes for Hub Scenario'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Analytics.dataCategory: #DIMENSION
@ObjectModel.representativeKey: 'CompanyCode'
@Metadata.allowExtensions:true
define view I_BackendCoCodeForPurg  as select from mmpur_c_be_ccreg
  
 association [1..1] to I_BackendSourceSystem as _BackendSourceSystem on $projection.ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem
  
  {
    @ObjectModel.foreignKey.association: '_BackendSourceSystem'
 key be_source_sys as ProcurementHubSourceSystem,
     @ObjectModel.text.element : 'CompanyCodeName'
     @Consumption.labelElement: 'CompanyCodeName'
 key be_co_code as CompanyCode, 
 @Semantics.text: true
 be_co_code_name as CompanyCodeName,
 be_cc_unique_id as ProcmtHubCompanyCodeUniqueID,
 be_source_sys as  SourceSystem,

 _BackendSourceSystem.LogicalSystem,
 @Semantics.text: true
 _BackendSourceSystem.ProcurementHubSourceSystemName,
 _BackendSourceSystem.CommSyst,
 _BackendSourceSystem
 
} where cp_activate = 'X' and cp_delete <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BACKENDSOURCESYSTEM",
"MMPUR_C_BE_CCREG"
],
"ASSOCIATED":
[
"I_BACKENDSOURCESYSTEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More