PVCMPD

Transparent Table Application Table
8 Fields 2 CDS Views

PVS Variant (CMP): Basic Data

PVCMPD is an SAP database table in S/4HANA. PVS Variant (CMP): Basic Data. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProdStrucVariantMaterial view from BASIC Product Structure Variant Material
I_VariantMaterial view from BASIC Material of Variant

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pvguid PVS_PVGUID Internal Number
KEY pvcdcnt PVS_COUNT Counter
pvctype PVS_PVCTYPE Variant Type
cmpid PVS_CMPID Material Number
quant PVS_QUANT Quantity
qunit PVS_QUNIT Unit
docid PVS_DOCID Document

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.

-- PVS Variant (CMP): Basic Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PVCMPD (
    MANDT,    -- Client [MANDT]
    PVGUID,   -- Internal Number [PVS_PVGUID]
    PVCDCNT,  -- Counter [PVS_COUNT]
    PVCTYPE,  -- Variant Type [PVS_PVCTYPE]
    CMPID,    -- Material Number [PVS_CMPID]
    QUANT,    -- Quantity [PVS_QUANT]
    QUNIT,    -- Unit [PVS_QUNIT]
    DOCID,    -- Document [PVS_DOCID]
    PRIMARY KEY (MANDT, PVGUID, PVCDCNT)
);

Learn More