I_PURCHASINGCATEGORY

CDS View
17 Fields 17 CDS Views

Purchasing Category

I_PURCHASINGCATEGORY is a CDS View in S/4HANA. Purchasing Category. It contains 17 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
A_PurgCat view from BASIC Purchasing Category
C_PurchasingCategoryFs view from CONSUMPTION Purchasing Category
C_PurchasingCategoryTranST view from CONSUMPTION Translate Purchasing Categories
C_PurchasingCategoryValueHelp view from CONSUMPTION Purchasing Category Value Help
C_PurgCatBySupplier view from CONSUMPTION Purchasing Category
ESH_N_PURG_CAT view from
I_ProdSrcgPurchasingCategory view_entity from BASIC Purchasing Category
I_PurgCatAPI01 view from BASIC Purchasing Category
I_SuplrEvaluationCriteria view left_outer BASIC Supplier Evaluation Criteria Config
P_PurgCatSupplierInfo view from CONSUMPTION Supplier Count Measures at Purchasing Category
P_SuplrEvalByPurgCategory view union_all CONSUMPTION P_SuplrEvalByPurgCategory
P_SuplrEvalPurchasingCategory view from CONSUMPTION Purchasing Categories
P_SuplrEvalPurgCategory view from CONSUMPTION Purchasing Categories Not Configured
P_SuplrEvalPurgCatScores view left_outer CONSUMPTION Supplier Evaluation Scores
P_SuplrEvalPurgCatScoring view from CONSUMPTION Purchasing Category All Scoring
P_SuplrEvalTimeVarBaseVal view union_all CONSUMPTION Base Value for Time Variance
R_SuplrListPurgCategoryVH view_entity from COMPOSITE Purchasing Category for Supplier List

Fields (17)

KeyField CDS FieldsUsed in Views
KEY PurchasingCategory PurchasingCategory 6
KEY PurgCatUUID PurgCatUUID 5
_ContactCard _ContactCard 1
_CreatedByUser _CreatedByUser 1
_Language _Language 1
_LastChangedByUser _LastChangedByUser 1
_PurchasingCategoryParty _PurchasingCategoryParty 1
_Supplier _Supplier 1
_SupplierActivity _SupplierActivity 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
Language Language 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
PurgCatIsInactive PurgCatIsInactive 1
PurgCatName PurgCatName 5
PurgCatTranslationOvrlStatus PurgCatTranslationOvrlStatus 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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGCATEGORY (
    PURCHASINGCATEGORY,
    PURGCATUUID,
    _CONTACTCARD,
    _CREATEDBYUSER,
    _LANGUAGE,
    _LASTCHANGEDBYUSER,
    _PURCHASINGCATEGORYPARTY,
    _SUPPLIER,
    _SUPPLIERACTIVITY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LANGUAGE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PURGCATISINACTIVE,
    PURGCATNAME,
    PURGCATTRANSLATIONOVRLSTATUS,
    PRIMARY KEY (PURCHASINGCATEGORY, PURGCATUUID)
);

Learn More