I_PURCHASINGCATEGORYMATLGROUP

CDS View

Purchasing Category Material Group

I_PURCHASINGCATEGORYMATLGROUP is a CDS View in S/4HANA. Purchasing Category Material Group. It contains 3 fields. 33 CDS views read from this table.

Used by 33 CDS view(s) 3 fields

CDS Views using this table (33)

ViewTypeJoinVDMDescription
A_PurgCatMaterialGroup view from BASIC Material Group
C_MatlGroupPurCatVH view from CONSUMPTION Material Group Pur Category Value Help
C_MonitorSupplierConfirmation view left_outer CONSUMPTION Monitor Supplier Confirmations
C_NonMngdPurchasingSpend3 view left_outer CONSUMPTION Non Managed Purchasing Spend Cube
C_Purcatvalhelp view left_outer CONSUMPTION Purchasing Category Value Help
C_PurchaseContractLeakage1 view left_outer CONSUMPTION Purchase Contract Leakage Cube
C_PurchaseOrderSpend view left_outer CONSUMPTION Purchase Order Spend
C_PurchaseOrderValue view left_outer CONSUMPTION Purchase Order Value
C_PurgCatMatlGroup view from CONSUMPTION Material Group
C_PurOrderItemHistoryValues2 view left_outer CONSUMPTION Purchase Order Item History Values 2
C_PurOrdValueWithPlnd view left_outer CONSUMPTION Purchase Order Value with Planned Spend
C_PurReqnItemTypeAnalysis view left_outer CONSUMPTION Purchase Requisition Item Type Analysis
C_PurReqnNoTouch view left_outer CONSUMPTION Purchase Requisition No Touch Rate
C_PurRequisitionNoTouch view left_outer CONSUMPTION Purchase Requisition No Touch Rate
C_QuantityContractAcctAssgmt view left_outer CONSUMPTION Quantity Contract Account Assignment
C_ReqnAvgApprovalTime view left_outer CONSUMPTION Requisition Average Approval Time
C_ReqnToOrderCycleTime view left_outer CONSUMPTION Requisition To Order Cycle Time
C_RequisitionChange view left_outer CONSUMPTION Change Purchase Requisition
C_RequisitionTypeAnalysis view left_outer CONSUMPTION Purchase Requisition Type Analysis
C_SchedgAgrmtItmHistory view left_outer CONSUMPTION Scheduling Agreement Item History
C_SuplrEvalByQuality view left_outer CONSUMPTION Supplier Evaluation by Quality
C_SupplierPurchasingSpend view left_outer CONSUMPTION Purchasing Spend for Supplier
I_PurgCatMaterialGroupAPI01 view from BASIC Material Group for Purchasing Category
P_InvoicePriceVariance view left_outer CONSUMPTION
P_MatlGrpPurgCat view left_outer CONSUMPTION Material Group and Purchasing Category
P_PriceAndQuantityVariance1 view left_outer CONSUMPTION Price And Quantity Variance 1
P_Purcatvalhelp view left_outer CONSUMPTION Purchasing Category Value Help
P_PurchasingCategoryMatGrp view from CONSUMPTION Material Groups
P_PurOrdQuantityVariance view left_outer CONSUMPTION Purchase Order Quantity Variance
P_PurReqItemAcctmntr view left_outer CONSUMPTION PR Items by Account Assignment
P_PurReqnItemTypeAnalysis view left_outer CONSUMPTION Purchase Requistion No Touch for OVP
P_SupplierEvalSoftMatGrp view left_outer CONSUMPTION Soft Fact Supplier Eval with Mat Group
P_VendorEvaluation_OVP1 view left_outer CONSUMPTION VendorEvaluation OVP 1

Fields (3)

KeyField CDS FieldsUsed in Views
KEY PurgCatUUID PurgCatUUID 2
_PurchasingCategory _PurchasingCategory 1
MaterialGroup MaterialGroup 1 
@EndUserText.label: 'Purchasing Category Material Group'

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey:true

@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.representativeKey: ['PurCatMaterialGroupUUID']

@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.sqlViewName: 'IPURCATMATLGROUP'

define view I_PurchasingCategoryMatlGroup as select from /srmsmc/d_pucmg
  association [1..1] to I_PurchasingCategory as _PurchasingCategory on $projection.PurgCatUUID   = _PurchasingCategory.PurgCatUUID
  association [0..1] to I_MaterialGroup      as _MaterialGroup      on $projection.MaterialGroup = _MaterialGroup.MaterialGroup
{ 
  @UI.hidden: true
  key cast(db_key as /srmsmc/puc_matl_group_uuid preserving type) as PurCatMaterialGroupUUID,
  
  @UI.hidden: true
  cast(parent_key as /srmsmc/puc_uuid preserving type) as PurgCatUUID, 
  
  cast (matkl as matkl preserving type) as MaterialGroup,
  
  @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
  _PurchasingCategory,
  _MaterialGroup

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

Learn More