I_WORKVIEWASSGMT

CDS View
13 Fields 3 CDS Views

Work Perspective Assignment

I_WORKVIEWASSGMT is a CDS View in S/4HANA. Work Perspective Assignment. It contains 13 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_ChmlCmplncInfoAssmtCmbnd view inner CONSUMPTION CCI assignments combined
P_ChmlCmplncInfoCmpstnCmbnd view inner CONSUMPTION CCI Composition Combined
P_WorkViewAssgmtPrptyRootType view from CONSUMPTION Work perspective assignment property root type

Fields (13)

KeyField CDS FieldsUsed in Views
KEY WorkView WorkView 3
KEY WorkViewAssgmtUUID WorkViewAssgmtUUID 1
ComplianceRequirement ComplianceRequirement 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
ProdCmplncLegalArea ProdCmplncLegalArea 1
WorkViewComposition ChmlCompositionType,WorkViewComposition 1
WorkViewDataType WorkViewDataType 1
WorkViewGroupUUID WorkViewGroupUUID 1
WorkViewProperty WorkViewProperty 1
WorkViewUUID WorkViewUUID 3

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 Perspective Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKVIEWASSGMT (
    WORKVIEW,
    WORKVIEWASSGMTUUID,
    COMPLIANCEREQUIREMENT,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PRODCMPLNCLEGALAREA,
    WORKVIEWCOMPOSITION,
    WORKVIEWDATATYPE,
    WORKVIEWGROUPUUID,
    WORKVIEWPROPERTY,
    WORKVIEWUUID,
    PRIMARY KEY (WORKVIEW, WORKVIEWASSGMTUUID)
);

Learn More