EHFNDD_WV_ASSGMT

Transparent Table Control Table (SAP+Cust)
14 Fields 1 CDS Views

Work View assignment

EHFNDD_WV_ASSGMT is an SAP database table in S/4HANA. Work View assignment. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkViewAssgmt view from BASIC Work Perspective Assignment

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY workview EHFND_WV_ID Work View ID
KEY workviewassgmtuuid EHFND_WV_ASSGMT_UUID Work View Assignment
workviewuuid EHFND_WV_UUID Work View
workviewgroupuuid EHFND_WV_GROUP_UUID Work View Group
compliancerequirement EHFND_REQ_IDENTIFIER Compliance Requirement
workviewcomposition EHFND_CCI_CCMPS_TYPE Legal Area
workviewproperty EHFND_PROP_PROPERTY_ROOT Property Group
workviewdatatype EHFND_WV_DATA_TYPE Work View Data Type
prodcmplnclegalarea EHFND_LEGAL_AREA Legal Area
creationdatetime /BOBF/CREATIONDATETIME Created On
createdbyuser /BOBF/CREATEDBYUSER Created By
lastchangedatetime /BOBF/LASTCHANGEDATETIME Last Changed On
lastchangedbyuser /BOBF/LASTCHANGEDBYUSER Last Changed By

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.

-- Work View assignment
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_WV_ASSGMT (
    MANDT,                  -- Client [MANDT]
    WORKVIEW,               -- Work View ID [EHFND_WV_ID]
    WORKVIEWASSGMTUUID,     -- Work View Assignment [EHFND_WV_ASSGMT_UUID]
    WORKVIEWUUID,           -- Work View [EHFND_WV_UUID]
    WORKVIEWGROUPUUID,      -- Work View Group [EHFND_WV_GROUP_UUID]
    COMPLIANCEREQUIREMENT,  -- Compliance Requirement [EHFND_REQ_IDENTIFIER]
    WORKVIEWCOMPOSITION,    -- Legal Area [EHFND_CCI_CCMPS_TYPE]
    WORKVIEWPROPERTY,       -- Property Group [EHFND_PROP_PROPERTY_ROOT]
    WORKVIEWDATATYPE,       -- Work View Data Type [EHFND_WV_DATA_TYPE]
    PRODCMPLNCLEGALAREA,    -- Legal Area [EHFND_LEGAL_AREA]
    CREATIONDATETIME,       -- Created On [/BOBF/CREATIONDATETIME]
    CREATEDBYUSER,          -- Created By [/BOBF/CREATEDBYUSER]
    LASTCHANGEDATETIME,     -- Last Changed On [/BOBF/LASTCHANGEDATETIME]
    LASTCHANGEDBYUSER,      -- Last Changed By [/BOBF/LASTCHANGEDBYUSER]
    PRIMARY KEY (MANDT, WORKVIEW, WORKVIEWASSGMTUUID)
);

Learn More