I_CHEMICALAPPROVAL

CDS View

Chemical Approval

I_CHEMICALAPPROVAL is a CDS View in S/4HANA. Chemical Approval. It contains 2 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_EHSLocationAprvdChemicalUse view from COMPOSITE Approved Chemical for Location
I_EHSLocationChemicalApproval view from BASIC Chemical Approval for Location
I_MyChemicalApprovalRole view inner COMPOSITE Chemical Approval Role
I_SftyRlvtChgAffcdObjUser view left_outer COMPOSITE SRC: Relevant Affected Objects for Users
I_SftyRlvtChgAffcdObjUser_2 view inner COMPOSITE SRC: Relevant Affected Objects for Users
P_EHSLocationChemicalApproval view from COMPOSITE Chemical Approval for Location
P_MyChemicalApprovals view inner COMPOSITE My chemical approvals

Fields (2)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser SafetyRelevantChgNotifProcgUsr 1
ChemicalApprovalUUID ChemicalApprovalUUID 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.

-- Chemical Approval
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHEMICALAPPROVAL (
    CREATEDBYUSER,
    CHEMICALAPPROVALUUID,
    PRIMARY KEY (CREATEDBYUSER)
);