I_PURCHASINGGROUP

CDS View

Purchasing Group

I_PURCHASINGGROUP is a CDS View in S/4HANA. Purchasing Group. It contains 7 fields. 18 CDS views read from this table.

Used by 18 CDS view(s) 7 fields

CDS Views using this table (18)

ViewTypeJoinVDMDescription
A_DigitalVehPurchaseGroup view_entity from CONSUMPTION Digital Vehicle Purchasing Group
A_PurchasingGroup view_entity from CONSUMPTION Purchasing Group Code list
C_CN_TaxInvcPurchasingGroup view from CONSUMPTION China Tax Purcharsing Group
C_FixedAssetOvwPurgGrpVH view from CONSUMPTION Purchasing Group Value Help
C_MassUpdtPurgGrpVH view from CONSUMPTION Purchasing Group Value Help
C_PlannedOrderPurchasingGrpVH view_entity from CONSUMPTION Purchasing group
C_ProcmtHubCntrlContrPurgGrpVH view from CONSUMPTION Purchasing Group Value Help for Central Contr Distribution
C_PurchasingGroup view from CONSUMPTION Purchasing Group Details
C_PurchasingGroupValueHelp view from CONSUMPTION Purchasing Group Value Help
C_PurOrdMaintainPurgGrpValHelp view from CONSUMPTION PO Maintenance: Value Help for Purchasing Group
C_SSPPurchasingGroup view from CONSUMPTION Purchasing Group
CIC_PURGROUP view_entity from CDS view for Purchasing group
I_ACMPurchasingGroup view from BASIC Interface Layer for Purchasing Group
I_SrcgProjPurchasingGroupVH view_entity from BASIC Purchasing Group in Sourcing Project
I_SrcgProjQtnPurchasingGroupVH view_entity from BASIC Purchasing Group in Sourcing Project Qtn
P_MMIM_PURGRP_M_BEST_EKG_01 view from COMPOSITE
P_Plant_Fs view left_outer BASIC
P_Purchaseorders_Fs view left_outer BASIC

Fields (7)

KeyField CDS FieldsUsed in Views
KEY PurchasingGroup PurchasingGroup 6
EmailAddress EmailAddress 4
FaxNumber FaxNumber 4
PhoneNumber PhoneNumber 4
PhoneNumberExtension PhoneNumberExtension 4
PurchasingGroupName PurchasingGroupName 9
PurchasingGroupPhoneNumber PurchasingGroupPhoneNumber 5 
@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


}

Learn More