PROD_PLANT_SALES

Transparent Table Application Table
10 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTPLANTSALESWD

PROD_PLANT_SALES is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTPLANTSALESWD. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productplantsalesd view from EXTENSION Ext view plant qm draft(prd_plant_sales)

Fields (10)

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
loadinggroup ladgr Loading Group
availabilitychecktype mtvfp Avail. check
hasactiveentity sdraft_has_active Has 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.

-- I_PRODUCTWD I_PRODUCTPLANTSALESWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PLANT_SALES (
    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]
    LOADINGGROUP,           -- Loading Group [ladgr]
    AVAILABILITYCHECKTYPE,  -- Avail. check [mtvfp]
    HASACTIVEENTITY,        -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More