PROD_PLANT_QM

Transparent Table Application Table
22 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTPLANTQTMANAGEMENTWD

PROD_PLANT_QM is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTPLANTQTMANAGEMENTWD. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productplantqtmanagementd view from EXTENSION Ext view plant qm draft (prd_plant_qm)

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
parentdraftuuid /BOBF/UUID Key
rootdraftuuid /BOBF/UUID Key
product PRODUCTNUMBER Product
plant WERKS_D Plant
plantforedit WERKS_D Plant
qltymgmtinprocmtisactive QMPUR QM Procurement
qualitymgmtctrlkey QSSPUR QM Control Key
productqualitycertificatetype QZGTYP CertificateType
hasposttoinspectionstock HASPOSTTOINSPECTIONSTOCK Post to insp. stk
matlqualityauthorizationgroup QMATAUTH QM Matl Auth.
insplotdocumentationisrequired KZDKZ Doc. required
recrrginspintervaltimeindays PRFRQ Insp. Interval
suplrqualitymanagementsystem QSSYS_SOLL Target QM Sys.
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_plnt_incl_eew_ps PLNT_INCL_EEW MD product plant extensible field element

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.

-- I_PRODUCTWD I_PRODUCTPLANTQTMANAGEMENTWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PLANT_QM (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    PARENTDRAFTUUID,                 -- Key [/BOBF/UUID]
    ROOTDRAFTUUID,                   -- Key [/BOBF/UUID]
    PRODUCT,                         -- Product [PRODUCTNUMBER]
    PLANT,                           -- Plant [WERKS_D]
    PLANTFOREDIT,                    -- Plant [WERKS_D]
    QLTYMGMTINPROCMTISACTIVE,        -- QM Procurement [QMPUR]
    QUALITYMGMTCTRLKEY,              -- QM Control Key [QSSPUR]
    PRODUCTQUALITYCERTIFICATETYPE,   -- CertificateType [QZGTYP]
    HASPOSTTOINSPECTIONSTOCK,        -- Post to insp. stk [HASPOSTTOINSPECTIONSTOCK]
    MATLQUALITYAUTHORIZATIONGROUP,   -- QM Matl Auth. [QMATAUTH]
    INSPLOTDOCUMENTATIONISREQUIRED,  -- Doc. required [KZDKZ]
    RECRRGINSPINTERVALTIMEINDAYS,    -- Insp. Interval [PRFRQ]
    SUPLRQUALITYMANAGEMENTSYSTEM,    -- Target QM Sys. [QSSYS_SOLL]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_PLNT_INCL_EEW_PS,          -- MD product plant extensible field element [PLNT_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More