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.

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

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 Group
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGGROUP (
    PURCHASINGGROUP,
    EMAILADDRESS,
    FAXNUMBER,
    PHONENUMBER,
    PHONENUMBEREXTENSION,
    PURCHASINGGROUPNAME,
    PURCHASINGGROUPPHONENUMBER,
    PRIMARY KEY (PURCHASINGGROUP)
);