PROD_PLANT_PROC

Transparent Table Application Table
19 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTPLANTPROCUREMENTWD

PROD_PLANT_PROC is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTPLANTPROCUREMENTWD. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productplantprocurementd view from EXTENSION Ext view plant proc draft (plant_proc)

Fields (19)

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
isautopurordcreationallowed KAUTB Autom. PO
issourcelistrequired KORDB Source list
ispurgacrosspurggroup WRF_POHF_OTHER_EKGRP_ALLOW Across Purch.Group
sourceofsupplycategory BWSCL Supply source
purchasinggroup EKGRP Purch. Group
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_PRODUCTPLANTPROCUREMENTWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PLANT_PROC (
    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]
    ISAUTOPURORDCREATIONALLOWED,    -- Autom. PO [KAUTB]
    ISSOURCELISTREQUIRED,           -- Source list [KORDB]
    ISPURGACROSSPURGGROUP,          -- Across Purch.Group [WRF_POHF_OTHER_EKGRP_ALLOW]
    SOURCEOFSUPPLYCATEGORY,         -- Supply source [BWSCL]
    PURCHASINGGROUP,                -- Purch. Group [EKGRP]
    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