PURGCATPRODCLFN

Transparent Table Application Table
13 Fields 1 CDS Views

Purchasing Category Product Classification

PURGCATPRODCLFN is an SAP database table in S/4HANA. Purchasing Category Product Classification. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PurgCatProductClassification view_entity from BASIC Purchasing Category Product Classificatn

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purgcatuuid VDM_PURCHASINGCATEGORY_UUID Purg Category UUID
KEY purgcatproductclassificationid VDM_PURGCATPRODCLASSFCTN_UUID Product Classification UUID
purgcatprodclassfctntypecode VDM_PURGCATPRODCLASSFCTNTPCODE Product Classification Type Code
purchasingcategoryunspsc VDM_PURGCATEGORY_UNSPSC_CODE Purchasing Catgory UNSPSC Code
purchasingcategoryunspscname VDM_PURGCATEGORY_UNSPSC_NAME Purchasing Category UNSPSC Description
purchasingcategoryeclasscode VDM_PURGCATEGORY_ECLASS_CODE Purchasing Category EClass Code
purchasingcategoryeclassname VDM_PURGCATEGORY_ECLASS_NAME Purchasing Category EClass Description
purgcatcstmclassificationcode VDM_PURGCAT_CSTM_CLSFCTN_CODE Custom Classification Code
purgcatcstmclassificationname VDM_PURGCAT_CSTM_CLSFCTN_NAME Custom Classification Name
purgcatcstmclassfctndomain VDM_PURGCAT_CSTM_CLSFCTNDOMAIN Custom Classification Domain
logicalsystem VDM_PURGCATEGORY_LOGICALSYSTEM Purchasing Category Logical System
isactive VDM_PURCHASINGCATEGORYISACTIVE Is Active

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 Product Classification
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PURGCATPRODCLFN (
    MANDT,                           -- Client [MANDT]
    PURGCATUUID,                     -- Purg Category UUID [VDM_PURCHASINGCATEGORY_UUID]
    PURGCATPRODUCTCLASSIFICATIONID,  -- Product Classification UUID [VDM_PURGCATPRODCLASSFCTN_UUID]
    PURGCATPRODCLASSFCTNTYPECODE,    -- Product Classification Type Code [VDM_PURGCATPRODCLASSFCTNTPCODE]
    PURCHASINGCATEGORYUNSPSC,        -- Purchasing Catgory UNSPSC Code [VDM_PURGCATEGORY_UNSPSC_CODE]
    PURCHASINGCATEGORYUNSPSCNAME,    -- Purchasing Category UNSPSC Description [VDM_PURGCATEGORY_UNSPSC_NAME]
    PURCHASINGCATEGORYECLASSCODE,    -- Purchasing Category EClass Code [VDM_PURGCATEGORY_ECLASS_CODE]
    PURCHASINGCATEGORYECLASSNAME,    -- Purchasing Category EClass Description [VDM_PURGCATEGORY_ECLASS_NAME]
    PURGCATCSTMCLASSIFICATIONCODE,   -- Custom Classification Code [VDM_PURGCAT_CSTM_CLSFCTN_CODE]
    PURGCATCSTMCLASSIFICATIONNAME,   -- Custom Classification Name [VDM_PURGCAT_CSTM_CLSFCTN_NAME]
    PURGCATCSTMCLASSFCTNDOMAIN,      -- Custom Classification Domain [VDM_PURGCAT_CSTM_CLSFCTNDOMAIN]
    LOGICALSYSTEM,                   -- Purchasing Category Logical System [VDM_PURGCATEGORY_LOGICALSYSTEM]
    ISACTIVE,                        -- Is Active [VDM_PURCHASINGCATEGORYISACTIVE]
    PRIMARY KEY (MANDT, PURGCATUUID, PURGCATPRODUCTCLASSIFICATIONID)
);

Learn More