I_PURCHASINGCATEGORYMATLGROUP

CDS View
3 Fields 35 CDS Views

Purchasing Category Material Group

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

CDS Views using this table (35)

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_SrcgProjPurgCatMaterialGroup view_entity from CONSUMPTION Material groups of purchasing categories
C_SuplrEvalByQuality view left_outer CONSUMPTION Supplier Evaluation by Quality
C_SuplrListPurgCatMatlGroupTP view_entity from CONSUMPTION Material groups of purchasing categories
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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Purchasing Category Material Group
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGCATEGORYMATLGROUP (
    PURGCATUUID,
    _PURCHASINGCATEGORY,
    MATERIALGROUP,
    PRIMARY KEY (PURGCATUUID)
);

Learn More