I_PurchasingGroup

DDL: I_PURCHASINGGROUP SQL: IMMPURCHGROUP Type: view BASIC

Purchasing Group

I_PurchasingGroup is a Basic CDS View (Dimension) that provides data about "Purchasing Group" in SAP S/4HANA. It reads from 1 data source (t024) and exposes 7 fields with key field PurchasingGroup.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
t024 t024 from

Annotations (17)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PurchasingGroup view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.sapObjectNodeType.name PurchasingGroup view
AbapCatalog.sqlViewName IMMPURCHGROUP view
AbapCatalog.preserveKey true view
EndUserText.label Purchasing Group view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataExtraction.enabled true view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchasingGroup t024 ekgrp
PurchasingGroupName
PurchasingGroupPhoneNumber t024 ektel
FaxNumber t024 telfx
PhoneNumber t024 tel_number
PhoneNumberExtension t024 tel_extens
EmailAddress t024 smtp_addr 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'PurchasingGroup'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.sapObjectNodeType.name:'PurchasingGroup'
@AbapCatalog.sqlViewName: 'IMMPURCHGROUP'
@AbapCatalog.preserveKey:true 
@EndUserText.label: 'Purchasing Group'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.supportedCapabilities:[#SQL_DATA_SOURCE,
                                    #CDS_MODELING_DATA_SOURCE, 
                                    #CDS_MODELING_ASSOCIATION_TARGET, 
                                    #ANALYTICAL_DIMENSION,
                                    #EXTRACTION_DATA_SOURCE]
@Analytics.dataExtraction.enabled: true
@Search.searchable: true        
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck:#NOT_REQUIRED
define view I_PurchasingGroup 

as select from t024 
{
    @ObjectModel.text.element : 'PurchasingGroupName'
    
    @Consumption.labelElement: 'PurchasingGroupName'  
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.75  
    key t024.ekgrp as PurchasingGroup,
    
    @Semantics.text: true
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.75
    cast(t024.eknam as mm_a_purg_grp_name preserving type ) as PurchasingGroupName,
   
    t024.ektel as PurchasingGroupPhoneNumber,
    
    t024.telfx as FaxNumber,
    
    t024.tel_number as PhoneNumber,
    
    t024.tel_extens as PhoneNumberExtension,
    
    t024.smtp_addr as EmailAddress


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

Learn More