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
KEY purgcatproductclassificationid vdm_purgcatprodclassfctn_uuid
purgcatprodclassfctntypecode vdm_purgcatprodclassfctntpcode
purchasingcategoryunspsc vdm_purgcategory_unspsc_code
purchasingcategoryunspscname vdm_purgcategory_unspsc_name
purchasingcategoryeclasscode vdm_purgcategory_eclass_code
purchasingcategoryeclassname vdm_purgcategory_eclass_name
purgcatcstmclassificationcode vdm_purgcat_cstm_clsfctn_code
purgcatcstmclassificationname vdm_purgcat_cstm_clsfctn_name
purgcatcstmclassfctndomain vdm_purgcat_cstm_clsfctndomain
logicalsystem vdm_purgcategory_logicalsystem
isactive vdm_purchasingcategoryisactive

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,                     -- vdm_purchasingcategory_uuid
    PURGCATPRODUCTCLASSIFICATIONID,  -- vdm_purgcatprodclassfctn_uuid
    PURGCATPRODCLASSFCTNTYPECODE,    -- vdm_purgcatprodclassfctntpcode
    PURCHASINGCATEGORYUNSPSC,        -- vdm_purgcategory_unspsc_code
    PURCHASINGCATEGORYUNSPSCNAME,    -- vdm_purgcategory_unspsc_name
    PURCHASINGCATEGORYECLASSCODE,    -- vdm_purgcategory_eclass_code
    PURCHASINGCATEGORYECLASSNAME,    -- vdm_purgcategory_eclass_name
    PURGCATCSTMCLASSIFICATIONCODE,   -- vdm_purgcat_cstm_clsfctn_code
    PURGCATCSTMCLASSIFICATIONNAME,   -- vdm_purgcat_cstm_clsfctn_name
    PURGCATCSTMCLASSFCTNDOMAIN,      -- vdm_purgcat_cstm_clsfctndomain
    LOGICALSYSTEM,                   -- vdm_purgcategory_logicalsystem
    ISACTIVE,                        -- vdm_purchasingcategoryisactive
    PRIMARY KEY (MANDT, PURGCATUUID, PURGCATPRODUCTCLASSIFICATIONID)
);

Learn More