I_CndnContrProcVarPurAssgmt

DDL: I_CNDNCONTRPROCVARPURASSGMT Type: view BASIC

Cndn Contr Process Var Pur Org Assgmt

I_CndnContrProcVarPurAssgmt is a Basic CDS View (Dimension) that provides data about "Cndn Contr Process Var Pur Org Assgmt" in SAP S/4HANA. It reads from 1 data source (wcb_c_proc_var_e) and exposes 6 fields with key fields CndnContrProcVar, PurchasingOrganization, CompanyCode. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
wcb_c_proc_var_e wcb_c_proc_var_e from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CndnContrProcVar _CndnContrProcVar $projection.CndnContrProcVar = _CndnContrProcVar.CndnContrProcVar
[0..1] I_PurchasingOrganization _PurchasingOrganization $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName IWCBPROCVARPOASG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 001 view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey CndnContrProcVar view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
EndUserText.label Cndn Contr Process Var Pur Org Assgmt view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CndnContrProcVar process_variant
KEY PurchasingOrganization ekorg
KEY CompanyCode bukrs
_CndnContrProcVar _CndnContrProcVar
_PurchasingOrganization _PurchasingOrganization
_CompanyCode _CompanyCode
@AbapCatalog: {
  sqlViewName: 'IWCBPROCVARPOASG',
  compiler.compareFilter: true,
  buffering: {
    status: #ACTIVE,
    type: #GENERIC,
    numberOfKeyFields: 001
  },
  preserveKey: true
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
   representativeKey: 'CndnContrProcVar',
   modelingPattern: #ANALYTICAL_DIMENSION,
   supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE],
   usageType: {
     dataClass:      #CUSTOMIZING,
     serviceQuality: #B,
     sizeCategory:   #S
   }
}
@ClientHandling: {
     type: #INHERITED,
     algorithm: #SESSION_VARIABLE
}
@Analytics: {
    dataCategory: #DIMENSION,
    dataExtraction.enabled: false,
    internalName: #LOCAL
}
@EndUserText.label: 'Cndn Contr Process Var Pur Org Assgmt'
@Metadata.ignorePropagatedAnnotations: true
define view I_CndnContrProcVarPurAssgmt
  as select from wcb_c_proc_var_e
  association [0..1] to I_CndnContrProcVar       as _CndnContrProcVar       on $projection.CndnContrProcVar = _CndnContrProcVar.CndnContrProcVar
  association [0..1] to I_PurchasingOrganization as _PurchasingOrganization on $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
  association [0..1] to I_CompanyCode            as _CompanyCode            on $projection.CompanyCode = _CompanyCode.CompanyCode
{
  key process_variant       as CndnContrProcVar,
      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
  key ekorg                 as PurchasingOrganization,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Consumption: {
       valueHelpDefinition: [{ entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } }]
       }
  key bukrs                 as CompanyCode,

      //Associations

      _CndnContrProcVar,
      _PurchasingOrganization,
      _CompanyCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WCB_C_PROC_VAR_E"
],
"ASSOCIATED":
[
"I_CNDNCONTRPROCVAR",
"I_COMPANYCODE",
"I_PURCHASINGORGANIZATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/